Improve productivity with Excel hacks that include creating dynamic emails, unstacking data, custom formatting, creating charts, transposing data, working with text, using advanced filters, managing external links, and more. Learn various Excel tricks to save time and enhance your Excel skills. This course is suitable for individuals looking to optimize their Excel usage and 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
