MS Excel Advanced Course

About Course

माइक्रोसॉफ्ट एक्‍सल को MS Excel नाम से भी जाना जाता है यह Microsoft Office Suite के साथ आने वाला Spread Sheet Program है Ms Excel में Data को Tabular Format में Open, Create, Edit, Format, Calculate किया जाता है इस कोर्स में हम जानने वाले हैं कि Ms Excel क्‍या है और इसे कैसे उपयोग करते हैं केसे आप Ms Excel में विभिन्‍न फार्मूला लगाकर Report तैयार कर सकते हैं इसके साथ ही हम जानेंगे Ms Excel Use करने में किन Keyboard Shortcut Key का इस्‍तेमाल किया जाता है शुरू से लेकर आखिर तक यह कोर्स आपको एक जबरदस्त अनुभव प्रदान करेगा इस कोर्स को करने के बाद आपका एक्सेल के साथ एक जबरदस्त रिश्ता जुड़ जाएगा

अगर आपको Microsoft Excel चलाना आता है तो आप ऑफिस के कई घण्‍टों का काम मिनटों में कर सकते हैं Microsoft excel के अन्‍दर ढेर सारे Formulae दिये गये होते हैं जिसे किसी भी Spreadsheet पर Apply करने पर बडी जटिल Calculation भी मिनटों में Automatic तरीके से की जा सकती है इन Formulas को आप अगर एक बार Sheet में Save कर लेते हैं तो हर महीने Repeat होने वाले कामों को आप चुटकियों में तैयार कर सकते हैं Microsoft excel में बडी आसानी से Salary chart, Office employee, Database management, Billing Software, stock management Software तैयार किये जा सकते हैं

Create Your Own Custom List
How Make Password your Excel File
How To Create a Backup Excel File
Use Sum Formula
Use Skip Blanks
Subtract
Multiple
Divide
Percentage
Use of Number Format in Excel
Use Conditional Formatting
Sort & Filter Data
Find and Replace and Using GoTo
Use Status Bar
Freeze Panes Option
Split Window
Fill Option
Flesh Fill
Pivot Table
Pictures Option
Use Shape
Use 3D Modal
Smart Art
Advanced Charts & Graph
People Graph
Create Hyperlinks
Header and Footer
Write Equation
Complete Page Setup
Scale to Fit Setup
IF Formula
Change Case Formula
Round Figure Formula
VLOOKUP Formula
HLOOKUP Formula
And Formula
Convert Number into Word Formula
Use Macros
Subtotal Formula
Data Consolidate Formula
Date If Formula
E-Date Formula
Eo-Month Formula
Percent Formula
Superscript Formula
Subscript Formula
Group Ungroup
Subtotal Formula
Goal Seek Formula
PMT Formula
Goal With PMT Formula
Concat Formula
INDIRECT Formula
Match Formula
Count Formula
Counta Formula
Countblank Formula
EXACT Formula
Sumif Formula
Sumifs Formula
Round Formula
RoundUp Formula
RoundDown Formula
MRound Formula
Array Formula
LEFT Formula
RIGHT Formula
MID Formula
LEN Formula
FIND Formula
Mod Formula
Quotient Formula
Replace Formula
SUBSTITUTE Formula
Formula Error Types
SUMPRODUCT Formula
Text Formula
Double VLOOKUP Formula
Simple Interest Formula
Compound Interest Formula
Ceiling Formula
Floor Formula
Index Formula
INDEX + MATCH Formula
Forecast Formula
Value Formula
Mail Merge
Dynamic Dropdown List
Dynamic Unit Converter
Daily Stock Register
Employees Payroll and Salary Slip

Course Content

Chapter 01 – Microsoft Excel Basic Knowledge

1- Microsoft Excel Introduction

10:56
2 – How to Work in Excel And Use Basic Formulas

11:10
3- Use Clipboard Like Pro Full Explain

11:57
4 – Organize Row Column And Worksheet

08:47
5 – Data Entry Like Pro

05:45
6 – Create Your Own Custom List

06:31

Chapter 02 – Password Protection & Backup

Chapter 03 – Basic Formula & Data Entry

Chapter 04 – Excel Home Tab Tutorial

12 – Use of Number Format in Excel

11:14
13 – Use Conditional Formatting

13:37
14 – How to Sort & Filter Data

08:37
15 – Using Find and Replace and Using GoTo

07:20
16 – How to Use Status Bar

07:27
17 – Freeze Panes Option

04:42
18 – Split Window

04:41
19 – Fill Option

10:51
20 – Flesh Fill

08:10

Chapter 05 – Excel INSERT Tab Tutorial

21 – Pivot Table

11:40
22 – All Table Option

11:23
23 – Pictures Option

11:36
24 – Use Shape

12:23
25 – Use 3D Modal

06:04
26 – Smart Art

08:28
27 – Advanced Charts & Graph

06:29
28 – People Graph

03:18
29 – Create Hyperlinks

07:45
30 – Header and Footer

07:30
31 – Write, Insert, or Change an Equation

04:27

Chapter 06 – Excel Draw Tab Tutorial

Chapter 07 – Excel Page Layout Tab Tutorial

Chapter 08 – Excel Advanced Formulas Part 1

36 – IF Formula

05:20
37 – IF Formula With Multiple Conditions

06:37
38 – Change Case and Round Figure Formula

05:07
39 – VLOOKUP Formula

06:49
40 – VLOOKUP Formula Examples

16:30
41- HLOOKUP Formula
42 – And Formula

