Microsoft Excel 2010 Modules Training Course Outline

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

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 2010 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
  • Customise the Ribbon
  • Changing the file type and converting to PDF
  • Entering dates, numbers and text
  • Font formatting
  • Cell alignment
  • Number formatting
  • Entering formulas
  • Printing documents

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

  • Quick 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
  • Adding text boxes and arrows
  • Printing chart
  • Creating chart templates
  • Inserting Sparklines

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 PivotTables
  • Reorganising the PivotTable
  • Formatting the data in PivotTables
  • Refreshing a PivotTable
  • Grouping PivotTable data such as dates into calendar periods
  • Slicers
  • 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

  • Conditional formatting
  • Data Validation
  • Creating drop down lists
  • Goal Seek
  • Data tables
  • Scenarios
  • Protection
  • Sharing Workbooks
  • Tracking Changes
  • Removing duplicates
, Microsoft Excel 2010 Modules Training Course Outline
, Microsoft Excel 2010 Modules Training Course Outline