Microsoft Excel Intermediate

Level
Total time

Microsoft Excel Intermediate

Hemsley Fraser
Logo Hemsley Fraser

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Overview

Course duration: 2 days.

By the end of this course you will be able to manage lists, create an Excel model using logical and lookup formulae coupled will adding a third dimension. In addition you will also be able to audit a spreadsheet checking and preventing errors, using the provided manual if required.

This course is run in partnership with 2e2 Training.

Is it right for me?

This course is designed for students who have completed the Excel Fundamentals Course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.

This course can be run in versions 2000 / 2002 / 2003 and 2007.

What will it …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Overview

Course duration: 2 days.

By the end of this course you will be able to manage lists, create an Excel model using logical and lookup formulae coupled will adding a third dimension. In addition you will also be able to audit a spreadsheet checking and preventing errors, using the provided manual if required.

This course is run in partnership with 2e2 Training.

Is it right for me?

This course is designed for students who have completed the Excel Fundamentals Course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.

This course can be run in versions 2000 / 2002 / 2003 and 2007.

What will it cover?

Working With Large Worksheets

  • Viewing Options
  • Hiding And Displaying Data
  • Printing Large Worksheets

Working With Multiple Worksheets

  • Using Multiple Worksheets
  • Linking Worksheets By Using 3-D Formulas
  • Managing Workbooks

Advanced Formulae

  • Lookups
  • Logical Statements

Advanced Charting

  • Chart Formatting Options
  • Creating Combination Charts
  • Using Graphic Elements

List Management

  • Working With Lists
  • Sorting And Filtering Lists
  • Advanced Filtering

Advanced Formatting

  • Borders And Shading
  • Using Special Number Formats
  • Working With Dates
  • Working With Styles
  • Other Advanced Formatting

Documenting And Auditing

  • Comments And Text Boxes
  • Auditing Features
  • Protection
  • Workgroup Collaboration

Customising Excel

  • Changing Options
  • Customising Toolbars And Menus
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.