Microsoft Excel Complete Training - Beginner, Intermediate & Advanced with Minute Taking

Embark on a comprehensive journey with Microsoft Excel Complete Training 2024, designed to transform beginners into proficient Microsoft Excel users. This course covers everything from foundational Microsoft Excel skills to advanced functionalities, equipping you with the tools needed to excel in Microsoft Excel data analysis, report generation, and decision-making processes.

Key Performance Metrics:

• Master Microsoft Excel basics, including data entry, cell formatting, and worksheet navigation in Microsoft Excel.
• Understand and apply essential Microsoft Excel functions for complex calculations and data analysis.
• Enhance Microsoft Excel spreadsheets visually and functionally through advanced formatting of data and tables.
• Create and manipulate Microsoft Excel Pivot Tables to summarize and analyze large datasets effectively.
• Utilize Microsoft Excel Business-Geo Charts to integrate geographic data visualization into your reports.

Courses Included:

• Course 01: Microsoft Excel Complete Training 2024
• Course 02: Minute Taking

Accreditation:

Microsoft Excel Complete Training Course is CPDQE accredited, which serves as an impactful mechanism for skill enhancement.

Accredited Certificate from LearnDrive

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

Learndrive Special Bundle Certificate

Digital certificate - £7

• Microsoft Excel: Getting Started 15:15

  • 1: Microsoft Excel: 1a Introduction 03:15
  • 2: Microsoft Excel: 1b Course Curriculum 04:19
  • 3: Microsoft Excel: 1c Getting started on Windows, macOS, Android, and IOS 01:11
  • 4: Microsoft Excel: 1d How to ask great questions 01:30
  • 5: Microsoft Excel: 1e FAQ’s 01:20
  • 6: Microsoft Excel: 1f Starting Excel 03:40

• Microsoft Excel Basics 1:07:08

  • 7: Microsoft Excel: 2a Introduction 01:57
  • 8: Microsoft Excel: 2b Worksheet basics 21:51
  • 9: Microsoft Excel: 2c Entering values and formulas 12:02
  • 10: Microsoft Excel: 2d Data formats 09:39
  • 11: Microsoft Excel: 2e Data handling basics – cut copy and paste 06:38
  • 12: Microsoft Excel: 2f Save and print in excel 10:14
  • 13: Microsoft Excel: 2g Excel Ranges 04:47

• Microsoft Excel essential functions 1:49:25

  • 14: Microsoft Excel: 3a Introduction 01:14
  • 15: Microsoft Excel: 3b Basic formula operations 06:14
  • 16: Microsoft Excel: 3c Mathematical functions level1 19:54
  • 17: Microsoft Excel: 3d Mathematical functions level 2 12:23
  • 18: Microsoft Excel: 3e Text functions level 1 09:07
  • 19: Microsoft Excel: 3f Text functions level 2 12:56
  • 20: Microsoft Excel: 3g Logical functions 11:03
  • 21: Microsoft Excel: 3h Date time functions 06:20
  • 22: Microsoft Excel: 3i V Lookup formula 12:12
  • 23: Microsoft Excel: 3j HLookup formula 04:07
  • 24: Microsoft Excel: 3k HLookup Match formula 08:34
  • 25: Microsoft Excel: 3l Match Index formula 05:21

• XLOOKUP only for Excel 2021 and Office 365 26:22

  • 26: Microsoft Excel: 4a Introduction 02:00
  • 27: Microsoft Excel: 4b XLookup 07:39
  • 28: Microsoft Excel: 4c Handling NA and Approximates match in XLookup 10:31
  • 29: Microsoft Excel: 4d Wildcard matching in XLookup 06:12

• Way to GO! 00:11

  • 30: Way to GO! 00:11

• Get Data and tools 39:12

  • 31: Microsoft Excel: 5a Introduction 01:45
  • 32: Microsoft Excel: 5b Split Text into columns 07:03
  • 33: Microsoft Excel: 5c Flash Fill 07:03
  • 34: Microsoft Excel: 5d Remove Duplicates 07:47
  • 35: Microsoft Excel: 5e Data Validation 06:34
  • 36: Microsoft Excel: 5f Get - import Data from Text 05:38
  • 37: Microsoft Excel: 5g Get - import Data from CSV 03:22

• Formatting data and tables 25:00

  • 38: Microsoft Excel: 6a Introduction 01:22
  • 39: Microsoft Excel: 6b Formatting Font 04:15
  • 40: Microsoft Excel: 6c Formatting Alignment 06:04
  • 41: Microsoft Excel: 6d Formatting Number 04:37
  • 42: Microsoft Excel: 6e Formatting Date 03:29
  • 43: Microsoft Excel: 6f Formatting tables 05:13

• Pivot Tables 20:47

  • 44: Microsoft Excel: 7a Introduction 01:08
  • 45: Microsoft Excel: 7b Creating Pivot Table 06:43
  • 46: Microsoft Excel: 7c Value field settings 04:06
  • 47: Microsoft Excel: 7d Number format 02:28
  • 48: Microsoft Excel: 7e Pivot Table Design 03:20
  • 49: Microsoft Excel: 7f Excel Exercise 01:29
  • 50: Microsoft Excel: 7g Solution for Excel Exercise 01:33

• Microsoft Excel Charts 35:31

  • 51: Microsoft Excel: 8a Introduction 01:12
  • 52: Microsoft Excel: 8b Excel Charts – Categories 02:30
  • 53: Microsoft Excel: 8c Elements of a chart 04:12
  • 54: Microsoft Excel: 8d Easy way to create charts 01:55
  • 55: Microsoft Excel: 8e Column or Bar charts 04:21
  • 56: Microsoft Excel: 8f Formatting charts 03:37
  • 57: Microsoft Excel: 8g Line charts 02:13
  • 58: Microsoft Excel: 8h Area charts 02:03
  • 59: Microsoft Excel: 8i Pie and Doughnut charts 03:47
  • 60: Microsoft Excel: 8j Format Area Plot or XY chart 07:33
  • 61: Microsoft Excel: 8k Scatter or bubble charts 02:08