04:12
43 – Convert Number into Word Formula

04:37
44 – Use Macros with Example

04:37
45 – Subtotal Formula

05:15
46 – Link Data in Excel Spreadsheets Formula

04:37
47 – Data Consolidate Formula

02:39
48 – Calculate Age With Date, Date If Formula

05:39
49 – E-Date and Eo-Month Formula

03:39
50 – Calculating Percent Formula

03:13
51 – Superscript and Subscript Formula

02:08

Chapter 09 – Excel Advanced Formulas Part 2

52 – Group Ungroup Subtotal Formula

03:49
53 – Goal Seek Formula

02:38
54 – PMT Formula

03:03
55 – Goal With PMT Formula

01:24
56 – Concat Formula

06:24
57 – INDIRECT Formula

03:26
58 – Match Formula

04:34
59 – Count, Counta, Countblank Formula

02:38
60 – EXACT Formula

02:42
61 – Sumif Formula

03:08
62 – Sumifs Formula

07:25

Chapter 10 – Excel Advanced Formulas Part 3

63 – Round, RoundUp, RoundDown, MRound Formula

06:59
64 – Array Formula

05:28
65 – LEFT, RIGHT, MID, LEN & FIND Formula

06:10
66 – Split Name Using LEFT, RIGHT, MID, LEN Formula

04:06
67 – Mod Formula

04:03
68 – Quotient Formula

03:14
69 – Replace Formula

03:43
70 – SUBSTITUTE Formula

04:45
71- Excel Formula Error Types

06:32
72 – SUMPRODUCT Formula

04:38

Chapter 11 – Excel Advanced Formulas Part 4

73 – Text Formula

03:29
74 – Double VLOOKUP Formula

05:50
75 – Simple Interest Formula

02:47
76 – Compound Interest Formula

05:17
77 – Ceiling And Floor Formula

03:53
78 – Index Formula

02:13
79 – INDEX + MATCH Formula

04:00
80 – Forecast Formula

03:26
81 – Value Formula

03:59

Chapter 12 – Practical

82 – Most Important Keyboard Shortcut

10:42
83 – Employees Payroll and Salary Slip

13:00
84 – Daily Stock Register

08:39
85 – Dynamic Unit Converter

06:00
86 – Dynamic Dropdown List

08:52
87 – School Marksheet With Grade

07:39
88 – Make Checklist & To Do List

05:11
89 – Make Attendance Sheet

07:19
90 – Student Database With Mail Merge

32:56

PCskill

About Course

What Will You Learn?

Course Content

Chapter 01 – Microsoft Excel Basic Knowledge

1- Microsoft Excel Introduction

2 – How to Work in Excel And Use Basic Formulas

3- Use Clipboard Like Pro Full Explain

4 – Organize Row Column And Worksheet

5 – Data Entry Like Pro

6 – Create Your Own Custom List

Chapter 02 – Password Protection & Backup

07 – How Make Password your Excel File

08 – How To Create a Backup Excel File

Chapter 03 – Basic Formula & Data Entry

09 – How to Use Sum Formula

10 – How to Use Skip Blanks

11 – Subtract, Multiple, Divide And Percentage

Chapter 04 – Excel Home Tab Tutorial

12 – Use of Number Format in Excel

13 – Use Conditional Formatting

14 – How to Sort & Filter Data

15 – Using Find and Replace and Using GoTo

16 – How to Use Status Bar

17 – Freeze Panes Option

18 – Split Window

19 – Fill Option

20 – Flesh Fill

Chapter 05 – Excel INSERT Tab Tutorial

21 – Pivot Table

22 – All Table Option

23 – Pictures Option

24 – Use Shape

25 – Use 3D Modal

26 – Smart Art

27 – Advanced Charts & Graph

28 – People Graph

29 – Create Hyperlinks

30 – Header and Footer

31 – Write, Insert, or Change an Equation

Chapter 06 – Excel Draw Tab Tutorial

32 – Using the Draw Tab

Chapter 07 – Excel Page Layout Tab Tutorial

33 – How to Use Themes

34 – Complete Page Setup

35 – Scale to Fit Setup

Chapter 08 – Excel Advanced Formulas Part 1

36 – IF Formula

37 – IF Formula With Multiple Conditions

38 – Change Case and Round Figure Formula

39 – VLOOKUP Formula

40 – VLOOKUP Formula Examples

41- HLOOKUP Formula

42 – And Formula

43 – Convert Number into Word Formula

44 – Use Macros with Example

45 – Subtotal Formula

46 – Link Data in Excel Spreadsheets Formula

47 – Data Consolidate Formula

48 – Calculate Age With Date, Date If Formula

49 – E-Date and Eo-Month Formula

50 – Calculating Percent Formula

51 – Superscript and Subscript Formula

Chapter 09 – Excel Advanced Formulas Part 2

52 – Group Ungroup Subtotal Formula

53 – Goal Seek Formula

54 – PMT Formula

55 – Goal With PMT Formula

56 – Concat Formula

57 – INDIRECT Formula

58 – Match Formula

59 – Count, Counta, Countblank Formula

60 – EXACT Formula

61 – Sumif Formula

62 – Sumifs Formula

Chapter 10 – Excel Advanced Formulas Part 3

63 – Round, RoundUp, RoundDown, MRound Formula

64 – Array Formula

65 – LEFT, RIGHT, MID, LEN & FIND Formula

66 – Split Name Using LEFT, RIGHT, MID, LEN Formula