Microsoft Excel Modules Training Course Outline

Audience: This course is aimed at those who wishing to tailor Excel course to specific requirements, for ideas of course content below we have listed example areas.

We are happy to arrange for a trainer to contact you to help tailor you course.

Course Duration: 1 day.

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Excel modules training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Choose from the follow topics:

Getting started with Excel

  • Creating and saving workbooks
  • Opening and closing workbooks
  • Working with Backstage
  • Changing the file type and converting to PDF
  • Entering dates, numbers and text
  • Font formatting
  • Cell alignment
  • Number formatting
  • Entering formulas
  • Printing documents
  • Smart Lookup

Essential Excel formulas

  • Moving and copying data
  • Using Paste Special and Format Painter
  • Inserting, deleting and changing rows and columns
  • Borders and shading
  • Autofill and creating series
  • Entering and copying formulas
  • Relative and absolute cell references
  • Order of calculation
  • Using AutoSum
  • AVERAGE, COUNT, COUNTA, MIN and MAX functions

Excel Charts

  • Using Recommended Charts
  • Selecting the data to plot
  • Different types of charts
  • Adding titles and labels
  • Chart sheets and embedded charts
  • Gridlines, data tables and legends
  • Changing the chart type
  • Adjusting, adding and removing a data series
  • Formatting chart elements
  • Adding a picture to your chart

Excel Charts Continued…

  • Adding text boxes and arrows
  • Printing chart
  • Creating chart templates
  • Inserting Sparklines

Module 4: Analysing Excel data

  • Creating tables
  • Moving around and selecting a table
  • Adding a total row
  • Sorting data
  • Filtering data
  • Creating Subtotals
  • Creating nested subtotals
  • Analysing data with Pivot Tables
  • Reorganising the Pivot Table
  • Formatting the data in Pivot Tables
  • Refreshing a Pivot Table
  • Grouping Pivot Table data such as dates into calendar periods
  • Slicers and Timelines
  • Aggregation functions; SUMIFS and COUNTIFS

Further Excel formulas

  • Review of basic formulas and functions
  • The structure of functions
  • Nesting functions
  • IF and nested IF functions
  • Lookup functions
  • Date and Time functions
  • Information functions
  • Financial functions
  • Text functions
  • Arrays and array functions

Essential Excel utilities

  • Using FlashFill
  • Conditional formatting
  • Data Validation
  • Creating drop down lists
  • Goal Seek
  • Data tables
  • Scenarios
  • Protection
  • Sharing Workbooks
  • Tracking Changes
  • Removing duplicates
  • One Click Forecasting
, Microsoft Excel Modules Training Course
, Microsoft Excel Modules Training Course