Advance Excel Course institute in Delhi, Advance DTP Course institute in janakpuri - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

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

Description:

Advance Excel courses, Advance Excel courses institute in delhi, Advance Excel course institute, Advance Excel courses, Advance Excel courses institute in delhi, course institute – PowerPoint PPT presentation

Number of Views:73

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: 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
About PowerShow.com