SUPERIOR TRAINING FOR THE WA MINING SECTOR

U

Microsoft Excel Intermediate Course

$840

Intermediate Microsoft Excel Training

 

Course Overview

This is an intermediate Excel course that will build on your existing Excel skills.  Following this course, you will work smarter in Excel, helping you to better organise and present your data. You will Learn to use some of Excel’s more powerful functions such as If’s, features like sorting and filtering data.  Conditional Formatting along with improvements to charts will allow you to feel much more confident in creating effective presentation of your data.  This is a hands-on course and includes plenty of chances to try out what you are being taught and ask questions.

Naomi has extensive experience in the computer training industry and is a Microsoft Office Master Instructor. Evaluations reflect Naomi’s passion for facilitating learning and helping participants achieve their goals. Naomi has extensive experience delivering training across all industry sectors and developing specialist training materials to suit different clients. Naomi is enthusiastic about the products and how to work effectively and as quickly as possible using them and the aim is for all participants leave the room excited to get back to using the product more efficiently.

Requirements

  • A moderate English language, literacy and numeracy skill is required.
  • Participants must bring their own laptop for training days.
  • Lunch:  Catering is provided, or you are welcome to bring your own (microwave and fridge available). Tea, Coffee and biscuits available.
  • Parking is available on site, or it is a short walk from Glendalough Train Station.

Learning Outcomes

At the completion of the program Excel Intermediate participants should be able to:

  • Create If Functions to analyse data
  • Format Spreadsheets according to their values
  • Analyse Data using Sorting and Filtering
  • Apply Borders
  • Create Advanced charts.

Course Content

  • Revision Exercise
  • Complex Formulas
  • Scoping Formulas
  • Logical Functions
  • IF, AND, OR, NOT
  • Number Formatting
  • Conditional Formatting
  • Data Bars, Icon Sets, Colour Scales
  • Applying Borders
  • Working with a Worksheet
  • Adv Find and Replace
  • Page Setup
  • Print Titles
  • Creating Sparklines
  • Sorting Data
  • Filtering Data
  • Understanding Chart Elements
  • Chart Object Formatting

 

Choose A Date To Enrol

$840

MTA Training Facility in Osborne Park or;
on-site delivery with you (minimum 6 people)

Two (2) days.

Certificate of Attendance
RTO: 51586

Other Courses

Microsoft Excel Essentials Course
Learn the essential skills of using the spreadsheet management program Excel. In this course you will learn how to enter data, edit and move around a spreadsheet. You will learn how to format and print spreadsheets.

Microsoft Excel Essentials Course

Microsoft Excel Intermediate Course
This is an intermediate Excel course that will build on your existing Excel skills. Following this course, you will work smarter in Excel, helping you to better organise and present your data.

Microsoft Excel Intermediate Course

Microsoft Excel Advanced Course
This Advanced Excel course will further enhance on your existing Excel skills. Increasing your knowledge by understanding advanced functions and productivity tools.

Microsoft Excel Advanced Course

Microsoft Word Essentials Course
This hands-on course aims to give the learner a sound grounding in the use of Microsoft Word to create everyday documents required either at work or at home.

Microsoft Word Essentials Course

Microsoft Word Intermediate Course
This hands-on course will enable the learner to enhance their Microsoft Word documents to include Tables, watermarks, and Pictures.

Microsoft Word Intermediate Course

Microsoft Word Advanced Course
This hands-on course aims to give the learner a sound understanding of all that is involved in working with long documents, including cross references, Table of Contents and Indexing.

Microsoft Word Advanced Course

Microsoft PowerPoint Essentials Course
This course is for those aiming to use PowerPoint to produce presentation materials for seminars, training sessions, presentations or workshops.

Microsoft PowerPoint Essentials Course

Microsoft PowerPoint Advanced Course
This course is for those looking to advance their to use PowerPoint presentation materials.

Microsoft PowerPoint Advanced Course

Microsoft Outlook Essentials Course
You will find out how to use Microsoft Outlook as a time management tool, so you can manage the flow of emails and manage your calendar.

Microsoft Outlook Essentials Course

Microsoft Project Introduction Intermediate Course
Master using Microsoft Project to plan and manage your projects on this two-day introduction.

Microsoft Project Introduction Intermediate Course

N

Mine Training Australia will provide you with all the skills and knowledge you need for working in Mines in Australia

You can get in touch with us on our contact form, by email, or by phone on 1300 938 411. The x team are always here to discuss your training requirements in Perth, regional WA or throughout Australia.

WA Owned & Run Business

Z

Nationally Recognised Certifications

Industry Specialists

w

Easy Help & Support

Easy & Flexible Payment Options

h

Specialised Trainers & Assessors