Microsoft Excel Beginner to Advanced w/ Data Analysis 101

Focused View

Irfan Sharif ACA ACCA,ITAAI Education

6:03:22

11 View

1. Level 1 Getting to know Excel

1. Introduction to Spreadsheet, Cell, Column and Row.mp4

07:51

2. Learning keyboard shortcuts to navigatge in a sheet, to add columns and rows.mp4

05:41

3. Understanding cell format.mp4

03:08

4. Autofill.mp4

01:37

5. Basic Mathamatical functions.mp4

06:10

6. Resources files for the lectures.html

7.1 Practice sheet.xlsx

7. Practice on real data.mp4

09:57

8. Entering data in Excel - Best Practices.html

2. Level 2 Cleaning data

1.1 Product-Lookup - removing duplicates.xlsx

1. Remove duplicates.mp4

03:55

2.1 Product-Lookup - removing spaces.xlsx

2. Removing spaces.mp4

06:27

3.1 Product-Lookup - spell check.xlsx

3. Spell check.mp4

03:23

4.1 Product-Lookup - find find and replace.xlsx

4. Find Find & Replace.mp4

05:54

5.1 Product-Lookup - blanks.xlsx

5. Replacing blank cells.mp4

01:53

6.1 Product-Lookup - Proper case.xlsx

6. Using proper fonts.mp4

03:14

7.1 Substring.xlsx

7. Extracting Substring or part of data.mp4

20:24

3. Level 3 Transforming Data

1.1 Product-Lookup - merging data in columns.xlsx

1. Merging data in cells.mp4

04:27

2.1 Product-Lookup - unmerge or delimate.xlsx

2. Text to Columns.mp4

06:01

3.1 Product-Lookup - sorting.xlsx

3. Data Sorting.mp4

05:00

4.1 Transpose.xlsx

4. Transpose Data.mp4

03:14

5.1 Flash fill.xlsx

5. Flash Fill.mp4

02:39

4. Level 4 Compiling data

1.1 Vlookup practice file.xlsx

1. Vlookup.mp4

13:55

2.1 Hlookup.xlsx

2. Hlookup.mp4

05:30

3.1 IndexMatch.xlsx

3. Index and match.mp4

13:46

4.1 Consolidate.xlsx

4. Consolidate.mp4

04:48

5.1 MonthlySalesFiles.zip

5. Append data with Power Query.mp4

05:52

5. Level 5 Getting ready for Data Analysis

1.1 Getting ready for data analysis - lectures.xlsx

1. Manipulating dates - Date Month Year.mp4

04:13

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

03:30

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

04:27

4. Day of the Year.mp4

08:15

5. Quarter of the Year.mp4

05:48

6. Dynamic TODAY Tomorrow Yesterday.mp4

01:39

7. Calculating Age.mp4

03:16

8. Adding conditional columns based on IF.mp4

02:05

9. NESTED IF.mp4

02:53

10. IF OR.mp4

04:32

11. IF OR Multiple Column.mp4

03:00

12. IF OR OR OR Practice.mp4

03:32

13. IF AND.mp4

02:56

14. IF AND AND AND Practice.mp4

02:44

6. Level 6 Basic Data Analysis (Ad hoc Data Analysis)

1.1 Analysis sheet.xlsx

1. Freeze Panes.mp4

03:24

2. Filters and advance filters.mp4

06:41

3. Conditional Formatting.mp4

07:49

4. Subtotals.mp4

02:26

5. COUNTIF.mp4

03:42

6. COUNTIFS.mp4

02:37

7. SUMIF.mp4

03:47

8. SUMIFS.mp4

03:10

7. Level 7 Data Analysis

1.1 Analysis - lectures.xlsx

1. Introduction to Data Analaysis and Data.mp4

04:57

2. Summay by a parameter.mp4

06:02

3. Adding parameters with drill down and drill up.mp4

03:03

4. Breaking down information by Column.mp4

02:54

5. Filtering the data in reports.mp4

02:05

6. Understanding Value Field Settings.mp4

03:42

7. Working with Dates in rows.mp4

04:54

8. Grouping example.mp4

03:16

9. Compiling data on one sheet.mp4

06:52

10. Slicers.mp4

05:31

11. Timeline.mp4

03:27

12. Adding Calculated Fields.mp4

11:12

13. Calculated Fields - Why this approach is better.mp4

08:57

8. Preparing Dashboard

1.1 Dashboard - data.xlsx

1. Introduction and first chart.mp4

04:39

2. Exploring the chart options further.mp4

07:09

3. Compiling data on one sheet.mp4

06:38

4. Adding timeline (time slicer) on dashboard.mp4

