Advance Excel & MIS Report

This program is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

Topics:

• Overview of the Basics
• Customizing common options in Excel
• Absolute and relative cells
• Protecting and un-protecting worksheets and cells
• Working with Functions
• Writing conditional expressions (using IF)
• Using logical functions (AND, OR, NOT)
• Using lookup and reference functions (VLOOKUP, HLOOKUP)
• Data Validations
• Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell
• Specifying custom validations based on formula for a cell
• Working with Templates
• Designing the structure of a template
• Using templates for standardization of worksheets
• Sorting and Filtering Data
• Sorting tables
• Using multiple-level sorting
• Using custom sorting
• Filtering data for selected view (AutoFilter)
• Using advanced filter options
• Working with Reports
• Creating subtotals
• Multiple-level subtotals
• Creating Pivot tables
• Formatting and customizing Pivot tables
• Using advanced options of Pivot tables
• Pivot charts
• Consolidating data from multiple sheets and files using Pivot tables
• More Functions
• Date and time functions
• Text functions
• Database functions
• Formatting
• Using auto formatting option for worksheets
• Using conditional formatting option for rows, columns and cells
• Mis Report
• Assignment & project Works