Microsoft Excel 2016 Level 2

Microsoft Excel 2016 Level 2

Overview

Using multiple worksheets, workbooks and workspaces
Working with Financial functions
Use advanced formatting techniques
Using the Auditing Tools to track information
Using charts to display financial data
Using Macros to automate your work environment
Use Templates

Duration

1 Day

Target Audience

This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.

Prerequisites

Delegates should have an understanding of any of the following operating systems: Windows 2000 or above. Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Essentials course.

Topics

1: 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
Assignment

2: Charting
Using Charts
Creating a Chart
Changing Chart Type, Style and Chart Sub-Type
Changes to 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

3: 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
Assignment

4: 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

Appendix A: New Features in Excel 2016
New Chart Types
Get and Transform
One Click Forecasting
3D Maps
PivotTable Enhancements
Power BI
Quick Shape Formatting
Ink Equations
Data Loss Protection
Compatibility
File Types
The Ribbon and Toolbars
Screen Resolutions
Keyboard Shortcuts

Appendix B: Additional Features in Office 2016
Office 2016 – A New Platform
At a Glance Highlights Across the Suite
New Visual and navigational Features
File formats
User Assistance System (HELP)
Collaboration features
Themes and Quick Styles
General Keyboard Navigational Tips in Office 2016

 

Course Details

Course Ref:

MSE2016L2

Course Duration:

1 Day

Course Location:

Sunderland

Course Dates:

27th Sep 2018 - 27th Sep 2018

Course Price (Excl VAT):

£195

Book this course

Course Downloads

Send course details to a colleague

Telephone

   To book or for further information, please telephone 0191 515 3355 or e-mail us at sales@mtc-training.co.uk