• Virtual
  • June 23, 2022 - June 24, 2022
  • 10:00 AM to1:00 PM (Everyday)

Contact event manager

Tickets details

  • STANDARD 15 remaining
    $400
View cart
Thank you Kindly

Microsoft Excel – Intermediate (Virtual)

VIRTUAL (AEST)

Thu, 23 June, 2022 to Fri, 24 June, 2022
June 23, 2022

000000

Microsoft Excel – Intermediate (Virtual)

VIRTUAL (AEST)

Thu, 23 June, 2022 to Fri, 24 June, 2022
June 23, 2022

PRINT

Excel intermediate is for people who already work with Excel quite comfortably (are happy modifying worksheets and creating simple formulas) but want to start working more
efficiently and using a broader selection of tools. In this course we will get on top of our data, harnessing some important automation tools and looking at a broad range of Excel
functions for cleaning, transforming, summarising, categorising and linking data. We will also look at lots of tips and tricks to help you work more efficiently.

FILLING DATA
• Use the fill handle to quickly generate data
• Look at fill options and Flash Fill
• Work with Custom Lists

TEXT AND DATE FUNCTIONS
• Functions for joining text
• Functions for changing case
• Functions for splitting text
• Date functions

NAMED RANGES
• Creating Named Ranges using the Name Box
• Create from Selection
• Using the Name Manager
• Using Named Ranges in Calculations

AGGREGATION FUNCTIONS
• Different COUNT functions
• COUNTIFS, SUMIFS & AVERAGEIFS

TABLES
• Converting from a range to a table
• Customising tables and working with the total row
• Sorting and Filtering table data
• Slicers
• Automating processes with tables

LOOKUP FUNCTIONS
• VLOOKUP range lookup
• VLOOKUP exact match

CHARTS
• Create combination charts
• Customise Charts
• Work with more specialised chart types

Ideal for individual delegates who have specific requirements from the software, or where previous knowledge makes group training inappropriate. The pace and content can be adjusted to the individuals exact needs.

• 1-day Face to Face instructor-led program
• 2 x 3-hour web-based virtual sessions

  • Comprehensive Learning Guide