To learn excel VBA is to relearn Excel from the ground up. In Excel you are comfortable selecting cells, sheets and workbooks using your keyboard or mouse. Our previous tutorial introduced the importance of Excel VBA variables. This tutorial covers navigation techniques. Navigate From Cell To Cell To navigate to a cell you can use [...]
One of the most commonly asked questions about Excel, even at the advanced level, is what is an absolute reference, when do I need it? As you work in Excel, for the most part, you’ll be fine using relative references. Relative references are references to cells that adjust relative to the direction of the movement [...]
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 [...]
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. [...]
In any introductory Excel class training you are taught to sum (add) rows and columns. That’s called a one or possibly a two dimensional formula. In the real world (outside a class) that technique is insufficient to build robust Excel models. In my Excel class we also learn about Excel 3-dimensional formulas. A three dimensional [...]
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 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 [...]
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 [...]
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 [...]
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 [...]