Microsoft Excel: Microsoft Excel Diploma

Are you interested to begin your microsoft excel career or want to gain more advanced skills in microsoft excel? Then this microsoft excel diploma course will help you get one step closer to your professional aspirations and develop your skills and knowledge in microsoft excel for a rewarding career. Gain microsoft excel skills and credentials that employers value.

This course is accredited by the CPD UK. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards to your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world.

Master the skills you need to propel your career forward in microsoft excel. Equip yourself with the essential knowledge and skillset that make you a confident office admin and take your career to the next level. This comprehensive microsoft excel diploma course is designed to help you reach your professional goals.

The skills and knowledge that you will gain through studying this microsoft excel diploma course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career.

This comprehensive microsoft excel diploma course will teach you the theory of effective microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the microsoft excel industry. You’ll gain a solid understanding of the core competencies required to drive a successful career in microsoft excel.

Learn from expert tutors with industry experience, teaching you the latest expertise and best practice. This extensive microsoft excel diploma course is designed for microsoft excel professionals who are aspiring to specialise in microsoft excel. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV.

Enrol today and take the next step towards your personal and professional goals.

Why choose this course?

• CPD UK & IPHM Accredited Course
• FREE GIFT: Course Completion PDF & Hardcopy Certificates, MCQ Exam & Full Tutor Support Included
• Get dual certificate (2 accredited certificate) in 1 course (CPD UK and IPHM)
• Unlimited lifetime access
• Instructor-led distance learning
• Get trained by industry experts
• 24/7 student support system
• Learn at your own pace and leisure
• Earn industry-recognised credentials
• User-friendly, advanced online learning material
• Effective training, written and designed by certified professional

***Additional GIFT***

• Course Completion PDF & Hardcopy Certificate, MCQ Exam & Full Tutor Support Included
• 2 Accreditation in 1 Course (CPD UK and IPHM)

Reason to learn with Study Plex

• Over 89,000 students taught across a range of fully certified courses
• Offering learners the chance to acquire the most in-demand and marketable skills
• Full commitment to helping our students find success on their chosen path
• Partnership with some of the world's best-known accreditation organisations
• Full belief in you, your success, and your ability to thrive
  

Reed courses certificate of completion

Digital certificate - Included

• Obtain Your Student ID Card 01:00

  • 1: Obtain Your Student ID Card 01:00

• Supplementary Resources 01:00

  • 2: Supplementary Resources 01:00

• Introduction to Microsoft Excel 40:28

  • 3: 0101 Touring the interface 03:21
  • 4: 0102 Enter data & saving workbook 04:50
  • 5: 0103 Applying Formulas 03:30
  • 6: 0104 Changing a worksheet’s structure 04:04
  • 7: 0105 Find, Replace & Spell Check 03:15
  • 8: 0106 Applying fonts, background colors, and borders 05:01
  • 9: 0107 Formatting numbers and dates 04:43
  • 10: 0108 Making the pieces fit 04:22
  • 11: 0109 Inserting headers & footers and Repeating Rows 02:21
  • 12: 0110 Managing Large Workbooks 05:01

• Excel Essentials 10:28

  • 13: 0201 Formula Writing (Don’t Miss This) 08:28
  • 14: Ex 0201 Formula Writing (Don’t Miss This) 02:00

• Sum Count Average Functionality - With Conditions 51:33

  • 15: 0301 SumIf & SumIfs 24:32
  • 16: Ex 0301 SumIf & SumIfs 08:23
  • 17: 0302 Count Functions 08:24
  • 18: Ex 0302 Count Functions 02:46
  • 19: 0303 AverageIf & AverageIfs 03:39
  • 20: Ex 0303 AverageIf & AverageIfs 03:49

