Automating Excel with Macros and Analysis Tools

Automating Excel with Macros and Analysis Tools
Image from eventbrite.ie
Mon 27 May 2019
Monday 27 May 2019
9:00 AM - 5:00 PM
Ended

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 OBJECTIVES

Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.

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

More details click below:

https://www.nhireland.ie/training-and-certifications/course-outline/id/1020884112/c/excel-2016-automating-excel-with-macros-and-analysis-tools

721 Views - 28/05/2019 Last update
sports courses
New Horizons Ireland
22-24 Strand Street Great, Strand House, Dublin 1, County Dublin, Ireland

Event from
eventbrite.ie

Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event

Nearby hotels and apartments

22-24 Strand Street Great, Strand House, Dublin 1, County Dublin, Ireland

Browse other venues in Dublin
Discover now

The best nearby experiences from our partners

Get your guide
Viator
WhitLocals
Tiqets
Musement
bed egges

Discover more events in Dublin
Discover now



New Horizons Ireland
22-24 Strand Street Great, Strand House, Dublin 1, County Dublin, Ireland

Event from
eventbrite.ie

Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event
 
 
 
 
Your changes have been saved.