Microsoft Excel

Category
Duration Time
1 day
Courses Provided:
2010 1 day
2013 1 day
2016 1 day
Introduction to Excel VBA 2 Days

Excel is an electronic spreadsheet program whose options for manipulating numbers have made it the most popular spreadsheet program in the world. Its widespread use makes it easy to exchange files with almost anyone, or to display information in printed form. Because it is part of the Microsoft Office Suite, it can easily exchange data with that suite's database, word processing and presentation program.

 

Essentials Overview

Duration: 1 day

Benefit: This course will benefit new users of Excel as well as those who typically use Excel for data input or to work with data created by others.

Objectives: On completion of this course attendees will be able to create and manipulate basic Spreadsheets. They will be confident in entering Formulae, using Functions and applying Formatting. They will also be able to set up and print Spreadsheets, as well as create basic Charts.

Key Features

  • Introduction to the Excel screen and Navigation
  • Creating Spreadsheets
  • Working with multiple worksheets
  • Managing Data
  • Formatting Data
  • Viewing and printing Spreadsheets
  • Introduction to Charts
  • Course content can be designed to fit your company requirements

Intermediate Overview

Duration: 1 day

Benefit: This course will benefit those who wish to build on their basic knowledge of Excel. Attendees will gain more confidence in creating and manipulating spreadsheets.

Objectives: On completion of this course, attendees will be able to use calculations with Functions, manage Workbooks and use Database features.

Key Features

  • Review of Essential skills
  • Data Management tools
  • Templates
  • Pivot Tables
  • Macros
  • Course content can be designed to fit your company requirements

Advanced Overview

Duration: 1 day

Benefit: This course will benefit experienced Excel users who wish to understand how to use Excels most powerful features to analyse and present data more efficiently.

Objectives: By the end of the course attendees will be able to use advanced functions in formulae, present data using Pivot Tables, analyse data using the management tools and record Macros.

Key Features

  • Review of Essential skills
  • Further Functions
  • Advanced Formatting
  • Linking Worksheets and Workbooks
  • Data List management
  • Advanced Charts
  • Course content can be designed to fit your company requirements

Introduction to Excel VBA Overview

Duration: 2 Days

Benefit: This course will benefit those who wish to build on their advanced knowledge of Excel. Attendees will gain the skills needed to speed up repetitive tasks and write VBA code.

Objectives: On completion of this course, attendees will be able to record and edit macros, write VBA code and create a user friendly interface to automate tasks.

Key Features

  • What is a Macro
  • The Visual Basic Window
  • Understanding Code
  • Interactive Code
  • Advanced Functions
  • Checking for Errors
  • Advanced User Interface
  • Custom Functions
  • Security
  • Course content can be designed to fit your company requirements
Key Features
Introduction to the Excel screen and Navigation
Creating Spreadsheets
Working with multiple worksheets
Managing Data

Find out more about our Evergreen service   Learn more