Excel : Microsoft Excel Beginner to Advanced

Diploma in Microsoft Excel 2016 (Beginner to Advanced)

----------Gain Access to 5 FREE Courses!!!----------

**Complimentary Course Bundle - 5 Courses Absolutely FREE**

• Course 1 : Microsoft Excel 2016 - Beginner
• Course 2 : Mastering Data Analysis with Excel
• Course 3 : Advanced Microsoft Excel 2016 Training
• Course 4 : Microsoft Word 2016 Beginner
• Course 5 : Advanced Microsoft Word 2016 Training

Microsoft Excel has grown to become arguably the most important computer program in workplaces around the world. , you generally would use Excel. In business, any function in any industry can benefit from those with strong Excel knowledge. Excel is a powerful tool that has become entrenched in business processes worldwide - whether for analysing stocks or issuers, budgeting, or organising client sales lists.

Working knowledge of Excel is vital for most office-based professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities. Excel is a powerful tool but cannot function alone. This course will help you to take advantage of everything Excel has to offer to provide the best results for their company. No matter what industry you go into, these essential skills will help you advance in your career.

In this Diploma in Microsoft Excel 2016 (Beginner to Advanced) course, you will learn the very basics of Excel all the way to advanced Excel skills used by the experts in Excel such as data validation, slicers and timelines, and running macros.

• Microsoft Excel 2016 Introduction 03:09

  • 1: Microsoft Excel 2016 Introduction Preview 03:09

• Module 01: Introduction to Excel 1:07:23

  • 2: Module One – Introduction to Excel 1:07:23

• Module 02: Creating a Worksheet 28:49

  • 3: Module Two – Creating a worksheet 28:49

• Module 03: Managing Workbooks 33:17

  • 4: Module Three – Managing workbooks 33:17

• Module 04: Formulas and Basic Functions 36:03

  • 5: Module Four – Formulas and basic functions 36:03

• Module 05: Spreadsheet Presentation 54:33

  • 6: Module Five – Spreadsheet presentation 54:33

• Module 06: Rearranging Data 34:20

  • 7: Module Six – Rearranging data 34:20

• Module 07: Printing 19:02

  • 8: Module Seven – Printing 19:02

• Exercise Files 01:00

  • 9: Exercise Files - Microsoft Excel 2016 Beginner 01:00

• Microsoft Excel 2016 Introduction 02:29

  • 10: Microsoft Excel 2016 Intermediate – Introduction 02:29

• Module 01: Statistical and Logical Functions 43:19

  • 11: Module One – Statistical And Logical Functions 43:19

• Module 02: Working With Multiple Sheets & Books 44:56

  • 12: Module Two – Working With Multiple Sheets & Books 44:56

• Module 03: Sorting, Filtering & Subtotaling Lists 42:00

  • 13: Module Three – Sorting, Filtering & Subtotaling Lists 42:00

• Module 04: Formulas and Basic Functions 21:25

  • 14: Module Four – Conditional Formatting 21:25

• Module 05: Charts 36:40

  • 15: Module Five – Charts 36:40

• Module 06: Using the Worksheet Efficiently 28:07

  • 16: Module Six – Using The Worksheet Efficiently 28:07

• Module 07: Printing Large Spreadsheets 19:02

  • 17: Module Seven – Printing Large Spreadsheets 19:02

• Module 08: The Quick Analysis Button 8 18:41

  • 18: Module Eight – The Quick Analysis Button 8 18:41

• Exercise Files 01:00

  • 19: Exercise Files – Microsoft Excel 2016 Intermediate 01:00

• Module 01: Text Functions 36:58

  • 20: Module 1 – Text Functions 36:58

• Module 02: Date & Time Functions 28:38

  • 21: Module 2 – Date & Time Functions 28:38

• Module 03: Understanding the functions 30:07

  • 22: Module 3 – Part 1 – Recap 01:44
  • 23: Module 3 – Part 2 – Nested IF with =MAX() Function 07:13
  • 24: Module 3 – Part 3 – Max & Ifs – & And & OR Using If Function 05:38
  • 25: Module 3 – Part 4 – Nested IF with multiple Ifs 06:26
  • 26: Module 3 – Part 5 – IF functions with =AND() & =OR() functions 09:06

• Module 04: Working With VLOOKUP 26:40

  • 27: Module 4 – Part 1 – VLOOKUP To find the nearest match 09:36
  • 28: Module 4 – Part 2 – VLOOKUP To find an exact match 17:04

• Module 05: MATCH & INDEX Functions 21:36

  • 29: Module 5 – MATCH & INDEX Functions 21:36

• Module 06: Data Validation 12:14

  • 30: Module 6 – Data Validation 12:14

• Module 07: Protecting Worksheets & Workbooks 07:58

  • 31: Module 7 – Protecting Worksheets & Workbooks 07:58

• Module 08: Working With Templates 09:55

  • 32: Module 8 – Working With Templates 09:55

• Module 09: Exploring Pivot Tables 57:18

  • 33: Module 9 – Part 1 – Creating, rearranging and updating a Pivot Table 17:51
  • 34: Module 9 – Part 2 – Filtering and grouping data in a Pivot Table 15:46
  • 35: Module 9 – Part 3 – Slicers and timelines 11:11
  • 36: Module 9 – Part 4 – Creating a Pivot chart 12:30

• Module 10: How to Work With a Macro? 29:24

  • 37: Module 10 – Part 1 – Recording a macro in a macro-enabled workbook 11:12
  • 38: Module 10 – Part 2 – Running a macro and assigning it to objects 06:35
  • 39: Module 10 – Part 3 – Editing and deleting a macro 11:37

• Module 11: Conclusion 01:16

  • 40: Module 11 – Conclusion 01:16

• Exercise Files 01:00

  • 41: Exercise Files – Microsoft Excel 2016 Advanced 01:00

• Exams 1:06:00

  • 42: Mock Exam 35:00
  • 43: Final Exam 31:00

The Diploma in Microsoft Excel 2016 (Beginner to Advanced) contains the following courses:

• Microsoft Excel 2016
• Introduction Microsoft Excel 2016
• Intermediate Microsoft Excel 2016 Advanced

Learning Outcomes

• Gain a thorough introduction to Excel and be able to navigate thought the software with total ease
• Learn the intermediate level functions of Microsoft Excel such as creating tables, conditional formatting, and the quick analysis button
• Study the advanced level functions of Microsoft Excel such as data validation, slicers and timelines, and running macros.
• Have a clear understanding of formulas and basic functions

Access Duration

The course will be delivered directly to you, and from the date you joined the course you have 12 months of access to the online learning platform. The course is self-paced, and you can complete it in stages at any time.

Method of Assessment

In order to complete the course successfully, learners will take an online assessment. This online test is marked automatically, so you will receive an instant grade and know whether you have passed the course.

Certification

Upon the successful completion of the course, you will be awarded the ‘Diploma in Microsoft Excel 2016 (Beginner to Advanced)’ certificate by CPD.

Awarding Body

CPD is an internationally recognised qualification that will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in an enterprise.

This course is introduction level, so will be suitable for those who have never used Excel before, or who would like an introduction to the programme.

• Learners should be over the age of 16, and have a basic understanding of English, ICT and numeracy.
• A sound educational background is recommended

Below given are a few of the jobs this certificate will help you in, along with the average UK salary per annum

• Accountant – £28,563 per annum
• Accounting executive - £22,454 per annum
• Finance manager – £38,241 per annum
• Marketing executive – £23,462 per annum
• Bookkeeper – £20,833 per annum

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included