CPD Accredited Microsoft Office Skills Mastery: Excel, Word, Access & Data Analysis

This Microsoft Office Skills Bundle includes the following courses:

➥ Course 01: Mastering Microsoft Office 2021
Elevate your Microsoft Office skills to an advanced level with this focused training on Excel, Word, and Access. Master essential tools and advanced features in Microsoft Office 2021 to boost productivity, streamline workflows, and improve work performance through practical, real-world applications.

➥ Course 02: Data Science & Data Analysis Diploma for Data Analyst
While not directly focused on Microsoft Office, this course supports professionals looking to complement their Microsoft Office skills with strong analytical capabilities. Learn to collect, interpret, and visualise data using industry-relevant tools, enabling you to turn complex datasets into actionable business insights.

➥ Course 03: Bookkeeper Training
Strengthen your financial management with hands-on training in bookkeeping, while enhancing your Microsoft Office skills for use in finance-related tasks. Learn to record transactions, maintain ledgers, and prepare accurate financial reports using tools like Excel to meet professional standards.

➥ Course 04: Functional Skills IT
Build essential digital competencies with this foundational IT course, ideal for improving day-to-day Microsoft Office skills. Learn to use software applications, manage files, communicate online, and understand data security—all crucial for personal, academic, and professional success.

➥ Course 05: Basics of Accounting
This entry-level course introduces accounting fundamentals while integrating core Microsoft Office skills for financial documentation and analysis. Learn double-entry bookkeeping, how to prepare income statements, and use spreadsheets to manage and present financial data with clarity and accuracy.

This Microsoft Office Skills Bundle Offer 2 Gift Courses:

• Gift Course 01: Admin, Secretarial and PA Diploma Level 3
• Gift Course 02: Managerial Leadership

Reed Courses Certificate of Completion

Digital certificate - Included

CPD Accredited Certificate

Digital certificate - £10

