Excel Class Free VBA Tutorial – Variables
Few things in life are constant. Heraclitus said: The only thing constant is change. Change is constant and variables are used to capture change. In the context of Excel, the names of workbooks change, the number of workbooks you have open is variable, the number of sheets, pivot tables and charts is usually variable, the name of sheets is variable, the values in cells are variable, and on, and on.
PEMDAS and the Mathematical Order of Operations with Microsoft Excel
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 begin […]
Excel Class Launches Online VBA Training
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 […]
Excel Class VBA Macro Adds IfError Functions To Every Formula
Excel Class VBA Macro Adds IfError Functions To Every Formula Today a student asked Excel Class if there was a macro to automatically add an IfError function to every formula on every sheet in a selected workbook, assuming there was not already an IfError function used. On short notice the Excel Class instructor provided the […]
Data Tables And Interactive Charts
The Excel Class blog provides an opportunity to supplement the material we teach in our class. This tutorial assumes our readers are familiar with named ranges. (See: Advanced Excel Class) Excel’s data table feature is a what-if analysis tool that allows users to create tables (rows/columns) of results based on a one or two variable […]
SumProduct Function Applications
SumProduct Function Applications When teaching Excel classes students occasionally ask about the SumProduct function. There are many aspects of SumProduct that mirror the SumIfs functions capabilities but SumProduct can produce different answers when combined with the unary operator. This tutorial is not meant to be a thorough discussion of SumProduct but is meant to provide […]
Two Criteria Lookups
Two Criteria Lookups In the process of teaching Excel over the past 20 years I have found that most students are often shocked and unaware that Vlookup and Index/Match can only locate the first item in a list. They find this unacceptable and I would tend to agree. When a value repeats in many rows, […]
Excel Class Training NYC Announces Spring Excel Calendar
Excel Class Training NYC Announces Spring Excel Calendar for Introduction To Excel class dates, Intermediate – Advanced Excel class dates, and Excel VBA class dates
Excel Class NYC – Free Excel Training Tutorial – Excel Text Functions
Excel Class nyc offers a free excel training blog tutorial post. This Excel Class Blog is part I of a three part series of Excel training about text functions.
Excel VBA Class Announces East Coast Schedule For Q1 2011
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 […]