About this course
The skills and knowledge acquired in Microsoft Excel Office 365 – Level 2 enable users to expand their knowledge and learn how to create more productive workbooks.
It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.
Successful completion of this course and the required assessments leads to a Statement of Attainment.
Face-to-Face Delivery:
- Learn from certified trainers with real-world experience.
- Participate in interactive learning experiences.
- Feel supported through your studies with our dedicated Student Support Days to provide one on one guidance.
Rather study online?
Check out our Microsoft Excel Office 365 – Intermediate Online Course for online delivery.
Prerequisites
Microsoft Excel Office 365 - Level 2 assumes the learner has the knowledge required to create, edit, print and chart simple worksheets. Understanding ranges and copying is also important.
General Description
The skills and knowledge acquired in Microsoft Excel Office 365 – Level 2 enable users to expand their knowledge and learn how to create more productive workbooks.
It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.
Learning Outcomes
At the completion of this course you should be able to:
- use the fill operations available to fill a data series
- use a range of techniques to work with worksheets
- apply a variety of page setup techniques
- apply borders to cells and ranges in a worksheet
- use common worksheet functions
- create more complex formulas and functions
- create and use defined names in a workbook
- apply a range of number formatting techniques to worksheet cells
- apply conditional formatting to ranges in a worksheet
- use goal seeking to determine the values required to reach a desired result
- understand and use Excel's Quick Analysis tools
- create and work with tables
- use a range of elements and features to enhance charts
- select and change the format of objects in a chart
Pre-Course Assessment Questions
Not sure what level of course you should complete?
Level 1
If you answer “no” to two of these questions, you should consider doing Excel Level One:
1. Can you create simple formulas in Excel?
2. Can you use the SUM, AVERAGE, MAX, MIN and COUNT functions?
3. Can you create a simple chart?
Level 2
If you answer “no” to two of these questions, you should consider doing Excel Level Two:
1. Can you use the IF and VLOOKUP functions?
2. Can you use Conditional Formatting?
3. Can you sort data and apply complex filters?
Level 3
If you answer “no” to two of these questions, you should consider doing Excel Level Three:
1. Can you create a Pivot Table?
2. Can you record and edit macros?
3. Can you link data across workbooks?
Latest Courses