• Course 01: Mastering Microsoft Office 2021 8:16:59

  • 1: Microsoft Office Skills _ 1a Introduction 02:58
  • 2: Microsoft Office Skills _ 1b Getting started on Windows macOS and Linux 01:21
  • 3: Microsoft Office Skills _ 1c How to ask great questions 01:14
  • 4: Microsoft Office Skills _ 1d FAQs 01:19
  • 5: Microsoft Office Skills _ 2a Excel Overview 05:20
  • 6: Microsoft Office Skills _ 2b Start Excel Spreadsheet 04:26
  • 7: Microsoft Office Skills _ 2c Enter Text and Numbers 07:24
  • 8: Microsoft Office Skills _ 2d Relative References 03:40
  • 9: Microsoft Office Skills _ 2e Working with ranges 06:52
  • 10: Microsoft Office Skills _ 2f Save and Save as Actions 07:52
  • 11: Microsoft Office Skills _ 2g File Extensions, Share, Export, and Publish files 05:53
  • 12: Microsoft Office Skills _ 3a Adding Rows and Columns 02:34
  • 13: Microsoft Office Skills _ 3b Modifying Rows and Column lengths 05:03
  • 14: Microsoft Office Skills _ 4a Copy Cut and Paste 07:07
  • 15: Microsoft Office Skills _ 4b Copying Formulas 03:01
  • 16: Microsoft Office Skills _ 5a Page setup options 05:50
  • 17: Microsoft Office Skills _ 5b Fit to print on One Page 02:39
  • 18: Microsoft Office Skills _ 5c Print Workbooks 02:47
  • 19: Microsoft Office Skills _ 6a Sorting Data Ascending Order 03:48
  • 20: Microsoft Office Skills _ 6b Sorting Data Descending Order 02:25
  • 21: Microsoft Office Skills _ 6c Filter Data 04:09
  • 22: Microsoft Office Skills _ 7a Basic formula operations 06:14
  • 23: Microsoft Office Skills _ 7b Date time functions 06:20
  • 24: Microsoft Office Skills _ 7c Mathematical functions phase1 19:54
  • 25: Microsoft Office Skills _ 7d Mathematical functions phase2 12:23
  • 26: Microsoft Office Skills _ 8a V Lookup formula 12:12
  • 27: Microsoft Office Skills _ 8b HLookup formula 04:07
  • 28: Microsoft Office Skills _ 9a XLookup 07:39
  • 29: Microsoft Office Skills _ 9b Handling NA and Approximates match in XLookup 10:31
  • 30: Microsoft Office Skills _ 10a Split Text into columns 07:03
  • 31: Microsoft Office Skills _ 10b Flash Fill 07:03
  • 32: Microsoft Office Skills _ 10c Data Validation 06:34
  • 33: Microsoft Office Skills _ 10d Remove Duplicates 07:47
  • 34: Microsoft Office Skills _ 10e Get - import Data from Text 05:38
  • 35: Microsoft Office Skills _ 10f Get - import Data from CSV 03:22
  • 36: Microsoft Office Skills _ 11a Formatting Font 04:15
  • 37: Microsoft Office Skills _ 11b Formatting Alignment 06:04
  • 38: Microsoft Office Skills _ 11c Formatting Number 04:37
  • 39: Microsoft Office Skills _ 11d Formatting Date 03:29
  • 40: Microsoft Office Skills _ 11e Formatting tables 05:13
  • 41: Microsoft Office Skills _ 12a Creating Pivot Table 06:43
  • 42: Microsoft Office Skills _ 12b Pivot charts 01:49
  • 43: Microsoft Office Skills _ 13a Excel Charts – Categories 02:30
  • 44: Microsoft Office Skills _ 13b Elements of a chart 04:12
  • 45: Microsoft Office Skills _ 13c Creating charts 01:55
  • 46: Microsoft Office Skills _ 13d Column or Bar charts 04:21
  • 47: Microsoft Office Skills _ 13e Formatting charts 03:37
  • 48: Microsoft Office Skills _ 13f Line charts 02:13
  • 49: Microsoft Office Skills _ 13g Pie and Doughnut charts 03:47
  • 50: Microsoft Office Skills _ 14a Overview 03:47
  • 51: Microsoft Office Skills _ 14b Start PowerPoint Presentation 04:59
  • 52: Microsoft Office Skills _ 14c Screen setting and Views 04:37
  • 53: Microsoft Office Skills _ 15a Presentation Tips and Guidelines 06:00
  • 54: Microsoft Office Skills _ 15b Creating a New Presentation 03:51
  • 55: Microsoft Office Skills _ 15c Working with Slides 03:40
  • 56: Microsoft Office Skills _ 15d Save a Presentation 04:16
  • 57: Microsoft Office Skills _ 15e Print Slides 03:10
  • 58: Microsoft Office Skills _ 16a Formatting Text 05:05
  • 59: Microsoft Office Skills _ 16b Slide Text Alignments 03:01
  • 60: Microsoft Office Skills _ 16c Multi-Column Text Alignments 01:40
  • 61: Microsoft Office Skills _ 16d Adding Bullets and Numbered List Items 02:48
  • 62: Microsoft Office Skills _ 17a Insert Shapes 03:26
  • 63: Microsoft Office Skills _ 17b Insert Icons 03:02
  • 64: Microsoft Office Skills _ 17c Insert Graphics 03:38
  • 65: Microsoft Office Skills _ 17d Add 3D Models 02:41
  • 66: Microsoft Office Skills _ 17e Insert Pictures 02:58
  • 67: Microsoft Office Skills _ 18a Picture Options 03:56
  • 68: Microsoft Office Skills _ 18b Picture Cropping 02:33
  • 69: Microsoft Office Skills _ 18c Applying Built-in Picture Styles 04:02
  • 70: Microsoft Office Skills _ 19a Add SmartArt Graphic 02:33
  • 71: Microsoft Office Skills _ 19b Modifying SmartArt 03:13
  • 72: Microsoft Office Skills _ 19c Creating a Target Chart using SmartArt 03:04
  • 73: Microsoft Office Skills _ 20a Create a Table on Slide 04:13
  • 74: Microsoft Office Skills _ 20b Formatting Tables 02:24
  • 75: Microsoft Office Skills _ 20c Inserting Tables 01:55
  • 76: Microsoft Office Skills _ 20d Table Layouts 01:19
  • 77: Microsoft Office Skills _ 21a Add a Chart 01:57
  • 78: Microsoft Office Skills _ 21b Formatting Charts 01:48
  • 79: Microsoft Office Skills _ 21c Insert Chart from Microsoft Excel 02:57
  • 80: Microsoft Office Skills _ 22a Adding Video to a Presentation 02:31
  • 81: Microsoft Office Skills _ 22b Adding Audio to a Presentation 01:33
  • 82: Microsoft Office Skills _ 22c Screen Recording and Adding 02:28
  • 83: Microsoft Office Skills _ 23a Applying Transitions to Presentation 04:14
  • 84: Microsoft Office Skills _ 24a Object Animation 03:14
  • 85: Microsoft Office Skills _ 24b Effect Options 02:03
  • 86: Microsoft Office Skills _ 24c Advanced Animation 01:31
  • 87: Microsoft Office Skills _ 24d Triggers to control animation 01:47
  • 88: Microsoft Office Skills _ 25a Onscreen Presentation 02:16
  • 89: Microsoft Office Skills _ 25b Hiding Slides 01:42
  • 90: Microsoft Office Skills _ 25c Changing Order of Slides 01:50
  • 91: Microsoft Office Skills _ 25d Copying Slides 02:10
  • 92: Microsoft Office Skills _ 26a Overview of MS Word 03:57
  • 93: Microsoft Office Skills _ 26b Start MS Word 2021 04:48
  • 94: Microsoft Office Skills _ 27a Create a New Blank Document 04:20
  • 95: Microsoft Office Skills _ 27b Creating a Paragraph Text 04:55
  • 96: Microsoft Office Skills _ 27c Non-printing characters 02:59
  • 97: Microsoft Office Skills _ 27d Save a Document 02:45
  • 98: Microsoft Office Skills _ 27e Open a Document 01:22
  • 99: Microsoft Office Skills _ 27f Find and Replace 03:50
  • 100: Microsoft Office Skills _ 28a AutoCorrect Options 02:54
  • 101: Microsoft Office Skills _ 28b Formatting Text 03:59
  • 102: Microsoft Office Skills _ 28c Copy Cut and Paste 03:50
  • 103: Microsoft Office Skills _ 28d Character Formatting 02:28
  • 104: Microsoft Office Skills _ 28e Format Painter 03:58
  • 105: Microsoft Office Skills _ 28f Work with Numbers 01:43
  • 106: Microsoft Office Skills _ 28g Add Bullets 02:46
  • 107: Microsoft Office Skills _ 28h Outline Creation 03:42
  • 108: Microsoft Office Skills _ 29a Creating a Table 02:30
  • 109: Microsoft Office Skills _ 29b Adding Rows and Columns to a table 02:10
  • 110: Microsoft Office Skills _ 29c Formatting Table Data 02:19
  • 111: Microsoft Office Skills _ 29d Borders and Shading 01:45
  • 112: Microsoft Office Skills _ 29e Sorting in a Table 03:41
  • 113: Microsoft Office Skills _ 29f Draw a Table 03:31
  • 114: Microsoft Office Skills _ 29g Convert Text to Table 02:43
  • 115: Microsoft Office Skills _ 29h Convert Table to Text 02:05
  • 116: Microsoft Office Skills _ 29i Insert a Spreadsheet 01:41
  • 117: Microsoft Office Skills _ 29j Quick Tables – Readily Available Formats 01:52
  • 118: Microsoft Office Skills _ 30a Working with Styles 01:54
  • 119: Microsoft Office Skills _ 30b Creating Styles 01:50
  • 120: Microsoft Office Skills _ 30c Clear Formatting 01:16
  • 121: Microsoft Office Skills _ 31a Margins 01:44
  • 122: Microsoft Office Skills _ 31b Orientation 01:23
  • 123: Microsoft Office Skills _ 31c Page size setting 00:57
  • 124: Microsoft Office Skills _ 31d Adding columns 03:24
  • 125: Microsoft Office Skills _ 31e Page break section break 01:37
  • 126: Microsoft Office Skills _ 31f Adding watermark 02:58
  • 127: Microsoft Office Skills _ 31g Headers and footers 02:41
  • 128: Microsoft Office Skills _ 32a Create envelops 02:28
  • 129: Microsoft Office Skills _ 32b Creating labels 01:58
  • 130: Microsoft Office Skills _ 33a Creating a mail merge document 03:19
  • 131: Microsoft Office Skills _ 34a Thesaurus and spell check 01:09
  • 132: Microsoft Office Skills _ 34b Word count 01:21
  • 133: Microsoft Office Skills _ 34c Speech - read aloud 00:58
  • 134: Microsoft Office Skills _ 34d Language - translate 01:13
  • 135: Microsoft Office Skills _ 34e Tracking 01:10

