About the course
If you’re looking to update your skills in the home and workplace, then get ready for today’s deal.
Whether you need to brighten up your CV, looking for a career change or just want to learn something new, the online Excel Advanced course is ideal for anyone who wants to learn how to use the spreadsheets and data.
With over 90 hours of learning split across 30 easily accessible modules, the course has been designed to provide learners with an enjoyable and informative learning experience. The Excel Advanced course is studied online, meaning you can study in your own time, at your own pace, on your own schedule. Study whenever it suits you best, day or night. You’ll have access to the course 24 hours a day, 7 days a week for 12 months.
What’s more, the course is CPD accredited, therefore upon successful completion of the course learners will be awarded with the certificate of completion, ensuring that the course will be recognised by employers and institutions.
The Microsoft Excel 2013 Advanced course is split into the following modules:
- Introduction to Excel Advanced
- Using Text to Columns
- The Paste Special Function
- Data Validation
- Subtotals and Grouping
- Consolidating Data
- Scenario Analysis
- Data Tables in Scenario Analysis
- What-if Analysis
- Mats and Trig Functions
- Text Functions in Excel
- Using Lookup Functions
- Using Statistical Functions
- Databse Functions
- Formaula Auditing and Error Tracing
- Hyperlinks in Excel
- Linking Data
- Understanding Pivot Tables
- Using Pivot Charts
- Workbook Properties
- Protecting and Sharing Worksheets
- Data Encrypting and Finalising Workbooks
- Understanding to Macros
- Custom Number Formats in Excel
- Using Custom Lists
- Working with Templates
- Tracking Changes in Excel
- Merging and Compare Excel Workbooks
- Final Assessment
- Final Assessment
MICROSOFT EXCEL SOFTWARE
This course relates to Microsoft 2013 software. In order to complete the course, learners should have their own copy of Microsoft Excel 2013. If learner does not own a copy of the software, Microsoft provide a free trial version of Microsoft Excel 2013.
To assess the learner's ability and knowledge to effectively understand the topics contained within the Microsoft Excel 2013 Advanced course, the course features a number of end of module interactive quiz questions.
Additionally, at the end of the Microsoft Excel 2013 Advanced course learners will also take an online multiple choice assessment test. This online multiple choice test is marked automatically so you will receive an instant grade and know whether you have passed the course. For more details on the assessments for this course, please read the Assessment tab.
You’ll be glad to know that as part of the Microsoft Excel 2013 Advanced course, you also receive our dedicated tutor help and support service. So if you ever get stuck while studying, need any help or support or have a question, our team of tutors are on hand to give you all the help you need.
Our tutor support team want you to succeed in your studies and achieve the best grade possible, so no matter how big or small your question is they're on hand to help.
The Microsoft Excel 2013 Advanced course is delivered online through our eLearning platform. Learners of the course will receive instant access to our interactive student learning portal, which offers 24/7 access to the course.
The student learning portal is like an interactive classroom, allowing you to access your course materials, study resources, tutor support and assessments from the comfort of your own home. With our student learning portal you can study whenever suits you best, around your own work or life commitments with 24/7 access to the portal, it couldn’t be simpler.
The online Microsoft Excel 2013 Advanced course requires approximately 90 hours to complete. This is only a guide to the learning hours required to complete the course and it depends on how quickly an individual can absorb the information. The learning is online so it can be spread out over multiple sessions to suit your style of learning.