Advance Excel

1.Lets Upgrade Advance Skills

• Type Of Function 
• Find, Concatenate , Length , Abs ,Round ,Roundup , Rounddown,
• Power ,Exact ,Left, Right, Trim, Find , Substitute , ABS , Text 

2.Audit & Management Of Data

• Trace Precedent , Trace Dependent ,
• Remove Arrow , Error Checking , 
• Text to Column , Flash Fill, 
• Data Validation , Remove Duplicate , 
• Consolidate

3.Salary Sheet

• Definition
• Salary sheet Calculation
• Pay slip

4.Dashboard

• Pivot Table
• Pivot Chart
• Slicer
• Timeline 
• Value Function
• Convert Function 

5.Loan Installment Sheet 

• Financial Function 
• PMT, NPER, PV , FV, RATE

6.Garbage Clearing

• If function in Loan Sheet 
• Age Calculation

7.Working With Function

• Double Vlookup Function 
• Vlookup With Match
• Vlookup With Hlookup

8.Xfunction

• If with Vlookup & Hlookup 
• IF with Not
• Xlookukp Function
• XOR

9.Special Tools In Excel 

• Name Manager 
• Conditional Formatting 
• Calendar
• Checkbox

10.Attendance Sheet

• If Error Function
• Eomonth Function

11.Trick & Techniques

• Basic Tricks
• Subtotal With Filter