Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Course Outline

Excel 2013 Level 2

This is a 1 day, instructor-led course.

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

Upon successful completion of this course, students will have the skills necessary to: 
•   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

Delegates should have a basic understanding of the Windows Operating System and should have a good understanding of Microsoft Excel or alternatively should have attended our Microsoft Excel 2013 Level 1 course.

Excel 2013 Level 2

This is a 1 day, instructor-led course.

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

Upon successful completion of this course, students will have the skills necessary to: 
•   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

Delegates should have a basic understanding of the Windows Operating System and should have a good understanding of Microsoft Excel or alternatively should have attended our Microsoft Excel 2013 Level 1 course.

Course Contents

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
Creating and Opening a Workspace
Managing Multiple Worksheets and Workbooks
Selecting Multiple Worksheets
Moving and Copying Data between Worksheets
Linking Data Between Worksheets
Creating a 3-D Formula
Assignment

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

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

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

Price per delegate

£249

Scheduled Classes

Indicia Training, Glasgow:

Please complete the contact form below or call 0141 221 5676 for further course information and available dates.
Alternatively you can email us at info@indiciatraining.com

Contact Us