|
Find Consulting training courses and schools in Cities of Australia: Adelaide - Brisbane - Cairns - Canberra - Darwin - Melbourne - Perth - Sydney
Consulting training courses and schools
Consultancy SkillsTotal 77 training course(s) at schools in Australia.
School: Ian Fraser Consulting
[All Courses] Training Center(s)/Venue(s): Melbourne, Victoria, Australia
Tel.: (03) 9489 7989Excel - Formulas and Functions
Course Format: On-site
At the end of the course participants will be able to:
Understand basic mathematical formulas in Excel
Understand the BODMAS method of calculations
Use absolute references when copying formulas
Create linking formulas between worksheets
Understand and use a variety of functions in Excel
Course Topics
Formulas
What is a formula
BODMAS theory
Creating a formula
Copying f...
Excel Advanced
Course Format: On-site
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...
Excel Introduction
Course Format: On-site
At the end of the course participants will be able to:
Create a basic worksheet by entering text and values
Work with cells and cell data by using a variety of moving and copying techniques
Perform calculations on data by using functions and formulas
Change the appearance of worksheet data by using a variety of formatting techniques
Use a variety of techniques to manipulate multiple...
Access Advanced
Course Format: On-site
At the end of the course participants will be able to:
Understand Table Design in a practical context
Understand and apply Field Properties
Understand the major components of Form and Report Design
Design customised Forms and Reports
Create Calculated Fields within Queries
Create and use Action Queries
Create and use Multi-Table Queries
Create Switchboards and Startup Forms
...
Access Introduction
Course Format: On-site
At the end of the course participants will be able to:
Understand the fundamental properties of a database
Understand the major components of Access
Use the Database Wizard to create a database
Create, edit and add data to tables
Search for data
Design customised forms and reports
Create Query Tables using a variety of methods
Understand and create Relationships between tables...
InDesign CS3
Course Format: On-site
At the end of the course participants will be able to:
Create, modify and import text and graphic frames
Use master pages and guides to design a document
Define colours and swatches and apply them to fills and strokes
Apply character and paragraph formatting
Place and manage graphics, text wrap and layers
Apply transparency effects to objects and work with transparency flattener s...
Adobe Illustrator
Course Format: On-site
We have expertise in delivering training in the full suite of Microsoft Office, Adobe and web publishing applications. All of our information technology training programs are tailored to your organisational and business needs, including course duration, learning outcomes & course content.
Ian Fraser Consulting can also offer one on one training using participants’ own files, or classro...
Adobe Photoshop
Course Format: On-site
We have expertise in delivering training in the full suite of Microsoft Office, Adobe and web publishing applications. All of our information technology training programs are tailored to your organisational and business needs, including course duration, learning outcomes & course content.
Ian Fraser Consulting can also offer one on one training using participants’ own files, or classro...
Adobe Dreamweaver
Course Format: On-site
We have expertise in delivering training in the full suite of Microsoft Office, Adobe and web publishing applications. All of our information technology training programs are tailored to your organisational and business needs, including course duration, learning outcomes & course content.
Ian Fraser Consulting can also offer one on one training using participants’ own files, or classro...
Adobe Acrobat
Course Format: On-site
We have expertise in delivering training in the full suite of Microsoft Office, Adobe and web publishing applications. All of our information technology training programs are tailored to your organisational and business needs, including course duration, learning outcomes & course content.
Ian Fraser Consulting can also offer one on one training using participants’ own files, or classro...
Page(s):- 1 2 3 4 5 6 7 8 [ Popular Topics ] [ Schools Only ]
- Free Services -
Link students and schools worldwide
|
Tips:
Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent. |
|
| 
