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?
Articles
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.
Collapse the ribbon when you don't need it
Does it ever bother you that the ribbon sits up there at the top of the workbook, smugly hogging a bunch of space while you toil away in your (smaller) worksheet below?
How to group a pivot table by age range
In this article, we look at how to use a pivot table to group voting data by age. This is a good example of the "group by number" feature that all pivot tables share.
Calculating the break-even point for Google Adwords
In this article, we build a model using the seldom-seen Data Table to visualize at what point an Adwords campaign becomes profitable.
How to use Mac function keys with Excel
A summary of how to use Function keys on a Mac with Excel and other applications, including information on system defaults and how to change these defaults.
Pages
I've recently found myself in a job where I need to do a lot more excel data modelling. I'm constantly finding I need to look up bits and pieces to get things done and Exceljet has *consistently* been the best resource I've found. I really, really appreciate the fact that the instructions are to the point, I'm not swimming in ads, and you do a full explanation of how all the functions work which has significantly built my capability and conceptual understanding over recent weeks.
Tim
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
