Microsoft Excel 2010 UpgradeDownload Course Outline

This is the outline of our Excel 2010 Upgrade course - Duration: 1 day

With Microsoft Office Excel 2010, following from Excel 2007, there has been a major overhaul of the user interface and many things have changed. The menus, toolbars and task panes have been replaced by a single palette of commands called The Ribbon. This is intuitive and very powerful but different from previous versions. So when you upgrade you will be both frustrated and confused depending on your level of experience.  This course will allay your fears and resolve your frustration with using the new software. You will learn about the new features in Excel that are going to greatly increase your productivity and efficiency in using Microsoft Excel 2010.

To get the best from this course you should be a reasonably competent user of Excel 2003 or earlier.

We specialise on on-site training and can come to you to run our course either on your PC's or provide our own high specification equipment. If you want specific training for your staff, we're happy to customise this course to your requirements, adding or removing topics as necessary.

Microsoft Excel 2010 Upgrade course content

Download a PDF course outline using the link on the right.

The New Office 2010 Interface

  • Use the Ribbon that replaces toolbars and menus.
  • Use “Contextual Tabs” that only appear when those commands are relevant.
  • Put frequently used commands on the Quick Access Toolbar so you can find them again easily.

Compatibility

  • Save your Office 2010 spreadsheets in earlier versions.
  • Work with spreadsheets created in previous versions.
  • Export spreadsheets to PDF and send PDF attachments.

Excel Table Styles

  • Sort data into alphabetical or numeric order.
  • Filter data to show only the data you want to see.
  • Filter and sort data by colour.
  • Use Table Styles to format large amounts of data for readability.
  • Use Table Styles to analyse totals eg averages, maximum and minimum.

Conditional Formatting

  • Apply conditional formatting to analyse specific data.
  • Use coloured gradients (heat maps), data bars, and icons to find specific data.
  • Use conditional formatting for comparing data.

Excel Sparklines

  • Create “mini” charts to instantaneously represent data visually.

Pivot Tables

  • Create a simple Pivot Table to analyse database information.
  • Insert a “Slicer” to further filter data.

Entry of Formulas

  • Accurately enter an Excel formula or function.
  • Use the Autofill to quickly replicate formulas and enter sequential data.
  • Absolute References
  • Accurately enter a formula that uses absolute references.
  • The IF Function
  • Construct an IF function correctly so that you can enter data into cells based on the result of a test.

The Countifs and Sumifs Functions

  • Correctly construct the Countifs function to count up specific values in a range of values.
  • Correctly construct the SumIfs function to add up specific values in a range of values.

Page Layout View

  • Use Page Layout View to work with spreadsheets.

We also offer this course as Live Online Learning - follow this link to learn more.