EXCEL AND Advance Excel 

• • Introduction to excel

  • Excel worksheet and workbooks

  • Entering and editing worksheet data

  • Introducing formulas and function

  • Customizing common option in excel

  • Absolute and relative cells

  • Protecting and un-protecting worksheet and cells

  • Lookup

  • Vertical and horizontal lookup

  • Double v lookup with if error formula

  • V LOOKUP with exact match , approximate match

  • V lookup using tables, dynamic ranges

  • Using VLOOKUP to consolidate data from multiple sheets

  • Use if and lookup function together in excel

  • Using v lookup and if error

  • V lookup exact match with N/A error to fix

  • V lookup v/s index and match

  • Specifying a valid range of values for a cell

  • Specifying a valid values for a cell

  • Specifying custom validation based on formula for a cell

  • sorting tables

  • using advance filter option

  • using multiple –level sorting

  • pivot tables

  • pivot charts

  • creating pivot tables

  • formatting and customizing pivot tables

  • pivot table using subtotal

  • using advance option of pivot tables

  • show value as (%of row, % of column, % of running total, compare with specific field)

  • pivot using concatenate function

  • viewing subtotal under pivot

  • creating slicers

  • pivot table using index

  • consolidating data from multiple sheets and files using pivot tables 

  • date and time functions

  • text function

  • database functions

  • power functions(count if, count ifs, sum if, sum ifs) 

  • Goal seek

  • Data tables

  • Scenario manager

  • Using charts

  • Using 3d graphs

  • Using bar and line chart together

  • Emi calculation

  • Present value and future value calculation

  • Loan calculation

  • Bank pass book

  • Attendance with salary sheet

  • Salary increase sheet

  • Pay slip

  • Gst calculation

  • Calculated sales

  • Human age calculation

  • function (length ,right , left, concatenate, trim, upper, lower, mid, find ,rept, char)

  • Count function(counta ,countblank ,count)