MS Word
October 9, 2018
MS PowerPoint
October 9, 2018
Show all

MS Excel

790.00 365.00

Category:
Description

Microsoft Excel Is Great Spread Sheet Based Software Which Is Used To Create Formulation Sheet And You Can Apply Formulas , Calculations Or Add Imortant Tools Like Graph , Charts And Many More. It Has A Lot Of Tools Which Are Really Great And Very Easy To Learn , So Buy Your Favourite Tutorial Dvd. You Can Learn Basic And Advance Feature With This Dvd.

 

Home Tab

S.No Particulars Time
1 Intro To Mircrosoft Excel 00.00.00
2 Excel Screen Parts 00.00.34
3 Let’s Start Home Tab 00.03.19
4 Selection In Microsoft Excel 00.03.34
5 Font Group In  Microsoft Excel 00.04.00
6 Alignment Group 00.07.57
7 Number Group 00.11.46
8 Styles 00.14.48
9 Table Tools ,Design Tab 00.19.54
10 Cell Styles 00.23.33
11 Cells Group 00.24.18
12 Editing Section 00.32.53
13 Formulas Introduction In Excel 00.34.17
14 Using Autosum 00.36.46
15 Using Insert Function 00.37.38
16 Avg , Min , Max , If Function 00.39.05
17 Fill Options In Excel 00.44.09
18 Fill Options With Dates , Number 00.47.00
19 Sort And Filter In Excel 00.49.00
20 Find And Select In Excel
 

Formulation Tab

S.No Particulars Time
1 Using Autosum 00.36.46
2 Using Insert Function 00.37.38
3 Avg , Min , Max , If Function 00.39.05
4 Basics Of Functions And Formulas 00.00.00
5 Use Of Insert Function 00.02.25
6 How To Type Formulas 00.04.35
7 Basics Of Formulas 00.07.38
8 Total On Status Bar 00.15.15
Financial Formulas 00.16.48
9 Rate Function (Using Loan Installments Example) 00.17.11
10 Pmt Function (Using Monthly Repayment Example) 00.19.44
11 Future Value Function (Using Deposit Amount Example) 00.23.30
12 Nper Function ( Using Loan Time Calculation Example) 00.25.42
13 Db Function (Depriciation Calculation Example) 00.27.54
Logical Formulas 00.32.12
14 Logical If (Using Result Example) 00.32.25
15 Logical And (Using Age Example) 00.34.48
16 Logical If & And (Using Age Example) 00.37.00
17 Logical Combined If & And (Using Age Example) 00.38.06
18 Logical Or (Using Test  Example) 00.39.06
19 Logical If & Or (Using Age Example) 00.41.23
20 Logical Combined If & Or (Using Age Example) 00.41.52
Text Formulas 00.42.49
21 Trim Formula(Remove Extra Spaces Example) 00.42.53
22 Left Formula(Using In Extract Left Characters) 00.43.37
23 Right Formula(Using In Extract Right Characters) 00.44.30
24 Replace Formula( Using Character Removing Example) 00.45.12
25 Mid Formula (With Character Extractor Example) 00.46.39
26 Concatenate Function( With Text Joining Example) 00.47.53
27 Upper Function ( Use To Uppercase Characters) 00.49.06
28 Upper And Concatenate 00.49.44
29 Find Function 00.50.28
30 Left And Find Function( Use To Seprate Names) 00.51.50
Date Formulas 00.52.38
31 How To Set Date Formats 00.53.00
32 Date Function 00.53.25
33 Days 360 (Using Library Record Example) 00.54.25
34 Now Function 00.55.38
35 Day Function 00.56.14
36 Month Function 00.56.44
37 Year Function 00.56.52
38 Hour Function 00.56.53
39 Minute Function 00.56.55
40 Networkdays (To Count Networking Days ) 00.57.10
Lookup Formulas 00.59.04
41 Vlookup Formula ( With Exact Match Example) 00.59.06
 

Data Tab

S.No Particulars Time
1 Get External Data Group 00.00.00
2 From Access 00.00.36
3 From Web 00.01.48
4 Connections Group 00.05.49
5 Sort And Filter-Sort Options 00.08.04
6 Sort And Filter-Filter Options 00.10.27
7 Advance Filter Options 00.12.02
 

Insert Tab

 

 

 

S.No Particulars Time
1 Pivot Tables And Its Options 00.00.00
2 Table And Its Options 00.15.33
3 Charts And Its Options 00.18.09
4 Sparklines And Its Options 00.25.20
5 Filter Slicer 00.27.00
6 Links 00.27.05
7 Text Options 00.27.39
8 Symbols Group 00.35.58
 

Pagelayout Tab

 
S.No Particulars Time
1 Themes Group 00.00.00
2 Page Setup Group Settings In Excel 00.01.50
3 Orientation 00.04.46
4 Scale To Fit 00.07.55
5 Sheet Options 00.10.55
6 Arrange 00.12.32
 

Review Tab

 
S.No Particulars Time
1 Proffing 00.00.10
2 Language 00.05.02
3 Comment 00.05.49
4 Changes Group With Password Protection 00.08.05
 

View Tab

 
S.No Particulars Time
1 Workbook Views 00.00.12
2 Show Group 00.03.41
3 Zoom Group 00.04.05
4 Window Group 00.05.11
5 Macros Group In Excel 00.13.30
 

File Tab

 
S.No Particulars Time
1 File Tab Options , Contains , New, Open ,Save And Basics 00.00.00
File Tab Commands 00.07.59

Have any query? Fill this form to Get a Callback

From where you came to know about us?
Call Now