50 Excel HacksFrom the Excel tips videos · Instant PDF
Stop wasting hours in Excel
The 50 shortcuts, formulas and tricks that actually come up at work, each on half a page with an example you can copy.
- 50 hacks
- 7 chapters
- 40 pages
- Instant PDF
Secure checkout by Payhip. Download link by email within a minute. Prices exclude VAT. For buyers in the EU, VAT is added at checkout.
Seen one of our videos?
Every video shows one trick. The book has all fifty.
Most people use about 10% of Excel and spend hours doing by hand what Excel can do in seconds. This guide covers the other 90%: the 50 tricks that actually come up at work.
Every hack fits on half a page: the problem, the exact keys or formula, a small example and a pro tip. You do not need to read it in order. Find the problem you have today and fix it in a minute.
Sum a column instantly
Click under your numbers and Excel writes the SUM for you.
Today's date without typing
Add Shift for the current time. Two keystrokes for a log entry.
Turn a list into a real table
New rows get the same formatting and formulas automatically.
Filters on and off
One keystroke instead of hunting for the Filter button.
Lock a reference
A1 becomes $A$1, so formulas stop breaking when you copy them.
=XLOOKUP(what, where, return)The VLOOKUP killer
Looks in any direction and survives inserted columns. Microsoft 365 / Excel 2021+.
What's inside
50 hacks in 7 chapters
- Shortcuts That Save Hours10 keyboard moves you will use every day
- Find AnythingXLOOKUP, SUMIFS, COUNTIFS and smart totals
- Dynamic ArraysOne formula fills a whole table: FILTER, SORT, UNIQUE
- Clean Up Messy DataSplit names, remove duplicates, fix text in seconds
- Dates Without HeadachesDeadlines, working days and ages, calculated for you
- Make It Look ProfessionalDropdowns, data bars, slicers, frozen headers
- Reports in MinutesPivotTables, Quick Analysis and Power Query
What you get
Made to keep next to your keyboard
- Every hack on half a page: the problem, the fix, an example and a pro tip
- The exact keys and formulas, ready to copy into your own sheet
- A printable cheat sheet with the 20 shortcuts that save the most time
- Works with Excel 2016 and newer; hacks that need Microsoft 365 or Excel 2021 are marked
- Mac users: use Cmd instead of Ctrl in most shortcuts, as the book explains
PDF, 40 pages, instant download. Read it on your phone, tablet or computer, or print it.
FAQ
Questions, answered
Which Excel versions does it cover?
Excel 2016 and newer. The few hacks that need Microsoft 365 or Excel 2021 are clearly marked.
Does it work on a Mac?
Yes. The formulas are the same, and for the shortcuts you use Cmd instead of Ctrl in most cases, as the book explains.
My Excel uses ; instead of , in formulas. Is that a problem?
No. In some countries, such as the Netherlands and Germany, Excel separates arguments with a semicolon. The book points this out, so you can adjust the formulas in a second.
What do I get after paying?
An email from Payhip with your download link, usually within a minute. The PDF is yours to keep: download it as often as you like.
Do I need an account?
No. Checkout asks for your email address so the download link can be sent to you.
Is VAT included?
Prices are shown excluding VAT. If you buy from an EU country, VAT is added at checkout at your country's rate.
Can I get a refund?
If the file does not open or is not what the page described, send a message within 14 days and we will put it right or refund you.
Fix today's spreadsheet problem in a minute
50 hacks, 7 chapters, one instant PDF for €7.99.