Microsoft Excel 2007 Modules Training course Outline

Audience: This course is aimed at those who wish to tailor their Excel 2007 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 your 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 2007 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
  • 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 pictures, text boxes and arrows
  • Printing charts
  • Creating chart templates

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 data such as dates into calendar periods
  • 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