03:05

5. Adding and adjusting slicers.mp4

04:00

6. Adding trendline charts.mp4

07:33

9. Relational Data and Data Modelling

1.1 AdventureWorks db style RawData.xlsx

1.2 AdventureWorks db style.xlsx

1.3 AdventureWorks traditional style data.xlsx

1. Understanding Relational Data.mp4

08:29

2. Adding Power Pivot to Excel.mp4

01:10

3. Adding data to Data Model.mp4

05:12

4. Data Modelling.mp4

05:36

5. Power Pivot.mp4

04:25

10. Keyboard Shortcuts Masterclass

1. Shortcuts Masterclass Part 1.mp4

03:17

2. Shortcuts Masterclass Part 2.mp4

04:05

Description

Microsoft Excel A to Z with Excel Data Analysis, & Excel Dashboards. A complete MS Excel Beginner to Advanced Course!

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
Microsoft Excel is one of the most powerful data management, data analysis and dashboarding tool.
This course enables students to start using Excel in an effective manner. It starts from the very basics and within a few minutes, you will be having a good command over basic excel functions and even some advanced and frequently used features.

About this course:
Designed to teach Microsoft Excel to absolute beginners, this course will take you from scratch to a level where you can effectively store, manage, clean, transform, consolidate, analyze, and visualize data.

Prerequisites:
There is absolutely no prerequisite to start this course. Even 8 years old can take this course to learn Excel.

Who should take this course:
First-time learners, who have no idea about Excel and want to start the right way. This includes:
Students
Professionals, especially those who have to work with numbers.
Daydreamers who wish to bring financial sense to their dreams.
Anyone who wants to learn a better way to manage the numbers and calculations.

Software Requirement:
You should have Microsoft Excel installed on your computer. Any version above Excel 2010 will be okay. I will be using Excel 2016 in this course. If you do not have Excel currently, please download Office 365 free trial from the Microsoft website. Just google Office 365 free trial and it will take you to the page.

Money-Back Guarantee:Â
Nothing to lose! If you won't be satisfied with the course, Udemy offers 30 days money-back guarantee!

Introduction to the teacher:
Chartered Accountant | 12 years of work experience | 12 years of teaching experience as visiting faculty | 4000+ in-class students | 100,000+ Udemy students | In love with Excel for 15 years
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

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!

ITAAI Education

Instructor's Courses

Welcome to ITAAI - International Tech Age Accounting InstituteAre you ready to embark on a transformative journey in the world of accounting and financial technology? Look no further than ITAAI - the International Tech Age Accounting Institute. Our online academy is a pioneering hub for fully comprehensive Tech Age Accounting education, designed to equip aspiring accountants and financial professionals with the skills and knowledge needed to thrive in a rapidly evolving industry.Our Mission At ITAAI, our mission is clear: to prepare accountants for the future of accounting. We understand that the landscape of accounting is constantly shifting, with emerging technologies playing a pivotal role in shaping the profession. With this in mind, our academy is dedicated to providing cutting-edge education that empowers individuals to excel in this dynamic field.Key Features of ITAAIPractical Learning: Our curriculum is built on a foundation of practicality. We believe that real-world application is the key to mastering the complexities of modern accounting and financial technology.Flexibility: Life is busy, and we get it. That's why ITAAI offers a flexible learning environment. You choose when and where to study, allowing you to tailor your education to fit your schedule.Affordability: Quality education shouldn't come with a hefty price tag. ITAAI is committed to making Tech Age Accounting education accessible to all, ensuring affordability without compromising on quality.Self-Paced: We understand that every student is unique. With our self-paced courses, you have the freedom to learn at your own speed, ensuring a comfortable and effective learning experience.Hands-On Experience: Our courses are enriched with hands-on exercises and projects that bridge the gap between theory and practice. You'll graduate with the practical skills necessary to succeed in the real world.Future-Focused: The future of accounting is tech-driven. ITAAI stays at the forefront of industry trends, ensuring that our students are well-prepared for the challenges and opportunities that lie ahead.Meet Our Leader Leading the charge at ITAAI is a Chartered Accountant with extensive experience in both accounting and financial technology. With a wealth of knowledge and a commitment to excellence, our leader guides the academy's vision and ensures that every student receives the best education possible.Join Us at ITAAI Are you ready to embrace the future of accounting? Join the ranks of forward-thinking accountants and financial professionals who have chosen ITAAI as their gateway to success. Enroll today and unlock a world of possibilities in Tech Age Accounting.At ITAAI, we don't just teach accounting; we shape the future of accounting. Discover your potential with us and become a driving force in the ever-evolving world of finance and technology. Your journey starts here.

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.