Microsoft: Excel Advanced

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.

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.

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

For more information on this course click HERE

This one day training course provides a PDF manual and certificate of attendance.

For more information about this course call (0151) 650 6907 or email [email protected]

Terms and Conditions.Generally, our courses run from 09:30 until 16:30 unless otherwise stated. Some courses will be more than 1 day so please read the dates at the time of booking.

After booking via Eventbrite you will receive notification from them of your purchase. You will also receive joining instructions from the SquareOne team, confirming dates, times and location. We will also at that time check on any special needs or dietary requirements you may have.

In the unlikely event that this course is cancelled – then SquareOne will work with you to schedule new dates.

1 Day Classroom Training or Online

Our course timings are 09:30 - 16:30.

Nested IF statements for nesting IF with AND, OR, ISERROR and IFERROR

SUMIF and SUMIFS

COUNTIF and COUNTIFS

• DATEDIF
• Date Functions

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

• Creating Subtotals
• Outline View

• 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

• Scenarios
• Custom Views
• Goal Seek
• Solver
• Data Tables, One Input, Two Input

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

• Formula View
• Tracing Precedents
• Tracing Dependents
• Using Watch Window
• Go to Special

• 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

Event Venue & Nearby Stays

Friends Meeting House, 6 Mount Street, Manchester, United Kingdom