Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Tips, Tricks & Timesavers
Welcome
This Is How It's Going Down AKA Rules (2:48)
Part I: The Scope of Workbooks and Files
Customizing Excel (15:20)
Protecting Your Data in Excel (7:18)
Document Themes
Printer Settings - Must See! (14:25)
Part II: Formatting Options in Excel
Merging Cells in Excel (16:26)
Using Styles & Formatting Techniques (8:09)
Customizing Formats (13:33)
Conditional Formatting .. Just the Beginning (13:25)
Text & Value in the Same Cell (5:59)
Part III: Working with Formulas/Functions
SUM Tips & Tricks (7:50)
Absolute vs. Mixed References (13:25)
Error Free Formulas (9:12)
Worksheet Level Names (13:57)
Using Named Constants (9:36)
LookUp Functions (17:59)
Part IV: Working With Data Efficiently
Keyboard Shorts to Select Cells (7:53)
Transforming Data (12:42)
Drop Down Lists (14:19)
More Conditional Formatting (15:46)
Part V: Tables & PivotTables
Creating & Understanding Tables (11:07)
Creating PivotTables (12:02)
Grouping in PivotTables (9:40)
Slicers and Timelines in PivotTables (13:42)
Thank You!!
Let's Connect (3:05)
Teach online with
Customizing Formats
Download
Part II Formatting_Answer (2).xlsx
Download
Part II Formatting.xlsx
Excel Custom Formatting Shortcut List.pdf
Complete and Continue
Discussion
0
comments
Load more
0 comments