Excel Intermediate

Course Overview (1 day)     

This course is designed for anyone with a basic knowledge of how to use Microsoft Excel, particularly with those familiar with what is covered in our introduction course . At the end of the training course you will be more adept at manipulating data, using formulas such as SUMIF, AVERAGEIF, VLOOKUPS and COUNT()

We offer two weeks free consultation on completion.

Course Content

Review cell referencing, formulas, and formatting

Conditional Formatting

Named Ranges

Tables

Formatting

Conditional formatting

  • Highlight Cell Rules
  • Top/Bottom Rules
  • Data Bars

Functions

The anatomy of a function

The Insert Function dialog box/Help

SUMIF, SUMIFS, COUNTIF, COUNTIFS AVERAGEIF, AVERAGEIFS

VLOOKUPs, HLOOKUPs, LOOKUPs

MATCH, INDEX, OFFSET

Charts

The anatomy of a chart

Column charts

Bar charts

Pie charts

Class Project