Microsoft Excel Intermediate Level Course
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 3 - Creating Formulas
Using the AutoSum feature to automatically add values
Understanding Formulas and their rules
Creating Basic Formulas
Copying and Pasting Formulas
Using and Creating Absolute Formulas to enable a specific value to be used many times, i.e. VAT rate (using a dollar sign in a formula)
Finding Minimum, Maximum and Average values of a list of data
Using the Audit Feature to display cells used within Formulas
Using named ranges within a formula
Preventing error messages using IFERROR
Using the Function Library
Inserting and Formatting Dates and Times
Using Dates within Formulas
Module 4 - Links, Graphs & Basic Conditional Logic
Working with Hyperlinks
Remove Duplicate Values for line of data
Using AutoFilter to view a specific set of data
Using AutoFilter to view a specific set of data
Sorting a Spreadsheet
Use of the Transpose feature to flip the orientation of data
Inserting Automatic Subtotals
Linking Workbooks
Protecting Formulas and Worksheets
Working with Multiple Worksheets within a Single Workbook, Renaming, Inserting, Copying Information
Create summary worksheets using 3D formulas
Creating and formatting Charts
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:
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