MS EXCEL - BEGINNER LEVEL

Skills can include

General Information:

  • Anatomy of an Excel screen - toolbars and menus
  • Using the Office ribbon
  • Using the Task Pane
  • Workbooks and worksheets - what is the difference-
  • Create a new spreadsheet, save and close
  • Open, edit, rename and closing program
  • Tricks to move around spreadsheet
  • Cut, copy and paste text
  • Exiting Excel

Basic Excel features

  • Using AutoSum
  • Autofill - dates, numbers, custom lists
  • Merging cells, adjusting column and row sizes
  • Moving and copying data
  • Creating formulas
  • Order of maths functions - BODMAS
  • Absolute and relative cell references
  • Working with large worksheets
  • Naming ranges
  • Formatting worksheets
  • Conditional formatting

Using Charts

  • Displaying data in chart style
  • Modifying or changing charts
  • Highlighting portions of charts
  • Charts on separate worksheets

Printing

  • Printing selected parts of worksheet
  • Printing whole workbook
  • Inserting page breaks
  • Printing only charts

MS EXCEL ADVANCED LEVEL

Skills can include

Creating simple formulae

  • Creating simple formula
  • Cell references - absolute and relative - what is the difference-
  • Using Range names in formula

Templates

  • Creating custom templates, eg wages sheet

Pivot Tables

  • Reporting on lists using Pivot Tables and Pivot Charts
  • Creating  and editing Pivot Tables
  • Creating and editing Pivot Charts

Using filters

  • Sorting lists
  • Applying criteria to filter data
  • Custom filters
  • Advanced filters

Advanced Functions:

  • IF
  • SUMIF
  • COUNTIF
  • AND
  • OR
  • ISBLANK
  • VLOOKUP
  • HLOOKUP
  • What If analysis - goal seeker, PMT

Macros

  • Recording a macro to do repetitive work
  • Putting macro on toolbar on a button