Business Reporting with MS EXCEL


Microsoft Excel allows you to manipulate, manage and analyze data, helping assist in decision-making and creating efficiencies that will directly affect your bottom line. Whether you’re using it for business or to help manage personal databases and expenses, Microsoft Excel gives you the right tools to enable you to accomplish all your needs..

Goal of Course

  • Identify the different components of the Excel worksheet.
  • Differentiate between an Excel workbook & worksheet.
  • Open an existing workbook and create a new workbook
  • Enter text and formulas into an Excel spreadsheet
  • Enhance alpha and numeric data in an Excel worksheet
  • Move & copy alpha and numeric data
  • Construct formulas to manipulate numeric data in an Excel Worksheet
  • Create a spreadsheet to tabulate and record numeric values
  • Change the appearance of an Excel spreadsheet
  • Use the print function to create a printable copy of data stored on an Excel spreadsheet.
  • Set up the chart function of Excel to represent numeric data in multiple formats.
  • Differentiate between formulas and functions in Excel.
  • Use at least four functions that are stored in Excel.
  • Access and manipulate data using the database functions of Excel.

Key Modules

  • MS Excel Formulas
  • Data Summarization with Pivot
  • MIS Reporting with MS Excel
  • Understanding of VBA/Macro Programming

Introduction to Data Science - Advanced Analytics

  • Relevance in industry & need of the hour
  • Types of analytics – Marketing, Risk, Operations, etc
  • Business & Technology drivers for analytics
  • Future of analytics & critical requirement
  • Types of problems and business objectives in various industries
  • Different phases of Analytics Project

Fundamentals of MS Excel

  • Introduction to Excel
  • Working with Formulas and functions
  • Formatting & Conditional Formatting
  • Filtering, sorting, paste special etc
  • Functions (Logical & Text, Mathematical, Statistical etc)
  • Data Manipulation & Data Aggregation
  • Data Analysis using functions

Advanced Functions in MS Excel

  • Analyzing Data using Pivots
  • Descriptive Statistics
  • Creating Charts & Graphics
  • Data analytics tool (What -if analysis, Goal seek, Data Table, Solver)
  • Protecting Workbooks, worksheets and formulas

MIS Reporting with MS Excel

  • Start by building bar charts, column charts, pie charts and line charts to display your data.
  • Build more complex charts like scatter plots, combination charts and more to really tell your story.
  • Add interactivity to your dashboard with the slicer and timelines.
  • Leverage pivot tables within your dashboard to add even more interactivity.

Introduction to VBA/Macro

  • Working with VBE (Visual Basic Editor)
  • Introduction to Excel Object Model
  • Understanding of Sub and Function Procedures
  • Key Component of Programming Language
  • Understanding of If, Select Case, With End With Statements
  • Looping with VBA
  • User Defined Function
  • Some Commonly Used Macro Examples

Note :you can speak to our team for detailed content and available batch timings.