9
JUN

Masterclass in Excel Tips & Tricks Intermediate – 9th & 10th June

Date: 9th & 10th June

Time: 09:30 -12:30 (Both dates)

Location: Online

Price: €65.00

Book Online: Wexford Chamber Skillnet

 

 

 

This course is not suitable for beginners

 

INTERMEDIATE – Online Workshop Duration 2 x Half day workshops 9th & 10th June 9.30-12.30 (both days)

Objectives

 

Many experienced excel users are self-taught. They know how to use most of the main Excel tools, but they don’t know how to use many of them to the best effect, or just aren’t using the power of excel to help them do their work. Taught by someone who has been working with and teaching Excel for 30 years, you will be amazed by how much you will learn.

 

Content

 

  • Overview – Tips & Tricks

  • Customise Excel

  • Formula – Best Approach

  • Functions

    • Stats

    • Date

    • Text

  • Freeze Panes

  • Formatting

  • Audit Options

  • Sub-Totals – Paste Options

  • IF Statements

  • VLOOKUP’s

  • Pivot Tables

  • Pivot Charts

  • Reports

  • Conditional Formatting