• Text Functions - Manipulating Text 34:33

  • 21: 0401 Change Case (Upper, Lower, Proper) 04:32
  • 22: Ex 0401 Change Case (Upper, Lower, Proper) 03:39
  • 23: 0402 Separating Text on Symmetrical Data 06:26
  • 24: Ex 0402 Separating Text on Symmetrical Data 05:57
  • 25: 0403 Separating Text on Non-Symmetrical Data 08:47
  • 26: Ex 0403 Separating Text on Non-Symmetrical Data 05:12

• Logical Functions - Working With Conditions 55:18

  • 27: 0501 If Functionality 04:31
  • 28: Ex 0501 IF Functionality 03:13
  • 29: 0502 If with AND 05:40
  • 30: Ex 0502 If with AND 03:45
  • 31: 0503 If with OR 03:22
  • 32: Ex 0503 If with OR 02:53
  • 33: 0504 If with “AND” & “OR” / IF with Countif 08:43
  • 34: Ex 0504 If with “AND” & “OR” / IF with Countif 04:12
  • 35: 0505 Nested IF (A Genie with 3 wishes) 13:34
  • 36: Ex 0505 Nested IF (A Genie with 3 wishes) 05:25

• Lookup Functionality - Burn Simple Find Technique 2:50:10

  • 37: 0601 Vlookup (Exact Match) # 1 22:59
  • 38: Ex 0601 Vlookup (Exact Match) # 1 03:52
  • 39: 0602 Type of References (Use of $ sign) 11:35
  • 40: 0603 Vlookup (Exact Match) # 2 04:03
  • 41: Ex 0603 Vlookup (Exact Match) # 2 06:30
  • 42: 0604 Double Vlookup 11:13
  • 43: Ex 0604 Double Vlookup 10:10
  • 44: 0605 Vlookup on Duplicate Values 10:10
  • 45: Ex 0605 Vlookup on Duplicate Values 05:50
  • 46: 0606 Vlookup (Approximate Match) 08:11
  • 47: Ex 0606 Vlookup (Approximate Match) 02:13
  • 48: 0607 Vlookup with If (Conditional Vlookup) 04:53
  • 49: Ex 0607 Vlookup with If (Conditional Vlookup) 02:54
  • 50: 0608 Hlookup (Exact Match) 03:46
  • 51: Ex 0608 Hlookup (Exact Match) 03:42
  • 52: 0609 Hlookup (Approximate Match) 02:02
  • 53: Ex 0609 Hlookup (Approximate Match) 02:20
  • 54: 0610 Lookup (Don’t use this !) 05:19
  • 55: Ex 0610 Lookup (Don’t use this !) 01:58
  • 56: 0611 Vlookup with Match (Create Magical Vlookup) 14:16
  • 57: Ex 0611 Vlookup with Match (Create Magical Vlookup) 05:40
  • 58: 0612 Match (Gives us Column/Row Index #) 03:14
  • 59: Ex 0612 Match (Gives us Column/Row Index #) 02:55
  • 60: 0613 Index & Match (Made for Each Other) 11:02
  • 61: Ex 0613 (1) Index & Match (Made for Each Other) 05:31
  • 62: Ex 0613 (2) Index & Match (Made for Each Other) 03:52

• Date & Time Function - A Tricky Game 16:04

  • 63: 0701 How Excel Records Date & Time 02:25
  • 64: 0702 Now, Today & Autofill 02:41
  • 65: 0703 Date Value & Time Value 02:23
  • 66: 0704 Calculate Working Days 03:15
  • 67: 0705 DatedIf 05:20

• Financial Functions 38:38

  • 68: 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 12:41
  • 69: Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 07:39
  • 70: 0802 Creating a Loan Table 02:51
  • 71: Ex 0802 Creating a Loan Table 09:48
  • 72: 0803 Calculate Depriciation 02:51
  • 73: Ex 0803 Calculate Depriciation 02:48

• Sort & Filter 1:39:39

  • 74: 0901 Basic Sorting & Shortcut keys 16:14
  • 75: Ex 0901 Basic Sorting & Shortcut keys 06:48
  • 76: 0902 Sorting Using Custom List 08:28
  • 77: Ex 0902 Sorting Using Custom List 02:41
  • 78: 0903 Horizontal Sorting 01:27
  • 79: Ex 0903 Horizontal Sorting 01:17
  • 80: 0904 Basic Filter & Shortcut Keys 09:28
  • 81: Ex 0904 Basic Filter & Shortcut Keys 05:19
  • 82: 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 05:56
  • 83: Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 03:19
  • 84: 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 07:33
  • 85: Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 02:49
  • 86: 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 07:45
  • 87: Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 01:40
  • 88: 0908 Advanced Filter (Applying Complex Criteria’s) 13:07
  • 89: Ex 0908 Advanced Filter (Applying Complex Criteria’s) 05:48

• Excel Charts - Visual Presentation 1:09:06

  • 90: 1001 How to create a chart 06:23
  • 91: 1002 Format Axis 02:01
  • 92: 1003 Plot Values on Secondary Axis 03:56
  • 93: 1004 Life of Pie (Charts) 03:39
  • 94: 1005 How to Show Axis Title 02:34
  • 95: 1006 How to Show Data Label 02:11
  • 96: 1007 Show data with chart in Data Table 02:02
  • 97: 1008 Column Chart 02:03
  • 98: 1009 Bar Chart 01:33
  • 99: 1010 Line Chart 1 03:05
  • 100: 1011 Line Chart 2 02:42
  • 101: 1012 Area Chart 01:22
  • 102: 1013 Pie Chart 02:35
  • 103: 1014 Pie of Pie or Bar of Pie 02:34
  • 104: 1015 Line Chart with Log Scale 02:07
  • 105: 1016 Bubble Chart 01:21
  • 106: 1017 Selecting Chart Elements 05:17
  • 107: 1018 Use of Format Dialog box 03:07
  • 108: 1019 Modifying Chart & Plot Area 04:21
  • 109: 1020 Modifying Data Series 02:05
  • 110: 1021 How to handle Missing Data 03:57
  • 111: 1022 Modifying 3-D Charts 02:57
  • 112: 1023 Creating Combination of upto 5 Different Charts 03:02
  • 113: 1025 Creating Picture Charts 02:12

• Data Consolidation - Multiple Workbooks Worksheets 09:37

  • 114: Consolidate Data using Excel Inbuilt Function 06:38
  • 115: Ex Consolidate Data using Excel Inbuilt Function 02:59

• Data Validation 47:22

  • 116: 1201 Applying Data Validation 13:26
  • 117: Ex 1201 Applying Data Validation 04:57
  • 118: 1202 Dependent Dropdown List 07:34
  • 119: Ex1202 Dependent Dropdown List 04:55
  • 120: Using Data Validation with Vlookup & Match 05:52
  • 121: Other Data Validation Examples 10:38

• Protection of Worksheet Workbook 21:00

  • 122: 1301 Worksheet Level Protection 01:27
  • 123: Ex 1301 Worksheet Level Protection 00:49
  • 124: 1302 Cell Level Protection 05:00
  • 125: Ex 1302 Cell Level Protection 02:04
  • 126: 1303 Hiding Formulas from Formula Bar 03:14
  • 127: Ex 1303 Hiding Formulas from Formula Bar 02:30
  • 128: 1304 Protecting Workbook Structure 01:10
  • 129: Ex 1304 Protecting Workbook Structure 01:07
  • 130: 1305 Workbook Level Protection 02:29
  • 131: Ex 1305 Workbook Level Protection 01:10

• Pivot Table & Techniques 43:32

  • 132: 1401 Understanding pivot Table 12:33
  • 133: 1402 Using Pivot Table in Real Scenario 10:18
  • 134: Ex 1402 Using Pivot Table in Real Scenario 09:39
  • 135: 1403 Grouping in Pivot Table 04:24
  • 136: Ex 1403 Grouping in Pivot Table 01:36
  • 137: 1404 Using Slicers (A Visually attractive Filter) 03:29
  • 138: Ex 1404 Using Slicers (A Visually attractive Filter) 01:33

• What-If Analysis & Solver Add-In 24:53

  • 139: 1501 Goal Seek (A Reverse Approach) 04:19
  • 140: Ex 1501 Goal Seek (A Reverse Approach) 02:48
  • 141: 1502 One Way Data Table 02:55
  • 142: 1503 Two Way Data Table 02:50
  • 143: 1504 Scenario Manager 04:09
  • 144: 1505 Solver Add-In 07:52

• Automation in Excel - Macros 25:07

  • 145: 1601 Record your first Macro 15:18
  • 146: 1602 Record Another Macro 02:02
  • 147: 1603 Assigning macro to a Shape, Button, Picture etc 02:46
  • 148: 1604 Editing or Deleting a Macro 03:01
  • 149: 1605 Security Settings of a Macro 02:00

• Assessment 07:00

  • 150: Assessment 06:00
  • 151: Obtain Your Accredited Certificate of Achievement 01:00

This extensive microsoft excel diploma course is designed by industry experts; this microsoft excel diploma course will provide you with the skills and knowledge you need to succeed. Not only will it make you more lucrative to potential employers, but it will also give you the confidence to apply for that dream job.

This microsoft excel diploma course is divided into bite-sized modules to make it easy to follow. Whether you are travelling around the world or juggling work and family, this course can be completed anytime, anywhere. This flexibility enables you to learn at your own pace, fitting your studies around your current lifestyle.

Course Curriculum

This comprehensive microsoft excel diploma course covers the following modules:

Introduction to Microsoft Excel

• 0101 Touring the interface
• 0102 Enter data & saving workbook
• 0103 Applying Formulas
• 0104 Changing a worksheet’s structure
• 0105 Find, Replace & Spell Check

Excel Essentials

• 0201 Formula Writing (Don’t Miss This)
• Ex 0201 Formula Writing (Don’t Miss this)

Sum Count Average Functionality - With Conditions

• 0301 SumIf & SumIfs
• Ex 0301 SumIf & SumIfs
• 0302 Count Functions
• Ex 0302 Count Functions
• 0303 average & averages

Text Functions - Manipulating Text

• 0401 Change Case (Upper, Lower, Proper)
• Ex 0401 Change Case (Upper, Lower, Proper)
• 0402 Separating Text on Symmetrical Data
• Ex 0402 Separating Text on Symmetrical Data

Logical Functions - Working With Conditions

• 0501 If Functionality
• Ex 0501 IF Functionality
• 0502 If with AND
• Ex 0502 If with AND
• 0503 If with OR
• Ex 0503 If with OR

Lookup Functionality - Burn Simple Find Technique

• 0601 Vlookup (Exact Match) # 1
• Ex 0601 Vlookup (Exact Match) # 1
• 0602 Type of References (Use of $ sign)
• 0603 Vlookup (Exact Match) # 2
• Ex 0603 Vlookup (Exact Match) # 2
• 0604 Double Vlookup

Date & Time Function - A Tricky Game

• 0701 How Excel Records Date & Time
• 0702 Now, Today & Autofill
• 0703 DateValue & TimeValue
• 0704 Calculate working days
• 0705 DatedIf

Financial Functions

• 0801 Loan Calculation (PMT, PPMT, IPMT, etc.)
• Ex 0801 Loan Calculation (PMT, PPMT, IPMT, etc.)
• 0802 Creating a Loan Table
• Ex 0802 Creating a Loan Table
• 0803 Calculate Depreciation

Sort & Filter

• 0901 Basic Sorting & Shortcut keys
• Ex 0901 Basic Sorting & Shortcut keys
• 0902 Sorting Using Custom List
• 0903 Horizontal Sorting
• Ex 0903 Horizontal Sorting

Excel Charts - Visual Presentation

• 1001 How to create a chart
• 1002 Format Axis
• 1003 Plot Values on Secondary Axis
• 1004 Life of Pie (Charts)
• 1005 How to Show Axis Title
• 1006 How to Show Data Label

Data Consolidation - Multiple WorkBooks WorkSheets

• Consolidate Data using Excel Inbuilt Function
• Ex Consolidate Data using Excel Inbuilt Function

Data Validation

• 1201 Applying Data Validation
• Ex 1201 Applying Data Validation
• 1202 Dependent Dropdown List
• Ex1202 Dependent Dropdown List
• Using Data Validation with Vlookup & Match

Protection of Worksheet Workbook

• 1301 Worksheet Level Protection
• Ex 1301 Worksheet Level Protection
• 1302 Cell Level Protection
• Ex 1302 Cell Level Protection
• 1303 Hiding Formulas from Formula Bar

Pivot Table & Techniques

• 1401 Understanding pivot Table
• 1402 Using Pivot Table in Real Scenario
• Ex 1402 Using Pivot Table in Real Scenario
• 1403 Grouping in Pivot Table
• Ex 1403 Grouping in Pivot Table
• 1404 Using Slicers (A Visually attractive Filter)

What-If Analysis & Solver Add-In

• 1501 Goal Seek (A Reverse Approach)
• Ex 1501 Goal Seek (A Reverse Approach)
• 1502 One Way Data Table
• 1503 Two Way Data Table
• 1504 Scenario Manager

Automation in Excel - Macros

• 1601 Record your first Macro
• 1602 Record Another Macro
• 1603 Assigning a macro to a Shape, Button, etc
• 1604 Editing or Deleting a Macro

Supplementary Resources

• Supplementary Resources

How am I assessed?

Once you have completed the microsoft excel diploma course, you will then be required to undertake an online MCQ assessment. This exam will cover everything you have already learnt. This means that you will have plenty of time to study and prepare for the assessment before taking it.

The assessment itself is made up of multiple-choice questions in your chosen subject area. You will receive your results straight after completion.

Become Certified

Explore new skills

Equip yourself with the essential skills, confidence and competence to assist you in your chosen industry.

Accelerate your career

Learn the most in-demand skills, get certified and level up your career. This microsoft excel diploma online training course is designed to help you reach your professional goals.

Make your CV stand out

Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV.

Certificate of Completion

After successfully finishing the course, you will be eligible to order your free PDF & Hardcopy certificate of course completion. There is a minimal shipping charge to get the hardcopy course completion certificate which is:

• Inside the UK = £5.99
• International Students = £16.99

CPD and IPHM Accredited Certificate of Achievement

Grow your career by earning CPD and IPHM accredited certificate of achievement and add extra value to your CV. On successful completion of this microsoft excel diploma course, you will be eligible to order your CPD and IPHM accredited certificate of achievement (dual certificate) to demonstrate your new skills. You can also share this certificate with prospective employers and your professional network. The CPD and IPHM accredited certificate of achievement (dual certificate) can be obtained in PDF format at the nominal fee of £12; there is an additional fee to get a printed copy certificate which is £25.

If you are a beginner or already working as a office admin, or are considering a career in microsoft excel, then this microsoft excel diploma course will give you a solid understanding of the core competencies required to drive a successful career in microsoft excel.

This microsoft excel diploma course is suitable for all skill levels and backgrounds. Whether you want to advance your career prospects, learn a new skill, or broaden your educational horizons this microsoft excel diploma course will help you to gain a solid understanding of the core competencies required to drive a successful career in your chosen industry.

Academic

This microsoft excel diploma course is open to students of all academic backgrounds aiming to enhance their skills.

Age

At Study Plex, we invite everyone to learn. This microsoft excel diploma course is open to anyone aged 16 and over.

Eligibility

If you have a basic grasp of English, numeracy and ICT, you will be eligible to enrol.

This microsoft excel diploma course will equip you with the essential skills and credentials to demonstrate your new skills and add extra value to your CV. On successful completion of this microsoft excel diploma course, you will gain a solid understanding of the core competencies required to drive a successful career in your chosen industry.

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