Training Course:Excel AdvancedSchool/Trainer:Ian Fraser Consulting
Melbourne, Victoria, Australia
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' At the end of the course participants will be able to:
Use Advanced Excel functions such as IF and VLOOKUP to reduce the chance of data error
Sort and Filter large amounts of data quickly
Use PivotTables to summarise large amounts of data in lists or tables to spot comparisons or trends such as monthly sales figures
Use Goal Seek to analyse data efficiently
Record and edit macros to automate repetitive tasks such as formatting, sorting lists or adding subtotals
Assign macros to toolbar buttons and menus to make access more convenient
Course Topics
Rules for Creating a Database
Elements of a Database
Create an Excel Database
Do’s
Don’t’s
Modifying the Database Structure
Database Tools
Sorting
Filtering in Excel
Calculations for Filtered Lists
Calculating your Data
Subtotals
Pivot Tables
Other Features of PivotTables
Advanced Functions
What is a function
Function Syntax
Paste Function Dialog Box
Date and Time Functions
Text Functions
Math & Trig
Financial Functions
Logical Functions
Is Functions
Lookup Functions
Goal Seek
Identify uses for goal seek
How to Use Goal Seek
Macros
Identify uses for Macros
Record a Macro
Run a Macro
View the Macro in the Visual Basic Editor
Pre-requisites
Intermediate Microsoft Excel or have a good understanding of Microsoft Excel.
...''
Please go to the school's official website for training price and schedule:
http://www.ianfraserconsulting.com.au/
Phone:(03) 9489 7989
School Address:
Ian Fraser Consulting
10 Wakanui Street
Northcote Victoria 3070
Australia
Jobs & Resumes: Melbourne
Houses & Roommates: Melbourne
Travel Agencies: Melbourne
Search other schools for Excel Advanced training resources.
Other training courses offered by Ian Fraser Consulting:
Adobe Acrobat
Adobe Dreamweaver
Adobe Photoshop
Adobe Illustrator
InDesign CS3
Access Introduction
Access Advanced
Excel Introduction
Excel - Formulas and Functions
Excel - Managing Databases
Frontpage Introduction
Outlook
Powerpoint Introduction
Powerpoint Advanced
Project Advanced
Project Introduction
Publisher
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges. |
|
| 
