Microsoft Excel Beginner To Professional Complete Training 2024

Microsoft Excel Beginner To Professional Complete Training 2024

Immerse yourself in data mastery with Microsoft Excel Beginner To Professional Complete Training 2024. This course guides you from basic to advanced Microsoft Excel skills, enhancing productivity, data management, and analytical capabilities. Equip yourself with the expertise to transform simple spreadsheets into powerful analytical tools, ensuring you leverage Microsoft Excel to its full potential for making informed decisions.

Learning Outcomes:

• Master the basic features and setup of Microsoft Excel.
• Learn to implement core functions of Microsoft Excel.
• Use XLOOKUP in Excel 2021 and Office 365 efficiently.
• Develop skills in formatting, importing data, and managing tables in Microsoft Excel.
• Build proficiency in creating and managing various charts using Microsoft Excel.
• Gain expertise in creating and analyzing data with pivot tables in Microsoft Excel.
• Learn to use Maps and Geo charts in Microsoft Excel for visual data representation.

Key Employment Opportunities:

• Excel Cost Estimator: Yearly £45,000 approx
• Excel Project Manager: Yearly £50,000 approx
• Office Administrator: Yearly £18,000 to £30,000 approx

More Benefits:

• Assignment on the Microsoft Excel course
• Free Digital Reed Certificate on Microsoft Excel course
• Compatible with iPhone & Android Devices
• Moneyback Guarantee

Empower UK Diploma Certificate

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• Getting Started 15:15

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

• Excel Basics 1:07:08

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

• Excel Essential Function 1:49:25

  • 14: Microsoft Excel: Introduction 01:14
  • 15: Microsoft Excel: Basic formula operations 06:14
  • 16: Microsoft Excel: Mathematical functions level1 19:54
  • 17: Microsoft Excel: Mathematical functions level2 12:23
  • 18: Microsoft Excel: Text functions level1 09:07
  • 19: Microsoft Excel: Text functions level2 12:56
  • 20: Microsoft Excel: Logical functions 11:03
  • 21: Microsoft Excel: Date time functions 06:20
  • 22: Microsoft Excel: V Lookup formula 12:12
  • 23: Microsoft Excel: HLookup formula 04:07
  • 24: Microsoft Excel: HLookup Match formula 08:34
  • 25: Microsoft Excel: Match Index formula 05:21

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

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

• Get Data and Tools 39:12

  • 30: Microsoft Excel: Introduction 01:45
  • 31: Microsoft Excel: Split Text into columns 07:03
  • 32: Microsoft Excel: Flash Fill 07:03
  • 33: Microsoft Excel: Remove Duplicates 07:47
  • 34: Microsoft Excel: Data Validation 06:34
  • 35: Microsoft Excel: Get - import Data from Text 05:38
  • 36: Microsoft Excel: Get - import Data from CSV 03:22

• Formatting Data and Tools 25:00

  • 37: Microsoft Excel: Introduction 01:22
  • 38: Microsoft Excel: Formatting Font 04:15
  • 39: Microsoft Excel: Formatting Alignment 06:04
  • 40: Microsoft Excel: Formatting Number 04:37
  • 41: Microsoft Excel: Formatting Date 03:29
  • 42: Microsoft Excel: Formatting tables 05:13

• Pivot Tables 20:47

  • 43: Microsoft Excel: Introduction 01:08
  • 44: Microsoft Excel: Creating Pivot Table 06:43
  • 45: Microsoft Excel: Value field settings 04:06
  • 46: Microsoft Excel: Number format 02:28
  • 47: Microsoft Excel: Pivot Table Design 03:20
  • 48: Microsoft Excel: Excel Exercise 01:29
  • 49: Microsoft Excel: Solution for Excel Exercise 01:33

• Excel Charts 35:31

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

• Advanced Excel Charts 16:29

  • 61: Microsoft Excel: Introduction 00:52
  • 62: Microsoft Excel: Frequency Distribution and Histograms 03:44
  • 63: Microsoft Excel: Waterfall charts 01:50
  • 64: Microsoft Excel: Hierarchy charts sunburst and tree map 02:46
  • 65: Microsoft Excel: Combination charts 02:19
  • 66: Microsoft Excel: Sparklines 04:58

• Pivot Charts 01:49

  • 67: Microsoft Excel: Pivot charts 01:49

• Maps Chart above 2019 06:29

  • 68: Microsoft Excel: Maps chart 03:53
  • 69: Microsoft Excel: 3D Maps chart 02:36

• Business-Geo Charts 09:44

  • 70: Microsoft Excel: Introduction 00:50
  • 71: Microsoft Excel: Stock charts 01:55
  • 72: Microsoft Excel: Radar charts 01:34
  • 73: Microsoft Excel: Surface charts 01:54
  • 74: Microsoft Excel: Heat maps 03:31

• Named Ranges 11:17

  • 75: Microsoft Excel: Named ranges - dropdown 05:03
  • 76: Microsoft Excel: Indirect Name range Function 06:14

• Import Data into Excel 12:39

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

• Advanced Excel 11:17

  • 79: Microsoft Excel: Project Sales forecast tracker 06:39
  • 80: Microsoft Excel: Product Sale Tax invoice Tax Calculations 04:38

• Microsoft Excel - Course Assignment 12:00

  • 81: Microsoft Excel: Assignment Instruction 01:00
  • 82: Course Assignment Worksheet 10:00
  • 83: Empower UK Submit Your Assignment 01:00

• Bonus: Workplace Management Toolkit 23:18

  • 84: The Workplace Management Toolkit Promo Preview 00:18
  • 85: Workplace Management Toolkit 23:00

Key Lesson Snippets:

• Getting Started with Microsoft Excel: Familiarize with the interface and basic setup of Microsoft Excel.
• Excel Basics: Acquire foundational skills for creating and managing spreadsheets in Microsoft Excel.
• Excel Essential Functions: Learn core functions that are critical for daily use in Microsoft Excel.
• XLOOKUP: Master the XLOOKUP function exclusive to Excel 2021 and Office 365.
• Data Management Tools: Explore Microsoft Excel's tools for importing, formatting, and handling data.
• Advanced Formatting and Tables: Learn advanced techniques for data presentation and organization in Microsoft Excel.
• Pivot Tables and Charts: Become proficient in creating and manipulating pivot tables and charts for data analysis in Microsoft Excel.
• Advanced Data Visualization: Delve into advanced charting techniques, including pivot charts and maps for geographical data presentation using Microsoft Excel.

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

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)
• 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

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