Excel Level 3 Training Course

Automating Excel with Macros and Analysis Tools

Duration:     1 day

Next Course Running on 30th July 2019

Course Content For Excel Level 3

Module 1: Working with Multiple Worksheets and Workbooks  

  • Working with Named Ranges
  • Link Cells Across Worksheets and Workbooks  
  • Use 3D References to Calculate Across Worksheets
  • Consolidate Data

Module 2: Use Formula Auditing and Error Checking

  • Reveal Formulas
  • Trace Cell Precedents and Dependents  
  • Locate Errors in Formulas  
  • Watch and Evaluate Formulas  

Module 3: Reviewing and Protecting Workbooks  

  • Control Data Entry via Data Validation
  • Protect Workbook Access
  • Protect Worksheets and Cell Content  
  • Add and Edit Comments
  • Prepare a Workbook for Distribution  
  • Modify Excel’s Default Settings

Module 4: Using Macros to Automate Workbook Functionality

  • Create Macros via Recording  
  • Run Macros via Buttons and Shortcuts
  • Assign Macros to the Quick Access Toolbar and Ribbon  
  • Assign Macros to Objects  
  • View Macro Code

Module 5: Forecasting and Analysis Data

  • Use Conditional Formatting to Highlight, Sort and Filter Key Data
  • Advanced Conditional Formatting using Formulas
  • Create Sparklines to Visualise Data
  • Add Trendlines to Charts to Visualise and Forecast Trends
  • Use Data Tables and Scenarios to Project Potential Outcomes  
  • Use Goal Seek to Calculate Outcomes
  • Forecast Data Trends Using Solver

Contact Maureen@dppskillnet.ie to book your place

Excel Level 2 Training Course

Excel Level 1 Training Course

Leave a Reply