A Free Excel Add-in Function: Convert Shorthand Notation Because A Smart Student Asked An Insightful Question In business reports, large numbers are often reported in numeric shorthand notation like $2.5B or USD25M. While we can use the format cells dialog to create a custom number format, the majority of data we may import from other …
Category: Excel Class
Oct 27
Online Excel Classes 50% Off Sale – November Cyber Monday Special Offer
Online Excel Classes 50% Off Sale – November Cyber Monday Special Offer Excel Class celebrates Cyber Monday the entire month of November to give thanks to all our customers. Exclusive limited time offer: 50% off select online classes – Save up to $120 Excel class will celebrate cyber Monday the entire month of November to …
May 12
Excel User Defined Function (UDF) Calls A Macro To Change A Value In Another Cell
Excel User Defined Function (UDF) Calls A Macro To Change A Value In Another Cell According to Excel’s ‘rules’ a UDF should not be allowed to change values in other cells. If you are like me, you might hate it when someone says “It can’t be done”. I tend to follow a contrarian viewpoint, and …
Jul 25
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 …
Aug 27
Excel Class NYC Custom Table Styles Free Tutorial
Excel Classes in NYC offers a free Excel tutorial on how to create a custom table style. To learn Excel in NYC, call us at 212.828.7089 to discuss your Excel training objectives.
Jun 26
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.
Apr 24
Excel Class Favorite Keyboard Shortcuts To Help You Save Time With Microsoft Excel
Excel class shares some of our favorite Excel keyboard shortcut techniques. Our list is not exhaustive, but we believe it offers some of the most common and frequently used shortcuts to save you substantial time and effort when using Microsoft Excel.
Apr 22
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
Jan 02
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 …
Aug 15
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.
- 1
- 2