|
                 
| |
Introduction Course
Duration: 2 Days
Objectives:
By the end of the course the
delegate will be able to use Microsoft Excel for the creation and maintenance of spreadsheets and
to present information in Report and Graphical form. They will know of and be able to use
the Database facility and will have used the software in a number of 'live' problem
solving situations.
Designed for:
This course is suitable for
anyone who has a basic knowledge of Personal Computing and is to become a user of Excel.
The course is also suitable for delegates who are familiar with other spreadsheets and who
wish to move to Excel.
Description:
The course rapidly introduces
the student to the basic principles of Spreadsheets. With this fundamental knowledge as a
basis, the student will spend the major portion of the course doing hands-on practical
work in a closely monitored training situation.
Course Topics
 | An Overview of Excel |
| Basic Spreadsheet Handing |
| Labels and Formulae |
| Building Spreadsheets |
| Worksheet Formatting |
| Graphs |
| Printing |
| Security and Protection |
| Further Commands and Functions |
| Multiple Spreadsheets |
| Multiple Workbooks |
| Sorting |
| Introduction to Lists and Databases |
| Automatic features |
| Document Management |
Advanced Course
Duration: 1 Day
Objectives:
By the end of the course the delegate will be
fully conversant with all aspects of the software and be able to produce integrated
solutions to business problems using the more advanced features of the software.
Designed for:
This course is suitable for delegates who have
attended Introductory training or those who have become familiar with the software the
'hard way' and who need to increase their level of competence.
Description:
The course begins with a very rapid overview of
the basic facilities of Excel, but quickly progresses to more advanced topics. The
course has a high practical content with a number of tutorial sessions enabling the
delegate to use the software to solve simulated business problems.
Course Topics
| Review of Basic Features |
| Table Lookup and Other Functions |
| Data Tables |
| Custom Number Formats |
| Conditional Formatting |
| Goal Seek |
| Solver |
| Scenarios |
| Templates and Styles |
| Using Outline |
| Consolidating Spreadsheets |
| Data Validation |
| Further Database Techniques |
| Introduction to Data Maps |
| Introduction to Pivot Tables |
| Worksheet Auditing |
Excel Application
Development
Duration: 2 days
This course can also be covered
as two one-day courses, divided into Excel Macros and
Excel VBA. (Click on the title to go to the
respective pages).
Objectives:
This course will provide
delegates with a good understanding of how macros and user-defined functions
can be recorded and edited, or written directly in Visual Basic.
By the end of the course,
delegates will be able to create effective macros to automate many aspects
of Excel and produce sophisticated spreadsheet-based applications.
Designed for:
The course is suitable for
delegates with a good understanding of Excel, especially the use of formulae
and functions, multiple worksheets and Range Names. Ability to use a modern
programming language, including an understanding of variables, arrays, loops
and decision structures, will be an advantage, though is not essential.
Description:
Creating complex workbooks
that can be used effectively by people other than the designer is not a
simple task. Excel macros, written in Visual Basic, offer the possibility of
automating and simplifying the use of such workbooks, enabling users to
remain focused on the business needs and results, rather than the technical
details of how the workbook operates.
The first part of the course
focuses on the essential knowledge required to create and use macros and
functions to automate many aspects of Excel.
The remainder explores the
use of Visual Basic with Excel in more depth and shows how it can be used to
build sophisticated and tightly controlled applications that can be operated
effectively by users with relatively little knowledge of Excel.
Topics
| Recording and Running Macros |
| Controls on Worksheets |
| The Visual Basic Editor |
| Debugging and Error Handling |
| Object Oriented Programming |
| User Forms |
| Programming Techniques |
| The Excel Object Model |
| Variables and Built in Functions |
| Workbook and Worksheet Events |
| Functions and Subroutines |
| Application Design Issues |
| Standard Dialogues |
|
