Description

The complete guide to everything Microsoft Word and Excel can do that nobody ever taught you from hidden navigation tricks to secret formulas, power formatting, PivotTable shortcuts and automation hacks that save hours every single week.

THE REALITY

29% of Learning & Development decision-makers now identify Excel as the single most in-demand skill for employees above AI tools, above coding, above everything else.

Excel skills are required for 83% of clerical and administrative positions, and are essential in the majority of engineering, finance, and management roles.

Nearly 1 in 10 UK job postings explicitly require strong spreadsheet skills and that number keeps rising.

Professionals with certified Excel skills are 12% more likely to be promoted and earn higher salaries than those without.

And yet most people who use Word and Excel every single day have never been properly taught how to use them.

They click through menus that should take one keystroke. They reformat the same document layout over and over. They write formulas from scratch that already exist as a single function. They spend 20 minutes doing something that takes a power user 20 seconds.

The software already knows how to do everything faster. Nobody showed you where to look.

THE SOLUTION

The Hidden Word & Excel Secrets Bible is an 18-page, beautifully designed PDF guide packed with 200+ hidden shortcuts, exclusive power tricks, and secret formulas across both Microsoft Word and Microsoft Excel organised by category so you can jump straight to the skills you need most.

Every single tip was chosen because it genuinely changes how fast and how confidently you work. Not because it exists but because it saves real time on real tasks that real people do every single day.

Works on Windows and Mac. Covers all recent versions of Microsoft 365, Word and Excel.

WHAT’S INSIDE — 8 CHAPTERS OF EXCLUSIVE CONTENT

Word Chapter 1 — Navigation Secrets Move around any document in seconds without touching the mouse.

• The Shift+F5 trick that cycles through your last 3 editing positions — never lose your place again ★
• F8 multi-level selection — press it once for a word, twice for a sentence, three times for a paragraph, four times for the whole document ★
• Alt+click+drag rectangular column selection — select a vertical block of text that standard selection can’t touch ★
• The Browse Object (Alt+Ctrl+Home) — navigate a document by heading, table, image or comment with one keystroke ★
• Ctrl+G / F5 Go To — jump to any page, line, heading, bookmark or table instantly

Word Chapter 2 — Find, Replace & Table Secrets The hidden superpower inside Ctrl+H that most Word users never discover.

• ^p, ^t, ^l, ^w codes in Find & Replace — find paragraph breaks, tabs, line breaks, and any white space to reformat entire documents in seconds ★
• The ^& wrap trick — find any word and automatically wrap it in brackets, quotes, or formatting in one Replace operation ★
• Replace with Format — change every instance of one font to another font without touching a single line manually ★
• Alt+Shift+Up/Down — move an entire table row up or down without cutting and pasting ★
• Ctrl+Shift+Enter — split any table into two separate tables at the cursor position ★
• Alt+drag on a column border — resize a Word table column with exact measurements shown live in the ruler ★

Word Chapter 3 — Styles, Templates & Automation Work at a truly professional level — consistency, navigation and document automation.

• Ctrl+Shift+S — open the Apply Styles box and apply any style by name without touching the ribbon ★
• Right-click Style → Update to Match — reformat every single instance of a style across the entire document from one example ★
• Drag headings in the Navigation Pane — reorder entire document sections by dragging, with all content underneath moving with them ★
• Ctrl+click a heading in the Nav Pane — select an entire section including all content beneath it in one click ★
• Alt+Shift+D / T — insert today’s date or the current time as a live-updating field code ★
• Ctrl+Shift+F9 — convert all dynamic field codes to plain permanent text in one move ★

Excel Chapter 4 — Navigation & Selection Mastery Move around thousands of rows and select exactly what you need — instantly.

• Ctrl+G → Special → Blanks → Ctrl+Enter — fill every blank cell in a range simultaneously in 10 seconds ★
• Shift+F8 Add to Selection — select multiple non-adjacent ranges without holding Ctrl ★
• Ctrl+Shift+O — select every cell in the sheet that contains a comment ★
• Right-click the navigation arrows (bottom left of screen) — see ALL sheet tabs at once, even when they’re hidden off screen ★
• Ctrl+Backspace — instantly scroll the view back to show your active cell when you’ve scrolled away ★

Excel Chapter 5 — Formula Secrets & Hidden Functions The formulas Excel doesn’t teach you — that solve real problems in seconds.