• Advanced Excel charts 16:29

  • 62: Microsoft Excel: 9a Introduction 00:52
  • 63: Microsoft Excel: 9b Frequency Distribution and Histograms 03:44
  • 64: Microsoft Excel: 9c Waterfall charts 01:50
  • 65: Microsoft Excel: 9d Hierarchy charts sunburst and tree map 02:46
  • 66: Microsoft Excel: 9e Combination charts 02:19
  • 67: Microsoft Excel: 9f Sparklines 04:58

• Pivot Charts 01:49

  • 68: Microsoft Excel: 10a Pivot charts 01:49

• Maps Chart above 2019 06:29

  • 69: Microsoft Excel: 11a Maps chart 03:53
  • 70: Microsoft Excel: 11b 3D Maps chart 02:36

• Business-Geo charts 09:44

  • 71: Microsoft Excel: 12a Introduction 00:50
  • 72: Microsoft Excel: 12b Stock charts 01:55
  • 73: Microsoft Excel: 12c Radar charts 01:34
  • 74: Microsoft Excel: 12d Surface charts 01:54
  • 75: Microsoft Excel: 12e Heat maps 03:31

• Named Ranges 11:17

  • 76: Microsoft Excel: 13a Named ranges - dropdown 05:03
  • 77: Microsoft Excel: 13b Indirect Name range Function 06:14

• Import Data into Excel 12:39

  • 78: Microsoft Excel: 14a Import Data table from PDF file – Excel 2021 03:50
  • 79: Microsoft Excel: 14b Import Data from Website – Excel 2019 above 08:49

• Advanced Microsoft Excel 11:17

  • 80: Microsoft Excel: 15a Project Sales forecast tracker 06:39
  • 81: Microsoft Excel: 15b Product Sale Tax invoice Tax Calculations 04:38

• Course 02: Minute Taking 1:32:03

  • 82: Module 1 Minute Taking An Introduction 11:46
  • 83: Module 2 Preparing for Minute Taking 11:21
  • 84: Module 3 At the Meeting 12:35
  • 85: Module 4 The Structure of a Meeting 11:38
  • 86: Module 5 Taking Notes 09:04
  • 87: Module 6 The Minute-Taking Process 08:59
  • 88: Module 7 Recording Decisions and Actions 08:32
  • 89: Module 8 Business English 05:06
  • 90: Module 9 Building Confidence 07:48
  • 91: Module 10 Effective Minute Taking 05:14

• Claim Your Free Accredited Certificate 01:00

  • 92: Claim Your Free Accredited Certificate 01:00

Key Lesson Snippets:

Course 01: Microsoft Excel Complete Training 2024

• Microsoft Excel Basics: Introduction to the Microsoft Excel interface, basic operations like entering data, sorting, and basic formulas.
• Excel Essential Functions: Deep dive into Microsoft Excel formulas and functions such as VLOOKUP, SUMIF, and conditional functions.
• Formatting Data and Tables: Techniques for enhancing the visual appeal and usability of Microsoft Excel data through formatting.
• Pivot Tables: Step-by-step guide to creating and customizing Microsoft Excel Pivot Tables to analyze data without extensive Microsoft Excel expertise.
• Microsoft Excel Charts: Training on creating various types of charts in Microsoft Excel, including bar, line, and pie charts, to represent data graphically.
• Advanced Microsoft Excel Charts: Explore complex charting techniques in Microsoft Excel including waterfall and combo charts for advanced data presentation.
• Business-Geo Charts: Use Microsoft Excel’s Geographic Data Types and Maps feature to transform data into a geographical visualization.
• Named Ranges: Learn to define and use Microsoft Excel Named Ranges for more intuitive formulas and data referencing.

Course 02: Minute Taking

• The Structure of a Meeting: Overview of typical meeting formats and key elements that require documentation.
• The Minute-Taking Process: Comprehensive techniques for taking accurate and efficient minutes, including tools and tips for capturing essential information.
• Recording Decisions and Actions: Focus on identifying and noting down key decisions and actionable items during meetings.
• Building Confidence: Strategies to enhance confidence in minute-taking through practice, preparation, and understanding of meeting dynamics.

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

• Level 2 Award in Microsoft Excel
• Level 3 Award in Microsoft Excel
• Level 3 Diploma in Microsoft Excel
• ICDL Microsoft Excel 2019 (Basic)
• ICDL Microsoft Excel 2019 (Standard)
• ICDL Microsoft Excel 2019 (Expert)
• CAVA Certificate in Microsoft Excel 2016 Fundamentals
• CAVA Certificate in Microsoft Excel 2016 Intermediate
• CAVA Certificate in Microsoft Excel 2016 Advanced
• Microsoft Excel 2019: Introduction
• Microsoft Excel 2019: Intermediate
• Microsoft Excel 2019: Advanced
• Introduction to Microsoft Excel 365
• Intermediate Microsoft Excel 365
• Advanced Microsoft Excel 365
• Microsoft Excel Formulas and Functions
• Microsoft Excel Data Analysis and PivotTables
• Microsoft Excel for Financial Modeling
• Microsoft Excel for Business Intelligence
• Microsoft Excel VBA Programming
• Microsoft Excel Macros and Automation
• Microsoft Excel Dashboards and Reporting
• Microsoft Excel for Project Management

• Microsoft Excel Cost Estimator
• Microsoft Excel Project Manager
• Data Analyst
• Business Analyst
• Accountant
• Office Administrator

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