Microsoft Excel specialists

Conversion to Excel 2007/10/13 - agenda

Format: fully hands-on - computers are supplied
Duration: one day
Arrival and refreshments: 8:45 am Start: 9:00 am Finish: 4:30 pm

Your power-packed agenda  

Learn the Ribbon interface

  • Understand the new Ribbon.
  • Discover what happened to the File menu!
  • Know how to operate the Ribbon with keys.
  • Find Excel Options.
  • Look up the commands of earlier Excel versions.
  • Customise the Quick Access Toolbar (QAT).

Format cells to create readable worksheets

  • Use formats to distinguish inputs from calculations.
  • Apply number formats.
  • Format text to improve readability.

Know Excel limits and file formats

  • Learn the increased limits of Excel 2007/2010/2013.
  • Discover the file formats of Excel 2007/2010/2013.
  • Be aware of issues with cell references and named ranges in Excel 2007/10/13.

Apply Conditional Formatting to cells

  • Apply cell background colours In Excel/2013.
  • Use Excel 2007/2010/2013 Data Bars and Icon Sets to highlight KPIs.

Filter data to show only required information

  • Apply a numerical filter.
  • Find the top tier of values with a filter.
  • Use filters to delete and format.

Sort by multiple columns

  • Add sort levels as required.

Create a chart

  • Create a simple column chart In Excel/2013.
  • Apply formatting to charts.
  • Create Sparklines in Excel 2010/2013.

Convert a range into an Excel 2007/2010/2013 Table

  • Create a Table that provides automatic adjustment of ranges in formulas, PivotTables and other Excel components.

See new Excel 2007/2010/2013 functions

  • Discover new functions including SUMIFS and other.

Create a PivotTable

  • Select the data, create the PivotTable report and format it.
  • Refresh a PivotTable.
  • Show percentages of column totals.
  • Know the compatibility issues of Excel 2007/2010/2013 PivotTables in earlier Excel versions.
  • Use Slicers in Excel 2010/2013.

Who should attend:

  • Those who want to discover the new features of Excel 2007 or 2010 or 2013.

Learn in a positive environment

  • Be assured the advice you get is well-proven and utilised.
  • Feel free to ask questions.
  • Get time away from the office and constant interruptions.
  • Enjoy a friendly environment where you don’t feel you’re holding others up.
  • Instantly apply what you’ve learned on return to work.

The courses cover Microsoft Excel releases XP(2002) through 2013.
Where there are differences among the covered releases, they are pointed out.

Course cancellation policy:

A course booking is considered final when received in writing (online, email, fax or post) by AbleOwl, and can be cancelled up to ten working days before the course. After that, payment is expected in full and no refund will be given. All cancellations must be notified in writing, i.e. post, fax or email. Another delegate may be substituted at any time.