• Course 02: Data Science & Data Analysis Diploma for Data Analyst 1:15:38

  • 136: Office Skills _ 1 02:59
  • 137: Office Skills _ 2 10:15
  • 138: Office Skills _ 3 15:46
  • 139: Office Skills _ 4 19:11
  • 140: Office Skills _ 5 16:26
  • 141: Office Skills _ 6 11:01

• Course 03: Bookkeeper Training 1:14:00

  • 142: Office Skills _ Module 01_ Introduction to Book-keeping.docx - _ 09:00
  • 143: Office Skills _ Module 02_ Double-Entry Bookkeeping Systems.docx - _ 07:00
  • 144: Office Skills _ Module 03_ The General Ledger.docx - _ 08:00
  • 145: Office Skills _ Module 04_ Accounts Receivable and Payable.docx - _ 08:00
  • 146: Office Skills _ Module 05_ Income Statement 07:00
  • 147: Office Skills _ Module 06_ The Balance Sheet 06:00
  • 148: Office Skills _ Module 07_ Cash Flow Statements 07:00
  • 149: Office Skills _ Module 08_ Financial Budgeting and Planning 07:00
  • 150: Office Skills _ Module 09_ Auditing in Book-keeping 08:00
  • 151: Office Skills _ Module 10_ Advanced Topics and Future Trends 07:00

