Discover a wealth of Excel productivity hacks, tips, and tricks in this comprehensive 2.5-hour tutorial. Learn to create dynamic emails with a single formula, unstack data efficiently, apply custom formatting with thresholds and icons, and design unique sales funnel charts. Master data transposition techniques, manage dependent drop-downs, and explore sheet visibility options. Dive into advanced text and number manipulation, including converting numbers to words without VBA. Uncover surprising uses for Advanced Filter, extract external links effortlessly, and grasp 3D formulas. Explore hidden shortcuts for data selection, leverage the FILTER function for non-adjacent columns, and discover six essential free Excel add-ins. Enhance your Excel skills with techniques for formula copying, sheet protection, duplicate removal, and custom working day calculations, all designed to significantly boost your spreadsheet efficiency.
Overview
Syllabus
Fully Dynamic Emails from Excel with a SINGLE FORMULA!.
Quick Excel Trick to Unstack Data from one Column to Multiple Columns.
Excel Custom Formatting with Thresholds & Icons: Quick & easy.
How to Create a Sales Funnel Chart in Excel (Not the "usual" Funnel).
3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa).
Reset Dependent Drop-down in Excel (with a tiny bit of VBA).
3 Methods to Unhide All Sheets in Excel (& how to hide).
VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns).
Convert NUMBERS to WORDS (NO VBA) in Excel.
The QUICKEST & EASIEST Way to Work with TEXT in Excel.
SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!).
Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!).
Excel 3D Formulas Explained (Includes a Bonus Excel Hack!).
Mysterious Excel Formula Syntax to Count Text Cells (as NEVER Seen Before).
Excel Hidden Shortcut to Select Data Column including Blanks.
Complete: Excel Hidden SHORTCUTS to Select Data Column including Blanks.
Excel FILTER Function TRICK for Non Adjacent Columns.
6 FREE Add-Ins for Excel to Start Using Now.
Excel Hack: Copy Formula Without Changing Cell References (or Without File References).
GUESS what's HIDDEN in Excel? (Cool Trick).
Better Excel Presentations: Increase Font Size of Formula Bar.
EASILY UNLOCK Protected Excel Sheets WITHOUT Password.
3 EASY Ways to Find and Remove Duplicates in Excel.
How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too).
Taught by
Leila Gharani
