Details
Offered in Beginner, Intermediate and Advanced level. Learn how to analyse, share and manage information to make more informed decisions with the world’s premier spreadsheet application. Take your Excel skills to the next level!
DURING THE PROGRAM:
Delivery mode: Online and Classroom (Melbourne CBD) available
Please contact us to confirm the training fee and further information.
Call us: 1300 369 809
Email: [email protected]
Location: Seed Training Group, L10/356 Collins St, Melbourne.
DURING THE PROGRAM:
- Hands-on practical training
- Customised for specific industry needs
- Training facilities and materials provided
- Experienced Excel trainers
- Online forum for on-going support
- Certificate provided upon completion
Delivery mode: Online and Classroom (Melbourne CBD) available
Please contact us to confirm the training fee and further information.
Call us: 1300 369 809
Email: [email protected]
Location: Seed Training Group, L10/356 Collins St, Melbourne.
Outline
BEGINNER LEVEL
Areas of training:
- Getting Started with Excel
- Excel Selection Techniques
- Manipulating rows and columns
- Manipulating cells and cell content
- Sorting a Cell Range
- Excel Worksheets
- Freezing Row and Column Titles within Excel
- Font, Number and Alignment Formatting within Excel
- Excel Formulas
- Functions and Chart
- Customising Excel
Areas of training:
- Excel Setup and Viewing Options
- Excel Functions and Formulas
- Excel Time and Date Functions
- Excel Mathematical, Logical and Statistical Functions
- Excel Financial, Lookup, and Database Functions
- Excel Named Ranges
- Excel Cell and Range Formatting
- Advanced Worksheet Manipulation within Excel
- Excel Templates
- Paste Special Options within Excel
- Proofing and Printing
Areas of training:
- Excel Pivot and Input Tables
- Excel Charts and Hyperlinks
- Linking within Excel
- Embedding within Excel
- Importing Text Files into Excel
- Sorting, Filtering and Totalling Data within Excel
- Tracking and Reviewing Changes in Excel
- Excel Scenarios
- Validating within Excel
- Auditing Techniques in Excel
- Macros within Excel
- Excel Passwords and Security Issues
Schedules
Jan 16, 2019 - Dec 31, 2019
ENDED
Reviews
Be the first to write a review about this course.
Write a Review
A Melbourne based training institute focusing on innovation education and career development. By providing practical and professional training services, we prepare trainees with the skills and knowledge to become successful individuals and help them move up the career ladder.