Diploma in Microsoft Excel 2016 Beginner to Advanced
4.5( 6 REVIEWS )
212 STUDENTS
Overview If you’ve always wanted to learn Excel and qualify in it, here’s a great opportunity. Now, you can study …
Overview
If you’ve always wanted to learn Excel and qualify in it, here’s a great opportunity. Now, you can study the Excel course bundle and learn from beginner to intermediate and advanced levels. Excel is an application that is frequently used in multiple sectors and industries. Whether you are an entry level worker or top employee, you will need to apply Excel in the workplace. The Diploma in Microsoft Excel 2016 Beginner to Advanced training is perfect for anyone hoping to learn Excel functions and features to give your CV a boost.
The course bundle will start with an introduction to Excel, teach you intermediate functions and move onto Advanced features. It is a comprehensive course that will make you a master of Excel. Excel is not only used in the office but also at home or in higher education. So if you are a student who wants to gain a thorough training in Excel, this course will benefit you in the long-term.
The course will cover the features of Excel 2016 which starts with teaching you the simple functions and move onto more complicated features. You will learn how to navigate the programme efficiently and operating Excel in any situation will become a breeze. Training in this application will serve your career well making you eligible to progress quickly and forward in the workplace.
- Why consider learning at Study 365?
- What will I Learn?
- This bundle consists of the following courses
- Who is it aimed at?
- Course Description
- Entry Requirements
- Method of Assessment
- Certification
- Career Path
- Other benefits
With so many commitments in our lives, we may not have the time to learn new skills. The beauty of studying online is that you get to find this balance between your education and your daily commitments
Study 365 offers hundreds of online courses to students across the world. Gaining new skills has never been this easy as many of our courses are open to students with little or no qualifications or previous experience. All the courses are up-to-date, relevant, affordable, and will build on existing expertise or give you a jump-start to a new career. The courses are meticulously designed and equals what is offered in a classroom setting. With a solid reputation that has established and made us made us one of the most trusted and reliable online course providers we offer the most convenient path to gain recognised skills and training that will give you the opportunity to put into practice your knowledge and expertise in your chosen career. You can learn at your own pace at Study 365 and you will be provided with all the necessary material, tutorials, qualified course instructor, narrated e-learning modules, interactive quizzes and free resources which include Free CV writing pack, free career support and course demo to make your learning experience enriching and more rewarding.
- Gain a thorough introduction to Excel
- Have a clear understanding of formulas and basic functions
- Learn about spreadsheet presentation
- Learn to edit workbook with multiple sheets
- Learn to use graphic elements to visually present data
- Learn how to protect workbooks and worksheets
- Explore pivot tables
- Microsoft Excel 2016 Introduction
- Microsoft Excel 2016 Intermediate
- Microsoft Excel 2016 Advanced
This course is an introduction level, so it is a suitable programme for anyone who has never used Excel before, or who would like to learn more about this application.
This online training course is comprehensive and is designed to cover the topics listed under the curriculum.
Learners taking this course must be over the age of 16 and should have a basic grasp of English, Maths and ICT. In addition you will need Microsoft Excel 2016 installed onto your computer / laptop / tablet.
PLEASE NOTE: We do not provide any software along with this course, please acquire Microsoft Excel 2016 before you undertake the course.
At the end of the course learners will also take an online multiple choice questions assessment test. This online multiple choice questions assessment test is marked automatically so that you will receive an instant grade and know whether you have passed the course.
Learners who successfully complete the course will be awarded a Diploma in Microsoft Excel 2016 Beginner to Advanced Training.
Although this certificate will not directly qualify you for any job position, it will greatly improve your candidature for a number of jobs across various industries. You can also use this certificate to demand for a higher pay or job promotion from your employer to progress in your career. Below listed are some of the jobs this certificate will help you in, along with the average UK salary per annum according to https://www.payscale.com/career-path-planner,
- Accountant – £28,563 per annum
- Finance manager – £38,241 per annum
- Accounting executive - £22,454 per annum
- Bookkeeper – £20,833 per annum
- Marketing executive – £23,462 per annum
- Written and designed by the industry’s finest expert instructors with over 15 years of experience
- Repeat and rewind all your lectures and enjoy a personalised learning experience
- Unlimited 12 months access from anywhere, anytime
- Save time and money on travel
- Learn at your convenience and leisure
- Eligible for a TOTUM discount card
- Free Career Support Service
Course Curriculum
| Getting Started | |||
| E Certificate Download Guide | 00:00:00 | ||
| ➤ Beginner | |||
| Microsoft Excel 2016 Introduction | |||
| Microsoft Excel 2016 Introduction | 00:00:00 | ||
| Module 01: Introduction To Excel | |||
| Introduction to Excel | 00:00:00 | ||
| Module 02: Creating A Worksheet | |||
| Creating a worksheet | 00:00:00 | ||
| Module 03: Managing Workbooks | |||
| Managing workbooks | 00:00:00 | ||
| Module 04: Formulas And Basic Functions | |||
| Formulas and basic functions | 00:00:00 | ||
| Module 05: Spreadsheet Presentation | |||
| Spreadsheet presentation | 00:00:00 | ||
| Module 06: Rearranging Data | |||
| Rearranging data | 00:00:00 | ||
| Module 07: Printing | |||
| Printing Large Spreadsheets | 00:00:00 | ||
| Exercise Files | |||
| Exercise Files_Excel 2016 | |||
| ➤ Intermediate | |||
| Microsoft Excel 2016 Introduction | |||
| Microsoft Excel 2016 Intermediate – Introduction | 00:00:00 | ||
| Module 01: Statistical And Logical Functions | |||
| Statistical And Logical Functions | 00:00:00 | ||
| Module 02: Working With Multiple Sheets & Books | |||
| Working With Multiple Sheets & Books | 00:00:00 | ||
| Module 03: Sorting, Filtering & Subtotaling Lists | |||
| Sorting, Filtering & Subtotaling Lists | 00:00:00 | ||
| Module 04: Formulas And Basic Functions | |||
| Conditional Formatting | 00:00:00 | ||
| Module 05: Charts | |||
| Charts | 00:00:00 | ||
| Module 06: Using The Worksheet Efficiently | |||
| Using The Worksheet Efficiently | 00:00:00 | ||
| Module 07: Printing Large Spreadsheets | |||
| Printing Large Spreadsheets | 00:00:00 | ||
| Module 08: The Quick Analysis Button 8 | |||
| The Quick Analysis Button 8 | 00:00:00 | ||
| Exercise Files | |||
| Exercise Files – Microsoft Excel 2016 Intermediate | |||
| ➤ Advanced | |||
| Module 01: Text Functions | |||
| Text Functions | 00:00:00 | ||
| Module 02: Date & Time Functions | |||
| Date & Time Functions | 00:00:00 | ||
| Module 03: Understanding The Functions | |||
| Part 1 – Recap | 00:00:00 | ||
| Part 2 – Nested IF with =MAX() Function | 00:00:00 | ||
| Part 3 – Max & Ifs – & And & OR Using If Function | 00:00:00 | ||
| Part 4 – Nested IF with multiple Ifs | 00:00:00 | ||
| Part 5 – IF functions with =AND() & =OR() functions | 00:00:00 | ||
| Module 04: Working With Vlookup | |||
| Part 1 – VLOOKUP To find the nearest match | 00:00:00 | ||
| Part 2 – VLOOKUP To find an exact match | 00:00:00 | ||
| Module 05: Match & Index Functions | |||
| MATCH & INDEX Functions | 00:00:00 | ||
| Module 06: Data Validation | |||
| Data Validation | 00:00:00 | ||
| Module 07: Protecting Worksheets & Workbooks | |||
| Protecting Worksheets & Workbooks | 00:00:00 | ||
| Module 08: Working With Templates | |||
| Working With Templates | 00:00:00 | ||
| Module 09: Exploring Pivot Tables | |||
| Part 1 – Creating, rearranging and updating a Pivot Table | 00:00:00 | ||
| Part 2 – Filtering and grouping data in a Pivot Table | 00:00:00 | ||
| Part 3 – Slicers and timelines | 00:00:00 | ||
| Part 4 – Creating a Pivot chart | 00:00:00 | ||
| Module 10: How To Work With A Macro? | |||
| Part 1 – Recording a macro in a macro-enabled workbook (using relative references) | 00:00:00 | ||
| Part 2 – Running a macro and assigning it to objects | 00:00:00 | ||
| Part 3 – Editing and deleting a macro | 00:00:00 | ||
| Module 11: Conclusion | |||
| Conclusion | 00:00:00 | ||
| Exercise Files | |||
| Exercise Files – Microsoft Excel 2016 Advanced | |||
| Mock Exam | |||
| Mock Exam : Diploma in Microsoft Excel 2016 Beginner to Advanced | 01:00:00 | ||
| Exam | |||
| Exam : Diploma in Microsoft Excel 2016 Beginner to Advanced | 01:00:00 | ||
Dario D'Sanchez
Good course. Learnt a bunch of new features which I look forward to using in day to day life at work. 😀
Yasmin Price
Course rich in content! Keep up the good work.
Lenny Bradley
The tutor support that was given was highly appreciated. My tutor helped me to study and complete this course in record time.
Maria Perry
Thank you for the knowledge given from this course. The course was rich in content and the knowledge was useful for my career as well.
Zofia Shaw
I will recommend this course to others. This has proved to be an amazing and useful learning experience for me.
Joanna Sutton
The flexibility of the course was exceptional as I was given the opportunity to study from the comfort of my own home. Great experience