Course Outline
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 Lists, Macros, Pivot Tables, Charts and much more.
Upon successful completion of this course, students will have the skills necessary to:
• Creating, Maintaining, Filtering and using Subtotals in a List
• Recording, Assigning and Using Macros
• Creating and Using User Defined Functions
• Performing “What If” Analyses
• Working with Scenarios
• Querying a Database
• Importing and Exporting Files and Data
• Protecting Data
• Pivot Tables, Reports and Charts.
• Other Advanced Business Analysis Tools.
Delegates should have an understanding of the Windows operating system. Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Microsoft Excel Level 1 & Microsoft Excel Level 2 courses.
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 and much more.
Upon successful completion of this course, students will have the skills necessary to:
• Creating, Maintaining, Filtering and using Subtotals in a List
• Recording, Assigning and Using Macros
• Creating and Using User Defined Functions
• Performing “What If” Analyses
• Working with Scenarios
• Querying a Database
• Importing and Exporting Files and Data
• Protecting Data
• Pivot Tables, Reports and Charts.
• Other Advanced Business Analysis Tools.
Delegates should have an understanding of the Windows operating system. Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Excel Level 1 & Excel Level 2 courses.
Working with Lists
Creating a List
Maintaining a List
Editing Records Using the Data Form
Filtering a List
Using Subtotals in a List
Assignment
Working with Macros and User Defined Functions
Recording and Using Macros
Assigning Macros
Using User Defined Functions
Assignment
Using Basic Analysis Tools
Performing “What If” Analyses
Working with Scenarios
Assignment
Using Advanced Analysis Tools and External Data
Querying a Database
Importing and Exporting Files
Protecting Data
Using Data Validation
Using Worksheet Protection
Password Protecting a Workbook
Assignment
Using Business Analysis Tools
Working with Pivot Tables and Pivot Charts
Identifying the Parts of a Basic Pivot Table
Pivot Table Reports
Create a PivotTable from worksheet data
Create a PivotTable from an external data source
Create a PivotChart report from an existing PivotTable report
Delete a PivotTable or PivotChart report
Slicers
Using slicers
Formatting slicers for a consistent look
Sparklines
Types of Sparklines
Create a sparkline
Customize sparklines
Control which value points are shown
Change the style of or format sparklines
Price per delegate
£350
Scheduled Classes
Remote Access:
02 May 2023
04 Jul 2023
05 Sep 2023
07 Nov 2023
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