Introduction
  • Introduction
Make Your Own Default Book and Sheet Templates
  • Creating a Default Template
  • Updating the Default Template
  • Creating SHEET Templates
  • Creating Custom Templates
  • TEMPLATES Quiz
Customizing THEMES and SHAPES
  • Introduction to THEMES
  • Introduction to SHAPES
  • Sizing Shapes and Adding Text
  • Using WORDART with Shapes
  • Grouping Shapes and Custom Themes
  • Add Website Images and Colors
  • THEMES and SHAPES Quiz
Customizing CELL STYLES
  • How Cell Styles Can Save Time
  • Introduction to Cell Styles
  • Creating Custom Cell Styles
  • Merging Cell Styles Into Templates
  • CELL STYLES Quiz
Saving Custom Table Styles to Your Templates
  • How to Save Custom Table Styles to Your Templates
  • SAVING TABLE STYLES Quiz
Customizing Filter Views
  • Introduction to Custom Views
  • Setup Custom Filter Views
  • CUSTOM VIEWS Quiz
Customize the Quick Access Toolbar
  • How to Modify the Quick Access Toolbar
  • Add Commands to the Quick Access Toolbar
  • QUICK ACCESS TOOLBAR Quiz
Customize the Ribbon
  • Customizing Existing Ribbons
  • Creating a New Ribbon
  • CUSTOMIZE RIBBON Quiz
Creating and Using Simple Macros
  • The TWO Missing Pieces in Our Capability to Customize Excel
  • Editing or Replacing Macros in the Personal Workbook
  • How to Add Macros to a Custom Ribbon
  • SIMPLE MACROS Quiz
Conclusion
  • Conclusion
  • BONUS Lecture! Learn Even More!