Course description
Excel: Advanced (Level 3) - Online Training
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.
Suitability - Who should attend?
Prerequisites
This course is perfect for those who have attended ourExcel Intermediatecourse and are looking to progress by learning features such as advanced formula, data functions and how to analyse large spreadsheets with advanced pivot tables.
Course Objectives
Upon completion, all delegates will receive a certificate of attendance, an extensive manual and the skills to progress into Excel Macros.
Training Course Content
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
Why choose SquareOne Training
25 years' experience of delivering quality IT Training Services
All trainers Certified Microsoft Office Trainer (MOS) or higher
Public and in-house training throughout the UK
About provider
SquareOne Training
SquareOne believe that no two people are the same, therefore all our courses are unique just like you. SquareOne will work with you and your company to tailor a course that is suitable for your business needs, development and future...
Request info
Contact info
SquareOne Training
Reviews
Average rating 4.9
Based on 64 reviews.
Find out more about this Excel: Advanced (Online Training) course - simply fill out your details:
 |
Read the course |
|
 |
Fill in your details and Request information |
|
 |
Receive all the info you need |
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.
Read more
At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.
Read more