Automating Excel with Macros and Analysis Tools

Automating Excel with Macros and Analysis Tools

Actions and Detail Panel

On Sale Oct 13 at 12:00 AM

Event Information

Share this event

Date and time

Location

Location

Online event

Event description
This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data.

About this event

TARGET AUDIENCE

To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.

COURSE OUTLINE

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

2 - USE FORMULA AUDITING AND ERROR CHECKING

Reveal Formulas

Trace Cell Precedents and Dependents

Locate Errors in Formulas

Watch and Evaluate Formulas

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

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

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

Share with friends

Date and time

Location

Online event

Save This Event

Event Saved