Learn Complete MS Excel

I have picked out the Essential Excel skillsets needed by Data Analyst and packaged them in a structured course.

In fact, I collected the most common Excel problems faced by my clients. I added in my 10+ years' experience in finance and project management. I included all the important tips and tricks that I came to learn as an Excel course. I also made sure it covers the absolute Excel beginners.

These practical, real-world examples help you understand the full potential of each feature. You'll learn how to use Excel for quick and painless data analysis.

There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.

*** This is not a Microsoft Application. This is just an Excel Course

Topics are:

1 Excel structure

2 Cell properties

3 autofill val and text

4 autofill date

5 Autofill Adv tools

6 cell reference

7 Operators based Equation

8 Math Function

9 Text Function - Upper, Lower, Proper, Trim

10 Text Function - Right, Left

11 Text Function - Find and task

12 Text Function - Solution and Nested Left

13 Text Function - Find and Left Nesting

14 Text Function - MID

15 Text Function - Mid task and solution

16 Text Function - Concatenate

17 Text Function - Concatenate task and solution

18 Text Function - Replace

19 Text Function - Replace task and Solution

20 Text Function - Substitute

21 Text Function - Len, Rept, Exact, Search

22 text to column

23 workbook protect

24 protect sheet

25 Hide Formulas and unlocked Cell

26 Protect File with password

27 If Function - Logical Test

28 If Function - with Equation and task

29 If Function - Nested If

30 If Function - advance

31 If Function - adv 2

32 AND , OR Function

33 AND, OR, IF Nested

34 AND, OR Advance

35 Pivot Table - Intro

36 Pivot Table - Manage Field Area

37 Pivot Table - Value Field, Report and more

38 Pivot Table - Slicer and Dublicate Pivot

39 Pivot Table - Group to mange date and values

40 Pivot Table - Insert Calculated Field

41 goal seek

42 scenario manager

43 pmt function - EMI calculator

44 Data table - Create Loan Table

46 Print option in Excel - Part 1

47 Print option in Excel - Part 2

48 share book

49 Chart Preperation

50 Chart Preperation - Advance

51 Chart Preperation - Customize

52 Conditional Formatting

53 Conditional Formatting - Types of Rules

54 Conditional Formatting - Mange Rules

55 Conditional Formatting - New Rules 1

56 Conditional Formatting - New Rules 2

57 Data Validation

58 Data Validation - Input message and Error Alert

59 Advance Math Function

60 Advance Math Function 2

61 Using of Wild Card in Math Function

62 Vlookup Function

63 Vlookup with Iferror

64 Hlookup

65 Vlookup array

76 Macro Recording part 1

77 Macro Recording part 2

*** This is not an MS Excel Application, this is just a training app