Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

Are you currently using Microsoft Excel to a confident and comfortable level? Well our Excel Advanced course is perfect for those looking to learn advanced features and data functions to completely transform the way they use Microsoft Excel. 

Upon completion, all delegates will receive a certificate of attendance, an extensive manual and the skills to progress into Excel Macros.

Learning Objectives

Advanced Functions
- Nested IF statements for nesting IF with AND, OR, ISERROR and IFERROR
- SUMIF and SUMIFS
- COUNTIF and COUNTIFS

Date Functions
- DATEDIF
- Date Functions

Lookup and Information Functions
- Advanced Lookup (True and False)
- Creating Multiple Column Lookups
- MATCH Function
- INDEX Function
- OFFSET Function
- Advanced List Management
- Advanced Filter
- Database Functions

SubTotals
- Creating Subtotals
- Outline View

Advanced Pivot Tables
- Inserting Calculated Fields
- Manipulating Fields
- Changing Value Field Settings
- Grouping Data containing Dates and Numbers
- Formatting Pivot Table
- Showing and Hiding the Grand Totals
- Changing The Scope Of The Data source
- Summarizing Values by Sum, Count, Average, Max, and Product
- Show Values As % of Grand Total, % of Column Total, % of Row Total
- Creating Pivot Table Reports and Pivot Chart Reports

General Analysis Tools
- Scenarios
- Custom Views
- Goal Seek
- Solver
- Data Tables, One Input, Two Input

Protecting and Sharing
- Sharing a File
- Track Changes
- Protecting Cells, Worksheets
- Password Protecting a File/Read Only

Formulae Auditing
- Formula View
- Tracing Precedents
- Tracing Dependents
- Using Watch Window
- Go to Special

Introduction to Macros
- Displaying the Developer Tab
- Recording a Macro
- Where To Save Macros – Personal, Existing or New Workbook
- Absolute and Relative Recording
- Introduction to Form Control Buttons
- Creating Macro Buttons

Funding Option

Funding Eligibility

Skill Price ex VAT (£)

Skill Length

Skill Level

Skill Timings

Delivery Method

Skill Eligibility (Prerequisites for skill/software requirements)

This course is perfect for those who have attended our Excel Intermediate course and are looking to progress by learning features such as advanced formula, data functions and how to analyse large spreadsheets with advanced pivot tables.

Last Application Date

Skill Enrolment

Skill Status

Skill Enquiry Details

First Name

Last Name

Telephone

Postcode

Are you a company owner or senior decision maker?

NoYes

No. of Delegates

What is your company name?

Would you like to explore skills support for your organisation through GM Business Growth Hub?

NoYes

I accept the Terms and Conditions and Privacy Policy

NoYes

Skill