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 Blog
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 …
Sakila Database In Microsoft Access File Format Over the course of (more than) twenty years I have taught Microsoft programs like SQL, Excel, and Access. In the process of teaching I endeavor to educate students about different well known data sets that include: Contoso, AdventureWorks, Northwind, Sakila, Chinook, Lahman and others. I use these examples …
Excel UDF Calls A Macro To Change A Value In Another Cell Wishful Thinking: Update The Website With Accurate Information Update: November 23rd, 2020: Instead of acknowledging the problem and fixing the incorrect information, in typical Microsoft fashion, the link below on Microsoft’s website now produces a 404 error page, which is why I created …
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 …
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, …
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 …
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 …
In the process of teaching Excel classes, many students ask: How can I write a single vlookup function that returns multiple values to the right, instead of a single value, which causes me to write many vlookup functions in many columns. This tutorial does not teach vlookup, that feature is taught in the Introduction and …
Report Hidden Rows With An Excel VBA Macro Many Excel users choose to hide a row of data on a worksheet for a variety of reasons. When Excel users collaborate it’s difficult to know that a row has been hidden without careful visual inspection of every row. If a hidden row contains zero values there …
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 …
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 wont correctly sort to the new last row. Also, anytime you record a macro to …
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.
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.
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.
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 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 Training NYC offers a free Excel tutorial on Microsoft Excel’s Paste Special feature. Study our practice workbook, then take a short test.
Excel Class NYC Training Blog offers free Microsoft Excel Tutorial on 3-Dimensional Functions. Download the practice test to see if you can master data consolidation with Microsoft Excel.
VBA Class Blog – Learn Excel VBA To Navigate Cells and Sheets
Excel Class Free Tutorial – Learn about Excel Relative and Absolute References
Excel Class New Excel Blog