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.
This short course will extend your knowledge of Excel beyond Microsoft Excel: Level 1 and provide you with the skills and knowledge to produce more effective and productive workbooks. Learn essential functions as well as how to manage list data, cover formulas and function techniques, PivotTables, ...
Visualise, explore and effectively communicate through the use of diagrams, flow charts and drawings and create ‘real’ representation of your complex data that someone other then you can understand.
Step up your Excel game with our intermediate course, designed exclusively for experienced users who aim to streamline their workflow and harness the full power of Excel.
Within organizations of any size, safety and security around users and data are of paramount importance. Without the right user access and configuration settings, sensitive information can be accessed undesirably, causing possible future concerns and data leaks
For students and professionals who wish to learn the beginning foundations of Excel and develop their skills with guidance and support from a highly skilled and experienced instructor.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy