Skip to content
Microsoft Excel Intermediate course background

Microsoft Excel training courses

Enliten IT offers many Microsoft Excel courses to enhance your data analysis and spreadsheet program skills to ‘Excel’ at work. Whether you’re new or experienced, these Excel courses cover everything from basic functions to advanced formulas and pivot tables.

Certified trainers provide corporate training at your location (we come to you!) or in virtual classrooms, ensuring flexibility. Learn data management, financial analysis, and data visualization using Microsoft Office Excel to boost your career prospects and master Microsoft Excel through tailored, advanced Excel skills and techniques.

We train on ALL versions of Microsoft Excel and to All levels – Excel introduction, Excel intermediate, Excel advanced and Excel Super User.

Microsoft Excel Intermediate course logo

Microsoft Excel Intermediate course

1 day

This Microsoft Excel Intermediate course looks at some of the more sophisticated features needed to simplify (and speed up) working with large amounts of data in terms of formatting, formulae and security.   We also cover useful analysis tools required when working in working with lists of data such as sorting, filters and pivot tables.

Download PDF Book now

What will you learn?

At the end of this Microsoft Excel Intermediate course, delegates will be able to take advantage of Excel’s features to better manage and protect their spreadsheets and to analyse data quickly and efficiently.

Audience?

Users needing to move to the next stage of Excel mastery to simplify their day to day usage of the product (and to save time) by using more advanced features including 3-d formulae, data handling and working with large sheets.

Course Contents

3d Worksheets

  • Copy, Move, Rename, Hide worksheets
  • Group editing and formatting
  • 3d calculations & 3d Autosum

Linking Workbooks

  • View multiple sheets simultaneously
  • Creating & Managing links

Range Names

  • Why use them?
  • Assigning names
  • Using names (in formulae and Go To)
  • Named constants

Data Validation

  • Controlling data entry
  • Customising messages and Error alerts
  • Creating Drop-down Lists (with range names)

Protection

  • Adding passwords to files
  • Protecting cells from being altered
  • Go To function for cell selection

Working with Data

  • Highlighting data blocks quickly
  • Sorting – Quick sort, multi field sort, colour sort
  • Autofilter
    • Using logical parameters
  • Subtotals – to summarise data

Pivot Tables / Charts

  • Understanding how they work
  • Manual report v Quick report
  • Adding & Moving fields
  • Summary functions inc. %
  • Formatting fields and reports
  • Filtering data
  • Charts
  • Editing and changing data
  • Refreshing data
  • Slicers

Sparklines

Optional Topics (time permitting)

  • Tables - Create, Modify and Format

Course Materials

Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable.   These may be either paper based or in Adobe pdf format or a combination thereof.

“"Trainer kept us engaged and explained things thoroughly.  Very insightful and extremely interactive. The trainer was helpful and demonstrated great knowledge."”

Tim, Kind Build, Excel Advanced

Prerequisites

This course assumes attendance of our Microsoft Excel Introductory course (or equivalent knowledge).

Additional Information

Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.

The suggested course duration is a guideline.   Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.