Free · ADVANCE EXCEL COURSE

Published date: December 19, 2018 10:42 am

Location: Main Najafgarh Road, Janakpuri A1/17, Top Floor, Opposite Metro Pillar No: 636, New Delhi- 110058, delhi, india

FORMATTING
•FREEZE TITLES
•CONDITIONAL FORMATTING
•AUTOFORMAT
 PROTECTION
•PROTECTION
•WORKSHEET AND CELL PROTECTION
•HIDING ROWS AND COLUMNS
•WORKBOOK PROTECTION
•HIDING WORKSHEETS & WORKBOOKS
CELL COMMENTS
•CELL COMMENTS
•DISPLAY COMMENTS
•CREATE, EDIT & DELETE COMMENTS  NAMES
•NAMES
•USING NAMES IN FORMULAS
•USING TO WITH NAMES
 TEMPLATES
•CREATING A TEMPLATE
•USING A TEMPLATE
•EDITING A TEMPLATE
•DELETING A TEMPLATE
FORMULAS
•DISPLAY FORMULAS
•FORMULAS THAT PRODUCE ERRORS
•CUSTOM NUMBER FORMATS
SCENARIOS
•CREATING SCENARIOS
•USING AND EDITING SCENARIOS
•SCENARIO SUMMARY REPORT LINKING
•LINKING
•CREATING LINKS
•LINKING BETWEEN WORKBOOKS
•LINKING TO A WORD DOCUMENT
 SORTING
•SORTING
•MULTIPLE COLUMN SORTS
•CUSTOM SORTS
LISTS
•LISTS
•CREATING A LIST
•FILTERING LISTS
•AUTOFILTER
•CUSTOM AUTOFILTER
•ADVANCED FILTERING
•EXTRACTING FILTERED DATA
•ADDING SUBTOTALS LINKING
•LINKING
•CREATING LINKS
•LINKING BETWEEN WORKBOOKS
•LINKING TO A WORD DOCUMENT
 SORTING
•SORTING
•MULTIPLE COLUMN SORTS
•CUSTOM SORTS
LISTS
•LISTS
•CREATING A LIST
•FILTERING LISTS
•AUTOFILTER
•CUSTOM AUTOFILTER
•ADVANCED FILTERING
•EXTRACTING FILTERED DATA
•ADDING SUBTOTALS

Contact seller Share