• Course 04: Functional Skills IT 3:49:00

  • 152: Office Skills _ Module 01 Using Your Device.docx 40:00
  • 153: Office Skills _ Module 02 Learning to Use Internet.docx 35:00
  • 154: Office Skills _ Module 03 All about Email.docx 17:00
  • 155: Office Skills _ Module 04 Online Security.docx 27:00
  • 156: Office Skills _ Module 05 Online Health Management.docx 09:00
  • 157: Office Skills _ Module 06 Online Money Management.docx 54:00
  • 158: Office Skills _ Module 07 Working with Office Programs.docx 47:00

• Course 05: Basics of Accounting 2:31:00

  • 159: Office Skills _ Module 01_ Introduction to Accounting.docx 11:00
  • 160: Office Skills _ Module 02_ Bookkeeping and Basic Transactions.docx 20:00
  • 161: Office Skills _ Module 03_ Accounting Framework and Standards.docx 07:00
  • 162: Office Skills _ Module 04_ Financial Statements.docx 15:00
  • 163: Office Skills _ Module 05_ The Accounting Cycle.docx 20:00
  • 164: Office Skills _ Module 06_ Revenue and Expense Recognition.docx 18:00
  • 165: Office Skills _ Module 07_ Accounts Management.docx 08:00
  • 166: Office Skills _ Module 08_ Inventory and Cost Management.docx 20:00
  • 167: Office Skills _ Module 09_ Taxes, Leases, and Special Accounting.docx 09:00
  • 168: Office Skills _ Module 10 Limited Companies & Shares 14:00
  • 169: Office Skills _ Module 11_ Advanced Accounting Topics.docx 09:00

