Microsoft Excel 365 Training- Basic to Advance Level

Focused View

Himanshu Dhar

6:42:08

299 View

01 Introduction.mp4

01:35

02 Create New File and Title Bar Understanding.mp4

09:08

03 Customize Ribbons and Quick Access Toolbar.mp4

08:16

04 Excel Structure and Worksheets.mp4

10:47

05 Data Entry and Formatting.mp4

14:16

06 Fill Series in Excel.mp4

11:22

07 Cell Reference in Excel.mp4

05:57

08 Math Operators in Excel.mp4

15:51

09 Math Function in Excel.mp4

17:17

10 Advance Math Function in Excel.mp4

17:10

11 Database Math Function.mp4

07:56

12 IF Function in Excel.mp4

07:38

13 Nested IF in Excel.mp4

04:44

14 If Function Task Solution.mp4

08:42

15 AND and OR Function.mp4

06:07

16 IF Function Project.mp4

01:07

17 IF Function Project Solution.mp4

04:44

18 Upper, Lower, Proper and Trim Function.mp4

08:28

19 Left, Right and Find Function.mp4

07:18

20 Find Related Project Solution.mp4

06:21

21 Left, Right and Find Function Nesting.mp4

03:53

22 MID Function.mp4

04:17

23 Concatenate Function.mp4

04:25

24 Concatenate Function Project Solution.mp4

02:40

25 Replace Function.mp4

07:15

26 Replace Function Project Solution.mp4

01:55

27 Substitute Function.mp4

04:30

28 Rept, Len Function and Project.mp4

02:23

29 Project Solution - Substitute and Len Nesting.mp4

02:35

30 Text to Column Option.mp4

14:28

31 Protect Workbook in Excel.mp4

04:47

32 Protect Sheet.mp4

08:59

33 Hide Formula and Unlocked Cell.mp4

05:11

34 Protect Excel File with Password.mp4

02:47

35 Print Options in Excel part 1.mp4

10:25

36 Print Options in Excel part 2.mp4

08:44

37 Vlookup Function.mp4

13:53

38 Iferror Function with Vlookup.mp4

08:04

39 Array Vlookup Function.mp4

06:05

40 Hlookup Function in Excel.mp4

04:13

41 Match and Index Function.mp4

04:47

42 Match and Index Nesting.mp4

04:25

43 Vlookup TRUE.mp4

04:44

44 Lookup and Reference Function Trick.mp4

09:56

45 Xlookup Function.mp4

28:00

46 Conditional Formatting - How to Apply.mp4

06:11

47 Types of Rules in Conditional Formatting.mp4

11:56

48 Manage Rules in Conditional Formatting.mp4

04:51

49 Goal Seek in Excel.mp4

05:44

50 Scenario Manager in Excel.mp4

07:23

51 PMT Function - EMI Calculator.mp4

06:13

52 Data Table in Excel.mp4

11:45

Compare Data.xlsx.xlsx

Function Data.xlsx.xlsx

Real Data.xlsx.xlsx

Real Data - Copy.xlsx.xlsx

sum if.xlsx.xlsx

Description

Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications. The course curriculum is one of the most comprehensive and most advanced. Here you will trained from the very basic till the most advance level in the latest version.

You may expect to learn following topics in detail.

Learn about the structure of Excel
Learn how to adjust the way data and information are displayed in Excel
Learn how to apply function with function facts
Learn how to create powerful calculations with Excel functions
Learn how to use passwords in Excel to protect your work in multiple scenarios
Learn how to use printing and sharing in Excel
Learn to use Pivot table with slicers, Grouping and various tricks
Learn how to organize your data based on Condition.
Mastering all important Text function with nested methodology
Mastering Logical and Lookup and reference Function.
Mastering Operators use and Math Functions.
Working on latest XLOOKUP Function

What You'll Learn?

Business
Pivot Tables
Productivity
Microsoft Excel
Ms Excel
Slicer
Data Entry

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Microsoft Office 365

Himanshu Dhar

Instructor's Courses

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.

SkillShare

View courses SkillShare

Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.