Microsoft Excel 365 - Beginner to Advanced Level 2022

Focused View

Himanshu Dhar

11:32:04

147 View

1. Lets Start with Excel Fundamentals

1.1 Chart Preperation.xlsx

1.2 Compare Data.xlsx

1.3 Function Data.xlsx

1.4 Pivot Table.xlsx

1.5 Real Data - Copy.xlsx

1.6 Real Data.xlsx

1.7 sum if.xlsx

1. Excel Intro - New File and Title Bar.mp4

09:08

2. Excel Structure and Worksheets.mp4

10:47

3. Customize Ribbons and Quick Access Toolbar.mp4

08:16

4. Data Entry and Formatting.mp4

14:16

5. Fill Series in Excel.mp4

11:22

6. Flash Fill in Excel.mp4

03:15

7. Cell Reference Understanding.mp4

05:57

2. Mastering Mathematical Functions

1. Math Operators in Excel.mp4

15:51

2. Math Functions in Excel.mp4

17:17

3. Advance Math Function in Excel.mp4

17:10

4. Database Math Function.mp4

07:56

3. Mastering Logical Functions Use

1. IF Function in Excel.mp4

07:38

2. Nesting IF Methodology.mp4

04:44

3. IF Related Project Solution.mp4

08:42

4. IF Project Task.mp4

01:07

5. IF Project Task Solution.mp4

04:44

6. IFS Function - Newly Introduced.mp4

04:56

7. AND & OR Function in Excel.mp4

06:07

8. XOR Function.mp4

04:34

4. Data Filter and Sorting in Excel

1.1 Function Data.xlsx

1.2 Real Data.xlsx

1. Filter in Excel.mp4

16:27

2. Date and Color Filter.mp4

04:37

3. Advanced Filter Option.mp4

06:35

4. Sort and Custom Sort.mp4

04:20

5. Conditional Formatting in Excel

1.1 Function Data.xlsx

1. Conditional Formatting - How to Apply.mp4

06:11

2. Types of Rules in Conditional Formatting.mp4

11:56

3. Manage Rules in Conditional Formatting.mp4

04:51

6. Mastering Text Functions and Tools

1.1 Function Data.xlsx

1. UPPER, LOWER, PROPER and TRIM Function.mp4

08:28

2. LEFT, RIGHT and FIND Function.mp4

07:18

3. Find Related Task Solution.mp4

06:21

4. Nesting LEFT, RIGHT and FIND Function.mp4

03:53

5. MID Function.mp4

04:17

6. CONCATENATE Function.mp4

04:25

7. CONCATENATE Project Task Solution.mp4

02:40

8. CONCAT and TEXTJOIN Function.mp4

04:21

9. REPLACE Function.mp4

07:15

10. REPLACE Function Project Solution.mp4

01:55

11. SUBSTITUTE Function.mp4

04:30

12. REPT, LEN Function and Project.mp4

02:23

13. Project Task Solution.mp4

02:35

14. NUMBERVALUE Function.mp4

03:24

15. Text to Column Option.mp4

14:28

7. Mastering Chart Presentation in Excel

1. Chart Preparation in Excel.mp4

16:29

2. Designing and Format Chart.mp4

14:23

3. Chart Customization - Part 1.mp4

03:50

4. Chart Customization - Part 2.mp4

05:29

5. Pie Chart in Excel.mp4

12:25

6. Quick Analysis and Chart Recommendation.mp4

03:58

7. Power Map in Excel.mp4

05:11

8. Mastering Pivot Table and Power Pivot

1.1 Pivot Table.xlsx

1. Pivot Table in Excel.mp4

53:50

2.1 Client Info.xlsx

2.2 Items Info.xlsx

2.3 order info.xlsx

2. Power Pivot in Excel - Most Powerful Analysis Tool.mp4

29:45

9. Financial Functions and What if Analysis Tools

1. PDURATION Function.mp4

02:33

2. PMT Function - EMI Calculator.mp4

06:13

3. Data Table in Excel.mp4

11:45

4. Goal Seek in Excel.mp4

05:44

5. Solver Plugin in Excel.mp4

04:52

6. Scenario Manager in Excel.mp4

07:22

10. Data Grouping and Linking

1. Define Name Feature in Excel.mp4

08:56

2. Hyperlink in Excel.mp4

07:47

3. Group and Subtotal in Excel.mp4

07:24

4. Draw Tab in Excel.mp4

05:22

11. How to Print Spreadsheet Efficiently

1. Print Options in Excel - Part 1.mp4

10:25

2. Print Options in Excel - Part 2.mp4

08:44

12. Protect your Data in Excel

1. Protect Workbook in Excel.mp4

04:47

2. Protect Sheet in Excel.mp4

08:59

3. Hide Formula and Unlocked Cell.mp4

05:11

4. Protect Excel File with Password.mp4

02:47

13. Date and Time Management

1. Date and Time Setting.mp4

05:55

2. Date and Time Format in Excel.mp4

08:26

3. Date and Time Functions.mp4

07:03

4. NETWORKDAYS Function.mp4

04:39

5. DATEDIF Function.mp4

03:35

14. Mastering Lookup and Reference Functions

1.1 Real Data - Copy.xlsx

1.2 Real Data - Copy.xlsx

1.3 Real Data.xlsx

1. VLOOKUP Function.mp4

13:53

2. IFERROR Function with VLOOKUP.mp4

08:04

3. Array VLOOKUP Function.mp4

06:05

4. HLOOKUP Function in Excel.mp4

04:13

5. MATCH and INDEX Functions.mp4

04:47

6. MATCH and INDEX Functions Nesting.mp4

04:25

7. VLOOKUP TRUE Feature.mp4

04:43

8. Amazing Trick in LOOKUP Functions.mp4

09:56

9. XLOOKUP Function.mp4

28:00

15. Mastering Macro Recording Feature

1. Macro Recording in Excel.mp4

15:18

2. Macro Recording Examples.mp4

05:56

3. Ways to Run Macros in Excel.mp4

05:58

Description

Excel Beginner to Advance. Excel Formatting, Excel Functions, Excel Charts, Excel Pivot Table.. (2016, 2019 & Excel 365)

What You'll Learn?

Basic to Advance Level Excel in the latest Office 365
Mastering the use of Text Functions
Mastering the use of Math Functions
Mastering the use of Logical Functions
Mastering the use of Lookup and Reference Functions
Mastering the use of Date and Time Functions
Mastering the use of Pivot Table and Power Pivot
Mastering the use of Chart Preparation
Mastering the use of What If Analysis Tools
Mastering the use of Data Organizing Tools
Learn to Record Macro Effectively

Who is this for?

MIS Job Aspirants

Anyone want to get expertise in Excel

What You Need to Know?

Basic Computer Knowledge

No previous knowledge is required

Great for students who want to learn at their own pace

More details

Description
Do you want to learn how to work like a pro with latest Excel even if you donâ€™t have any prior experience?
If so, then this is the right course for you!
A Certificate of completion is presented to all students who complete this course.
Microsoft Excel serves today as the one essential business tool you must understand and master to manage large quantities of data. However, itâ€™s essential that you learn how to work with it effectively.
But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?
Microsoft Excel 365 - Beginner to Advanced Level 2022 is here for you. One of the best Excel course online. This training includes everything youâ€™ll need. We will start from the very basics like data entry in Excel and then gradually build a solid foundation through this 11 hours 30 minutes course that will help you mastered Microsoft Excel.
Why you should take this course on Excel:*
Jobs. A solid understanding of Excel opens the door for a number of career paths in every field.
Promotions and Growth. Top Excel users are often promoted very easily inside large corporations
Secure Future. Excel skills remain with you and provide extra security. You wonâ€™t ever have to fear unemployment
What makes this course different from the rest of the Excel courses out there?
High quality of production â€“ HD video and high quality sound.
Knowledgeable instructor (More then 19000 Udemy students, More then 14 years of working experience in the Industry)
Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc., Check the Resource option for that)
Extensive practical examples that will help you reinforce everything that youâ€™ve learned
Excellent support: If you donâ€™t understand a concept or you simply want to drop us a line, youâ€™ll receive an answer promptly
Dynamic: The course doesn't waste your time! It maintains a very good pace throughout the whole course.
Coverage: The course covers almost everything in Excel.
Latest Version: Its in the latest Office 365 however you can work on any version of Excel after the course completion.
This training is highly recommended for university students, entry-level finance, business and marketing professionals who would like to grow faster than their peers.
Please donâ€™t forget that the course comes with Udemyâ€™s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?
Buy the course today and let's start this journey!**
Who this course is for:
MIS Job Aspirants
Anyone want to get expertise in Excel

User Reviews

Rating

average 0

Total votes0

Focused display

My Name is Himanshu Dhar. I am a MIS trainer associated with I Turn Institute. I am having more then 14 years of experience in different projects in Excel and Macros. I do take care of freelancing projects as well and brings that practical touch into teaching. I have successfully trained more then 25000 students from various backgrounds and have conducted many corporate training and seminars.

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.