|
Advanced (E357) |
an eWord company |
|
Microsoft Office courses are conducted using 2003, however these courses are suitable for users of versions 97, 2000 and XP/2002. |
_files/image001.jpg)
|
General Course Information In this 2 day program, participants will gain the knowledge and skills to allow them to use Microsoft Excel 2003 to an advanced level, particularly for those interested in data analysis, data management and more complex calculations.
You will learn to Ø Customise the interface Ø Create new default worksheets and workbooks Ø Use workbook collaboration Ø Write advanced formulas and functions Ø Use advanced database filtering Ø Use Pivot Tables to analyse data Ø Use What If analysis Ø Record macros
What skills you need The ability to use Excel’s basic functions, write formulas, manage lists using AutoFilter .
Electus training Electus is a South Australian company with 20 years of experience in training. Trainers and facilitators at Electus are chosen for their expertise, practical and broad experience in their field and a relaxed and friendly manner.
Training includes Each participant receives a training reference manual/workbook and supplementary training materials. Refreshments and lunch are provided.
|
|
Duration 2 days 9:00am-4:15pm
Who needs to come Anyone who would like to learn how to customise Excel, manage and consolidate shared workbooks, analyse data using advanced filters and PivotTables and use advanced Functions.
Nationally Recognised Qualification You can choose to have this course assessed towards a unit of competency for a nationally recognised qualification.
Regular venue 37 Angas Street Adelaide SA (near Victoria Square)
How to book Contact Electus by
Course dates Visit www.electus.com.au for the latest course schedule or ring us on (08) 8221 5517.
|
Course Content
|
Using Custom toolbars and menus · Creating a custom toolbar · Editing toolbar buttons · Editing a button image · Attaching a custom toolbar · Creating a custom menu · Adding custom menu commands Customising Excel options · Setting View options · Setting Edit options · Setting manual recalculation · Resetting automatic recalculation · Setting General options · Automating data entry Using Templates · Saving a workbook as a template · Using a template · Editing a template · Inserting a worksheet · Creating default templates · Finding online templates Sharing Workbooks · Saving a shared workbook · Viewing users sharing a workbook · Viewing shared workbook changes · Highlighting Changes · Managing Conflicts · Reviewing Tracked Changes · Merging Shared Workbooks Using Paste Special · Copying Values between Worksheets · Copying Formulas between worksheets · Performing mathematical operations · Transposing data |
Consolidating Worksheets · Consolidating by Category · Consolidating by Position Using Scenarios & Goal Seek · Using Scenario Manager · Displaying a Scenario · Editing a Scenario · Creating a Summary Report · Using Goal Seek User Solver · Saving a solution as a scenario · Restoring original values · Changing a constraint · Creating a Solver report · Viewing solutions as scenarios Using Data Tables · Placing formulas in data tables · Creating a one-variable table · Creating a two-variable table Using Advanced Functions · Using LOOKUP Functions · Using Nested IF Functions · Using Functions to trap errors · Using Functions to manage and format data · More Nested Functions Using Auditing Tools · Viewing dependent and precedent arrows · Removing all tracer arrows · Tracing cells causing errors · Using the Error Checking button · Using the Evaluate Formula button · Using the Watch window Working with Outlines · Applying an outline · Collapsing/Expanding outlines · Modifying outline settings · Using AutoOutline |
Working with Views · Preserving a Normal View · Creating a Custom View · Displaying a View Working with Advanced Filters · Using a criteria range · Showing all records · Using comparison criteria · Using an Advanced AND condition · Using an Advanced OR condition · Copying filtered records · Using Database Functions Working with the Data Form · Viewing the Data Form · Viewing Data Form records · Editing Data Form records · Adding Data Form records · Defining Criteria · Clearing Data Form criteria · Deleting Data Form records Creating/Revising Pivot Tables · Creating a Pivot Table report · Adding report fields · Selecting a Page Field item · Changing the Summary function · Add new fields to a report · Hiding/unhiding report items · Deleting report fields · Creating a Page Field report · Formatting a PivotTable report · Creating a PivotChart report · Publishing reports to the Web · Using a PivotTable list Using Macros · Defining macros · Running a macro · Recording a macro · Assigning a macro · Creating a macro button |