Advance Excel Course institute in Delhi, Advance DTP Course institute in janakpuri

1
BALUJA INSTITUTE OF TECHNOLOGY
MANAGEMENT
ADVANCE EXCEL COURSE
www.balujalabs.com
2
BALUJA INSTITUTE OF TECHNOLOGY
MANAGEMENT
ADVANCE EXCEL COURSE

• PROTECTION
• PROTECTION
• WORKSHEET AND CELL PROTECTION
• HIDING ROWS AND COLUMNS
• WORKBOOK PROTECTION
• HIDING WORKSHEETS WORKBOOKS

• FORMATTING
• FREEZE TITLES
• CONDITIONAL FORMATTING
• AUTOFORMAT

• CELL COMMENTS
• CELL COMMENTS
• DISPLAY COMMENTS
• CREATE, EDIT DELETE COMMENTS

www.balujalabs.com
3
BALUJA INSTITUTE OF TECHNOLOGY
MANAGEMENT
ADVANCE EXCEL COURSE

• TEMPLATES
• CREATING A TEMPLATE
• USING A TEMPLATE
• EDITING A TEMPLATE
• DELETING A TEMPLATE

• NAMES
• NAMES
• USING NAMES IN FORMULAS
• USING TO WITH NAMES

• FORMULAS
• DISPLAY FORMULAS
• FORMULAS THAT PRODUCE ERRORS
• CUSTOM NUMBER FORMATS

• SCENARIOS
• CREATING SCENARIOS
• USING AND EDITING SCENARIOS
• SCENARIO SUMMARY REPORT

www.balujalabs.com
4
BALUJA INSTITUTE OF TECHNOLOGY
MANAGEMENT
ADVANCE EXCEL COURSE

• LINKING
• LINKING
• CREATING LINKS
• LINKING BETWEEN WORKBOOKS
• LINKING TO A WORD DOCUMENT

• LISTS
• LISTS
• CREATING A LIST
• FILTERING LISTS
• AUTOFILTER
• CUSTOM AUTOFILTER
• ADVANCED FILTERING
• EXTRACTING FILTERED DATA
• ADDING SUBTOTALS

• SORTING
• SORTING
• MULTIPLE COLUMN SORTS
• CUSTOM SORTS

www.balujalabs.com
5
BALUJA INSTITUTE OF TECHNOLOGY
MANAGEMENT
ADVANCE EXCEL COURSE

• A.E SECTION 12 FUNCTIONS
• FUNCTIONS
• LOGICAL FUNCTIONS
• DATE AND TIME FUNCTIONS
• LOOKUP FUNCTIONS
• MATHS AND STATISTICAL FUNCTIONS
• TEXT FUNCTIONS
• FINANCIAL FUNCTIONS
• DATABASE FUNCTIONS
• NESTED FUNCTIONS

• PIVOT TABLES
• PIVOT TABLES
• GROUPING DATA IN PIVOT TABLES

• CHARTS
• FORMATTING CHARTS
• MODIFYING CHARTS
• INSERT IMAGE IN 2D CHART

www.balujalabs.com
6
BALUJA INSTITUTE OF TECHNOLOGY
MANAGEMENT
ADVANCE EXCEL COURSE

• DATA TABLES
• ONE INPUT DATA TABLE
• TWO INPUT DATA TABLE

• MACROS
• MACROS
• RECORDING MACRO
• RUNNING A MACRO
• ASSIGNING A MACRO TO A TOOLBAR BUTTON

• AUDITING
• AUDITING
• TRACE PRECEDENTS
• TRACE DEPENDENTS

www.balujalabs.com
7
BALUJA INSTITUTE OF TECHNOLOGY
MANAGEMENT
Contact Us

• Main Najafgarh Road, Janakpuri
• A1/17, Top Floor, Opposite Metro Pillar no 636,
• New Delhi- 110058 

Email Id  - contactus_at_balujalabs.com
Contact no. 91-9015596280,
91-9313565406, 011-65495934
www.balujalabs.com