Microsoft Excel Intermediate 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 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

 

 
Previous
Previous

Microsoft Excel Advanced Level Course

Next
Next

Statistical Process Control