Excel and Advanced Excel Training

• Presenting and Managing Data in Excel:
• Basic Understanding Menu and Toolbar
• Introduction to a different categories of functions
• Creation of Excel Sheet Data
• Range Name, Format Painter
• Conditional Formatting, Wrap Text, Merge & Centre
• Sort, Filter, Advance Filter
• Different types of Chart Creations
• Auditing, (Trace Precedents, Trace Dependents) Print Area
• Data Validations, Consolidate, Subtotal
• What if Analysis (Data Table, Goal Seek, Scenario)
• Solver, Freeze Panes
• Various Simple Functions in Excel (Sum, Average, Max, Min)
• Real Life Assignment work

Manage workbook

• Save a workbook as a template,
• copy macros between workbooks,
• reference data in another workbook,
• reference data by using structured references,
• enable macros in a workbook,
• display hidden ribbon tabs

Manage workbook review:

• Restrict editing,
• protect a worksheet
• configure formula calculation options
• protect workbook structure
• manage workbook versions
• encrypt a workbook with a password

Apply custom data formats and validation:

• Create custom number formats
• populate cells by using advanced Fill Series options
• configure data validation

Apply advanced conditional formatting and filtering:

• Create custom conditional formatting rules
• create conditional formatting rules that use formulas
• manage conditional formatting rules

Create and modify custom workbook elements:

• Create custom color formats,
• create and modify cell styles,
• create and modify custom themes,
• create and modify simple macros
• insert and configure form controls

Prepare a workbook for internationalization:

• Display data in multiple international formats
• apply international currency formats,
• manage multiple options for Body and Heading fonts

Apply functions in formulas:

• Perform logical operations by using AND, OR, and NOT functions;
• perform logical operations by using nested functions
• perform statistical operations by using SUMIFS, AVERAGEIFS, and COUNTIFS functions

Look up data by using functions:

• Look up data by using the VLOOKUP function,
• lookup data by using the HLOOKUP function,
• lookup data by using the MATCH function,
• lookup data by using the INDEX function

Apply advanced date and time functions:

• Reference the date and time by using the NOW and TODAY functions,
• serialize numbers by using date and time functions

Perform data analysis and business intelligence:

• Reference the date and time by using the NOW and TODAY functions
• import, transform, combine, display, and connect to data
  consolidate data
• perform what-if analysis by using Goal Seek and Scenario Manager
• use cube functions to get data out of the Excel data model
• calculate data by using financial functions

Troubleshoot formulas:

• Trace precedence and dependence
• monitor cells and formulas by using the Watch Window
• validate formulas by using error-checking rules,
• Evaluate formulas

Define named ranges and objects:

• Name cells,
• name data ranges,
• name tables,
• manage named ranges and objects

Create advanced charts:

• Add trendlines to charts,
• create dual-axis charts,
• save a chart as a template

Create and manage PivotTables:

• Create PivotTables,
• modify field selections and options,
• create slicers,
• group PivotTable data,
• reference data in a PivotTable by using the GETPIVOTDATA function,
• add calculated fields,
• format data

Create and manage PivotCharts:

• Create PivotCharts,
• manipulate options in existing PivotCharts,
• apply styles to PivotCharts,
• drill down into PivotChart details

• Dashboard Background
• Dashboard Elements
• Interactive Dashboards
• Type of Reporting in India
• Reporting Analyst
• Indian Print Media Reporting
• Audit Report
• Accounting MIS Reports
• HR MIS Reports
• MIS Report Preparation Supplier, Exporter
• Data Analysis
• Costing Budgeting Mis Reporting
• MIS Reporting for Manufacturing Company
• MIS Reporting for Store and Billing
• Product Performance Report
• Member Performance Report
• Customer-Wise Sales Report
• Collections Report
• Channel Stock Report
• Prospect Analysis Report
• Calling Reports
• Expenses Report
• Stock Controller MIS Reporting
• Inventory Statement
• Payroll Report
• Salary Slip
• Loan Assumption Sheet
• Invoice Creation

• Tips to clear an Interview
• Common Interview questions and answers
• Advanced Excel Interview Questions and Answers
• Resume Building Guide