Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel 2013, Advanced Excel is designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data.
Course objectives:
ADVANCED MS – EXCEL 2007/2010/2013
- INTRODUCTION TO MS- EXCEL
- USES OF EXCEL
- BASICS OF EXCEL SHEET
- VIEWS OF EXCEL SHEET
- SPREED SHEET
- WORKSHEET CALCULATION
MENU TABS:
- OFFICE BOTTON/FILE
- HOME
- INSERT
- PAGE LAYOUT
- FORMULAS
- DATA
- REVIEW
- VIEW
- PICTURE TOOLS
- DRAWINGS TOOLS
- DESINGINGTOOL
FUNCTIONS IN EXCEL:
- GENERAL FUNCTIONS.
- SUM FUNCTIONS.
- LOGICAL FUNCTIONS.
- MATHEMATICAL FUNCTIONS.
- STATISTICAL FUNCTIONS.
- TEXT FUNCTIONS.
- DATE &TIME FUNCTIONS.
- DATEDIF FUNCTIONS.
- STRING MANIPUCATIONS
- LOOKUPS
- V LOOKUP
- V LOOKUP MATCH.
- V LOOKUP SHEET TO SHEET.
- VLOOKUPSHEETTO SHEET MATCH.
- V LOOKUP BOOK TO BOOK.
- VLOOKUPBOOK TO BOOK MATCH.
- H LOOK UP
- H LOOKUP MATCH
- H LOOKUP SHEET TO SHEET.
- H LOOKUP SHEET TO SHEET MATCH.
- H LOOKUP BOOK TO BOOK.
- HLOOKUP BOOKTO BOOK MATCH.
- OFFSET
- RIGHT LOOKUPS
- DOUBLE LOOKUPS
- CONDITIONAL LOOKUP
- INDIRECT
- INDEX
- PAYROLL CREATION
- REPORTING
- ADD INS
- DYNAMIC CHARTS
- MISREPORTING&DASHBOARD PREPARATION
- TEMPLATES CREATION
At the end of your course, you will work on a real time Project. You will receive a Problem Statement along with a data-set to work. Once you are successfully through the project (Reviewed by an expert), you will be awarded a certificate with a performance-based grading. If your project is not approved in 1st attempt, you can take extra assistance for any of your doubts to understand the concepts better and reattempt the Project free of cost.