Designed for

This two-day hands-on course designed for users of Excel who need to create sophisticated spreadsheets. Knowledge of basic Excel Spreadsheet commands is necessary.
 

Content

• Use windows and titles - Split the screen into windows - Connect windows - Retain titles
• Use named areas - Create names areas - Use named areas with expressions
• Link files - Open links to other files - Linking to multiple files - View multiple files on screen - Transfer data between files - Creating formulas to link files - consolidation
• Use advanced numeric and mathematical operations - Perform mathematical operations - Use Excel numeric functions - Use table function - Copy expressions
• Transfer data - Integrate data to other Windows packages such as Word for Windows - Export data to Lotus format
• Use conditional expressions - perform conditional expressions - Perform nested conditional expressions - Copy conditional expressions
• Use advanced printing techniques - Print named areas - Print using titles, grid, header/footer
• Perform "what if" operations - using solver
• Database functions within a Spreadsheet - Retrieve records from a spreadsheet - Finding records within a spreadsheet - Sorting records - Sorting records by multiple levels
• Graph - Create and print graphs with chart wizard - Enhance graphs with titles and comments - Adding symbols to graphs - Paste into spreadsheet
• Macros - Create and execute keystroke macros 

Award

A Certificate of Attendance will be issued at the completion of the course.

Learning Outcomes

On completion of this course participants should be able to:

• State how to use sophisticated calculations, conditional expressions and lookup functions 

Duration of Course 

Two days 9.00am - 4.30pm
 

Course Fee (GST Free) 

Fee Member AUD $650
Fee Non Member AUD $680

Course Venue

AFEI
Level 2, 97-99 Bathurst St
Sydney   NSW   2000

Other Details

Fee includes morning and afternoon teas, light lunch and course materials.

Course ID Date(s)