Tech Tools

Microsoft Excel

Harness the power of Excel to organise, analyse, and visualise data with greater ease.

MORE DETAILSDOWNLOAD BROCHURE

AT A GLANCE

In today’s competitive market, the ability to organise and interpret data contributes to better business results. Our Microsoft Excel courses teach the skills, resources, and tools required to harness the power of this essential business software. Learn how to make spreadsheets, organise data, create charts and more with our full range of Excel training options.

Audience

We have a wide range of Microsoft Excel courses for all levels:

  • New users
  • Those who have experience of Excel
  • Those who have a good level of Excel and want to develop their skills further

Format ​

  • Each course is 2 x 4-hour, instructor-led online sessions
  • Public workshops are available for all our Excel courses.

What’s Included

  • Comprehensive Learning Guide and Resource Manual
  • Subscription to our monthly LearningLink e-newsletter

Data-Driven Solutions - Data-Informed Decisions

Excel Level 1 – Basic: This workshop is intended to help all novice computer users get up to speed with Excel quickly. There are different features including creating a new spreadsheet, working with basic formulas and functions, making a spreadsheet look professional and presentable, and saving and printing.
FULL OUTLINE - EXCEL LEVEL 1 - BASIC
Excel Level 2 – Intermediate: In this course, you will create advanced formulas. analyze data with functions and PivotTables, work with tables, visualize data with charts, use graphical objects and enhance workbooks.
FULL OUTLINE - EXCEL LEVEL 2 - INTERMEDIATE
Excel Level 3 – Advanced: This workshop is intended to help all users get up to speed quickly on the advanced features of Excel. We will cover using Excel online, worksheet Automation, auditing and error checking, data analysis and presentation, working with multiple workbooks and exporting and sorting data.
FULL OUTLINE - EXCEL LEVEL 3 - ADVANCED

What You Will Learn

Excel Level 1 – Basic

After Level 1, you’ll be a proficient Excel basics user who can independently create, edit, and format basic worksheets; use simple formulas and functions; and efficiently organize, search, and print data

Excel Level 2 – Intermediate

After Level 2, you’ll be an advanced Excel user able to build complex formulas, professionally visualize data with PivotTables and charts, automate analyses, incorporate graphics, consolidate data from multiple sources, and optimize large datasets and workbooks.

Excel Level 3 – Advanced

After Level 3, you’ll be an Excel power user able to leverage the full breadth of Excel tools including macros, data modelling, external data connections, collaboration with Excel Online, auditing, advanced analysis, linking data across workbooks, and optimizing large datasets

Detailed Synopsis - Excel Level 1: Foundation

Format ​

  • Hands-on Instructor-led Sessions: 2 x 4-hour, instructor-led online sessions

What’s Included

  • Comprehensive Learning Guide and Resource Manual: Individual Virtual Learning Guide with training content to refer to, whenever you want.
  • Ongoing support: WorkingSm@rt Helpdesk, no matter where you work.​
  • LearningLink: Our monthly productivity e-newsletter to keep you updated.

Units

  • Unit 1 Getting Started
  • Unit 2 Working with Data.
  • Unit 3 Modifying a Worksheet
  • Unit 4 Printing Workbook Contents
  • Unit 5 Managing Large Workbooks
  • Unit 6 Customizing the Excel Environment

DOWNLOAD BROCHUREMake enquiry

Detailed Synopsis - Excel Level 2: Intermediate

Format ​

  • Hands-on Instructor-led Sessions: 2 x 4-hour, instructor-led online sessions

What’s Included

  • Comprehensive Learning Guide and Resource Manual: Individual Virtual Learning Guide with training content to refer to, whenever you want.
  • Ongoing support: WorkingSm@rt Helpdesk, no matter where you work.​
  • LearningLink: Our monthly productivity e-newsletter to keep you updated.

Units

  • Unit 1 Creating Advanced Formulas
  • Unit 2 Analyzing Data with Logical and Lookup Functions
  • Unit 3 Organizing Worksheet Data with Tables
  • Unit 4 Visualizing Data with Charts
  • Unit 5 Analyzing Data with PivotTables, Slicers, and PivotCharts
  • Unit 6 Working with Graphical Objects
  • Unit 7 Enhancing Workbooks

DOWNLOAD BROCHUREMake enquiry

Detailed Synopsis - Excel Level 3: Advanced

Format ​

  • Hands-on Instructor-led Sessions: 2 x 4-hour, instructor-led online sessions

What’s Included

  • Comprehensive Learning Guide and Resource Manual: Individual Virtual Learning Guide with training content to refer to, whenever you want.
  • Ongoing support: WorkingSm@rt Helpdesk, no matter where you work.​
  • LearningLink: Our monthly productivity e-newsletter to keep you updated.

Units

  • Unit 1 Excel Online
  • Unit 2 Worksheet Automation
  • Unit 3 Auditing and Error Checking
  • Unit 4 Data Analysis and Presentation
  • Unit 5 Working with Multiple Workbooks
  • Unit 6 Exporting and Sourcing Data

DOWNLOAD BROCHUREMake enquiry

How can we help?

MAKE AN ENQUIRY