Training Overview

Managing your data is a key to success in any business and Microsoft Excel, if used correctly, can be an exceptionally robust tool for storing, managing and examining your data.

The Working with Microsoft Excel – Level 2 workshop is targeted towards individuals who are familiar with the basics of Excel but wish to deepen or refresh their base of knowledge.

This workshop will give participants the skills and confidence they need to find success with Microsoft Excel.

Outcomes

On completion of this training, you should be able to:

  • Create advanced formulas
  • Utilize and maintain database records
  • Add graphic elements to your worksheets for greater visual impact
  • Work with Named Ranges
  • Use VLOOKUP, HLOOKUP, PMT, FV, and IF Functions
  • Insert and modify graphic objects such as SmartArt and images
  • Organize worksheet data with tables
  • Visualize data with charts

Intended Audience

This course is for individuals who are familiar with the basics of Excel and who wish to learn additional functions and tools to more fully organize and analyze their data.

Session Information

  • 1-day online instructor-led session
  • Optional follow up Coaching Session to reinforce learning
  • Customised options for shorter in-house training are also available

Level 2 – Units

Section 1: Creating Advanced Formulas

  • Apply Range Names
  • Use Specialized Functions

Section 2: Analyzing Data with Logical and Lookup Functions

  • Use Logical Functions
  • Use Lookup Functions
  • Use Date Functions

Section 3: Organizing Worksheet Data with Tables

  • Create and Modify Tables
  • Sort and Filter Data

Section 4: Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Create a Trendline

Section 5: Auditing Worksheets

  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline

Section 6: Inserting Graphics

  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Incorporate SmartArt

Additional Materials

  • Enrollment in our Monthly LearningLink Newsletter
  • Lifetime Support
  • A Free Follow-up 30-minute Coaching Session

Follow-up Coaching

There is a key difference between learning and knowing. Learning is the process of being taught the material while knowing is about internalizing and retaining it. If at any point after a session you feel the need for more support in knowing the lessons taught to you, a free 30-minute coaching session is available to you on request.