Excel training

In my Excel classes i do a brief review of using copy and paste, but given the amount of important material to cover, there is never enough time to cover Excel’s paste special feature in any detail. The purpose of this blog post is to explain the importance of Excel’s paste special feature in detail. […]

Excel Class NYC offers another free Excel class tutorial for our readers and subscribers. Everyone is encouraged to comment or reply about problems, questions, or suggestions. This tutorial can also be found at Excel Training. In Advanced Excel Training you’ll learn advanced Excel functions like Vlookup, If/Then, IsError, and others. With so much important material […]

Excel Class is pleased to announce our Q1 2011 Excel VBA Classes schedule. Philadelphia, PA February 16th – 18th – Register Here Boston, MA February 23rd – 25th – Register Here Baltimore, MD March 1st – 3rd – Register Here Miami, FL March 7th – 9th – Register Here Atlanta, GA March 16th – 18th […]

Excel Class Training NYC Announces Spring Excel Calendar Introduction To Excel Training Dates May 2-3 6pm-9pm May 24-25 6pm-9pm Intermediate – Advanced Excel Training Dates Evenings: May 12-13 6pm-9pm Days: May 14 10am-5:30pm Evenings: May 18-19 6pm-9pm Evenings: June 1-2 6pm-9pm Excel VBA Training Dates Days: May 9-10, 16-17, 23-24 3pm-6pm Days: June 5, 12, […]

Excel Class Favorite Keyboard Shortcuts To Help You Save Time With Microsoft Excel Excel class NYC is pleased to share some of our favorite Excel keyboard shortcut techniques. This list is not meant to be exhaustive, we believe it offers some of the most common and frequently used shortcuts to save you substantial time and […]

Constants Few things in life are constant. Examples of constants include the number of hours in a day, the number of days in a week, the speed of light, a dozen, pi, and several others. To declare a constant in Excel VBA we use the CONST statement. The CONST statement takes the form: Const constantname […]

One of the many terrific new features in Excel 2007 (and 2010) is the ability to create a table. Microsoft took a feature from 2003 called autoformat and improved it dramatically. Microsoft Excel Tables allow you to: Apply alternate row shading where inserting or deleting a row adjusts the shading for you Freeze column headings […]

Reposted from http://www.vbaclass.com/blog/excel-vba-tutorial-learn-to-use-vba-to-overcome-macro-recorder-limitations/ If you record a macro where you sort your data, the macro records the last contiguous row in the data set. Next time you run the macro, if you have more rows of data the recorded macro won’t correctly sort to the new last row. Also, anytime you record a macro to […]

Microsoft Excel works similarly to using a calculator but there are important differences. On a calculator to perform a calculation you might type numbers, then math symbols like plus (+) or minus (-) and then you would press the equal key to complete your calculation. In Excel we don’t end with the equal sign, we […]

Excel Class receives requests for Microsoft Excel VBA training courses from every corner of the country. We are pleased to announce that our new exclusive series: The Excel VBA webinar is now available online. Our training sessions begin once a month at different start times. Each session lasts two hours and includes no less than […]