19 tips for nested IF formulas
Are nested IFs evil? Are they necessary? Are there alternatives? The answer is Yes! This in-depth article explores nested IF formulas in detail, with lots of tips, and several alternatives.
Articles
How to use the MOD function to repeat values
MOD is nerdy, but cool. If you've ever struggled to create a more complex formula in Excel, you'll like this one. It shows you how to build a more complex formula step-by-step, without going crazy.
How to set a default template in Excel
Excel has the ability to use a custom template for all new workbooks. If you find yourself making the same changes to new workbooks (changing row height, font size, zoom, etc.) a default custom template can save you time and trouble.
How to find text with a formula
Does cell A1 contain "apple"? This is a surprisingly tricky problem in Excel. In this article, we look at several options, based on the functions FIND, SEARCH, ISNUMBER, and COUNTIF.
Excel shortcuts on the Mac
Shortcuts work great in the Mac version of Excel, but there are differences you should know about. This article explains the 5 key differences you need to be aware of to work productively with Excel shortcuts on a Mac.
20 very popular Excel shortcuts
We asked users how important Excel shortcuts are to them and also about their favorite shortcuts. This is what we learned...
How to turn off Scroll Lock in Excel
Your report is due in an hour. You're working along in Excel, and suddenly you notice you can no longer move around properly. You press the arrow keys, but instead of the cursor moving to another cell, the entire worksheet seems to be moving about. WTF?!
Before you panic, and call IT to tell them Excel is broken, check to see if Scroll Lock is to blame. Read below to learn how.
Top 10 reasons to learn Excel formulas
If you've ever wondered whether learning Excel formulas is worth your time, this list is for you. Formulas are the glue that hold spreadsheets together all over the world, and your skill with them can help you in many ways.
23 things you should know about VLOOKUP
Although VLOOKUP is a pretty simple function, there is plenty that can go wrong. Quickly learn more than 20 things you should know about VLOOKUP to make your experience pleasant and profitable.
Danger: beware VLOOKUP defaults
Many users aren't aware of it, but VLOOKUP will use approximate match mode by default. This can be a disaster because VLOOKUP can return a totally incorrect result. Read below to learn how match modes work in VLOOKUP, and how to avoid this dangerous problem.
Formula puzzle - how long was the truck stopped?
In this formula puzzle, we look at truck location GPS data, and ask: what formula will calculate the hours that each truck was stopped during the day?
Test conditional formatting with dummy formulas
If you've ever tried to apply conditional formatting with a formula, you know the hardest part is making sure the formula actually works. Here's an easy way to test the formula, before you use it in a rule.
5 formulas to highlight dates by month and year
How do you figure out what formula to use? A teardown of 5 good formulas you can use to highlight dates based on a common month and year value using conditional formatting.
Highlight dates in the same month and year
Excel has a built-in conditional formatting rule that will highlight dates that occur "this month". But what if you want to highlight dates in the same month and year for any date?
Cool things you can do with conditional formatting
In this article, we look at some cool ways that you can use Excel's conditional formatting feature to quickly visualize important data.
5 pivot tables you probably haven't seen before
In this article, we take a short tour of some "unconventional" pivot tables you probably haven't seen before. These are interesting pivot tables created to analyze something other than sales data.
Can pivot tables save your job?
This article is for those of you who don't get pivot tables. Maybe you tried pivot tables once, and didn't see what the big deal was, or maybe you got frustrated when a pivot table wouldn't behave. They can be that way.
Pivot Table Tips
Many Excel experts believe that Pivot Tables are the single most powerful tool in Excel. This article provides more than 20 tips you should know to work productively with Excel Pivot Tables.
The value of improving a skill (a simple model)
In this article, we take a look at a simple model that calculates the time that could be saved by doing a task or activity with more skill. The goal is to visualize whether it makes sense to invest in getting better at a skill.
The 54 Excel shortcuts you really should know
A list and description of just over 50 important Excel shortcuts you should know if you spend a lot of time in Excel. This is a summarized version of the more than 200 shortcuts that are available in Excel for both Windows and Mac platforms.
Pages
Excel is literally one of my favorite things in life + absolutely love learning new things through your site/newsletters!:)
Andrea
Get Training
Quick, clean, and to the point training
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.
View Paid Training & Bundles
