Master Excel From Scratch: Excel 2024 Challenge

Focused View

IT Security Online Training

8:24:23

11 View

1. Day 1 Introduction

1. Starting with Excel.mp4

02:06

2. Excel Basics- I.mp4

07:14

3. Excel Basics- II.mp4

03:53

4. Excel Basics- III.mp4

03:13

2. Day 2 Basic Formulas

1. Data Entry- I.mp4

08:19

2. Data Entry- II.mp4

05:32

3. SUM.mp4

04:49

4. 5 Basic Formulas.mp4

05:48

3. Day 3 Sorting and Filter

1. Sort.mp4

07:23

2. Filter- I.mp4

03:01

3. Filter- II.mp4

06:01

4. Advance Filter.mp4

04:26

5. Macro- I.mp4

07:06

6. Macro- II.mp4

07:09

4. Day 4 Data Validation

1. Data Validation- I.mp4

04:55

2. Data Validation- II.mp4

05:43

3. Data Validation- III.mp4

03:12

5. Day 5 Conditional Formatting

1. Conditional Formatting- I.mp4

03:56

2. Conditional Formatting- II.mp4

04:20

3. Conditional Formatting- III.mp4

08:14

6. Day 6 Text to Column and Flash Fill

1. Text to Column.mp4

03:47

2. Flash Fill.mp4

03:27

7. Day 7 Remove Duplicates and Paste Special

1. Remove Duplicates.mp4

02:42

2. Paste Special- I.mp4

04:12

3. Paste Special- II.mp4

03:57

4. Paste Special- III.mp4

02:48

5. Paste Special- IV.mp4

04:35

6. Paste Special- V.mp4

02:46

7. Paste Special- VI.mp4

03:42

8. Day 8 IF Formula [IF, AND, OR]

1. IF Formula.mp4

06:44

2. IF with AND Formula.mp4

09:30

3. IF with OR Formula.mp4

05:07

4. IF Nested.mp4

07:26

9. Day 9 Statistical Formulas

1. COUNTIF & SUMIF.mp4

05:54

2. SUMIFS & COUNTIFS.mp4

09:16

10. Day 10 More Formulas

1. Index & Match.mp4

07:12

2. Date.mp4

03:57

3. DatedIF.mp4

05:35

11. Day 11 VLOOKUP & HLOOKUP

1. VLOOKUP & HLOOKUP.mp4

07:32

2. row & column formulas.mp4

10:10

12. Day 12 Text Formulas in Excel

1. UPPER, LOWER & PROPER.mp4

03:03

2. 5 Text Formulas.mp4

08:46

3. MID.mp4

04:25

13. Day 13 Professional Printing and Pivot Table

1. Printing in Excel- I.mp4

03:50

2. Printing in Excel- II.mp4

08:11

3. Pivot Table.mp4

11:16

4. Pivot Chart.mp4

05:56

5. Slicer.mp4

07:29

6. Timeline.mp4

03:36

14. Day 14 ChatGPT & XLOOKUP

1. ChatGPT.mp4

07:30

2. XLOOKUP- I.mp4

06:54

3. XLOOKUP- II.mp4

04:32

15. Day 15 Financial Functions

1. Filter Formula.mp4

04:15

2. Sort Formula.mp4

04:58

3. Financial Functions.mp4

08:32

16. Additional Content Old Videos of Excel for Revision

1. Information.html

2. Lesson 1- What is Excel.mp4

02:44

3. Lesson 2- Open-Input-Save.mp4

04:10

4. Lesson 3- Customization.mp4

01:51

5. Lesson 4- Interface.mp4

01:50

6. Lesson 5- Formula-Status-Bar.mp4

03:38

7. Lesson 6- Tabs.mp4

03:46

8. Lesson 7- Navigation.mp4

04:40

9. Lesson 8- Shortcuts.mp4

02:16

10. Lesson 9- Basic Formulas- I.mp4

02:31

11. Lesson 10- Basic Formulas- II.mp4

02:12

12. Lesson 11- Basic Formulas- III.mp4

02:15

13. Lesson 12- Basic Formulas- IV.mp4

02:35

14. Lesson 13- Basic Formulas- V.mp4

02:15

15. Lesson 14- Basic Formulas- VI.mp4

02:27

16. Lesson 15- Find and Replace.mp4

02:31

17. Lesson 16- Advanced Find and Replace.mp4

04:01

18. Lesson 17- Assignment- I.mp4

02:20

19. Lesson 18- Solution- I.mp4

02:39

20. Lesson 19- Data Formatting.mp4

04:01

21. Lesson 20- Copying External Data.mp4

04:37

22. Lesson 21- Organize Data.mp4

05:54

23. Lesson 22- Arrange Data.mp4

02:40

24. Lesson 23- Text Conversion.mp4

06:22

25. Lesson 24- Text to Columns.mp4

03:39

26. Lesson 25- Relative Reference.mp4

02:56

27. Lesson 26- Assignment- 2.mp4

04:53

28. Lesson 27- Absolute Reference.mp4

