Introduction To this Course
  • Welcome To This Course!
  • Important: Let's Get To Know Each Other!
  • What I Recommend When Watching This Course
Functionality & Formatting Basics
  • Introduction To The Basics
  • Download This First: Spreadsheet For This Section
  • Getting Started & Auto-Fill
  • Getting Smart With Alignment-Based Formatting
  • Customising The Format With Borders
  • How To Effectively Manipulate Rows And Columns
  • Quick Hack #1: Insert Several Rows More Effectively
  • Beginners' Guide: Cell-Level Formatting
  • The Fundamental Excel Tool You Must Be Aware Of
  • Quick Hack #2: The Double Click Trick
  • Use Hide & Group To Your Advantage
  • Quick Hack #3: Effortlessly Select The Whole Sheet
  • Do This Before Moving On!
Manipulating Data In Excel - The Hacks You Need To Know
  • Introduction
  • Download This First: Spreadsheets For This Section
  • The Tool To Effortlessly Replicate Formulas & Values
  • Quick Hack #4: Auto-Fill... With A Twist!
  • The Easy Solution To Transposing Your Tables
  • Excel Hack #1: The Essential Functionality I Heavily Used To Build Spreadsheets
  • Quick Hack #5: Searching With Wildcard
  • PDF: 12 'Must-Know' Excel Shortcuts
  • How To Make Sense Of Data-Packed Tables
  • Sorting Efficiently In Excel
  • Quick Hack #6: Fast Navigation With A Few Keys
  • Ultimate Guide: Filtering
  • How To Get Rid Of Duplicates In Your Data
  • Using Subtotals To Your Advantage
  • Quick Hack #7: How To Copy Visible Cells Only
  • Excel Hack #2: Introducing Flash-Fill
Introduction To Formulas In Excel
  • Introduction To This Chapter
  • Download This First: Spreadsheet For This Section
  • Formula Syntax Explained
  • PDF: Formula Cheat Sheet #1
  • A Complete Guide To Absolute & Relative Referencing
  • 3 Essential Formulas To Master
  • Quick Hack #8: Verify Formulas Fast
  • 2 Ways To Identify Maximum & Minimum Values
  • How To Use The IF Function The Right Way
  • 3 Operators To Expand Your Condition-Based Formulas
  • No-Nonsense Guide To Solving Nested IFs
  • Excel Hack #3: Organised Formula Writing For Enhanced Visibility & Productivity
Manipulate Text Using Formulas
  • Introduction
  • Download This First: Spreadsheet For This Section
  • PDF: Formula Cheat Sheet #2
  • Formulas To Ensure Proper Formatting
  • How To Stick Text Strings Together
  • Quick Hack #9: Combine Strings Without A Formula
  • 3 Ways To Extract Bits Of Text
  • Ultimate Guide: Extracting Text By Identifying Specific Strings
  • Quick Hack #10: Ensure Text Accuracy
  • The Built-In Functionality To Customise Text Strings
Advanced Excel Formulas For Heavy Users
  • Introduction
  • Download This First: Spreadsheet For This Section
  • Time Saver: How To Define Names In Excel
  • Beginners Guide: Using VLookup
  • Quick Hack #11: Vlookups For 100% Accuracy
  • How To Identify Row & Column Indicators With Unique Values
  • Quick Hack #12: The VLookup & Match Combo
  • When To Use Nested VLookups
  • Excel Hack #4: Extract Values From A Database With Row & Column Indicators
  • The Tidiest Way To Deal With Errors
  • Excel Hack #5: Looking Up Values With 2+ Unique Criteria
  • The Fastest Way To Sum Up Different Sheets
  • The Easy Way To Transpose Tables With Formulas
  • Quick Hack #13: Excel Goal-Seeker
  • Important: This Will Only Take You 2 Minutes
Excel Tables & Conditional Formatting
  • Introduction
  • Download This First: Spreadsheet For This Section
  • Beginners' Guide: Excel Table Creation
  • Table Design Basics
  • Quick Hack #14: Adding Total Rows To Tables
  • Quick Hack #15: 3 Awesome Table Functionalities
  • Conditional Formatting Essentials
  • How To Manage Conditional Formatting
  • Conditional Formatting With Formulas
  • Excel Hack #6: 3 Features To Take Conditional Formatting To The Next LEvel
  • Excel Chart Creation Tutorial
  • Quick Hack #16: How Do I Know What Type Of Chart To Choose?
  • Customising Excel Charts
  • Excel Hack #7: How To Make Snap Judgements On Large Sets Of Data
The Secret Ingredient For Stunning Excel-Driven PowerPoint Charts
  • The Secret Ingredient Revealed
  • Download This First: Spreadsheet For This Section
  • How To Install The Software On Your Computer
  • The Most Effective Way To Create And Link Charts To PowerPoint
  • The Blueprint To Customising The Secret Charts
  • 15+ Ways To Customise & Format Your Secret Charts
  • 8 Secret Charts Exposed!
  • Case Study: Have Your Manager Get You The Secret Ingredient
  • 10 Secret Charts Preview