• =DATEDIF() — Microsoft’s hidden date function that calculates exact years, months, or days between dates. It doesn’t appear in autocomplete — you must type it manually. It still works perfectly. ★
• =AGGREGATE(9,5,range) — SUM that ignores both hidden rows AND errors simultaneously — replaces a complex SUMIF+IFERROR combination in one function ★
• =LET(x, A1*B1, x+x) — name a value inside a formula so you never have to repeat the same calculation twice ★
• =FILTER(), =UNIQUE(), =SEQUENCE() — the dynamic array functions that make traditional helper columns and complex array formulas obsolete ★
• =XLOOKUP() — the replacement for VLOOKUP that searches in any direction, requires no column number, and handles errors automatically ★
• =TEXTJOIN(“,”,TRUE,range) — join an entire range of cells into one string with a separator in a single formula ★
• F4 in formula mode — cycle through all four combinations of absolute and relative references ($A$1 → A$1 → $A1 → A1) in one key ★
• F9 in the formula bar — evaluate only the highlighted portion of a formula and see the result inline — the professional way to debug nested formulas ★
• Ctrl+` (backtick) — toggle between showing formula text and calculated values across ALL cells simultaneously ★

Excel Chapter 6 — Data, PivotTables & Power Formatting Transform raw data into insights in minutes — not hours.

• Paste Special Multiply/Divide trick — copy the number 1000, select a column of values, Paste Special → Divide — converts every cell by 1000 in one operation. No formula, no helper column. ★
• Double-click any PivotTable value — Excel creates a new sheet showing every raw data row behind that number — instant drill-down ★
• =MOD(ROW(),2)=0 in Conditional Formatting — apply alternating row shading to any range without converting to a Table ★
• Ctrl+Enter to fill selected cells — select a range first, type once, press Ctrl+Enter — the value fills every selected cell simultaneously ★
• Ctrl+; and Ctrl+Shift+; — insert a static date or static time that will never change, with no formula required ★
• Ctrl+Shift+3/4/5 — apply Date / Currency / Percentage format in one keystroke ★

Excel Chapter 7 — Workbook, View & Automation Secrets The advanced moves that separate casual users from genuine Excel power users.

• Ctrl+click multiple sheet tabs — type anything and it appears on ALL selected sheets simultaneously — the fastest way to add headers or totals across a multi-sheet workbook ★
• Personal Macro Workbook (PERSONAL.XLSB) — save any macro here and it becomes available in every Excel file you ever open, forever ★
• F9 formula bar evaluation — select just part of a formula, press F9, see its result — press Escape to restore. How professional auditors debug complex spreadsheets. ★
• Ctrl+[ and Ctrl+] — jump to every cell that feeds into a formula (precedents) or depends on it (dependents) ★
• Ctrl+Shift+` (formula audit mode) — show every formula as text across the entire sheet — the fastest way to audit a workbook at a glance ★
• Power Query — load, clean and transform data from any source automatically, without a single formula ★

Chapter 8 — Quick Reference Cards Three printable one-page reference cards:

• Microsoft Word Essential Shortcuts (15 shortcuts)
• Microsoft Excel Essential Shortcuts (15 shortcuts)
• Excel Hidden Formulas Cheat Sheet (12 power functions)

Print them. Pin them to your desk. In 4 weeks they’ll be automatic.

THE NUMBERS THAT SHOW WHY THIS MATTERS

• Mastering Excel can increase your personal productivity by up to 40%
• 29% of L&D decision-makers name Excel the single most in-demand employee skill in 2026
• Excel proficiency increases the likelihood of promotion and raises earnings by an average of 12%
• Nearly 1 in 10 UK job postings explicitly require strong spreadsheet skills
• Financial analysts and operations managers proficient in Excel can earn £40,000–£65,000 annually
• Most people use less than 15% of what Word and Excel can do after years of daily use

The skills in this guide could be worth thousands of pounds in salary, promotions, and time saved.

WHO IS THIS FOR?

This guide is for anyone who uses Microsoft Word or Excel — which covers most of the working population.

• Office workers and administrators who want to work faster and look sharper
• Finance, HR, marketing and ops professionals who use Excel daily but feel they’re missing tricks
• Students and graduates who want to stand out in job applications and interviews
• Career changers and returners who need to demonstrate current, advanced Office skills
• Small business owners who create documents and manage data but have never been formally trained
•  IT support workers and trainers who want to genuinely impress the people they teach
• Teachers and educators who use Word for planning, marking, and reports
• Anyone who has ever thought “there must be a faster way to do this” — and was right

WHAT MAKES THIS DIFFERENT?

There are plenty of “Excel tips” listicles online. This is not that.

Every shortcut in this guide was specifically selected because:

• Most people — including regular users — have never seen it
• It solves a real problem that real people encounter every week
• It saves meaningful time, not just a click or two

Every chapter is colour-coded (blue for Word, green for Excel). Every exclusive trick is marked with a red ★ star. The layout is clean, distraction-free, and designed to be readable on screen or printed at your desk.

WHAT YOU GET

18-page instant PDF download — read on any device or print at home

Word content — 3 chapters covering navigation, formatting, styles, tables, Find & Replace and automation Excel content — 4 chapters covering navigation, formulas, data, PivotTables, workbook power and auditing 3 printable Quick Reference Cards — Word shortcuts, Excel shortcuts, Excel hidden formulas

Exclusive ★ tricks — the hidden features most users never find in years of daily use

Works on Windows and Mac — every shortcut confirmed for both platforms

Lifetime access — download once, yours forever

Supports Won Connect CIC — every purchase funds free digital skills programmes across the UK