Excel 2016 Advanced

Objectives: This course will take learners to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.

Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology.

Unit Contents:

 1. Getting Started
In this topic you will cover a basic introduction to the course unit and its objectives.

 2. Using Multiple Worksheets and Workbooks
In this topic you will cover:
Using Multiple Worksheets and Workbooks
Using Multiple Worksheets
Inserting New Worksheets
Renaming Worksheets
Deleting Worksheets
Creating Multiple Views
Freezing Panes
Viewing and Arranging Multiple Worksheet Windows
Navigating in Multiple Workbooks
Selecting and Viewing Multiple Workbooks
Managing Multiple Worksheets and Workbooks
Selecting Multiple Worksheets
Moving and Copying Data between Worksheets
Linking Data Between Worksheets
Creating a 3-D Formula
Self-test Quiz

 3. Charting
In this topic you will cover:
Charting
Using Charts
Creating a Chart
Changing Chart Type, Style and Chart Sub-Type
Changesto the Chart Source Data
Add data to an existing chart
Change the data in an existing chart
Remove data from a chart
Managing Chart Objects    
Moving and Resizing Chart Objects
Deleting Chart Objects
Adding Data Series and Objects to a Chart
Changing the Chart Type
Formatting Chart Objects
Printing Charts
Self-test Quiz

 4. Advanced Functions
In this topic you will cover:
Advanced Functions
Creating and Using Functions
Using Built-in Functions
Working with Arguments: The PMT Function
Using Dates and Times
Using Dates in Calculations
Using Nested Functions
Auditing Worksheets
Identifying the Auditing Commands
The Watch Window
The Formula Evaluator
Tracing and Correcting Worksheet Errors
Self-test Quiz

 5. Advanced Formatting
In this topic you will cover:
Advanced Formatting
Using Comments in a Worksheet
Reviewing, Showing, and Hiding Comments
Deleting a Comment
Working with Styles
Applying a Style
Modifying Existing Styles
Using Format Painter
Creating Custom Number Formats
Applying an AutoFormat (Table Format)
Conditional Formats
Clear conditional formats
Self-test Quiz

 6. New Features in Excel 2016
In this topic you will cover:
In this topic you will cover:
New Features in Excel 2016
What’s New in Excel 2016
Compatibility
Benefits in the new version
File Types
The Ribbon
The Quick Access Toolbar
Different Screen Resolutions - Solutions
Keyboard shortcuts in Excel 2016 (KEY TIPS)
Self-test Quiz

 7. Wrapping Up / Assessment Result
In this topic you will cover:
Course Conclusion
Wrapping up
Test Results Summary