Coures Objectives
- Introduce more Excel functions.
- Utilise Excel's database functions.
- Control and enhance Excel graphs.
- Create simple macros.
- Customise your Excel environment.
Coures Content
Advanced Spreadsheets
Working with range names.
Working with multiple sheets.
Consolidating multiple worksheets.
Further use of Excel functions such as conditional IF and Lookup.
Working with Text
Text Functions.
Text Import.
Graphs and Charts
Different graph styles, creating, enhancing and editing elements of the graph.
Printing independently or as part of the spreadsheet.
Database Functions
Creating Excel databases.
Accessing data by sorting and filtering data.
Producing summary statistics.
Cross tabulation using Pivot tables.
Specific database functions.
Introducing Macros
Recording commands in macros to simplify routines.
Editing macros and assigning to objects.
Object Linking & Embedding
Embedded Objects.
Linking Objects (DDE) (Dynamic Data Exchange).
Security Features
Protecting Files.
Protecting Cells.
Protecting Worksheets.
Protecting Workbooks.
Templates
Creating & editing templates.
XLSTART Directory.
Understanding AutoTemplates.
What-If Analysis
Goal Seek.
Using the Solver.
Scenarios.
Data tables.
Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.
