Excel Zero to Advance w/ Data Analysis Masterclass & ChatGPT

Focused View

Irfan Sharif ACA ACCA

11:52:34

0 View

1 - Level 1 Getting to know Excel

1 - Getting started with Excel.mp4

12:51

2 - Understanding and working with Cell.mp4

19:49

3 - Understanding and working with Column.mp4

05:57

4 - Understanding and working with Row.mp4

05:31

5 - Mastering Copy Paste.mp4

16:14

6 - Mastering Autofill.mp4

06:53

7 - Intelligent navigation with Excel data.mp4

05:39

8 - Basic Mathematical functions.mp4

04:58

9 - Unlocking Keyboard Shortcuts with Masterkey.mp4

05:31

10 - Homework Entering 10 records in Excel.mp4

00:50

11 - Best Practices Entering data in Excel.mp4

16:31

2 - Level 2 Cleaning data

12 - Product-Lookup-removing-duplicates.xlsx

12 - Remove duplicates.mp4

03:55

13 - Product-Lookup-removing-spaces.xlsx

13 - Removing spaces.mp4

06:27

14 - Product-Lookup-spell-check.xlsx

14 - Spell check.mp4

03:23

15 - Find Find Replace.mp4

05:54

15 - Product-Lookup-find-find-and-replace.xlsx

16 - Product-Lookup-blanks.xlsx

16 - Replacing blank cells.mp4

01:53

17 - Product-Lookup-Proper-case.xlsx

17 - Using proper fonts.mp4

03:14

18 - Extracting Substring or part of data.mp4

20:24

18 - Substring.xlsx

18 - Substring-unsolved.xlsx

3 - Level 3 Transforming Data

19 - Merging data in cells.mp4

04:28

19 - Product-Lookup-merging-data-in-columns.xlsx

20 - Product-Lookup-unmerge-or-delimate.xlsx

20 - Text to Columns.mp4

06:01

21 - Data Sorting.mp4

05:00

21 - Product-Lookup-sorting.xlsx

22 - Transpose.xlsx

22 - Transpose Data.mp4

03:14

23 - Flash Fill.mp4

02:39

23 - Flash-fill.xlsx

4 - Level 4 Compiling data

24 - Vlookup.mp4

13:55

24 - Vlookup-practice-file.xlsx

25 - Hlookup.mp4

05:30

25 - Hlookup.xlsx

26 - IndexMatch.xlsx

26 - Index and match.mp4

13:46

27 - Consolidate.mp4

04:48

27 - Consolidate.xlsx

28 - Append data with Power Query.mp4

05:52

28 - MonthlySalesFiles.zip

5 - Level 5 Getting ready for Data Analysis

29 - Getting-ready-for-data-analysis-lectures.xlsx

29 - Manipulating dates Date Month Year.mp4

04:13

30 - Manipulate dates Name of the Day Name of the Month.mp4

03:30

31 - Manipulating dates Day of the week Week of the year.mp4

04:27

32 - Day of the Year.mp4

08:15

33 - Quarter of the Year.mp4

05:48

34 - Dynamic TODAY Tomorrow Yesterday.mp4

01:39

35 - Calculating Age.mp4

03:16

36 - Adding conditional columns based on IF.mp4

02:05

37 - NESTED IF.mp4

02:53

38 - IF OR.mp4

04:32

39 - IF OR Multiple Column.mp4

03:00

40 - IF OR OR OR Practice.mp4

03:32

41 - IF AND.mp4

02:57

42 - IF AND AND AND Practice.mp4

02:44

6 - Writing formulas to Clean transform Compile Analyze Data with AI ChatGPT

43 - Note for upcoming lectures.html

44 - Getting started writing basic formulas with AI.mp4

14:51

45 - Writing complex IF formulas with AI.mp4

05:11

7 - Level 6 Basic Data Analysis Ad hoc Data Analysis

46 - Analysis-sheet.xlsx

46 - Freeze Panes.mp4

03:25

47 - Filters and advance filters.mp4

06:41

48 - Conditional Formatting.mp4

07:49

49 - Subtotals.mp4

02:26

50 - COUNTIF.mp4

03:42

51 - COUNTIFS.mp4

02:37

52 - SUMIF.mp4

03:47

53 - SUMIFS.mp4

03:10

8 - Level 7 Data Analysis

54 - Analysis-lectures.xlsx

54 - Introduction to Data Analaysis and Data.mp4

04:57

55 - Summay by a parameter.mp4

06:03

56 - Adding parameters with drill down and drill up.mp4

03:03

57 - Breaking down information by Column.mp4

02:54

58 - Filtering the data in reports.mp4

02:05

59 - Understanding Value Field Settings.mp4

03:42

60 - Working with Dates in rows.mp4

04:54

61 - Grouping example.mp4

