Microsoft Excel

Course Description

A full course specification is available on request.

Microsoft Excel Introduction Overview

1 day course designed to help you to obtain the basic skills required to create and use a spreadsheet using Microsoft Excel.

Microsoft Excel Intermediate Overview

1 day course idesigned to help you develop your skills further by using Excel advanced functions and creating more complex formulae.

Microsoft Excel Advanced Overview

1 day course designed to help you develop spreadsheets in which data on different sheets can be linked, consolidated, summarised, and, using a variety of tools, enabling you to analyze, share, and manage information in order to make informed business decisions.

Course Objectives

On completion of Microsoft Excel Introduction delegates will be able to:

  • Enter and edit data
  • Create formulas
  • Format elements of a worksheet
  • Insert charts
  • Apply basic formatting
  • Use the Function Wizard
  • Select ranges
  • Adjust column widths and use the Autofit function
  • Create Absolute & Relative Addresses

Back to top...

On completion of Microsoft Excel Intermediate delegates will be able to:

  • Manage and link together multiple worksheets
  • Apply advanced formatting to charts
  • Sort data
  • Use name ranges
  • Apply conditional formatting
  • Use basic reviewing tools, such as the spelling checker and comments

On completion of Microsoft Excel Advanced delegates will be able to:

  • Validate data
  • Use PivotTables
  • Link worksheets
  • Use goal seeking
  • Create a scenario
  • Apply basic macros
  • Solve problems using the Solver function

Intended Audience

Microsoft Excel Introduction: Delegates requiring basic skills in using spreadsheets, such as updating data, applying formatting, printing, and making simple calculations.

Microsoft Excel Intermediate: Delegates who need to design spreadsheets for solving basic accounting and data analysis tasks.

Microsoft Excel Advanced: Delegates who need to design spreadsheet solutions, using tools for creating and formatting complex spreadsheets to solve difficult problems, and delegates who need to incorporate data from a wide range of sources.

What’s Included

The course includes the following:

  • Instructor Led Tuition
  • Exercise Files CD
  • Electronic Student Guide
  • Post Course Support Available (Optional)

Your Instructor

All WPM’s IT Instructors are CIPD accredited and/or Microsoft accredited professionals.

Benefits

  • Add a professional look to your Spreadsheets by using a variety of design layout features
  • Design effective documents by Creating dynamic charts & graphs from worksheet data
  • Become more productive by saving time collecting, analyzing, and formatting data in Excel

Back to top...