Excel 2007 upgrade

Adkins Matchett & Toy

Course

Inhouse

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Inhouse

This Excel New Features course isolates the important changes that will affect bankers and is designed to make the transition to the 2007 version as smooth as possible. Excel 2003 will be a distant memory after completing this course! By the end of this course, participants will be able to: Work with the new Excel 2007 interface. Locate familiar Excel 2003 commands in Excel 2007. Use. Suitable for: Associate Training Program

About this course

None

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

This Excel New Features course isolates the important changes that will affect bankers and is designed to make the transition to the 2007 version as smooth as possible. Excel 2003 will be a distant memory after completing this course!

By the end of this course, participants will be able to:
  • Work with the new Excel 2007 interface
  • Locate familiar Excel 2003 commands in Excel 2007
  • Use new shortcuts and legacy shortcuts
  • Use the database and pivot table functionality
  • Use the new conditional formatting functionality
  • Create charts using Excel''s new charting engine
The New Interface
  • The ribbon user interface
  • The quick access toolbar
  • The mini toolbar and other user interface improvements
  • Keyboard shortcuts
  • Galleries, live preview and themes
  • The Excel options dialog
  • Ideal settings for financial modeling purposes
New functions and formulas
  • The formulas ribbon
  • Using autocomplete to find functions
  • New functions (IFERROR, AVERAGEIF, SUMIFS, AVERAGEIFS, COUNTIFS)
  • Common Excel 2003 analysis toolpack functions included by default (i.e. XIRR, XNPV, EDATE)
Formatting
  • Styles are more cumbersome!
  • Amazing new Conditional Formatting
Databases and pivot tables
  • The new table feature
  • Pivot tables get a complete makeover
  • Sorting is vastly improved
  • Removing duplicates and filtering
The new charting engine
  • Understanding components of a chart
  • Setting up your data for charting
  • Chart types
  • Customizing chart types
  • Creating a football field chart for valuation purposes
  • Charting tricks and techniques
File formats
  • File format differences
  • Working with prior versions of Excel
Graphics
  • SmartArt, shapes, WordArt and text boxes
  • Using pictures and clipart

See related categories

Excel 2007 upgrade

Price on request

The best Excel courses

See all

See all