Advanced Excel-From Beginner to Expert in 5 hours

Focused View

Sejal Sharma

4:51:37

286 View

1. Introduction & Basics

1. Introduction.mp4

00:51

2. Basics of Excel - 1.mp4

10:41

3. Basics of Excel quiz.html

4. Basics of Excel - 2.mp4

08:30

5. Basics of custom formatting.mp4

08:20

2. Most Important formulae for analysis

1. Cell referencing.mp4

12:17

2.1 ASSignment of udemy cell referencing.xlsx

2. Assignment announcement.mp4

00:15

3. sum, subtract, division, multiplication.mp4

05:53

4. AverageMean function.mp4

02:45

5. COUNT, COUNTA, COUNTBLANK.mp4

06:33

6. Quiz of Formulas.html

7. MAX, MIN, SMALL, LARGE Functions.mp4

07:26

8.1 assignment count.xlsx

8. Assignment No 2.mp4

00:15

9. IF Function.mp4

04:45

10. Nested IF function.mp4

06:43

11. IFS Function.mp4

03:58

12. COUNTIF Function.mp4

04:47

13. SUMIF , AVERAGEIF Function.mp4

08:30

14. UPPER, LOWER AND RIGHT Function.mp4

05:26

15. LEFT, RIGHT, MID, FIND , SEARCH, SUBSTITUTE, LENGTH Function.mp4

12:24

16. Combination of LEFT, RIGHT and FIND Function.mp4

21:42

17.1 TeXT TO COLMS RESOURCES.xlsx

17. Text to column.mp4

05:27

18.1 text to col.xlsx

18. Assignment Announcement.mp4

00:15

19. TODAY NOW YEAR DAY MONTH FUNCTION.mp4

05:46

20. VLOOKUP Function.mp4

08:54

21. HLOOKUP Function.mp4

09:59

22. CONCATENATE Function.mp4

06:25

23.1 index.xlsx

23. INDEX and MATCH Functions.mp4

25:15

24. AND,OR Function.mp4

08:33

25. TRIM Function.mp4

04:24

26. Practice Test 1.html

3. Analysis of data

1. What-If analysis.mp4

14:56

2.1 Financial Sample.csv

2. Pivot Table and Pivot Charts.mp4

25:26

3.1 data validation resources.xlsx

3. Data Validation.mp4

24:20

4.1 Baseball Salaries 2011.xlsx

4.2 Descriptive Statistics In excel.pdf

4. Descriptive Statistics in excel.mp4

09:26

5. Solver Add-In.mp4

10:30

6. Practice test 2.html

Description

Advanced Excel, Excel Formulas, Pivot Tables , VLOOKUP&HLOOKUP, Business analytics

What You'll Learn?

Master Microsoft Excel from Beginner to Advanced
Understanding of data analysis techniques such as sorting, filtering, pivot tables, charts and graphs.
Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
Most Important formulae and tricks needed for analysis of data

Who is this for?

Beginner Microsoft Excel learners

Passionate for Advanced Excel

Aspiring data analysts

What You Need to Know?

No high level knowledge needed of excel. All the basic and important formulas will be discussed in this course.

By the end of this course, you will find yourself in a position to do analysis of data using Microsoft excel

More details

Description
40+ MOST IMPORTANTÂ FUNCTIONSÂ FORÂ ANALYSISÂ OFÂ DATA!
! ASSIGNMENTSÂ Â &Â QUIZZES FORÂ PRACTICALÂ EXPOSURE !
Course Overview: Dive into the world of data with our comprehensive course designed to transform you into an Excel analytics wizard! Whether youâ€™re a beginner looking to understand the basics or a seasoned professional aiming to refine your skills, this course offers a tailored learning experience to meet your needs.
What Youâ€™ll Learn:
Data Manipulation Mastery: Discover how to clean, sort, and organize data efficiently.
Formulas & Functions: Gain proficiency in complex formulas and functions that drive insightful analysis.
PivotTables: Learn to summarize vast datasets with PivotTables
Data Visualization: Create compelling charts and graphs that tell a story and make an impact.
Advanced Analytics Techniques: Explore conditional formatting, What-If analysis, and other advanced tools to uncover hidden trends.
Course Features:
Hands-On Projects: Apply your skills to real-world scenarios with guided projects.
Flexible Learning: Access course materials anytime, anywhere, at your own pace.
Certification: Earn a certificate of completion to showcase your expertise.
Who Should Enroll:
Anyone curious about harnessing the power of Excel for personal or professional growth.
Marketers, finance experts, and managers seeking data-driven decision-making skills.
Students and researchers looking to enhance their data handling capabilities.
Aspiring Business Analysts
Enroll now and start your journey to "ExcelÂ Beyond Expectations".
Who this course is for:
Beginner Microsoft Excel learners
Passionate for Advanced Excel
Aspiring data analysts

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Sejal Sharma

Instructor's Courses

Hey there!This is your tutor, Sejal Sharma. I am a keen learner and an enthusiastic singer with a strong passion for data driven decisions. I am proficient in analytical tools such as MS Excel, Power BI etc. I am confident that you guys are going to enjoy the content of the courses and gain the most out of them.I am ready to make a difference in your professional and career life.Stay Tuned for the upcoming courses:)

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.