Datrix Training
    Site Search  
  Home About Us Support FAQs Contact Us
   
  All Courses
Project Management
PRINCE2 Training
IT Training
ITIL Training
Delegate Information
On Site Training
Locations
Clients
T & Cs
Privacy Policy
Vacancies

Microsoft Excel Training

Microsoft Excel Intermediate Training Course Outline

Last Updated 4th Febuary
IT Homepage > Microsoft Excel Homepage > Microsoft Excel 2007 Intermediate Training Course Outline
Datrix Training offers Office Excel is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. Microsoft Excel 2007 also offers more room for you to work in and delivers faster performance.
MICROSOFT EXCEL 2007 INTERMEDIATE – 1 DAY COURSE
  • Module 1 - Multiple Worksheets And Workbooks in Excel 2007
  • Using Multiple Worksheets
  • Inserting New Worksheets
  • Renaming Worksheets
  • Deleting Worksheets
  • Creating Multiple Views
  • Freezing Panes
  • Viewing And Arranging Multiple Worksheet Windows
  • Navigating In Multiple Workbooks
  • Selecting And Viewing Multiple Workbooks
  • Creating And Opening A Workspace
  • Managing Multiple Worksheets And Workbooks
  • Selecting Multiple Worksheets
  • Moving And Copying Data Between Worksheets
  • Linking Data Between Worksheets
  • Creating A 3-D Formula
  • Module 2 - Charting in Excel 2007
  • Using Charts
  • Creating A Chart
  • Moving A Chart
  • Resizing A Chart
  • Changing The Layout And Style
  • Labelling Chart Elements
  • Formatting Chart Text
  • Formatting Chart Elements
  • Changing The Chart Type
  • Showing Or Hiding Gridlines
  • To Modify Chart Gridlines
  • Customizing Axes
  • Creating A Pie Chart
  • Changing, Adding And Deleting A Chart’s Source Data
  • Moving A Chart To A Different Worksheet
  • Saving A Chart Template
  • Printing Charts
  • Module 3 - Advanced Functions in Excel 2007
  • Creating And Using Functions
  • Using Built-In Functions
  • Use Formula Autocomplete
  • Working With Arguments: The PMT Function
  • Using Dates And Times
  • Using Dates In Calculations
  • Using Nested Functions
  • Auditing Worksheets
  • Identifying The Auditing Commands
  • The Watch Window
  • The Formula Evaluator
  • Tracing And Correcting Worksheet Errors
    1. Module 4 - Advanced Formatting in Excel 2007
    2. Using Comments In A Worksheet
    3. Reviewing, Showing, And Hiding Comments
    4. Deleting A Comment
    5. Applying Or Customising Document Themes
    6. Working With Cell Styles
    7. Using Format Painter
    8. Applying Table Styles
    9. Excel Tables
    10. Filtering Data Using Autofilter
    11. Creating Custom Filters
    12. Advanced Filtering
    13. Using Templates
    14. Creating A Template
    15. Editing A Template
    16. Verifying Your Work
    17. Using Autocorrect

 


Microsoft Excel Course Outlines
Microsoft Excel 2003
link
Microsoft Excel 2002
link
Microsoft Excel 2000
link
Note: It is possible to customise and tailor each Microsoft Excel course ot meet your training objectives. There is usually no extra charge for customising your training course.
Microsoft Project 2007
Freephone us on 0800 781 0626
Gold Microsoft Certified Training Partner
Training venues located*:
h
Merseyside
h
West Yorkshire
h
Merseyside
h
South Yorkshire
h London (Alie Street)  
h London (Clerkenwell)  
h
Greater Manchester
h Nottingham (Racecourse) Nottinghamshire
h
Lancashire
  *Not all Datrix courses are available at every venue, please call us for details on 0800 781 0626