Excel Level 3: Advanced – Booked Out

Start date: 10 May 2022

Duration: 10th & 11th May (9:30am - 12:30pm)

Location: Online - Live Webinar

Certificate: N/A

Cost: €69 for Members (€89 for Non Chamber Members)

Course code: N/A

Programme overview

Excel is the most in commonly used and in demand tool for making sense of data. When you can harness that power, you will be a sought after employee. If you run a business, being proficient in Excel can help you see your business in a completely different light.

This workshop looks at some of the more advanced tools in Excel and some of those tools in greater depth. Important functions such as V Lookup, Pivot tables and IF statements are covered in some detail and there are many invaluable short cuts and best practice included in the sessions.

Learning Outcomes

  • Create a PivotTable
  • Create a PivotChart
  • Create a Macro
  • Audit Worksheets
  • Protect Worksheets and Workbooks
  • Use Consolidation
  • Apply Conditional Formatting
  • Apply Data Validation
  • Import and Export information

Who Is This Course For?

This course is perfect if you have an understanding of excel level 2 and would like to progress to a more advanced level

Modules

Modules

Session 1

Overview – Tips & Tricks

Customise Excel

Formula – Best Approach

Functions

  • Stats
  • Date
  • Test

Freeze Panes

Formatting

Audit Options

Sub-Totals

Data Functions

IF Statements

VLOOKUPS

Drop-Down Lists

Session 2

Advanced Filter

Macros

Consolidation

Import / Export

Pivot Table

Pivot Charts

Reports

Conditional Formatting

Book Now To Guarantee a Place

Book Now

Applications Closing on 09/05/2022

Enquire Now