Excel 2010 - Course List
-
Introduction to Excel. The module is suitable for users with little or no experience of spreadsheets. The course covers spreadsheet formatting, text editing and simple calculations. Incorporates module: EXL-10-02 Excel 2010 Manipulating Existing Worksheet
Half day
EXL-10-01
-
Guidelines for manipulating text and data in existing spreadsheets. Incorporates topics from module: EXL-10-01 Excel 2010 Introduction
2 hours
EXL-10-02
-
Introduction to working with Excel functions and linking worksheets and files. Also covers the function wizard, named ranges and absolute addressing. Incorporates topics from module: EXL-10-01 Excel 2003 Introduction
2 hours
EXL-10-03
-
This module will suit all users who need to build and manage lists of data. Incorporates aspects of module: EXL-10-01 Excel 2010 Introduction
2 hours
EXL-10-04
-
This module will introduce users to working with analytical tools and using scenarios for what-if analysis. Features covered include pivot tables, scenario manager, report manager and solver.
2 hours
EXL-10-05
-
A session to cover any aspects of Excel.
1 hour - 1 day
EXL-10-06
-
The course explores the function wizard to write logical, string, date and other useful functions.
2 hours
EXL-10-08
-
Create reusable worksheet layouts using templates. Understand template components. Create a template from a worksheet.
Half day
EXL-10-09
-
Use charts to represent data graphically. Create diagrams.
2 hours
EXL-10-10
-
The course covers the fundamentals of programming using Visual Basic for Applications within Excel. The cousrse covers adding functionality and logic to recorded macros; automating repetitive tasks and communicating with the user using dialog boxes.
2 days
EXL-10-11
-
This intensive one day course covers the fundamentals of programming using Visual Basic for Applications within Excel. The cousrse covers how to record macros and then add functionality with variables, control structures and error checking.
1 day
EXL-10-12
