When you enrol for this programme, you will additionally receive two CPD accredited courses for free from 1Training. You have the opportunity to choose your preferred courses from a recommended list, and earn more CPD Points/Hours to your portfolio. The courses that you can choose from have been indicated on our suggested course below.
- Excel 2013 Advanced
- Microsoft Access 2013 Beginner to Advanced Training
- Microsoft Excel 2016 Advanced
- Microsoft Office 2016 Beginner Training
- Microsoft PowerPoint 2016 Beginner
- Microsoft Project Essentials
- Microsoft Word 2016 Advanced Online Training Course
- Microsoft Word 2016 Beginner
- MS Office 2016 Advanced Level
- MS Project and SPSS Statistics Software Training
What will I learn?
- Have a clear understanding of how to apply lookup and statistical functions
- Learn how to gather and organise data for business analysis
- Have a sound knowledge in chart generation
- Learn how to build dashboards using PivotCharts and PivotTables
- Acquire skills in how to use data analysis tools to generate different scenarios to aid decision making
Course Curriculum
Module 01: Functions And Formulas
01 Lesson - Topic A: Logical And Conditional Functions
02 Lesson - Topic B: Financial And Statistical Functions
03 Lesson - Topic C: Date/time And Arrays
Module 02: Lookups And Data Tables
01 Lesson - Topic A: Lookup Functions
02 Lesson - Topic B: Data Tables
03 Lesson -topic C: Validating Cells
04 Lesson - Topic D: Filtering
05 Lesson - Topic E: Charting And Graphics
Module 03: Pivottables
01 Lesson - Topic A: Working With Pivottables
02 Lesson - Topic B: Modifying Pivottable Data
03 Lesson - Topic C: Formatting Pivottables
04 Lesson - Topic D: Using Pivotcharts
05 Lesson - Topic E: Powerpivot
06 Lesson - Topic F: Exporting And Importing Data
Module 04: Analytical Tools
01 Lesson - Topic A: Goal Seek
02 Lesson - Topic B: Scenarios
03 Lesson - Topic C: Solver
04 Lesson - Topic D: Instant Data Analysis
Access Duration
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at any time.
Method of Assessment
In order to complete the Microsoft Excel 2016 Data Analysis course successfully and gain your professional qualification, all students are required to complete an online multiple choice question assessment test. This online test is marked automatically and learners will receive an instant grade on whether they have passed the course.
If it is an official exam, you can purchase it separately on the relevant website.
Certification and Awarding Body
At the successful completion of the course you will be awarded the Microsoft Excel 2016 Data Analysis Certification by CPD and iAP. It will make you valuable to employers, and your motivation at gaining new skills will be recognised.
