Preloader

Microsoft Office Excel 2013 Expert course is planned for those candidates who have an established track of working with MS Excel and a desire to display their advanced knowledge. After completing this course, participants will become skillful with advanced functions, data analysis tools and formulas. Students will also be able to look up data with functions and execute advanced date and time functions.

ACROTECH ADVANCED EXCEL COURSE

DATA Analysis:

  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt
  • Functions:- LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
  • What-if-analysis, GOAL SEEK
  • PIVOT Tables, NESTED IF
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation
  • MACRO’S
  • ADVANCED Excel Contents

  • Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)
  • Nested functions , Name cells /ranges /constants
  • Relative, Absolute, Mixed cell references : >,<,= operators
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function , Date and time functions , Annotating formulas
  • Develop the Worksheet:

  • Plan a worksheet , Row and Column labels
  • Split worksheet /box /bar, Copy data and formulas
  • Display /move toolbars , Enhance worksheet Appearance
  • Special Operations:

  • Use multiple windows : Copy/ paste between Worksheets
  • Link worksheets , Consolidate worksheets
  • Import and link from other Applications
  • Use AutoFormat : Create, use and modify styles and templates
  • Print features : Create /edit an outline
  • Graphic Operations:

  • Create charts , Enhance charts, Drawing toolbar features
  • Macros:

  • Definition and use , Record a macro
  • Assign a macro , Run a macro
  • Store a macro, Introduction to VBA Prog.
  • Let’s Discuss