"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

Excel Advanced Level 3

Course Overview

Target student 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 Windows operating system and a good understanding of Microsoft Excel or alternatively should have attended Excel level 1 and level 2 training or have equivalent knowledge.

 
Course Delivery:JCS training NN3 6QB and associate locations nationwide
 Related Courses
Excel 2013 VBA Part 1 and 2, Excel Mastering Financial Modelling
Duration: 1 Day
Course Objectives
Recording, Assigning and Using Macros
Templates
Data Consolidation
Performing “What If” Analysis
Advanced Formatting
Working with Scenarios
Querying a Database
Importing and Exporting Files and Data
Protecting Data
 
Target student
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 Windows operating system and a good understanding of Microsoft Excel or alternatively should have attended Excel level 1 and level 2 training or have equivalent knowledge.
 
Creating Templates
Creating a Template File
 
Working with Macros
Recording and Using Macros
Assigning a Macro to the Quick Access Toolbar
Editing/Deleting Macros
 
Data Consolidation
Using Data Consolidation by Position
Using Data Consolidation by Category
 
Using Data Analysis Tools
Working with Scenarios
Goalseek
Solver
Worksheet Protection
Protecting Data
Using Worksheet Protection
Password Protecting a Workbook
Sharing a workbook
Track Changes
 
Advanced Database options
Using Data Validation
Get External Data
Importing and Exporting Files
Using the Excel Table Feature
PivotTables
Creating PivotTables
Creating PivotCharts
Inserting Sparklines
Auditing Worksheets
Identifying the Auditing Commands
The Watch Window
The Formula Evaluator
Tracing and Correcting Worksheet Errors
Outlining
Manual outlining
Creating an auto outline
Clearing an outline