• Gift Course 01: Admin, Secretarial and PA Diploma Level 3 6:05:12

  • 170: Office Skills _ 1.1 - Introduction to Administrative Assistant 00:42
  • 171: Office Skills _ 1.2 - Role of an Administrative Assistant 05:27
  • 172: Office Skills _ 1.3 - Administrative to Organisational Success 04:33
  • 173: Office Skills _ 2.1 - Workstation and Daily Routine 00:39
  • 174: Office Skills _ 2.2 - The Importance of a Well-Organised Workstation 05:24
  • 175: Office Skills _ 2.3 - Use of Dictation and Transcription 04:29
  • 176: Office Skills _ 3.1 - Relationship Management 00:57
  • 177: Office Skills _ 3.2 - Relationship Building Between the Boss and Assistant 04:46
  • 178: Office Skills _ 3.3 - Professional Image for Effective Relationship 06:18
  • 179: Office Skills _ 4.1 - Communication Skills of Administrative Assistant 00:42
  • 180: Office Skills _ 4.2 - Body Language The Art of Communicating Without Words 05:24
  • 181: Office Skills _ 4.3 - Matching and Mirroring 08:52
  • 182: Office Skills _ 5.1 - Keeping Accurate Records 00:42
  • 183: Office Skills _ 5.2 - Duty of Administrative Assistant in Record-Keeping 05:20
  • 184: Office Skills _ 5.3 - Computer Files Organisation 02:54
  • 185: Office Skills _ 6.1 - Office Equipment in an Organisation 00:55
  • 186: Office Skills _ 6.2 - The Evolution of Telephones From PBXs to VoIP 03:59
  • 187: Office Skills _ 6.3 - Office Computers The Backbone of Business Productivity 08:17
  • 188: Office Skills _ 7.1 - Travel Arrangements 00:50
  • 189: Office Skills _ 7.2 - Business Travel and Making Travel Arrangements 05:16
  • 190: Office Skills _ 7.3 - Reservations of Transports 04:49
  • 191: Office Skills _ 8.1 - Email Management 00:47
  • 192: Office Skills _ 8.2 - Email An Essential Communication Tool for Businesses 06:49
  • 193: Office Skills _ 8.3 - Email Programs 05:28
  • 194: Office Skills _ 9.1 - Meeting Arrangement 00:36
  • 195: Office Skills _ 9.2 - Meeting Anatomy 05:05
  • 196: Office Skills _ 9.3 - Scheduling Meetings and Some Problems 04:55
  • 197: Office Skills _ 10.1 - Dealing with People and Managing Conflicts 00:47
  • 198: Office Skills _ 10.2 - Problem-Solving Techniques in an Organisation 05:11
  • 199: Office Skills _ 10.3 - Think Before Speaking 04:22
  • 200: Office Skills _ Module 1 Personal Assistant 08:35
  • 201: Office Skills _ Module 2 Developing Interpersonal Skills 13:14
  • 202: Office Skills _ Module 3 Developing Communication Skills 12:21
  • 203: Office Skills _ Module 4 Task Management Tips 08:20
  • 204: Office Skills _ Module 5 Time Management Techniques 09:41
  • 205: Office Skills _ Module 6 Diary Management _ Note Taking 20:02
  • 206: Office Skills _ Module 7 Meeting Management _ Minute Taking 06:47
  • 207: Office Skills _ Module 8 Office Management and Supervision 09:35
  • 208: Office Skills _ Module 9 Networking _ Relationship Management 06:56
  • 209: Office Skills _ Module 10 Record Keeping 08:18
  • 210: Office Skills _ Module 11 Telephone Etiquette 07:39
  • 211: Office Skills _ Module 12 E-mail Communication 09:44
  • 212: Office Skills _ Module 13 Presentation Skills 12:10
  • 213: Office Skills _ Module 14 Business Writing Skills 08:09
  • 214: Office Skills _ Module 15 Travel Arrangement 08:17
  • 215: Office Skills _ Module 16 Mail Services and Shipping 08:06
  • 216: Office Skills _ Module 1 Minute Taking An Introduction 11:46
  • 217: Office Skills _ Module 2 Preparing for Minute Taking 11:21
  • 218: Office Skills _ Module 3 At the Meeting 12:35
  • 219: Office Skills _ Module 4 The Structure of a Meeting 11:38
  • 220: Office Skills _ Module 5 Taking Notes 09:04
  • 221: Office Skills _ Module 6 The Minute-Taking Process 08:59
  • 222: Office Skills _ Module 7 Recording Decisions and Actions 08:32
  • 223: Office Skills _ Module 8 Business English 05:06
  • 224: Office Skills _ Module 9 Building Confidence 07:48
  • 225: Office Skills _ Module 10 Effective Minute Taking 05:14

• Gift Course 02: Managerial Leadership 2:14:16

  • 226: Office Skills _ Module 1 Managerial Leadership In the 21st Century 10:10
  • 227: Office Skills _ Module 2 Communication and Leadership 15:31
  • 228: Office Skills _ Module 3 Leadership and Management 10:28
  • 229: Office Skills _ Module 4 Team Building 16:56
  • 230: Office Skills _ Module 5 High-Performance Team Formation 11:13
  • 231: Office Skills _ Module 6 Team Motivation 11:25
  • 232: Office Skills _ Module 7 Retaining The Motivation 10:26
  • 233: Office Skills _ Module 8 Essentials of Employment Law in the UK 12:11
  • 234: Office Skills _ Module 9 Preventing Discrimination in the Workplace 15:40
  • 235: Office Skills _ Module 10 Health, Safety and Welfare of Employees 09:52
  • 236: Office Skills _ Module 11 Operational Risk Management 10:24

• Gain practical Microsoft Office skills in Excel, Word, and Access—key tools for boosting office productivity and workflow efficiency.

• Develop in-demand data analysis capabilities that enhance your Microsoft Office skills and provide a competitive edge in data-driven roles.

• Achieve industry-recognised qualifications that employers value for positions requiring strong Microsoft Office skills and data management expertise.

• Master Microsoft Office skills for creating professional documents, managing spreadsheets, and handling databases effectively.

• Develop advanced proficiency in Microsoft Excel to conduct data analysis, create reports, and support strategic decision-making.

• Strengthen your overall Office skills to improve workplace efficiency and communication.

• Build applied knowledge in data analysis methods, supporting business insights and informed decisions.

• Gain recognised qualifications in Microsoft Office skills and data analysis to meet the growing needs of employers across sectors.

• Office Administrator: Apply essential Microsoft Office skills in daily administrative tasks; salary range £20,000–£30,000 per annum.

• Data Analyst: Utilise data analysis tools and Excel-based reporting; salary range £25,000–£45,000 per annum.

• Business Analyst: Combine Microsoft Office skills with analytical thinking to drive business insights; salary range £30,000–£50,000 per annum.

This course will pave the way for higher study in the field of Microsoft Office. You can enrol on higher-level Microsoft Office courses, such as:

• Level 1 Award in Microsoft Office Word
• Level 1 Award in Microsoft Office Excel
• Level 1 Award in Microsoft Office PowerPoint
• Level 1 Award in Microsoft Office Suite
• Level 2 Award in Microsoft Office Word
• Level 2 Award in Microsoft Office Excel
• Level 2 Award in Microsoft Office PowerPoint
• Level 2 Certificate in Microsoft Office Suite

• Microsoft Office Skills Specialist
• Microsoft Excel for Accounting
• Office Administrator

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