Mastering Advanced Data Management & Analytics using Microsoft EXCEL

مميز

Sujood Khaled Al-Amayreh

Mastering Advanced Data Management & Analytics using Microsoft EXCEL

(5.0)

1 الطلاب المسجلون

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.

المتطلبات

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.

لمن تناسب هذه الدورة؟

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.

ماذا ستتعلم في هذه الدورة؟

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.

المنهج التعليمي

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

0.0

0 التعليقات

لا توجد تعليقات بعد. كن الأول لتعليق على هذه الدورة.

إضافة تعليق

يرجى تسجيل الدخول لإضافة تعليق. تسجيل الدخول

واتساب

البريد الإلكتروني