Excel for Busy People

Awesome Excel content for all skill levels.

Recent Excel Posts

Border Keyboard Shortcuts in Excel

Border Keyboard Shortcuts in Excel

Keyboard shortcuts are incredibly useful in any productive work. All to often, people neglect to use them in Excel. This article will cover border keyboard shortcuts so that you may quickly create and manipulate borders. Of course you can use the border menu up near...

read more
How to Print Empty Cells in Excel

How to Print Empty Cells in Excel

Sometimes you want your Excel spreadsheet to display data differently in file than on paper. Effectively what you can do is add custom views to print empty cells. To see a use case, let's take a look at this question from Jack: I have one excel sheet, in that sheet I...

read more
Nailing Down Basic Excel Terms: Excel for Busy People

Nailing Down Basic Excel Terms: Excel for Busy People

Before we jump into Excel content, it's important to nail down some basic Excel terms so we're all on the same page. After working in IT for many years, I got a chance to help a wide variety of people. You'd be surprised how many people get basic terms wrong. This...

read more

Excel Curriculum by Difficulty

The beginner's guide to Excel is available now! The curriculum the next intermediate version is done. Let me know if I should finish and release it.

I also have enough material to make the curriculum of the final advanced version. Also let me know if I should work on it more. This part is my favorite as this one has the potential to make you a boat load of money. It involves tricks taught by MBA programs and used in companies around the world.

Beginner Excel

Beginner tips to start using Excel strategically.

  • Interface and ribbon walkthrough.
  • Math and stat functions.
  • Other important functions for beginners.
  • Function libraries.
  • References and range names.
  • Calculations and subtotals.
  • Auditing and error correction.

Intermediate Excel

How to use and manage data effectively.

  • Reformatting data and flash fill.
  • Using lookups and indexes.
  • Using charts, graphs, and pivot tables.
  • Turning rows of data into maps.
  • Personal finance project exercises – debt payoff calculator, rule of 72, etc.
  • Extra tips for using Excel (get rid of empty rows).

Advanced Excel

Using Excel for modeling and other business purposes.

Excel Application Links by Store

The first three links will take you to the free Excel applications at their respective platform. The last link to Amazon is an affiliate link to buy the Office 365 platform (highly recommended).

Pin It on Pinterest