Offered in Beginner, Intermediate and Advanced levels. Learn how to analyse, share and manage information to make more informed decisions with the world’s premier spreadsheet application. This course uses Microsoft Excel 2013.
About The Course:
Offered in Beginner, Intermediate and Advanced levels. Learn how to analyse, share and manage information to make more informed decisions with the world’s premier spreadsheet application. This course uses Microsoft Excel 2013.
Units:
Module 1 Beginner Level
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 charts
Customising Excel
Module 2 INTERMEDIATE LEVEL
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 ell and range formatting
Advanced worksheet manipulation within Excel
Excel templates
Paste special options within Excel
Proofing and printing
Module 3 ADVANCED LEVEL
Excel pivot and input tables
Excel charts and hyperlinks
Linking within Excel
Embedding within Excel
Importing text files into Excel
Sorting, filtering and totaling 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
Upon Completion:
This course is eligible for CPD hours. Upon successful completion of all the required units of this course, students will receive a certificate of completion.
Established in 2014, Seed Training Group specialises in providing high quality and industry recognised courses either online or on-campus. Our courses widely range from bookkeeping, accounting, finance, marketing to professional development areas.
Our training courses are Australian Qualification Framework (AQF) nationally recognised and accredited to meet vocational and educational standards.
We draw on our established relationships with industry and other stakeholders to ensure our courses are appropriate to the demands of our students and consistently meet their expectations.Quality is maintained in compliance with the National VET Regulators Standards for Registered Training Organisations (RTOs) 2015 and through our continuous improvement system.
Mission:
Our principle purpose is to provide high quality and practical training and assessments at affordable prices.
Value:
Seed Training Group is a student driven education provider to make sure we are:
Assisting your career development with personalised study with us
Delivering courses in flexible methods
Providing ongoing support and mentoring
Focusing on outcomes
We acknowledge the importance of adult learning principles in the delivery of effective training. We believe that all students should be encouraged to take responsibility for their own learning and to understand that as learners, they have an active role to play in their training/ learning and assessment process.
Our trainers have relevant industry knowledge and experience and are professional, friendly, supportive and dynamic individuals!
We would like to make you feel as comfortable as possible whilst you undertake your training, so we keep our class sizes small to ensure optimum learning environments. We ensure that all our students receive in-depth learning and unlimited support as they need.
Learn to create professional documents, reports, and newsletters confidently by using efficient features such as forms and fields, text manipulation techniques, etc.
The skills and knowledge acquired in Microsoft Access 2016 - Level 1 are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.
Trainers Direct offers professional onsite Visio training courses for groups and individuals. Simplify complex information by creating professional Visio diagrams with our 1 day Visio Essentials course.
The Ultimate Microsoft PowerPoint Course in Perth. Discover our World Class Microsoft PowerPoint Training from Perth that teaches students how to correctly build and format PowerPoint Presentations and Templates with ease
Outlook is a powerful business tool allowing you to send emails, plan and organise yours and other team member’s time in the calendar, keep on top of your work by scheduling tasks, and have all your contacts at your fingertips! Save time and increase your productivity by getting to really know th...
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy