212-828-7089
Google PlacesExcel on YouTubeExcel Class NYC Faceook PageExcel Class on LinkedInExcel Class on TwitterExcel Class on YelpExcel on BloggerExcel on Wordpress

Category: Excel Blog

A Free Excel Add-in Function: Convert Shorthand Notation

Excel Add-in

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 …

Continue reading

Online Excel Classes 50% Off Sale – November Cyber Monday Special Offer

Sale

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 …

Continue reading

Sakila Database In Microsoft Access File Format

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 …

Continue reading

Excel UDF Calls A Macro To Change A Value In Another Cell

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 …

Continue reading

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 …

Continue reading

Excel Budgets

Excel Budgets When speaking with Excel students, one of the most commonly asked Excel questions is: “How do I create a budget?”. My advice would be, if your boss asks you to create a department budget your first question should be “Okay, will the CFO provide a template for this project” (the answer should be …

Continue reading

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, …

Continue reading

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 …

Continue reading

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 …

Continue reading

Excel Tutorial – Vlookup Multiple Columns To The Right With An Array Formula

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 …

Continue reading