Harness the power of Excel to organise, analyse, and visualise data with greater ease.
MORE DETAILSDOWNLOAD BROCHUREAT 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.
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.
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.
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 - Basic
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
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
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
