Microsoft Excel Intermediate

The topics listed under this level of training are a snapshot only of the skills which fall under the Microsoft Excel Intermediate category. If you are interested in this level of training, please contact us to register your interest using the form below. As we provide customised training, for multi-student training sessions the next step after you contact us involves us assessing your current skills to determine exactly which topics you require training in. After you have completed this level of training, you may want to up-skill to the next level: Microsoft Excel Advanced. If this level of training is too complex for you, you may want to consider the Microsoft Excel Basics course.

This level includes:

Excel Tools for Ease of Use

  • Intermediate level Conditional formatting
  • Locking cells
  • Protecting worksheets
  • Format Painter
  • Splitting panes
  • Freezing panes
  • Hiding columns/rows
  • Tables

Intermediate Excel Features

  • Text alignment & indentation
  • Text direction
  • Bullets & numbering in Excel
  • Custom cell borders
  • Applying gradients fills to cells
  • Clearing cell formats
  • Introduction to Conditional Formatting
  • increase/decrease row heights
  • increase/decrease column widths

Page Setup & Preparing for Printing

  • Horizontal & Vertical page alignment
  • Customising headers & footers with codes
  • Document Properties (viewing/changing)
  • Adding page numbers
  • Rows to repeat at top
  • Printing row & column headings
  • Setting & resetting the Print Area

Excel Tables

  • Inserting a table into a spreadsheet
  • Navigating tables
  • Inserting cells/rows/columns into a table
  • Deleting cells/rows/columns into a table
  • Shading cells/rows/columns with built-in formats for headings/cells
  • Extending Table perimeters
  • Formatting a table with a built in table design
  • Erase a table but keep its contents
  • Applying a Header Row
  • Applying a Total Row

Formulas & Functions

  • BOMDAS
  • Absolute cell references
  • Relative cell references
  • Formulas from scratch using:
    • Addition
    • Subtraction
    • Multiplication
    • Division
  • Intermediate level Functions
  • IF Statements
  • ROUND up/down
  • PMT
  • % of Total formula

Images

  • Images
    • Text wrap
    • Resizing & moving images
    • Editing/exposure correcting/retinting
    • Watermarking with images
    • Inserting WordArt
    • Inserting Shapes
    • Inserting Screenshots
    • Inserting SmartArt

Printing

  • Selecting your printer
  • Setting a default printer
  • Specifying the amount of copies
  • Setting the print area
  • Clearing the print area
  • Print preview
  • Scaling page to fit
  • Orientation
  • Printing only the formulas
  • Gridlines & Black/White printing
  • How to make all data fit onto a page
  • Adjusting margins/headers/footers

Sorting & Filtering Data

  • Setting filtering criteria
  • Using text filters
  • Using colour filters
  • Using number filters
  • Resetting a filter
  • Deleting a filter
  • Setting a custom filter
  • Setting multiple filters
  • Sorting data
  • Conditionally Sort/Filter

Fill Series

  • AutoFill
  • Fill Series options
  • Formula filling
  • Right-Click filling

Intermediate Level Charts

  • Charts recap
  • Types of charts
  • Chart source data
  • Chart titles & legend
  • Chart axis & gridlines
  • Chart data labels & tables
  • Chart location
  • Chart resize/ move/ delete/ print
  • Selecting non-contiguous ranges
  • Add / remove data in a chart
  • Format data markers & parts
  • Adding effects to chart

Protection

  • Locking cells in preparation for protection
  • Locking a Workbook
  • Locking a Worksheet

Excel Tools

  • Sparklines
  • Select Formulas pane
  • Select Objects pane
  • Go to Special
  • Paste Link
  • Transpose Data

Request for Training

Your Name (required)

Your Email (required)

Your Contact Number (required)

Any prior experience with Excel?

Motivation for Training? (upskilling / applying for a job...)

How soon do you need this Excel Intermediate training?

How many people require this training?