Included courses:
- Excel 2016 – PC
- Excel 2016 Bootcamp
- Excel 2016 for PC – Charting
- Excel 2016 for PC – Evaluating Data
- Excel 2016 for PC – Frequently Used Formulas & Functions
- Excel 2016 for PC – Pivot Tables
- Excel 2016 for PC – Protecting Your Spreadsheets
- Excel 2016 for PC – Statistical Analysis
Course Duration:
From the day you purchase the course, you will have 12 months access to the online study platform. As the course is self-paced you can decide how fast or slow the training goes, and are able to complete the course in stages, revisiting the training at any time.
Course Curriculum
-------- Excel 2016 - pc --------
1: getting started
2: work with data and datasets
3: create formulas
4: manage data and datasets
5: format your table
6: work with sheets
7: work with charts
8: share and secure data
9: import and export data
-------- excel 2016 bootcamp --------
1: overview
2: how to make a quote & invoicing form
3: using templates
4: cleaning up messy data
5: graphs in excel
6: pivot tables
7: how to make a profit & loss sheet
8: cheat sheet & shortcuts
-------- excel 2016 for pc - charting --------
1: getting started
2: chart tabs and riddons
3: format your chart
4: present your chart
5: work with sparklines
6: new chart types
-------- excel 2016 for pc – evaluating data --------
1: getting started
2: data validation
3: conditional formatting
-------- excel 2016 for pc – frequently used formulas & functions --------
1: getting started & what’s new
2: formulas
3: linking and consolidating worksheets
4: auditing & error checking
-------- excel 2016 for pc – pivot tables --------
1: getting started
2: creating & deleting
3: custom appearance & layout
4: printing options & copying a pivot table
5: summarizing with totals & formulas
6: refreshing data
7: pivot charts
8: sparklines & slicers
-------- excel 2016 for pc – protecting your spreadsheets --------
1: protecting your spreadsheet
-------- excel 2016 for pc – statistical analysis --------
1: describing data
2: comparing variables
3: tests of significance
4: printing options & copying a pivot table
5: data analysis toolpak
Method of Assessment:
At the end of each module, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed.
Certification:
Successful candidates will be awarded certificates for Excel 2016 – PC, Excel 2016 Bootcamp, Excel 2016 for PC – Charting, Excel 2016 for PC – Evaluating Data, Excel 2016 for PC – Frequently Used Formulas & Functions, Excel 2016 for PC – Pivot Tables, Excel 2016 for PC – Protecting Your Spreadsheets, and Excel 2016 for PC – Statistical Analysis.
Why Choose Us?
- Our courses represent outstanding value for money
- High quality e-learning study materials and mock exams.
- Each course is designed by industry experts, using an innovative interactive learning approach.
- Includes step-by-step guided videos tutorials.
- 24/7 Access to the Online Learning Portal.
- Anytime & Anywhere Learning.
- Recognised Accredited Qualification.
- Access Course Content on Mobile, Tablet or Desktop.
- Study in a user friendly, advanced online learning platform.
- Excellent customer service and administrative support.