03:16

62 - Compiling data on one sheet.mp4

06:52

63 - Slicers.mp4

05:31

64 - Timeline.mp4

03:27

65 - Adding Calculated Fields.mp4

11:12

66 - Calculated Fields Why this approach is better.mp4

08:57

9 - Level 8 Preparing Dashboard

67 - Dashboard-data.xlsx

67 - Introduction and first chart.mp4

04:40

68 - Exploring the chart options further.mp4

07:09

69 - Compiling data on one sheet.mp4

06:38

70 - Adding timeline time slicer on dashboard.mp4

03:05

71 - Adding and adjusting slicers.mp4

04:00

72 - Adding trendline charts.mp4

07:33

10 - Advanced Data Analysis Introduction and set up

73 - Beyond Pivot Tables.mp4

07:36

74 - A Quick Glimpse into Power Pivot.mp4

04:50

75 - Installing Power Pivot in Excel.mp4

02:53

76 - Business-Data-course-file.xlsx

76 - Download section data file.html

77 - Understanding Relational Data.mp4

11:57

78 - Uploading data to Data Model.mp4

06:52

79 - Connecting Tables Data Modeling.mp4

07:30

80 - Deploying Power Pivot and Exploring it.mp4

07:08

81 - Distinct Count The Amazing New Field Summarization.mp4

06:31

82 - Lecture-file-Section-10.xlsx

82 - Section file.html

83 - Next step.mp4

02:13

11 - Unlocking Advanced Calculations and Analytics

84 - Introduction to DAX.mp4

03:36

85 - Day Month Year.mp4

07:42

86 - Month Name WeekDay Name WeekDay.mp4

06:14

87 - IF IF OR IF AND IF OR AND.mp4

12:43

88 - Homework IF.html

89 - Multiple conditions with IN.mp4

06:24

90 - Variables Simplifying formulas.mp4

04:54

91 - Lecture file.html

91 - Lecture-file-Section-12-File1.xlsx

92 - Nested IF in DAX.mp4

05:19

93 - SWITCH SWITCH TRUE.mp4

04:30

94 - SWITCH Continued.mp4

04:20

95 - Next steps.mp4

00:48

12 - Putting ChatGPT to write DAX

96 - Firing up the ChatGPT.mp4

06:49

97 - Intro Prompt.html

98 - Writing Basic DAX functions with ChatGPT.mp4

03:07

99 - Just received a ChatGPT update.mp4

00:58

100 - Making ChatGPT write Conditional Columns.mp4

09:14

101 - Biggest use of ChatGPT with DAX.html

13 - DAX Part 2

102 - Simple Mathematical Calculation Column.mp4

05:14

103 - Simple Mathematical Column 2 Calculating Sales.mp4

01:42

104 - RELATED the vlookup xlookup of DAX.mp4

03:55

105 - RELATED within Calculations.mp4

08:33

106 - Deleting the unwanted columns.mp4

04:32

14 - DAX Measures The Real Deal

107 - Our first DAX Measure SUM.mp4

07:33

108 - Other Basic functions.html

109 - SUMX.mp4

07:29

110 - SUMX with RELATED.mp4

07:24

111 - Download the new and old section files here.html

111 - Section-14-File.xlsx

111 - Section-14-File-2.xlsx

112 - Let CHATGPT write measures for you.mp4

03:05

113 - CALCULATE Calculate values matching a Specific Criteria.mp4

06:14

114 - A complex calculation with our CALCULATED Value.mp4

08:41

115 - Section file.html

115 - Section-14-File-2.xlsx

15 - Time Intelligence with DAX

116 - Understanding standard time intelligence and its problems.mp4

08:16

117 - MIN and MAX.mp4

02:07

118 - ALL Bypassing Filters MIN Date Across Data.mp4

03:43

119 - Homework MAX Date Across.html

120 - YTD Year to Date Values.mp4

05:20

121 - QTD Quarter to Date and MTD Month to Date.mp4

04:11

122 - TTD Total to Date.mp4

04:21

123 - FTP For the period Values.mp4

01:34

124 - Rolling Sum and Moving Average.mp4

07:25

125 - Rolling Sum and Moving Average excluding the first two months.mp4

02:54

126 - Excel file for download.html

126 - Section-15-file.xlsx

16 - Time Intelligence with DAX Part 2 Comparison over periods

127 - Calculating Previous Month Value.mp4

05:02

128 - Calculating Previous Period Value dynamically.mp4

05:55

129 - Presenting growth in percentage.mp4

03:06

130 - Calculating Previous Corresponding Period value.mp4

03:29

131 - Homework PCP Growth.html

132 - PCP Growth.mp4

03:24

133 - 5.PCP-Growth.mp4

03:24

133 - Section file.html

17 - Clean Transform with Power Query

134 - Introduction.mp4

