Introduction to the Course
  • Introduction
  • Course Resources & Important Notes for New Student
  • Excel 2019 Useful keyboard Shortcuts and Tips
Excel Interface Hacks
  • Customizing the Quick Access Toolbar
  • Customizing the Ribbon
  • Using Keyboard to Access Ribbon
  • The Best Techniques for Inserting, Deleting & Hiding Columns and Rows
  • Undo, Redo and Repeat
  • Summary
  • Excel Interface Hacks
Excel Workbooks Hacks
  • 4 Ways To Protect Excel Workbooks, Worksheets And Cells
  • Navigate between Workbooks Quickly
  • Applying Document Themes in a Workbook
  • Saving Excel as a Read-only Webpage File
  • Zooming In and Out Quickly
  • Summary
  • Excel Workbooks Hacks
Excel Worksheets Hacks
  • Navigate between Worksheets Quickly
  • How to Create a Hyperlink to Other Worksheets
  • How to Prevent Someone from Unhiding a Worksheet – Very Hidden Property
  • Copying and Moving Worksheets in Various Ways
  • Entering Data to Multiple Worksheets at a Time
  • How to Print a 2-page Worksheet on 1 page
  • Hiding Scrollbars in a Worksheet
  • How to Set the Number of Worksheets
  • Learning Different Techniques for Navigating within a Given Worksheet
  • How to Create and Save Custom Views of a Worksheet
  • Summary
  • Excel Worksheets Hacks
Excel Formatting Hacks
  • Solving the Problem with Leading Zero
  • How to Add Text to a Number
  • How to Enter a Line Break into One of Your Cell’s Data
  • Using Wrap Text and Shrink Cell Tools to Have the Size of the Cells
  • Creating a Conditional Format based on a value
  • Blocking a User from Interacting Outside a Specific Range
  • How to Hide the Status Bar
  • Changing Values without Formulas
  • How to Highlight Formula Cells using Conditional Formatting
  • How to Color Rows using Conditional Formatting - Alternate Row Shading
  • How to Format Numbers using Keystroke Shortcuts
  • How to Modify or Create a Cell Style
  • Duplicate Records and How to Get Rid of These
  • Creating Bulleted List
  • Format Painter Tips
  • How to Insert a Watermark
  • Making Your Comments Stand Out
  • Creating a Custom List
  • Summary
  • Excel Formatting Hacks
Excel Productivity Hacks
  • The Paste Special Feature
  • How to Display a Print Preview using Keyboard Shortcuts
  • Using Fill Handle to Enter Sequences of Values
  • How to Use FlashFill to Fill Values in a Range Rapidly
  • How to Select Data using Various Keystroke Shortcuts
  • How to Set a Specific Print Area
  • Entering Data Quickly and Efficiently
  • Copying and Moving Data with Various Ways
  • Using Pick from Drop-down List and Enter Data Quickly
  • Using AutoCorrect to Enter Data Fast
  • How to Freeze Titles and Split Screens
  • How to Create a Data Entry Form
  • Filling non-adjacent Cells with the Current Entry
  • Highlighting Blank Cells and Sorting Columns with Them
  • Summary
  • Excel Productivity Hacks
Excel Formulas Hacks
  • Filling Random Values into Every Cell in a Selection
  • How to Generate Random Decimal Numbers between 0 and 1
  • How to use COUNTIF and Data Validation to Prevent Duplications
  • How to Add Comments Inside Formulas
  • The AutoSum Magic
  • Identifying and Fixing Error inside of an Excel Formula
  • Finding Related Formulas Easy
  • How to Enter the Current Date or Time
  • Using the new-in-Excel-2016 Function PDURATION to Calculate Time
  • How to Round Values with Various Ways
  • Converting Formulas to Values Easily
  • Using Named Ranges in Formulas
  • Displaying All Worksheet Formulas in a Second
  • Using TRIM Function to Get Rid of Unwanted Spaces
  • How to Calculate a Person's Age
  • How to Convert Values between Measurement Systems
  • Locking and Hiding Formula Cells
  • Summary
  • Excel Formulas Hacks
Excel Tables & Pivot Tables Hacks
  • Create Table & Formatting Data as Table with Table Styles
  • Using the Structure Reference to Create a Formula
  • How to Create Separate Worksheets from PivotTable using Filters Area
  • Summary
  • Excel Tables & Pivot Tables Hacks
Excel Visualization Hacks
  • How to Move or Resize a Chart using Special Keys
  • Create Mini Charts using Sparklines