Library

Course: Excel Essentials - Level 4

Excel Essentials - Level 4

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

Learn how to create, format and use a basic Pivot Table. Pivot Tables are a wonderful tool for analyzing data in Excel. Also, learn the basics of creating automated routines with Macros - a powerful tool that is much easier to use than most people think!

Basic knowledge
  • This course was created with Excel 2016. However, Excel 2007, 2010, or 2013 will work with most, or all features
  • You will need Microsoft Excel installed on your computer to follow along and complete the exercise files
What you will learn
  • Pivot Table Basics
  • Pivot Table Slicers
  • Pivot Table Layout Options
  • Macro Recording
  • Macro Editing
Curriculum
Lectures quantity: 13
Common duration: 01:17:21
Excel Essentials Level 4
  • Excel Level 4 - Workbook  
  • Excel Level 4 - Introduction  
  • Excel Level 4 - Pivot Table Basics  
  • Excel Level 4 - Pivot Table Layout Options  
  • Excel Level 4 - Pivot Table Summary Functions  
  • Excel Level 4 - Pivot Table Report Page Filters  
  • Excel Level 4 - Pivot Table Slicers  
  • Excel Level 4 - Updating Pivot Table Data  
  • Excel Level 4 - Pivot Charts  
  • Excel Level 4 - Recording a Macro  
  • Excel Level 4 - Macro Editing  
  • Excel Level 4 - Creating Macro Buttons  
  • Excel Level 4 - Next Steps  
Reviews (0)