01:52

135 - Navigating to Power Query.mp4

03:26

136 - Combining Sales from three tables to one.mp4

03:09

137 - Adding a Unique row identifier for each row Index Column.mp4

03:26

138 - Adding new columns.mp4

06:15

139 - Merging tables.mp4

08:19

140 - Other key features and Uploading data.mp4

05:51

141 - Book2.xlsx

141 - Section data file.html

18 - Bonus Section

142 - Bonus lecture.html

Description

Starting from Zero, Master Excel, Data Analysis in Excel, leveraging advanced tools like Power Pivot, DAX, & ChatGPT

What You'll Learn?

Basics like cells, rows, and columns
Adding/deleting rows and columns
Cell formats
Basic Mathematical functions
Keyboard shortcuts
Data cleaning
Data analysis
Dashboards
Learn everything you need to start working on Excel!

Who is this for?

Beginner level users of Excel who are looking for a solid foundation

Students, business owners, entrepreneurs and professionals

Students with Zero knowledge of Excel

What You Need to Know?

Microsoft Excel 2016, or any other version

More details

Description
Are you ready to transform from an Excel novice to a proficient Excel user or data analyst? This course is your gateway to mastering Microsoft Excelâ€”from foundational skills to advanced data manipulation and analysis techniques. Whether you're a beginner eager to grasp the basics or a seasoned professional aiming to refine your data management prowess, this course is designed to empower you every step of the way.
What You Will Learn:
Excel Mastery: Start from scratch and build a solid foundation in Excel. Learn essential functions, formulas, and shortcuts that streamline your workflow and enhance productivity.
Advanced Data Analysis Techniques: Dive deep into Power Pivot and DAX (Data Analysis Expressions). Discover how to efficiently manage large datasets, create dynamic reports, and extract valuable insights that drive business decisions.
Automate with ChatGPT: Experience the future of data analysis with ChatGPT. Learn how to harness AI to automate complex formulas and tasks, revolutionizing your approach to data manipulation.
Real-World Applications: Apply your skills to real-world scenarios, from financial analysis to marketing insights and operational efficiency. Gain hands-on experience that prepares you for practical challenges in any industry.
Why Choose This Course:
Comprehensive Curriculum: Covering everything from basic Excel functions to advanced data modeling, ensuring you're equipped with the skills needed to excel in today's data-driven world.
Expert Guidance: Taught by a seasoned Chartered Accountant with over a decade of professional experience and a passion for empowering learners through practical, engaging instruction.
Flexible Learning: Study at your own pace with lifetime access to course materials. Whether you're a student, professional, or entrepreneur, fit learning into your schedule and advance your career prospects.
Money-Back Guarantee: Join with confidenceâ€”Udemy offers a 30-day money-back guarantee. If the course doesn't meet your expectations, receive a full refundâ€”no questions asked.
Who Should Enroll:
Aspiring Data Analysts: Begin your journey into the world of data analysis with a solid foundation in Excel and advanced techniques.
Business Professionals: Enhance your analytical skills and gain a competitive edge in your career by mastering Excel, Power Pivot, and DAX.
Entrepreneurs and Small Business Owners: Optimize your business operations, analyze financial data, and make informed decisions to drive growth and profitability.
Anyone looking for a any job or starting a business... Yes, you need Excel!
Donâ€™t Miss Out!
Join thousands of learners worldwide who have transformed their Excel skills and unlocked new career opportunities. Enroll now and embark on your journey to mastering Excel for data analysis!
Who this course is for:
Beginner level users of Excel who are looking for a solid foundation
Students, business owners, entrepreneurs and professionals
Students with Zero knowledge of Excel

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Analytics

Irfan Sharif ACA ACCA

Instructor's Courses

Chartered Accountant with 12 years experience in Accounting, Finance, and Business Intelligence. I am a Chartered Accountant from ICAEW (Institute of Chartered Accountants of England and Wales) and a Chartered Certified Accountant from ACCA (Association of Chartered Certified Accountants in England) . I also have a Bachelors degree in Commerce. I started my professional career with PwC as a Functional Consultant, later moved to at FTSE 100 FMCG as a Finance Manager, then working a General Manager developed an outsourcing hub 'Excelsious' for US and UK accounting firms, and finally cofounded Receipt Bot - an accounting automation company which is automating some tedious aspects of Accounting for clients from 21 countries. Right from the beginning of my career, my role has been to improve the Accounting and Reporting systems. From automating data entry and bookkeeping to the preparation of interactive business analysis dashboards for the senior management, I have led multiple assignments. Over my professional career of 12 years, I have been teaching several programs of Accounting and BI at some reputed institutes. Over this time, I have trained 20,000+ students from 50+ countries. I am absolutely delighted to share my skills and experience with you on the Udemy platform!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.