Macro/VBA Training also available. Register for the class, you are interested in. In case of special requirement, ask for assistance **************************** ONLINE and OFFLINE both classes available. ************************* ******************************************** Complete Reference Advance Excel. I am covering Complete MS-Excel through two crash courses. 1. Functional Excel: All Functions 2. Complete Reference in Advance Excel: Covering all topics(except Functional Excel) It is excellent opportunity for professionals from all fields to get trained in all specialized tools of Excel. ****** Formulas/Functional Excel is same, irrespective of version, you are using. ************************

Topics Covered

Course in Advanced Excel 2007/2010/2013 This training course outline is designed to provide training in Functional aspects of MS-Excel. Module 1: Navigation and Data Cleaning Navigation in a spreadsheet Using Different Navigation Techniques for Data Cleaning Formatting numbers ,Clearing formats Managing records, Recognizing and Correcting blank, errors Precedents and dependents cells for cell value Formula Evaluation Module 2: Connect Excel Workbook with other applications Hyperlinks and Bookmarks in Excel Embedding Power Point, Excel, Word and PDF files in Excel Compatible file formats with Excel Using text files with Excel Module 3: Working with Ranges Working with ranges, continuous, dis-continuous, Intersecting ranges Module 4: Working with Large Worksheets Freezing and unfreezing panes Splitting windows Inserting page breaks for printing Module 5: Named Ranges Definition Named Ranges Usage of Named Ranges Utility: Using Named Ranges in tools like Data Validation Tool, Index and Match Function Module 6: Data Validations Specifying a valid range of values for a cell Specifying a list of valid values for a cell: Allowing Only whole number/decimal/text length Specifying custom validations Module 7: Sorting Data Sorting tables Using multiple-level sorting Using custom sorting Adding and deleting different levels of sorting Row wise sorting Module 8: Working with Charts Creating charts No. Of column, Types of columns required to create charts Creating different types of charts(Pie, Columnar, Bar, Stacked, Combination chart, , X-Y chart, Line chart Including titles and values in charts Formatting of chart Creating Secondary Axis in Chart Changing display of category on X-Axis Different Formatting options for different Chart components Themes available in Excel and its usage Module 9: What If Analysis Goal Seek Scenarios Table PMT function Module 10: Filtering the Data Need of Filter application Different kinds of filters Auto and Advance filter Filter condition for Filtering data Using advanced filter options Other usage of filters Module 11: Using Subtotals for Reporting Purpose Concept of Subtotal Creating subtotals Multiple-level subtotals Module 12: Using Pivot Tables Creating Pivot Table Dropping data into the Pivot Table Modifying data Refreshing the Pivot Table • Making amendments in existing rows of Database • Adding new rows in Database Moving Data in Pivot Table Grouping dates within a Pivot table Grouping Text Entry in Pivot Table Creating ranges for numbers in Pivot table Formatting Pivot Table Changing Value field setting Changing Report Layout Applying Slicer (in Excel 2010) Turn off/on Grand total for Rows/Column Drilling down report for Pivot Table values Using Conditional Formatting in Pivot Table Apply Page Report filter, Row and column Filter Number Formatting to Pivot Table values Customized column values (% of Total, % of column etc.) Customizing Pivot Table options Using advanced options of Pivot tables Module 13: Data Consolidation Using data consolidation feature to consolidate data Types of Data Consolidation Deploying Different capabilities of Data Consolidation • Consolidation by Category • Consolidation by Position Module 14: Dynamic Data Ranges Concept of Dynamic Data Ranges Creating Table Module 15: Multipurpose Function: I: Offset Function Offset Function Using Offset function for calculation and other purpose Using Offset Function to create Dynamic Data Ranges Module 16: Multipurpose Function: II Sumif, Sumifs Countif, Countifs Module 17: Auto and Conditional Formatting Concept of Condition Formatting Using Different Conditional Formatting(Data Bars, Color Scales and others. Applying Formulas for customized Conditional Formatting Creating new rules, Managing, Editing and deleting new rules. Using auto formatting option for worksheets Module 18: Protecting Your workbook Protecting Window or Content Workbook, Worksheet and Cell level of Protection Applying Password on Workbook, Worksheet and cell level Module 19: Creating Data Entry Form Predefine a format for data entry form for professionals Module 20: Formula Auditing Trace Precedents, Trace Dependents Error Checking Remove arrows Formula Evaluation Module 21: Shortcut Keys 50 most Important shortcut keys Module 22: Introduction to Macros- 1hr. Introductory Session Recording a Macro How to Save and Run Macro Editing any existing Macro Assigning a macro to a button MS Excel training: Who should attend? • Sales & Marketing, Finance, HR, Admin, Accounts, Project Management, MIS and CRM professionals. • Professionals from Engineering background, Real Estates, Customer Service Executives, Front desk Executives and Insurance Sector professionals. • Students studying professional courses Course Outline: Please see attached pics for course outline

Who should attend

BPO Emaployee Business person Management Professional dealing with Data MIS personnel Commerce field, Would be C.A. Sales/HR.

Pre-requisites

Well verse in Basics and Functions of Excel

What you need to bring

Computers with Excel 2007 installed, will be provided for practice.""""""""

Key Takeaways

Training material will be shared with you. Knowledge to manage your data. Knowledge specific to Business Solution no matter which field you are in. Program Deliverable: • Reference material for Excel training will be provided to all participants.