Intermediate Excel

Who is this course for?

This course is for you if you would like to take your knowledge of Microsoft Excel to the next level, have attended our “Brush up your Microsoft Excel” course or would like to “work smarter”.

What are the benefits

At the end of this course you will be able to highlight changing data using pre-set conditions and extract and manipulate data with formula and Pivot Tables

Enquire about this course

Course Enquiry

Please type your full name.
Invalid email address.
Invalid email address.
Invalid Input

Course Duration

1 Day

Course Content

Excel Interface and Terminology

  • Overview of Excel’s interface and terminology

Formula and Functions

  • Recap of the mathematical operators, SUM, MIN etc
  • Creating absolute and relative references
  • Make decisions using the IF statement
  • Extract data with VLOOKUP and HLOOKUP
  • Utilising the Function Wizard

Work with Multiple Worksheets

  • Use group editing to save time setting up worksheets
  • Inserting, renaming, moving, copying and deleting worksheets

Calculations across multiple Worksheets

  • Summarise data with 3D formula
  • Consolidate data to quickly calculate totals
  • Link workbooks and worksheets with formulas
  • Copying and linking Excel data to Word documents

Custom Lists

  • Speed up repeat data entry by creating Custom Lists

Sorting Data

  • Sort data alphabetically, numerically and by colour
  • Advanced data sorting on multiple columns and Custom Lists

Filters

  • Add custom filters to analyse data

Subtotalling Data

  • View and manipulate data quickly by grouping and outlining data
  • Analyse data with subtotals

Conditional Formatting

  • Set conditions to highlight data and show trends

Validation

  • Add Validation rules to restrict data entry
  • Eliminate entry errors with drop down data entry lists

Data Security

  • Work with Excel’s protection features to secure workbooks and worksheets
  • Create selective protection on worksheets Protect the structure and layout of worksheets

Introduction to Pivot Tables

  • Create Pivot Tables
  • Edit and update source data
  • Use Pivot filters to analyse data
  • Group Data

What our users say

 

  • A very good course, trainer had good knowledge and delivered well
  • I like the fact that you have selected topics/functions on the basis of their interest/possible use - course is much more than pertinent and a better use of time
  • Very friendly and helpful trainer
  • Ray is the only IT Trainer who has ever inspired me with enough confidence to learn effectively
  • It was very good, I really enjoyed it and learnt a lot
  • I will definitely use the Pivot Tables at work in the future! Thank you for such a great training day!
  • Will ensure my team all attend (they all work remotely)
  • Exactly what I was hoping to learn, thanks

  • Contact Us
  • 44 (0) 208 681 1485
  • 44 (0) 7794 0689 6985

E Mail Us