Advanced Excel Courses INR Rs.5,999 Special Offer Duration:2 Months Daily 2 Hours BASIC Microsoft Excel : Spreadsheet basics Creating, editing, saving and printing spreadsheets Working with functions & formulae Graphically representing data : Charts & Graphs Analyzing data : Data Menu, Subtotal, Filtering Data Working with functions & formulaeFormatting worksheets , Securing & Protecting spreadsheets ADVANCED Excel Course Contents : Formulas & Macros Formulas: 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 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 NESTED IF Reporting Character Functions Date Functions Age Calculations Consolidation of Data Data Validation PIVOT TABLES : Enter the Pivot Table Data Create the Pivot Table Adding Data to the Pivot Table Filtering the Pivot Table Data Change the Pivot Table Data Analyze Data Columns in Pivot Tables Adjust Data to Analyze MACRO’S ( Int ) : Macros Definition and use, Record a macro Assign a macro, Run a macro Store a macro, Introduction to VBA Prog. 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 SUBSCRIBE TO ENROLL FOR COURSES
