Skip to main content

Courses

The following are courses we currently have available

Loading Courses

« All Courses

  • This course has passed.

Excel Level 3

30th July 2019

€140

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

Details

Date:
30th July 2019
Cost:
€140
Courses Category:

Location

New Horizons
22-24 Strand Street Great,
Dublin, 1 Ireland
+ Google Map

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are not yet available