Microsoft Excel Advanced Level Course

icon-it.png

Prerequisites

Attendees should have attended, or have knowledge equivalent to the Intermediate Level course

This course can be delivered as a full day course or as individual 3 hour modules

Module 5 - Advanced Formulas

  • Understanding Conditional Logic, i.e. IF statements

  • Creating formulas using Basic Conditional Logic

  • Creating formulas using Nested IF statements

  • Creating formulas using Nested AND & OR statements

  • Using the =Countif feature to count data meeting specified criteria

  • Using the =Sumif feature to total data meeting specified criteria

  • Using the =Averageif feature to find the average of data meeting specified criteria

  • Apply Conditional Formatting

Module 6 - Using the Database Functions

  • Applying Data Validation to ensure the correct information is entered

  • Circling invalid data

  • Copying validation settings

  • Creation and use of VLOOKUP tables

  • XLOOKUP the new lookup tool (365 version only)

  • Creating and working with Excel Tables

  • Creation of Pivot Tables to display data in varying formats

  • Converting Text Strings to separate columns

  • Combining cells from multiple cells into one cell

  • Using Flash Fill to quickly split or join data

COST: Online £65 Face to face £95

PLEASE NOTE THAT TRAINING COURSES CAN BE ARRANGED TO SUIT COMPANY OR INDIVIDUAL NEEDS AND CAN BE ARRANGED IN COMPANY IF REQUIRED

If you require further information please contact us on 01686 668670 email mts@myrick.co.uk


ENQUIRY FORM:

 

 
Previous
Previous

1 Day Workshops

Next
Next

Microsoft Excel Intermediate Level Course