Recent Excel Posts
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...
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...
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...
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 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.
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).
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).