Microsoft Excel
& Power BI

Microsoft Excel & Power BIMicrosoft Excel & Power BIMicrosoft Excel & Power BIMicrosoft Excel & Power BI
  • Home
  • Our Clients and Reviews
  • Courses Offered
  • About Trainer
  • FAQs
  • Photo Gallery
  • Contact Us

Microsoft Excel
& Power BI

Microsoft Excel & Power BIMicrosoft Excel & Power BIMicrosoft Excel & Power BI
  • Home
  • Our Clients and Reviews
  • Courses Offered
  • About Trainer
  • FAQs
  • Photo Gallery
  • Contact Us
Excel Specialist Course

Excel Specialist

Excel Specialist

Excel Specialist

This program is for those excel beginners who are very new to excel and existing excel basis users who wish to improve skills and learn new techniques of performing tasks with speed and accuracy.

Learn more
Excel Expert Course

Excel Expert

Excel Specialist

Excel Specialist

 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 basic MIS reports, and automating various tasks.

Learn more
Excel Master Course

Excel Master

Excel Master

Excel Master

  This is only for those excel users who already are using Microsoft Excel regularly & effectively.

Aim for this program is to create professional who can create impactful Dashboards using excel, churn data and produce MIS reports with help of advance excel tools.

Learn more
Power BI Course

Power BI

Excel Master

Excel Master

  Create amazing Dashboards, Dynamic charts with live in depth analysis of your data and that too on your fingertips.


Amaze your boss by showing impact of business analytics using power of Business Inelegance  tool by Microsoft.

Learn more

Excel Specialist (Duration: 12-16 hours)

Objective: Creating and editing worksheets Formatting and securing worksheets Commands for managing data such as sorting, filters Working with charts Working with basic in-built functions of Excel Formatting data for analysis.

Module 1: Getting Started

  1. Relative and Absolute cell references
  2. Fast navigating & selection techniques
  3. Protecting/unprotecting worksheets and workbooks
  4. Customization of excel menus, Creating own shortcuts 

Module 2: Formatting Cell, Paste Options, Find/Replace

  1. Cell Formatting Options, Format Painter.
  2. Paste Special Values, Formats, Comments, Transpose
  3. Find, Replace in detail including Wild Card Characters 

Module 3: Formulae and Functions

  1. Understanding Formulae and Functions
  2. Basic Text Functions (CONCATENATE, LEN, LEFT, RIGHT, MID, FIND, Case Functions)
  3. Using AutoSum and aggregate functions (SUM, COUNT, MIN, MAX, AVERAGE)
  4. Logical function: IF, Nested IF

Module 4: Basic Data Operations

  1. Sorting data, Multi level sorting, Filtering data with auto filter
  2. Wild Card Char filtering.
  3. Removing duplicate values from data
  4. Data Text to Columns
  5. Dealing with Error values (Types of errors in excel)

Module 5: Working with Charts and Objects

  1. Creating different types of charts & formatting them
  2. Chart fine tune techniques
  3. Insert objects and object formatting (Pictures, Shapes, Textboxes, WordArt, Symbols)
  4. Hyperlinks

Module 6: Working with Large Worksheets

  1. Freezing and unfreezing panes, Creating New window, Splitting windows
  2. Inserting page breaks for printing
  3. Repeating rows and columns for multiple pages

Excel Expert (Duration: 12-16 hours)

Objective: Performing complex calculations effectively Organizing and analyzing large volumes of data, creating MIS reports Consolidating and managing data from multiple workbooks.

Module 1: Getting Started

  1. Cell references (Relative, Absolute, Mixed Row and Column)
  2. Fast navigating & selection techniques

Module 2: Working with Functions

  1. Advance use of Text Functions (CONCATENATE, LEN, LEFT, RIGHT, MID, FIND, SUBSTITUTE)
  2. Advance Maths Functions (SUM, COUNT, COUNTA, COUNTBLANK, ROUND)
  3. Advance Logical functions (IF, Nested IF, AND, OR)
  4. Date Functions (TODAY, TEXT, YEAR, MONTH, DAY, DATE), Operations with dates..
  5. Statistical functions for calculations (SUMIFS, COUNTIFS, MAXIFS, MINIFS, AVERAGEIFS)
  6. Statistical functions for ranking (RANK, LARGE, SMALL)
  7. Lookup Functions (VLOOKUP, HLOOKUP, Exact and Approx. match) in depth.

Module 3: Data Validations & Goal Seek

  1. Specifying a valid range of values for a cell and managing error messages for Data Validation
  2. Goal Seek for reverse calculations for complex analysis 

Module 4: Conditional Formatting

  1. Conditional Formatting for reports presentation
  2. Use of Data bars, Color set, Icon set
  3. Creating, modifying new rules for formatting
  4. Using excel functions for custom conditional formatting (Automating Conditional Format)

Module 5: Working with Pivot Tables

  1. Creating Pivot Tables
  2. Pivot table calculations
  3. Grouping of pivot fields for detailed analysis purpose.
  4. Pivot table variance analysis on different criteria