07:25

29. Lesson 28- Mixed Referencing.mp4

07:31

30. Lesson 29- Data Validation.mp4

05:33

31. Lesson 30- Types of Data Validation.mp4

06:07

32. Lesson 31- Ask Y or N.mp4

02:41

33. Lesson 32- Data Validation Example.mp4

04:34

34. Lesson 33- Conditional Formatting.mp4

05:54

35. Lesson 34- Conditional Formatting Example.mp4

05:33

36. Lesson 35- Practice.mp4

03:08

37. Lesson 36- Upper-Lower.mp4

04:27

38. Lesson 37- Proper-Trim.mp4

05:37

39. Lesson 38- Proper-Trim Editing.mp4

02:06

40. Lesson 39- VLOOKUP.mp4

03:48

41. Lesson 40- Index-Match.mp4

08:48

42. Lesson 41- Task- I.mp4

03:49

43. Lesson 42- SUMIFS.mp4

05:54

44. Lesson 43- AVERAGEIFS.mp4

04:05

45. Lesson 44- Task- II.mp4

02:41

46. Lesson 45- WORKDAY.INTL.mp4

05:01

47. Lesson 46- Task- III.mp4

02:35

48. Lesson 47- Presenting Data.mp4

02:26

49. Lesson 48- Choose.mp4

09:05

Description

Excel mastery From Scratch 2024: Empower yourself with essential skills, advanced techniques and real power of Excel.

What You'll Learn?

Master essential Excel formulas for efficient data manipulation.
Learn how to sort and filter data like a pro.
Dive into advanced filtering techniques for precise data analysis.
Harness the power of data validation to ensure accuracy.
Unlock creative possibilities with conditional formatting.
Transform text with ease using text to columns and flash fill.
Eliminate duplicates effortlessly with remove duplicates feature.
Explore the versatility of paste special options for seamless data management.
Master logical functions like IF, AND, OR, and NestedIF for dynamic analysis.
Dive deep into advanced functions like SUMIFS and COUNTIFS for complex calculations.
Uncover the magic of INDEX and MATCH for flexible data retrieval.
Master the art of data lookup with VLOOKUP, HLOOKUP, and XLOOKUP.
Explore text and date formulas for precise data manipulation.
Become a pivot table and pivot chart wizard for insightful data visualization.
Automate tasks and enhance productivity with macros and ChatGPT integration.

Who is this for?

Anyone who want to learn Excel from Beginner to Intermediate.

What You Need to Know?

No experience needed. Learn Excel from Scratch.

More details

Description
Welcome to the "Master Excel From Scratch: Excel 2024 Challenge "!
Unlock the full potential of Excel in just 15 days with our comprehensive course designed to empower you with essential skills and advanced techniques. Whether you're a novice or seeking to elevate your proficiency, our structured program covers everything from the fundamentals to expert-level strategies.
In this course, you'll embark on a journey through Excel mastery, starting with a solid foundation in basic formulas and essential functionalities like sort and filter. Dive deeper into advanced features such as data validation, conditional formatting, and text manipulation tools like text to columns and flash fill.
Uncover the power of logical functions with IF, AND, OR, and NestedIF, and harness the capabilities of SUMIFS and COUNTIFS for complex data analysis. Explore the versatility of INDEX and MATCH, VLOOKUP, HLOOKUP, and XLOOKUP, alongside mastering text and date formulas for dynamic data manipulation.
Take your data analysis skills to the next level with pivot tables, pivot charts, and slicers, enabling you to extract meaningful insights effortlessly. Delve into financial functions for comprehensive financial analysis and reporting.
But that's not all! Learn to streamline your workflow with printing options, automate tasks with macros, and discover the potential of ChatGPT integration for enhanced productivity and problem-solving.
Join us on this transformative journey to Excel mastery. Enroll now and empower yourself with the skills to excel in Excel!
Embark on a transformative journey to Excel mastery with our intensive 15-day course. Whether you're a beginner eager to unlock Excel's potential or a seasoned user aiming to refine your skills, our comprehensive curriculum ensures that you'll emerge equipped with the knowledge and confidence to tackle any spreadsheet challenge.
With a blend of hands-on learning, expert guidance, and real-world applications, this course offers a dynamic and engaging learning experience. Join a community of like-minded learners, receive personalized support from experienced instructors, and unlock the doors to limitless opportunities in data analysis, reporting, and beyond.
Don't miss this chance to supercharge your career and become a proficient Excel user in just 15 days. Enroll now and take the first step towards Excel excellence!
Note:Â We have added extra videos for you to revise everything you learned but this time with different videos.
Who this course is for:
Anyone who want to learn Excel from Beginner to Intermediate.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

IT Security Online Training

Instructor's Courses

We at IT Security Online Training provide training on Cyber Security and Linux. We are committed to deliver high quality training programs. After teaching thousands of students offline, we are now available to serve you online at Udemy. If you are planning to enter into the world of Cyber Security, our courses will definitely help you. So what are you waiting for, Let's get started.

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.