Our approach is quick, clean, and to the point. Join more than 50,000 people who get weekly updates from us.
One of the biggest mistakes you can make is to hard code assumptions into your formulas. Instead, if a value might change, put it in a cell and refer to it with a reference, as explained in...
In this video, we look at 5 key differences between Excel shortcuts on Mac and shortcuts in Windows Excel. If you use Excel on a Mac, be sure to check this out.
Why is the Excel ribbon cool? Because it gives you a way to use nearly every feature in Excel without touching the mouse. Watch this video to learn how.
Excel has great support for shortcuts in tables. Shortcuts for inserting, selecting, and deleting rows and columns all work much better! Watch the video to see how.
Did you know you can use shortcuts to control the direction Excel moves when you press Enter? In this video, learn a boatload of shortcuts for entering data in Excel.
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.
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.
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.
If you're used to working with Excel on Windows, one of the most confusing aspects of using Excel on a Mac is shortcuts. Excel shortcuts on the Mac are quite capable, you just have be aware of 5 key differences.
We asked users how important Excel shortcuts are to them and also about their favorite shortcuts. This is what we learned...
What people are saying
Sits Next to my Laptop // Excel Laminated Shortcut Card This sits right next to my laptop so I always have it available when I am using Excel. It has many useful shortcuts which have saved me a tremendous amount of time in my daily work. I highly recommend it, as well as the other products from Exceljet. - Anthony
Everything you need to know about pivot tables // Core PivotExcelJet does a fantastic job of breaking down the potentially complex topic of pivot tables into simple, easy to understand bite-sized pieces! This course serves up everything you need to know (and more) about pivot tables on a platter so you can create simple, straight-forward and customizable reports while significantly minimizing the learning curve. - Lauren
Brilliant // Core ExcelAbsolutely brilliant course. Easy to follow and implement. Well done. I can recommend this course to anybody who would like to learn Excel. - Linda
A must for EVERYONE switching from a PC to Mac! // Excel Laminated Shortcut Card A must for EVERYONE switching from a PC to Mac! I wish I had this back when I made the switch! Save yourself the headache and buy this NOW! Great product from GREAT people! Check out their website for the great tips and classes! - Mary Jo