MicroSoft Excel
Part-I


  • Introduction of Excel
  • Areas of Usage
  • Entering Data in Cell
  • Editing a Data
  • Format Data Using Font
  • Alignment
  • Number
  • Working with Worksheet
  • Simple Math Calculations
  • Saving a Workbook
  • Working with Rows/Column
  • Predefined Table Styles
  • Cell Styles
  • Cell References
  • Conditional Formatting
  • Filling Series
  • Custom List
  • Clear
  • Find, Replace & Go to
  • Sorting
  • Filter/Advance Filter
  • Illustration
  • Charts
  • Hyper-link
  • Text Box
  • Header & Footer
  • Word Art
  • Symbol
  • Formula Round
  • SQRT
  • Range
  • COMMENT
  • Date
  • Weekday
  • Date Value
  • Upper
  • Lower
  • Proper
  • If Statement
  • And / Or
  • Not
Knowledge of MicroSoft Word in muktsar

Part-II


  • Sumif()
  • Countif()
  • CountBlank
  • Convert
  • VLookUp
  • HLookUp
  • Pivot Table
  • Macro
  • Data-Validation
  • Splitting Worksheet
  • Freeze Panes
  • Workbook Protection
  • Page Setup Setting
  • PMT
  • PPMT
  • IPMT
  • FV, PV, NPER, RATE
  • M ROUND
  • GOAL SEEK
  • DATA TABLE
  • SCENARIO MANAGER
  • SOLVER
  • DMIN
  • DMAX
  • DAVERAGE
  • DCOUNT
  • DCOUNTA
  • DGET
  • CONSOLIDATE
  • AUDITING
  • DATA FORM
  • ISBLANK
  • IFERROR
  • CUSTOM EXCEL
  • IMPORTING DATA
  • IMPORTING DATA
    FROM TALLY
Web Development in muktsar
M. 86991-18177
Welcome to you !