Exclusive Autumn Sale: Access to 2000+ Courses for Lifetime for £149 Only
Course Overview
Are you looking to gain a new in-demand skill from the comfort of your home? Well, look no further; you’ve come to the right place!
Our easy-to-follow Microsoft Excel 2016 Bundle Diploma: 5 Accredited Diplomas in 1 Course will provide you with all the deep knowledge and insight you need to know about this topic. This comprehensive course has been broken down into several manageable modules, which we believe will assist you to easily grasp each concept – from the fundamental to the more advanced aspects of the course.
Learn the most in-demand skills from the safety & comfort of your home. Enjoy the freedom to learn at your own comfortable pace and prepare yourself for the market of the future.
Learning Outcomes
Whether you are an aspiring professional or a complete beginner, this course will improve your expertise and boost your CV with key skills and an accredited certification attesting to your knowledge.
Entry Requirement
- This course is available to all learners of all academic backgrounds.
- Learners should be aged 16 or over to undertake the qualification.
- Some basic understanding of the English language and numeracy.
Certification
After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can, however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £29 or in PDF format at the cost of £19.
- PDF certificate’s turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days
Why choose us?
- Affordable, engaging & high-quality e-learning study materials;
- Tutorial videos/materials from the industry-leading experts;
- Study in a user-friendly, advanced online learning platform;
- Efficient exam systems for the assessment and instant result;
- The UK & internationally recognised accredited qualification;
- Access to course content on mobile, tablet or desktop from anywhere, anytime;
- The benefit of career advancement opportunities;
- 24/7 student support via email.
Career path
Develop Your Career Plan is a useful qualification to possess and would be beneficial for any related profession or industry.
- 1 year
- Advanced, Intermediate
- Course Certificate
- Number of Units124
- Number of Quizzes6
- 2 days Gift this course
Course Curriculum
| Microsoft Excel 2016 Intermediate Training Diploma | |||
| Apply Range Names | 00:30:00 | ||
| Use Specialized Functions | 00:30:00 | ||
| Use Text Functions | 00:30:00 | ||
| Use Logical Functions | 00:30:00 | ||
| Use Lookup Functions | 00:30:00 | ||
| Use Date Functions | 00:30:00 | ||
| Use Financial Functions | 00:30:00 | ||
| Create and Modify Tables | 00:30:00 | ||
| Sort and Filter Data3 | 00:30:00 | ||
| Use Subtotal and Database Functions to Calculate Data | 00:30:00 | ||
| Create Charts | 00:30:00 | ||
| Modify and Format Charts | 00:30:00 | ||
| Create a Trendline | 00:30:00 | ||
| Create Advanced Charts | 00:30:00 | ||
| Create a PivotTable | 00:30:00 | ||
| Filter Data by Using Slicers | 00:30:00 | ||
| Analyze Data with PivotCharts | 00:30:00 | ||
| Insert and Modify Graphic Objects | 00:30:00 | ||
| Layer and Group Graphic Objects | 00:30:00 | ||
| Incorporate SmartArt | 00:30:00 | ||
| Customize Workbooks | 00:30:00 | ||
| Manage Themes | 00:30:00 | ||
| Create and Use Templates | 00:30:00 | ||
| Protect Files3 | 00:30:00 | ||
| Preparing a Workbook for Multiple Audiences | 00:30:00 | ||
| Activities – Microsoft Excel 2016 Intermediate | 00:00:00 | ||
| Microsoft Excel 2016 Advanced Level | |||
| Update Workbook Properties3 | 00:15:00 | ||
| Activity-Update Workbook Properties | 00:05:00 | ||
| Create and Edit a Macro3 | 00:15:00 | ||
| Activity-Create and Edit a Macro | 00:05:00 | ||
| Apply Conditional Formatting | 00:30:00 | ||
| Activity-Apply Conditional Formatting | 00:05:00 | ||
| Add Data Validation Criteria | 00:15:00 | ||
| Activity – Add Data Validation Criteriaty | 00:05:00 | ||
| Trace Cells | 00:15:00 | ||
| Activity-Trace Cells | 00:05:00 | ||
| Troubleshoot Invalid Data and Formula Errors | 00:15:00 | ||
| Activity-Troubleshoot Invalid Data and Formula Errors | 00:05:00 | ||
| Watch and Evaluate Formulas | 00:15:00 | ||
| Activity-Watch and Evaluate Formulas | 00:05:00 | ||
| Create a Data List Outline | 00:15:00 | ||
| Activity-Create a Data List Outline | 00:05:00 | ||
| Create Sparklines | 00:15:00 | ||
| Activity – Create Sparklines | 00:05:00 | ||
| Create Scenarios | 00:15:00 | ||
| Activity-Create Scenarios | 00:05:00 | ||
| Perform a What-If Analysis | 00:15:00 | ||
| Activity-Perform a What-If Analysis | 00:05:00 | ||
| Perform a Statistical Analysis with the Analysis ToolPak | 00:15:00 | ||
| Activity-Perform a Statistical Analysis with the Analysis ToolPak | 00:05:00 | ||
| Create Interactive Data with Power View | 00:15:00 | ||
| Activity-Create Interactive Data with Power View | 00:05:00 | ||
| Consolidate Data | 00:15:00 | ||
| Activity-Consolidate Data | 00:05:00 | ||
| Link Cells in Different Workbooks | 00:15:00 | ||
| Activity-Link Cells in Different Workbooks | 00:05:00 | ||
| Merge Workbooks | 00:15:00 | ||
| Activity-Merge Workbooks | 00:05:00 | ||
| Export Excel Data | 00:15:00 | ||
| Activity-Export Excel Data | 00:05:00 | ||
| Import a Delimited Text File | 00:14:00 | ||
| Activity- Import a Delimited Text File | 00:05:00 | ||
| Integrate Excel Data with the Web | 00:15:00 | ||
| Activity-Integrate Excel Data with the Web | 00:05:00 | ||
| Create a Web Query | 00:15:00 | ||
| Activity-Create a Web Query | 00:05:00 | ||
| Import and Export XML Data | 00:15:00 | ||
| Activity-Import and Export XML Data | 00:05:00 | ||
| Activities and Exercise Files – Microsoft Excel 2016 Advanced | 00:00:00 | ||
| Microsoft Excel 2016 and VBA Training Diploma | |||
| Create a Macro Using the Macro Recorder | 01:00:00 | ||
| Edit a Macro | 01:00:00 | ||
| Debug a Macro | 00:30:00 | ||
| Customize the Quick Access Toolbar and Hotkeys | 00:30:00 | ||
| Set Macro Security | 01:00:00 | ||
| Insert Text | 00:30:00 | ||
| Format Text | 00:30:00 | ||
| Sort Data | 00:30:00 | ||
| Duplicate Data | 01:00:00 | ||
| Generate a Report | 01:00:00 | ||
| Determine the Dialog Box Type | 00:15:00 | ||
| Capture User Input | 01:00:00 | ||
| Insert, Copy, and Delete Worksheets | 00:30:00 | ||
| Rename Worksheets | 00:30:00 | ||
| Modify the Order of Worksheets | 00:15:00 | ||
| Print Worksheets | 00:30:00 | ||
| Create User-Defined Functions | 00:30:00 | ||
| Automate SUM Functions | 00:30:00 | ||
| Activities – Microsoft Excel 2016 and VBA | 00:00:00 | ||
| Microsoft Office 2016 Excel Advanced - Certified Video Training | |||
| Use Links and External References | 00:12:00 | ||
| Use 3-D References | 00:06:00 | ||
| Consolidate Data | 00:05:00 | ||
| Use Lookup Functions | 00:12:00 | ||
| Trace Cells | 00:09:00 | ||
| Watch and Evaluate Formulas | 00:08:00 | ||
| Collaborate on a Workbook | 00:19:00 | ||
| Protect Worksheets and Workbooks | 00:08:00 | ||
| Apply Data Validation | 00:13:00 | ||
| Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
| Work with Macros | 00:18:00 | ||
| Create Sparklines | 00:07:00 | ||
| MapData | 00:07:00 | ||
| Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
| Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
| Use the Goal Seek Feature | 00:04:00 | ||
| Forecasting Data Trends | 00:05:00 | ||
| Microsoft Excel 2016 PowerPivot Advanced | |||
| Enable and Navigate | 00:30:00 | ||
| Import Data from Various Data Sources | 01:00:00 | ||
| Refresh Data from a Data Source | 00:30:00 | ||
| Create Linked Tables | 00:30:00 | ||
| Organize and Format Tables | 00:30:00 | ||
| Create Calculated Columns | 00:30:00 | ||
| Sort and Filter PowerPivot Data | 00:30:00 | ||
| Create and Manage Table Relationships | 01:00:00 | ||
| Create PivotTables | 01:00:00 | ||
| Create PivotCharts | 00:30:00 | ||
| Create Power Views | 01:00:00 | ||
| Filter Data Using Slicers | 00:30:00 | ||
| Present PivotTable Data Visually | 01:00:00 | ||
| Manipulate PowerPivot Data Using DAX Functions | 01:00:00 | ||
| Extract Data from Tables Using Functions | 00:30:00 | ||
| Save Reports in Different File Formats | 01:00:00 | ||
| Work with Time Dependent Data | 00:30:00 | ||
| Protect Reports | 00:30:00 | ||
| Activities – Microsoft Excel 2016 PowerPivot Advanced | 00:00:00 | ||
| Mock Exam – Microsoft Excel 2016 Intermediate Training Diploma | |||
| Mock Exam – Microsoft Excel 2016 Intermediate Training Diploma | 00:20:00 | ||
| Final Exam – Microsoft Excel 2016 Intermediate Training Diploma | |||
| Final Exam – Microsoft Excel 2016 Intermediate Training Diploma | 00:20:00 | ||
| Mock Exam – Microsoft Excel 2016 Advanced Level | |||
| Mock Exam – Microsoft Excel 2016 Advanced Level | 00:20:00 | ||
| Final Exam – Microsoft Excel 2016 Advanced Level | |||
| Final Exam – Microsoft Excel 2016 Advanced Level | 00:20:00 | ||
| Mock Exam – Microsoft Excel 2016 and VBA Training Diploma | |||
| Mock Exam- Microsoft Excel 2016 and VBA Training Diploma | 00:20:00 | ||
| Final Exam – Microsoft Excel 2016 and VBA Training Diploma | |||
| Final Exam- Microsoft Excel 2016 and VBA Training Diploma | 00:20:00 | ||
Course Ratings
No Ratings found for this course.
