Excel 2016 Advance Course

Introduction of Excel 2016 9 lectures 01:10:23 Introduction Excel file types Selection and move User Interface Alignment Cut copy paste Formatting Form design basic Form design advance Introduction of Excel 2016 9 lectures 01:10:23 Introduction Excel file types Selection and move User Interface Alignment Cut copy paste Formatting Form design basic Form design advance Introduction Introduction Introduction Introduction Excel file types Excel file types Excel file types Excel file types Selection and move Selection and move Selection and move Selection and move User Interface User Interface User Interface User Interface Alignment Alignment Alignment Alignment Cut copy paste Cut copy paste Cut copy paste Cut copy paste Formatting Formatting Formatting Formatting Form design basic Form design basic Form design basic Form design basic Form design advance Form design advance Form design advance Form design advance Chapter 2: Data Types 12 lectures 01:23:49 Data types Page setup print Autofill List Minitoolbar Right click long toolbar Table Format Cell Style Insert Delete Rows and Column Format Cell Hide Unhide Rows Column Move Worksheet Find Find and Replace View Tab Freeze unfreeze split arrange Page setup print 1 Chapter 2: Data Types 12 lectures 01:23:49 Data types Page setup print Autofill List Minitoolbar Right click long toolbar Table Format Cell Style Insert Delete Rows and Column Format Cell Hide Unhide Rows Column Move Worksheet Find Find and Replace View Tab Freeze unfreeze split arrange Page setup print 1 Data types Data types Data types Data types Page setup print Page setup print Page setup print Page setup print Autofill List Autofill List Autofill List Autofill List Minitoolbar Right click long toolbar Minitoolbar Right click long toolbar Minitoolbar Right click long toolbar Minitoolbar Right click long toolbar Table Format Cell Style Table Format Cell Style Table Format Cell Style Table Format Cell Style Insert Delete Rows and Column Insert Delete Rows and Column Insert Delete Rows and Column Insert Delete Rows and Column Format Cell Hide Unhide Rows Column Format Cell Hide Unhide Rows Column Format Cell Hide Unhide Rows Column Format Cell Hide Unhide Rows Column Move Worksheet Move Worksheet Move Worksheet Move Worksheet Find Find Find Find Find and Replace Find and Replace Find and Replace Find and Replace View Tab Freeze unfreeze split arrange View Tab Freeze unfreeze split arrange View Tab Freeze unfreeze split arrange View Tab Freeze unfreeze split arrange Page setup print 1 Page setup print 1 Page setup print 1 Page setup print 1 Chapter 3: Formula 8 lectures 32:59 Formula Introduction Give cell reference for formula How to use inbuilt functions -sum Cell Reference Error in formula Circular Reference Goal Seek Value Paste Chapter 3: Formula /p Padding number Padding number Change case Change case Change case Change case Extract character from string Extract character from string Extract character from string Extract character from string Remove trailing minus sign Remove trailing minus sign Remove trailing minus sign Remove trailing minus sign Ordinal number Ordinal number Ordinal number Ordinal number Extracting first word Extracting first word Extracting first word Extracting first word Extract except first word Extract except first word Extract except first word Extract except first word Chapter 6: Date 8 lectures 35:47 Date Display Date Autofill Covert text to date ...