### Course Description

We have designed this course to everybody’s real life work situations. This course will start with general understandings of Excel 2010 and finish with the depth knowledge of each formulas which used in our daily life.

You will get all excel files used to create this course in which we have explained the syntax of formulasalso include real life problems. We have also included advance use of each formula such as Vlookup formula used if iferror formula.

Advance use of Tables, Macros, Pivot Tables, Filtering etc.

You will get VBA code and method for converting numbers in to words in Excel 2010. This formula is not included in excel formulas but we explained all the procedures to do this task.

you will get more than your expectation that we can bet.

### What are the requirements?

• You need basic level of understanding of computers. That’s all you need to know before start our course

### What am I going to get from this course?

• You will be able to do complex calculations / Formats / Data Analysis including all things which you are not able right now. This course start from basic level but at the end you will be expert in the Excel

### What is the target audience?

• Whether you are fresher or working person and want to improve your skills in the excel to develop yourself. This course is for you. We included real time situation and calculation problems in the examples for easy learning

### Course Curriculum

 Introduction of Excel 2010 Introduction of Excel 2010 FREE 00:04:10 Excel 2010 practice files 00:00:00 Move Action 00:12:21 Data Autofil in Cell FREE 00:17:16 Numbers Customs Format 00:08:50 Text Formula in Excel Cell Contain Text 00:02:13 Special Symbols FREE 00:01:50 String Identical 00:01:47 Join Text 00:02:49 Format Text Values 00:03:05 Remove Space 00:01:50 Count Charactors 00:01:22 Padding A Number 00:04:11 Change Case 00:01:41 Extract Charctor 00:05:31 Remove Trailing Minus sign 00:02:45 Ordinal Numbering 00:08:05 First word Extract 00:02:51 Extract String Except First Word 00:03:26 Date Related Formula Introduction of Dates in Excel 00:07:58 Date Autofil Tips and Formulas 00:06:14 Convert Non Date String to Date 00:02:57 Calculate Number of Days between two dates 00:02:17 Calculate Number of Working Days between two dates FREE 00:03:34 Date Formulas 00:03:01 Date Value Formula 00:06:20 Network Days Formula 00:02:57 Working Days between Two Dates – Advance Verision 00:06:26 Offsetting a Date using only work Days 00:03:51 Number of years between two dates 00:02:55 Calculate Age of any person 00:02:17 Calculate Days Remain in a year 00:02:26 Weekday Determination 00:02:07 Calculate last Day of the month 00:01:34 Time Related Formulas in Excel 2010 Display Time 00:05:26 How to Sum of Hours 00:02:26 Number of Hours FREE 00:02:17 Converting Decimal Hours, Minutes, Seconds into Time 00:03:14 Rounding of Time Values 00:02:42 Count Formulas in Excel 2010 Basic of Count formulas 00:06:07 Formula countif 00:03:37 Mode 00:03:23 Countif Text 00:02:37 Examples of Count 00:04:25 Sumif Formulas in Excel Fomula – Sum 00:06:35 Fomula – Sumif 00:11:22 Fomula – SumIfs 00:08:03 Lookup Formulas in Excel Vlookup 00:06:16 Hlookup 00:02:39 Advance – Vlookup 00:03:07 Use of Vlookup with If 00:03:56 Use of Vlookup with Iferror Function 00:03:24 Vlookup Exmaple – 1 00:03:06 Vlookup Exmaple – 2 00:07:39 Vlookup Exmaple – 3 00:06:05 Table in Excel 2010 Introduction – Table 00:21:32 Fill in the Gaps 00:04:32 Advance Filter 00:09:01 Database Function 00:07:33 SubTotal 00:04:57 Financial Formulas in Excel 2010 Present Value of Money 00:08:10 Present Value of Lum sum Money 00:02:19 Annuity with Lum Sum 00:03:41 Future Value of Money 00:09:08 PMT Function 00:09:35 Rate 00:13:14 NPER 00:09:39 Defferred Payment 00:05:23 Price Bond 00:06:30 NPV Part-1 00:07:21 NPV Part-2 00:06:14 NPV – Advance Version 00:04:55 Internal Rate of Return 00:04:07 Depriciation 00:09:42 Logical Formulas in Excel 2010 Logical Formula 00:11:58 Macros in Excel 2010 Macro Part-1 00:12:45 Macro Part-2 00:05:04 Security Feature in Excel 2010 Security Part-1 00:04:13 Security Part-2 00:03:56 Pivot Tables in Excel 2010 Pivot Table Part-1 00:09:27 Pivot Table Part-2 00:01:37 Pivot Table Part-3 00:02:49 Pivot Table Part-4 00:03:24 Data Validation in Excel 2010 Data Validation Feature 00:08:20 List Feature 00:02:59 Page Setup in Excel 2010 Page Setup Header Footer 00:06:49 Page Setup 00:10:22 Advance use of Excel 2010 00:00 00:00 00:00

## 5

5
1 ratings
• 5 stars1
• 4 stars0
• 3 stars0
• 2 stars0
• 1 stars0
1. ### Good

5

Really good course.

• 1,500.00 499.00
• UNLIMITED ACCESS
• Course Certificate
• Wishlist
34 STUDENTS ENROLLED

• #### Learn Tally ERP 9 with GST video training complete course

Learn Tally ERP 9 Accounting Software from basic to advance level with real...

• #### Learn GST Goods and Services Tax online Free

Learn GST Goods and Services Tax online free. In this course, We have explained...

• #### Learn Income Tax Return efiling online

As per section 139(1) of the Income Tax Act, 1961 in the country, individuals...

All right reserved VeerTutorial