logo
Mastering Advanced Data Management & Analytics using Microsoft EXCEL

Mastering Advanced Data Management & Analytics using Microsoft EXCEL

  • Home
  • Courses
  • Mastering Advanced Data Management & Analytics using Microsoft EXCEL
Mastering Advanced Data Management & Analytics using Microsoft EXCEL

course.Featured

Sujood Khaled Al-Amayreh
Sujood Khaled Al-Amayreh

Mastering Advanced Data Management & Analytics using Microsoft EXCEL

(5.0)
1 Students Enrolled
This course is designed to help participants develop advanced Microsoft Excel skills for managing, analyzing, and visualizing data efficiently. By the end of the course, learners will be able to build structured workbooks, apply advanced formulas and functions, automate repetitive tasks using Power Query and VBA, create professional dashboards and reports, and leverage AI-powered tools to improve productivity, data analysis, and decision-making in real-world business environments.

Requirements

  • Basic computer skills and familiarity with Windows applications.

  • Access to Microsoft Excel 365, Excel 2021, or a compatible version.

  • A laptop or desktop computer for hands-on practice.

  • Willingness to complete exercises and practical assignments.

  • No prior advanced Excel knowledge is required.

Who this course for?

  • Anyone aiming to advance their career with professional Excel expertise.

  • Business owners and entrepreneurs managing data-driven decisions.

  • Administrative, HR, finance, sales, and operations professionals.

  • Business owners and entrepreneurs managing data-driven decisions.

  • Anyone aiming to advance their career with professional Excel expertise.

What will you learn?

  • Create and manage structured datasets, tables, and multi-sheet workbooks.

  • Use advanced formulas, lookup functions, and dynamic arrays confidently.

  • Analyze data with PivotTables, charts, conditional formatting, and What-If tools.

  • Automate repetitive tasks using Power Query, Macros, and basic VBA.

  • Build interactive dashboards and leverage AI tools for reporting and analysis.

Curriculum

Microsoft Excel Course is a practical training course designed to equip participants with essential and advanced Excel skills for organizing, analyzing, and visualizing data efficiently.

  • About Excel Course 1

    3 Minutes

  • About Excel Course 2

    2 Minutes

  • 01. Introduction to Excel

    9 Minutes

  • 02. Excel Interface

    6 Minutes

  • 03. Ribbon, Tabs & Quick Access Toolbar

    7 Minutes

  • 04. Workbook vs Worksheet & Cell References

    8 Minutes

  • 01. Insert & Rename Sheets

    8 Minutes

  • 02. Move, Copy & Delete Sheets

    8 Minutes

  • 03. Grouping Worksheets

    8 Minutes

  • 04. Linking Data Between Sheets

    7 Minutes

  • 05. Protecting, Hiding & Unhiding Sheets

    8 Minutes

  • 01. Creating Tables

    6 Minutes

  • 02. Table Styles

    6 Minutes

  • 03. Structured References

    7 Minutes

  • 04. Automatic Table Expansion

    6 Minutes

  • 05. Sorting & Filtering in Tables

    7 Minutes

  • 06. Total Row, Remove Duplicates & Slicers

    6 Minutes

  • 01. IF function

    7 Minutes

  • 02. Nested IF

    6 Minutes

  • 03. IFS & SWITCH

    9 Minutes

  • 04. AND & OR

    10 Minutes

  • 05. NOT

    6 Minutes

  • 06. IFERROR & IFNA

    5 Minutes

  • 01. VLOOKUP

    6 Minutes

  • 02. HLOOKUP

    6 Minutes

  • 03. INDEX

    6 Minutes

  • 04. MATCH

    7 Minutes

  • 05. INDEX + MATCH

    10 Minutes

  • 06. XLOOKUP

    5 Minutes

  • 07. XMATCH

    5 Minutes

  • 08. Two-way Lookup & Dynamic References

    7 Minutes

  • 01. LEFT RIGHT MID

    7 Minutes

  • 02. LEN & TRIM

    7 Minutes

  • 03. CLEAN

    4 Minutes

  • 04. CONCAT & TEXTJOIN

    6 Minutes

  • 05. SUBSTITUTE & REPLACE

    6 Minutes

  • 01. TODAY & NOW

    6 Minutes

  • 02. DATEDIF

    5 Minutes

  • 03. WORKDAY & NETWORKDAYS

    8 Minutes

  • 04. EOMONTH

    5 Minutes

  • 39. SUMIF

    5 Minutes

  • 40. SUMIFS

    6 Minutes

  • 41. ROUND Functions

    5 Minutes

  • 42. ABS & MOD

    5 Minutes

  • 43. POWER & SQRT

    5 Minutes

  • 44. CEILING FLOOR LARGE SMALL

    8 Minutes

  • 45. AVERAGE

    5 Minutes

  • 46. COUNT & COUNTA

    5 Minutes

  • 47. COUNTIF

    5 Minutes

  • 48. RANK

    7 Minutes

  • 49. PERCENTILE

    5 Minutes

  • 50. PMT

    6 Minutes

  • 51. FV & PV

    5 Minutes

  • 52. NPV & IRR

    5 Minutes

  • 53. Loan Amortization & Investment Models

    5 Minutes

  • 54. Excel Errors

    5 Minutes

  • 55. Formula Auditing

    5 Minutes

  • 56. Best Practices

    4 Minutes

  • 57. Advanced Sort & Filter

    6 Minutes

  • 58. Advanced Filter

    4 Minutes

  • 59. Data Validation

    5 Minutes

  • 60. Goal Seek

    4 Minutes

  • 61. Scenario Manager & Data Tables

    9 Minutes

  • 62. Create PivotTable

    5 Minutes

  • 63. Grouping & Summarizing

    4 Minutes

  • 64. Calculated Fields

    5 Minutes

  • 65. Pivot Charts

    5 Minutes

  • 66. Slicers & Timelines

    6 Minutes

  • 67. Basic Charts

    5 Minutes

  • 68. Combo & Secondary Axis

    5 Minutes

  • 69. Dynamic Charts

    4 Minutes

  • 70. Dashboard Design

    6 Minutes

  • 71. Highlight Rules

    4 Minutes

  • 72. Formula Based & KPI

    3 Minutes

  • 73. Import, Clean, Merge & Automate Data

    4 Minutes

  • 74. Recording Macros, Editing Macros & VBA Introduction

    3 Minutes

  • AI-Powered Excel

    4 Minutes

  • Course Material

  • Course files 1

  • Course files 2

  • Practice 1

    13 Minutes

  • Practice 2

    14 Minutes

  • Practice 3

    7 Minutes

  • Practice 4

    15 Minutes

  • Practice 5

    24 Minutes

  • Practice 6

    17 Minutes

  • Practice 7

    17 Minutes

  • Practice 8

    3 Minutes

  • Practice 9

    4 Minutes

  • Practice 10

    4 Minutes

  • Practice 11

    13 Minutes

  • Practice 12

    8 Minutes

  • Practice 13

    4 Minutes

  • Practice 14

    2 Minutes

  • Practice 15

    4 Minutes

  • Practice 16

    3 Minutes

  • Final Project

  • Final Exam

Reviews

Excellent

0

Very Good

0

Average

0

Poor

0

Terrible

0

0.0

0 reviews

No reviews yet. Be the first to review this course.

Add a Review

Please log in to leave a review. Log in

178 USD 160 USD

Buy this course

Related Courses

logo
English العربية