Module 6: Dynamic MIS Reports using Pivot Tables

  1. Pivot charts
  2. Pivot Slicers
  3. Timeline for Time Series Analysis
  4. Use of Conditional Formatting in pivots 

Excel Master (Duration: 16-20 hours)

Objectives: Preparation of Dynamic MIS reports, Highly Complex data analysis in quick time, Reports using form controls Dynamic data analysis & make yourself power user of excel operations

Module 1: Getting Started

  1.  Cell references including 3D reference.

Module 2: Advance functions

  1. Database functions: INDEX, MATCH, RANK, REPT, LARGE, SMALL
  2. Functions for dynamic ranges: IINDIRECT, OFFSET
  3. Error handling functions: IFERROR, ISERROR, NA()
  4. Custom data validations using logical functions
  5. Dynamic Array Functions: SORT, SORTBY, UNIQUE, FILTER, SEQUENCE, RANDARRAY (Office 365)
  6. Advance LOOKUP Function: XLOOKUP (Office 365) 

Module 3: Name manager & Named ranges

  1. Creating, Editing Named Ranges.
  2. Using named ranges in functions
  3. Use of named ranges/Dynamic Array functions in Data Validations 

Module 4: Working with Tables

  1. Table operations along with excel functions
  2. Creating dynamic table and dynamic charts

Module 5: Dynamic Dashboard for MIS reports

  1. Using Form Controls
  2. Creating Dynamic dashboard reports using form controls
  3. Creating Dynamic dashboard reports using dynamic functions
  4. Flash Fill for speed in MIS preparations 

Module 6: Dynamic Charts for MIS reports

  1. Use of Named ranges in Charts (Auto extendable charts)
  2. Creating Dynamic Charts using Dynamic Functions and Named ranges
  3. Sparklines, Inline Charts, Win-Loss Chart (Excel 2010 and above) 

Module 7: Power Query for Data Analysis and Dashboards (Excel 2013 and abov

  1. Importing data from different sources (Excel Tables/CSV/Web)
  2. Cleaning data using Power Query tools (Pivoting/Unpivoting).
  3. Data cleaning Techniques
  4. Power query Table Joins.
  5. Relationships between tables.
  6. Consolidation of multiple workbooks and creating automated dashboards.
  7. Using data models for pivots and Dashboards. 

Module 8: Power Pivot and DAX

  1. Creating Power Pivot
  2. Star Schema and Linking of tables,
  3. Table relationships
  4. Columns and Measures
  5.  Explicit Vs. Implicit Functions
  6. DAX (Data Analysis Expression) functions to use in Pivot Tables for dynamic results

Power BI (Duration: 16-20 hours)

Objectives: Microsoft Power BI is used to find insights within an organization's data. Power BI can help connect disparate data sets, transform and clean the data into a data model and create charts or graphs to provide visuals of the data. All of this can be shared with other Power BI users within the organization.

Module 1: Power Query

  1. Importing data from different sources (Excel Tables/CSV/Web)
  2. Cleaning data using Power Query tools (Pivoting/Unpivoting).
  3. Data cleaning Techniques
  4. Power query Table Joins.
  5. Relationships between tables.
  6. Consolidation of multiple workbooks and creating automated dashboards.
  7. Using data models for pivots and Dashboards.

Module 2: Power Pivot and DAX

  1. Creating Power Pivot
  2. Star Schema and Linking of tables,
  3. Table relationships
  4. Columns and Measures
  5.  Explicit Vs. Implicit Functions
  6. DAX (Data Analysis Expression) functions to use in Pivot Tables for dynamic results

Module 3: Power BI Visualizations

  1. Introduction to Interface
  2. Power BI Visualizations (Column, Bar, Ribbon, Pie, Line, Area, Combo, Scatter, Waterfall, Treemap, Gauge chart, Map Charts.
  3. Cards, Tables and Matrix
  4. Conditional Formatting, Style presets, Setting Web URL
  5. Hierarchy Levels, Drill Through (Rows and Columns)
  6. Manager Display units.
  7. Cards with calculated numbers using DAX measure
  8. Custom Headings using DAX functions
  9. Creating Measure Table

Module 4: Additional Features

  1. Include and Exclude items for analysis.
  2. Data type Geography
  3. Data type Web URL
  4. Export Data, Show As a Table, Show Data point as a table
  5. Group Data
  6. Elements and their Uses including Bookmark and Drill-Through
  7. Analyze-Explain Features, Smart Narrative

Module 5: DAX Functions for Operations

  1. TEXT Functions
  2. Date Functions
  3. Number Functions
  4. Table functions for creating Dimension Tables
  5. Custom Column
  6. Introduction to M Functions

Module 6: Parameters

  1. What If Parameter
  2. Field Parameter

Module 7: Report Publishing

  1. Publish, Export as PPT, PDF
  2. Refresh, schedule refresh, Comment, Share
  3. Pin visuals to Dashboard
  4. Dashboard Refresh, Dashboard Theme
  5. Subscribe to report  (auto-email on frequency) to stakeholders

Copyright © 2022 Professional Excel & power bi - All Rights Reserved.

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. 

Accept