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.
Simplify complex information by creating professional, versatile diagrams in just a few clicks. Visio provides new features to help you and your team create diagrams and share data-linked diagrams with more ease.
We tailor these programs to suit your needs. If you are an individual looking for basic to intermediate training in Microsoft Word, Excel or Outlook we can assist. If you are an organisation looking for basic to intermediate training for a group of people in Microsoft Word, Excel or Outlook we can ...
This Course Is Delivered As A 1-day Hands-On, Face-To-Face Session
Those who want to be able to produce short, simple documents quickly and easily using a wide range of formatting tools.
This short Introduction to Excel session will give you the confidence to move around the Microsoft Excel 2010 software and understand the basics of formulas, calculations and layouts. You will be guided by a skilled and patient trainer in a one on one session.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy