Microsoft Excel Online Training

[Updated 2024, Watch Free Preview]

Special Deal: Get 47% OFF + FREE PDF & Hardcopy Certificates + Free Microsoft Excel 2021 Course, MS Word, PowerPoint & Access, and more...

Microsoft Excel Complete Course - Beginner, Intermediate & Advanced- CPD Certified

Did you know over 800 million people have Microsoft Excel on their computers, but most don't know how to use it! This might be because Microsoft Excel can come across as being a little awkward with first-time users. Enrol in this Level 3 CPD accredited course to use Microsoft Excel confidently and get to a point where using Excel will be as natural as rolling out of bed in the morning.

Microsoft Excel training is a must in the modern-day workplace. So many jobs require you to have Microsoft Excel skills, and proficiency in it will make you a better candidate for any job position. Our course will give you a complete grasp of Microsoft Excel to enhance your professional career.

Microsoft Excel is much more than just a simple tool for data management and calculation. It is a demanding business tool for most firms. Learning Microsoft Excel can open up a world of possibilities for you. Our course is designed by experts in such a way that it will benefit both beginners and advanced learners. You will learn from top to bottom about Microsoft Excel and get ahead of your competitors. If you are looking for a Microsoft Office Specialist Excel certification course, then all you need to know is entirely about Microsoft Excel from scratch. So what are you waiting for?

Enrol in the Microsoft Excel course today!

Working knowledge of Microsoft Excel is vital for most office-based professionals today, and stronger skills can open the door to jobs, promotions, and leadership opportunities.

Key Features

• CPD Accredited Microsoft Excel Diploma
• Free Certificate included
• 126 unique lessons in the Microsoft Excel course
• Lifetime Access

Expand all

• Workbook 09:00

  • 1: Microsoft Excel Complete Course 2019 09:00

• Microsoft Excel 2019 New Features 27:34

  • 2: Course Promo Video Preview 01:20
  • 3: Introduction to Microsoft Excel 2019 New Features Preview 06:38
  • 4: CONCAT 01:30
  • 5: IFS 01:27
  • 6: MAXIFS 01:12
  • 7: MINIFS 00:47
  • 8: SWITCH 01:39
  • 9: TEXTJOIN 00:56
  • 10: Map Chart 01:40
  • 11: Funnel Chart 01:15
  • 12: Better Visuals 06:13
  • 13: Pivot Table Enhancements 01:38
  • 14: Power Pivot Updates 01:19

• Getting Started with Microsoft Office Excel 1:13:36

  • 15: Navigate the Excel User Interface 28:20
  • 16: Use Excel Commands 10:01
  • 17: Create and Save a Basic Workbook 18:44
  • 18: Enter Cell Data 11:40
  • 19: Use Excel Help 04:51

• Performing Calculations 49:21

  • 20: Create Worksheet Formulas 15:01
  • 21: Insert Functions 17:10
  • 22: Reuse Formulas and Functions 17:10

• Modifying a Worksheet 25:59

  • 23: Insert, Delete, and Adjust Cells, Columns, and Rows 10:08
  • 24: Search for and Replace Data 08:38
  • 25: Use Proofing and Research Tools 07:13

• Formatting a Worksheet 1:02:43

  • 26: Apply Text Formats 16:18
  • 27: Apply Number Format 07:30
  • 28: Align Cell Contents 08:52
  • 29: Apply Styles and Themes 11:39
  • 30: Apply Basic Conditional Formatting 10:48
  • 31: Create and Use Templates 07:36

• Printing Workbooks 26:24

  • 32: Preview and Print a Workbook 10:28
  • 33: Set Up the Page Layout 08:32
  • 34: Configure Headers and Footers 07:24

• Managing Workbooks 17:33

  • 35: Manage Worksheets 05:06
  • 36: Manage Workbook and Worksheet Views 06:54
  • 37: Manage Workbook Properties 05:33

• Working with Functions 1:12:33

  • 38: Work with Ranges 18:12
  • 39: Use Specialized Functions 11:39
  • 40: Work with Logical Functions 23:35
  • 41: Work with Date & Time Functions 08:10
  • 42: Work with Text Functions 10:57

• Working with Lists 37:47

  • 43: Sort Data 10:03
  • 44: Filter Data 09:49
  • 45: Query Data with Database Functions 09:02
  • 46: Outline and Subtotal Data 08:53

• Analyzing Data 12:33

  • 47: Apply Intermediate Conditional Formatting 06:50
  • 48: Apply Advanced Conditional Formatting 05:43

• Visualizing Data with Charts 38:03

  • 49: Create Charts 13:18
  • 50: Modify and Format Charts 12:16
  • 51: Use Advanced Chart Features 12:29

• Using PivotTables and PivotCharts 44:25

  • 52: Create a PivotTable 13:28
  • 53: Analyze PivotTable Data 12:00
  • 54: Present Data with PivotCharts 07:35
  • 55: Filter Data by Using Timelines and Slicers 11:22

• Working with Multiple Worksheets and Workbooks 24:00

  • 56: Use Links and External References 12:24
  • 57: Use 3-D References 05:51
  • 58: Consolidate Data 05:45

• Using Lookup Functions and Formula Auditing 30:28

  • 59: Use Lookup Functions 12:45
  • 60: Trace Cells 09:05
  • 61: Watch and Evaluate Formulas 08:38

• Sharing and Protecting Workbooks 28:02

  • 62: Collaborate on a Workbook 19:35
  • 63: Protect Worksheets and Workbooks 08:27

• Automating Workbook Functionality 35:27

  • 64: Apply Data Validation 13:28
  • 65: Search for Invalid Data and Formulas with Errors 04:06
  • 66: Work with Macros 17:53

• Creating Sparklines and Mapping Data 14:31

  • 67: Create Sparklines 07:12
  • 68: MapData 07:19

• Forecasting Data 28:54

  • 69: Forecasting Data Determine Potential Outcomes Using Data Tables 08:47
  • 70: Determine Potential Outcomes Using Scenarios 09:16
  • 71: Use the Goal Seek Feature 04:16
  • 72: Forecasting Data Trends 05:35
  • 73: CPD Certificate & Transcript 01:00

• Excel 2021 4:12:22

  • 74: Excel Overview 05:20
  • 75: Start Excel Spreadsheet 04:26
  • 76: Enter Text and Numbers 07:24
  • 77: Relative References 03:40
  • 78: Working with ranges 06:52
  • 79: Save and Save as Actions 07:52
  • 80: File Extensions, Share, Export, and Publish files 05:53
  • 81: Adding Rows and Columns 02:34
  • 82: Modifying Rows and Column lengths 05:03
  • 83: Copy Cut and Paste 07:07
  • 84: Copying Formulas 03:01
  • 85: Page setup options 05:50
  • 86: Fit to print on One Page 02:39
  • 87: Print Workbooks 02:47
  • 88: Sorting Data Ascending Order 03:48
  • 89: Sorting Data Descending Order 02:25
  • 90: Filter Data 04:09
  • 91: Basic formula operations 06:14
  • 92: Date time functions 06:20
  • 93: Mathematical functions phase1 19:54
  • 94: Mathematical functions phase2 12:23
  • 95: V Lookup formula 12:12
  • 96: HLookup formula 04:07
  • 97: XLookup 07:39
  • 98: Handling NA and Approximates match in XLookup 10:31
  • 99: Split Text into columns 07:03
  • 100: Flash Fill 07:03
  • 101: Data Validation 06:34
  • 102: Remove Duplicates 07:47
  • 103: Get - import Data from Text 05:38
  • 104: Get - import Data from CSV 03:22
  • 105: Formatting Font 04:15
  • 106: Formatting Alignment 06:04
  • 107: Formatting Number 04:37
  • 108: Formatting Date 03:29
  • 109: Formatting tables 05:13
  • 110: Creating Pivot Table 06:43
  • 111: Pivot charts 01:49
  • 112: Excel Charts – Categories 02:30
  • 113: Elements of a chart 04:12
  • 114: Creating charts 01:55
  • 115: Column or Bar charts 04:21
  • 116: Formatting charts 03:37
  • 117: Line charts 02:13
  • 118: Pie and Doughnut charts 03:47

• New Functions in Microsoft Excel 2021 Course 1:15:02

  • 119: Introduction and Agenda 06:59
  • 120: RANDARRAY 04:28
  • 121: UNIQUE 04:52
  • 122: SEQUENCE 04:28
  • 123: SORT and SORTBY 08:58
  • 124: SORT A Practical Example 05:59
  • 125: FILTER 07:28
  • 126: FILTER A Practical Example 07:58
  • 127: Other Useful New Functions 15:08
  • 128: Using the New Functions in Reports 07:44
  • 129: Leave a Review 01:00

• Microsoft Word 2019 4:40:20

  • 130: Create and Save Word Documents 24:17
  • 131: Manage Your Workspace 05:43
  • 132: Preview and Print Documents 04:06
  • 133: Edit Documents 15:38
  • 134: Navigate in Microsoft Word 12:28
  • 135: Customize the Word Environment 07:51
  • 136: Insert Symbols and Special Characters 04:01
  • 137: Add Images to a Document 11:24
  • 138: Insert a Table 06:51
  • 139: Convert Text to a Table 04:29
  • 140: Format a Table 03:20
  • 141: Modify a Table 05:32
  • 142: Format a List 06:03
  • 143: Sort a List 05:19
  • 144: Apply Character Formatting 16:56
  • 145: Display Text in Bulleted or Numbered Lists 02:38
  • 146: Apply Borders and Shading 04:29
  • 147: Align Text Using Tabs 07:11
  • 148: Control Paragraph Layout 19:20
  • 149: Save a Document to Other Formats 03:36
  • 150: Use Research Tools 05:45
  • 151: Check Spelling Grammar and Readability 07:14
  • 152: Check Accessibility 03:12
  • 153: Control Page Layout 05:00
  • 154: Add a Watermark 03:40
  • 155: Apply a Page Border and Color 03:09
  • 156: Add Headers and Footers 05:36
  • 157: Apply Repetitive Formatting 09:51
  • 158: Make Repetitive Edits 05:52
  • 159: Use Styles to Streamline Repetitive Formatting Tasks 14:17
  • 160: Learning Tools 06:40
  • 161: Introduction to Microsoft Word 2019 New Features 14:15
  • 162: Side to Side Scrolling 02:14
  • 163: Scalable Vector Graphics 03:17
  • 164: Inking Tools 06:56
  • 165: Microsoft Translate 02:46
  • 166: LaTeX 05:11
  • 167: Smart Lookup 04:13

• Microsoft PowerPoint 2019 5:17:55

  • 168: Insert a Table from Other Microsoft Office Applications 06:18
  • 169: Create a Table 08:58
  • 170: Format a Table 02:34
  • 171: Build a Presentation 26:39
  • 172: Select a Presentation Type 08:24
  • 173: Edit Text 13:18
  • 174: View and Navigate a Presentation 14:48
  • 175: Use PowerPoint Help 09:37
  • 176: Navigate the PowerPoint Environment 28:23
  • 177: Create and Save a PowerPoint Presentation 12:58
  • 178: Insert a Chart from Microsoft Excel 04:40
  • 179: Create a Chart 10:16
  • 180: Format a Chart 09:39
  • 181: Insert Images 09:38
  • 182: Insert Shapes 14:48
  • 183: Animate Objects 07:25
  • 184: Arrange Objects 06:59
  • 185: Format Objects 06:08
  • 186: Group Objects 04:22
  • 187: Edit Objects 15:31
  • 188: Apply Transitions 04:29
  • 189: Deliver Your Presentation 07:57
  • 190: Review Your Presentation 11:20
  • 191: Print Your Presentation 04:58
  • 192: Introduction to Microsoft PowerPoint 2019 New Features 06:24
  • 193: 4K 03:26
  • 194: SVG Icons to Shapes 04:16
  • 195: Vector Graphics 02:34
  • 196: Background Removal 03:06
  • 197: 3D Modeling 04:28
  • 198: Highlighting 01:30
  • 199: Morph Transition 02:39
  • 200: Zoom 02:53
  • 201: Format Paragraphs 16:12
  • 202: Format Characters 11:19
  • 203: Format Text Boxes 09:01

• Microsoft Access 2019 3:46:41

  • 204: Create a Simple Access Database 09:50
  • 205: Orientation to Microsoft Access 39:02
  • 206: Get Help and Configure Options in Microsoft Access 05:35
  • 207: Organize Report Information 14:56
  • 208: Add Controls to a Report 11:42
  • 209: Format Reports 12:05
  • 210: Enhance the Appearance of a Report 04:34
  • 211: Prepare a Report for Print 03:11
  • 212: Create a Report 23:12
  • 213: dbf 01:11
  • 214: Property Sorting 01:23
  • 215: Introduction to Microsoft Access 2019 New Features 05:25
  • 216: Charts 02:23
  • 217: Large Number 01:22
  • 218: Window Resize 00:44
  • 219: Create Basic Queries 15:12
  • 220: Perform Calculations in a Query 07:50
  • 221: Sort and Filter Data in a Query 14:16
  • 222: Create Basic Access Forms 07:03
  • 223: Work with Data on Access Forms 23:12
  • 224: Modify Table Data 17:15
  • 225: Sort and Filter Records 05:18

• Accountancy 1:56:08

  • 226: Module 01: Introduction to Accounting 08:23
  • 227: Module 02: The Role of an Accountant 09:04
  • 228: Module 03: Accounting Concepts and Standards 12:05
  • 229: Module 04: Double-Entry Bookkeeping 11:00
  • 230: Module 05: Balance Sheet 11:15
  • 231: Module 06: Income statement 10:04
  • 232: Module 07: Financial statements 12:52
  • 233: Module 08: Cash Flow Statements 09:18
  • 234: Module 09: Understanding Profit and Loss Statement 09:19
  • 235: Module 10: Financial Budgeting and Planning 14:20
  • 236: Module 11: Auditing 08:28

• Job Search Skills 1:19:40

  • 237: Job Search Skills Getting Started 09:59
  • 238: Job Market Research 07:07
  • 239: Cover Letter 09:03
  • 240: CV Writing 14:51
  • 241: Fundamental Skills 07:40
  • 242: Networking 08:31
  • 243: Personal Development 11:27
  • 244: The Interview 11:02

• Resilience Training 1:51:58

  • 245: Module 01: Resilience - Dealing with Adversity and Setbacks 12:11
  • 246: Module 02: Pathways to Resilience 23:20
  • 247: Module 03: The Pillars of Resilience 23:14
  • 248: Module 04: Training for Resilience 22:34
  • 249: Module 05: Promoting Emotional Resilience – CASMT 17:27
  • 250: Module 06: Mental Toughness & Resilience 13:12

• Supervisor Training 2:12:54

  • 251: Module 01 – Fundamentals of Supervisor Training 13:29
  • 252: Module 02 – Understanding the Role of Supervision 12:46
  • 253: Module 03 – Essential Skills in Supervision 18:33
  • 254: Module 04 – Recruitment and Dismissal 17:29
  • 255: Module 05 – Employee Management 12:45
  • 256: Module 06 – Communication Skill Development 12:16
  • 257: Module 07 – Interactive Training for New Supervisors 17:09
  • 258: Module 08 – Conflict Management 13:37
  • 259: Module 09 – Cybersecurity for Employees 14:50

• Leadership & Management Diploma 7:29:24

  • 260: Introduction to Leadership 30:52
  • 261: Body Language and Effective Communication 43:33
  • 262: Business Management Corporate Behaviour 44:03
  • 263: Critical Thinking Implications for Leadership 30:53
  • 264: Inspiration and Leadership 21:22
  • 265: Meeting Management 1:01:25
  • 266: Performance Management 36:33
  • 267: Project Management 45:01
  • 268: Risk Management 17:16
  • 269: Self Esteem and Assertiveness Skills 38:26
  • 270: Setting SMART Goals 48:36
  • 271: Team Work and Team Building 31:24

• Organisational Skills Course for Administrator 43:23

  • 272: Module One: Remove the Clutter 05:40
  • 273: Module Two: Prioritise 04:15
  • 274: Module Three: Scheduling Your Time 04:20
  • 275: Module Four: To Do Lists 03:35
  • 276: Module Five: Paper and Paperless Storage 04:25
  • 277: Module Six: Organisation in Your Work Area 04:05
  • 278: Module Seven: Tools to Fight Procrastination 04:21
  • 279: Module Eight: Organizing Your Inbox 04:21
  • 280: Module Nine: Avoid the Causes of Disorganization 04:18
  • 281: Module Ten: Discipline is the Key to Stay Organized 04:03

Key Features of Microsoft Excel 2019

• CPD Accredited Microsoft Excel Course
• Instant e-certificate
• Fully online, interactive course with audio voiceover
• Developed by qualified professionals
• Self-paced learning and laptop, tablet, smartphone-friendly
• 24/7 Learning Assistance

Learning Outcomes of Microsoft Excel 2019

• What is Microsoft Excel, and how to get started
• Examine spreadsheet concepts and explore the Microsoft Office Excel environment.
• Learn to enter and edit data
• Learn to adjust a worksheet and workbook
• Learn to use maths, statistics, logic and text functions in Microsoft Excel
• Learn to be a better, stronger and faster Excel user
• Learn to use functions and formulas
• Understand how to capture your first job as a Microsoft Excel expert
• Create and edit charts
• Tips for starting a successful career

Certificate

After completing this Microsoft Excel 2019 course, you will get a Free PDF certificate from Reed. Also, you will be awarded a FREE CPD Accredited PDF Certificate from Training Express.

This Microsoft Excel 2019 is suitable for:

• Administrator
• Accounts Administrator
• HR Administrator
• Accountant/Bookkeeper
• Office Administrator
• Warehouse Operatives
• Audio Typist
• Audio Secretary
• Anyone looking for Microsoft Office Specialist Excel Certification

Microsoft Excel Training

No formal qualification is required for this Microsoft Excel Online course.

• Client Service Support
• Payroll Officer
• Data Analyst
• Business Analysts
• Data Journalists

Search questions

---

PDF Certificates

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included