Accounting
Business
Care & Psychology
Food Hygiene
Health and Safety
7091 Enrolled Students
EnglishCourse Overview
Learn the Latest Skills | Accredited by CPD & IAO | Recognised Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training
We’ve integrated our Microsoft Excel Beginners, Intermediate, and Advanced Courses to provide an even more comprehensive learning experience. What is the end result? The Microsoft Excel Complete Course is our most popular, high-quality, and comprehensive Microsoft Excel course.
This course will teach you how to build and edit workbooks and spreadsheets using Microsoft Excel. Maximizing your Excel knowledge will save you numerous hours and increase your productivity.
What Will You Learn?
- In this course, you will learn about basic Excel skills all the way to advanced tools and functions.
- Master one of the most used tools, PivotTables, to create dynamic reports.
- Learn Formulas for functions such as sum, sumif, countif, average, index, match, and more.
- Learn how to use cells, the ribbon and work with rows and columns. Work with charts, tables, shapes and use filtering and formatting.
- Learn how to use a variety of shortcuts and how to review your work.
- Utilize the full potential of Microsoft Excel by automating routine activities with Macros and VBA.
What classes are included in this package?
- Earn a free certificate upon successful completion accredited by UK and internationally recognised accredited qualification
- There are no set schedules, so you can work at your own pace.
- Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week.
- On weekdays, you’ll have access to a full-time tutor.
- Learn in a user-friendly, cutting-edge online learning environment.
- High-quality e-learning study materials
- Lifetime Access
- Benefit from instant feedback through mock exams and multiple-choice assessments
Who Should Take This Course?
Microsoft Office 2016 Excel Beginner to Advanced is appropriate for anybody seeking substantial information, possible experience, and expert abilities in the associated profession. This is an excellent chance for students of various academic backgrounds to learn more about this topic.
Career Path
People of all backgrounds can use Microsoft Office 2016 Excel to ensure their personal and professional development.
Course Design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
- Mock exams
- Multiple-choice assessments
- Assignment
Certificate of Achievement
Endorsed Certificate of Achievement from the Quality Licence Scheme
Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage.
Certificate of Achievements from Janets
Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.
Endorsed Certificate of Achievement from the Quality Licence Scheme
Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage.
Endorsement
This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.
Method of Assessment
On successful completion of the Microsoft Office 2016 Excel Beginner To Advanced, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately.
Retake fee
If you do not pass the exam first time, you can purchase the Retake Exam for £1.99 and try again.
Featured review
Victoria Kucharczyk
3 Months Ago
That's a really cool course! It's well structured and gives you the really important skills . The real business example also helps to get the practice that is so exciting! Thanks a lot for your work, guys!
Course Curriculum
| Microsoft Excel Beginners | |||
| Getting Started with Microsoft Office Excel 2016 | |||
| Navigate the Excel User Interface | 00:28:00 | ||
| Use Excel Commands | 00:10:00 | ||
| Create and Save a Basic Workbook | 00:19:00 | ||
| Enter Cell Data | 00:12:00 | ||
| Use Excel Help | 00:05:00 | ||
| Performing Calculations | |||
| Create Worksheet Formulas | 00:15:00 | ||
| Insert Functions | 00:17:00 | ||
| Reuse Formulas and Functions | 00:17:00 | ||
| Modifying a Worksheet | |||
| Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
| Search for and Replace Data | 00:09:00 | ||
| Use Proofing and Research Tools | 00:07:00 | ||
| Formatting a Worksheet | |||
| Apply Text Formats | 00:17:00 | ||
| Apply Number Format | 00:08:00 | ||
| Align Cell Contents | 00:09:00 | ||
| Apply Styles and Themes | 00:12:00 | ||
| Apply Basic Conditional Formatting | 00:11:00 | ||
| Create and Use Templates | 00:07:00 | ||
| Printing Workbooks | |||
| Preview and Print a Workbook | 00:10:00 | ||
| Set Up the Page Layout | 00:08:00 | ||
| Configure Headers and Footers | 00:07:00 | ||
| Managing Workbooks | |||
| Manage Worksheets | 00:05:00 | ||
| Manage Workbook and Worksheet Views | 00:07:00 | ||
| Manage Workbook Properties | 00:05:00 | ||
| Microsoft Excel Intermediate | |||
| Working with Functions | |||
| Work with Ranges | 00:18:00 | ||
| Use Specialized Functions | 00:11:00 | ||
| Work with Logical Functions | 00:23:00 | ||
| Work with Date & Time Functions | 00:08:00 | ||
| Work with Text Functions | 00:11:00 | ||
| Working with Lists | |||
| Sort Data | 00:10:00 | ||
| Filter Data | 00:10:00 | ||
| Query Data with Database Functions | 00:09:00 | ||
| Outline and Subtotal Data | 00:09:00 | ||
| Analyzing Data | |||
| Create and Modify Tables | 00:15:00 | ||
| Apply Intermediate Conditional Formatting | 00:07:00 | ||
| Apply Advanced Conditional Formatting | 00:05:00 | ||
| Visualizing Data with Charts | |||
| Create Charts | 00:13:00 | ||
| Modify and Format Charts | 00:12:00 | ||
| Use Advanced Chart Features | 00:12:00 | ||
| Using PivotTables and PivotCharts | |||
| Create a PivotTable | 00:13:00 | ||
| Analyze PivotTable Data | 00:12:00 | ||
| Present Data with PivotCharts | 00:07:00 | ||
| Filter Data by Using Timelines and Slicers | 00:11:00 | ||
| Microsoft Excel Advanced | |||
| Working with Multiple Worksheets and Workbooks | |||
| Use Links and External References | 00:12:00 | ||
| Use 3-D References | 00:06:00 | ||
| Consolidate Data | 00:05:00 | ||
| Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | 00:12:00 | ||
| Trace Cells | 00:09:00 | ||
| Watch and Evaluate Formulas | 00:08:00 | ||
| Sharing and Protecting Workbooks | |||
| Collaborate on a Workbook | 00:19:00 | ||
| Protect Worksheets and Workbooks | 00:08:00 | ||
| Automating Workbook Functionality | |||
| Apply Data Validation | 00:13:00 | ||
| Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
| Work with Macros | 00:18:00 | ||
| Creating Sparklines and Mapping Data | |||
| Create Sparklines | 00:07:00 | ||
| MapData | 00:07:00 | ||
| Forecasting Data | |||
| 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 | ||
| Resources | |||
| Resources – Microsoft Office 2016 Excel Beginner to Advanced | 00:00:00 | ||
| Mock Exam | |||
| Mock Exam – Microsoft Office 2016 Excel Beginner to Advanced | 00:20:00 | ||
| Final Exam | |||
| Final Exam – Microsoft Office 2016 Excel Beginner to Advanced | 00:20:00 | ||
| Assignment | |||
| Assignment – Microsoft Office 2016 Excel Beginner to Advanced | 1 week, 3 days | ||
| Recommended Materials | |||
| Workbook – Microsoft Office 2016 Excel Beginner to Advanced | 2 weeks, 1 day | ||
Related Courses
13
2000+ Premium Courses
- $414.70
- 1 year
- Level 7
- Course Certificate
- Number of Units62
- Number of Quizzes2
- 3 weeks, 4 days
