We Are The Best

We are leading name in MS-Excel training programs, help organizations to
empower their employees with technical skills need to perform to their full potential.


MS-Excel Basic

Session is desinged for those who are fresher or very limited knowledge of the tool and want to make themself confortable using the tool.

  • Prequisities
    • Session is designed for freshers, hence, no perquisites as such. Operation knowledge would be an advantage.
  • Duration & Your Takeaway
    • Approximately 12-15 days x 1 hour.
    • One month online/telephonic after training support.
    • Real life/professional examples.
    • Soft copy of course material.
  • Course Content
    • Know MS-Excel
      • What is MS-Excel? Benchmarking features of MS-Excel 2010 & Why MS-Excel 2020?
      • Basic terminology i.e. what is workbook, worksheet, cell, range, name range & etc.
      • Get familiar with MS-Excel window/screen i.e. Ribbon, Quick Access Toolbar, Formula Bar & etc.
      • Shortcuts for quick navigation
    • Basic Commands
      • Quick overview Home, Insert, Page Layout, Formulas, Data, Review, View tabs commands.
      • Covering basic & commonly used commands in tabs for data handling & formatting.
    • Handling Workbook & Worksheets
      • Types of Workbook & Worksheet
      • Handling Workbook & Worksheets i.e. Templates, Open, Save, Rename, Copy, Paste & etc.
    • Data Entry & Data Ethics
      • Data Types
      • Formatting Options
      • Data Ethics
      • Conditional Formatting
      • Basic Mathematical Operations
      • Cell Linking: same worksheet, other worksheets, other workbook.
    • Optimizing & Data Validation
      • Data Sorting (Basic)
      • Data Filter (Basic)
      • Data Validation (Basic)
    • Introduction to MS-Excel Functions
      • Difference between function & formula.
      • Introduction to functions covering: SUM, MAX, MIN, AVERAGE, COUNT, COUNTA, DATA, NOW, SUMIF, COUNTIF, IF, IFS, VLOOKUP, CONCATENATE, LEN, LEFT, RIGHT, MID, LOWER, UPPER, PROPER
      • Data Validation (Basic)
    • Charts & Data Presentation
      • Data presention ethics
      • Overview of charts
      • Preparing & formatting charts


MS-Excel Advance

Session is designed for working professional having sound knowledge of MS-Excel operations and want to enhance further for advance features and using functions for data manipulation, MIS, reporting, handling complex data & etc.

  • Prequisities
    • Operation & data handling knowledge of MS-Excel along with writing simple functions i.e. SUM, SUMIF, etc.
  • Duration & Your Takeaway
    • Approximately 16-20 days x 1 hour.
    • One month online/telephonic after training support.
    • Real life/professional examples.
    • Effective usage of functions with mix-matches possibilities.
    • Soft copy of course material.
  • Course Content
    • Introduction & Basic Brush-up
      • Benchmarking features of MS-Excel 2010 & Why MS-Excel 2020?
      • MS-Excel Basic brush-up.
      • Terminology & Concept discussion
    • Data & Risk Handling
      • Data Validation (Basic & Advance)
      • Conditional Formatting (Basic & Advance)
      • Handling Duplicate Data
      • Subtotal & Grouping
      • Structured Data
    • Formulas & Functions
      • Difference between function & formulas
      • MS-Excel functions architecture & syntax
      • Nested functions and how to write & troubleshoot
    • MS-Excel Functions Covered
      • Logical: IF, AND, OR, IFS
      • Lookup & Reference: VLOOKUP, XLOOKUP, LOOKUP, INDEX, INDRECT, MATCH, CHOOSE
      • Text: EXACT, FIND, LEFT, RIGHT, LEN, MID, UPPER, LOWER, PROPER
      • Maths: SUM, COUNT, SUMIF, COUNTIF, SUMIFS, COUNTIFS, SUBTOTAL, SUMPRODUCT
      • Statistical: TREND, COREL, FREQUENCY
      • Date: DATE, NOW, TODAY, NETWORKDAYS, NETWORKDAYS.INTL
    • Array Functions (introduction)
      • Introduction to Array Functions
      • Data Filter (Basic)
      • Writing Array Functions
    • Analytical Tool
      • Pivot Table & Slicer
      • Calcualted Fields
      • Pivot Chart
    • WhatIF Analysis Tool
      • Scenarios for data presentation
      • Goal Seek
      • Data Table
    • Working With Templates
      • Worksheet Templates
      • Chart Templates
    • Charts & Data Presentation
      • Overview of creating chart
      • Working with chart
      • Dynamic chart
    • Working With Developer Object
      • Inserting developer tab
      • What is developer objects & their usage?
      • Using Checkbox and overview of other objects i.e. Radio Button, Spin Button
    • Working with Comments/Notes
      • Add/Edit/Delete Comment/Notes
      • Picture Comment/Notes
    • Macros
      • Introduction to macros
      • Recording / using recorded macros
      • Overview of VBE


MS-Excel VBA

Session is designed for professional using MS-Excel, wants to advance their MS-Excel programing skills for data automation, creating forms, tools & application, using MS-Excel VBA.

  • Prequisities
    • Session is designed for non-programing background, any programing knowledge would be an advantage.
  • Duration & Your Takeaway
    • Approximately 24-30 days x 1 hour.
    • One month online/telephonic after training support.
    • Real life/professional examples.
    • Using MS-Excel VBA for data automation.
    • Soft copy of course material.
    • Chance to work on live projects.
  • Course Content
    • Introduction
      • Introduction to VBA & VBE
      • Difference between VBA & Macros
      • How to use VBE
      • VBA code & code security
    • Writing Program/Code in VBA
      • MS-Excel VBA hierarchy
      • Where & how to write VBA code
      • VBA coding syntax & concepts
      • Using "immediate window", indenting, etc.
    • Procedure / Modules
      • What is procesure, module
      • How to insert module(s)
      • Difference between module & class module
      • Public & Private concept & usage
      • Calling procedure in another procedure
      • Passing values/arguments in caling procedure
    • Variables
      • What are variables?
      • Why variables required?
      • Rules to define variables
      • Variables types, scope & life.
    • MS-Excel VBA Object
      • MS-Excel VBA Object
      • Collections
      • Difference between collection & objects
      • Object properties and methods
    • Loop & Condition
      • What is loop & usage
      • Different types of loops
      • Nested loops
      • What are conditions
      • Nested conditions
    • Events
      • Introduction to events
      • Workbook & Worksheet events
      • Writing codes for events
    • Handling Workbook & Worksheet via VBA
      • Insert / Delete / Rename / Move / Copy worksheet
      • Open / Close / Save / New Workbook
      • Writting & pulling data to worksheet
    • Data Formatting via VBA
      • What is formatting?
      • How to format data i.e. fonts, font size, font color, cell color, cell merge & etc.
    • Using Outlook via VBA
      • Sending Outlook email via VBA
      • Introduction to fetch email data from Outlook.
    • Database Connectivity via VBA (MS-Access / MS-SQL)
      • Overview of database & database connectivity i.e. connection string, recordset, etc.
      • Adding records to database
      • Edit / deleting records from database
      • Pulling records from database to MS-Excel worksheet
    • Using Arrays in VBA
      • What is array?
      • Usage of array its benefits
    • Note:
      • Terms VBA used in this referred to/as "MS-Excel VBA"
      • Database connectivity will be covered not database
      • Session is designed for worksheet data automation. If you are looking for Forms, let us know


Power BI

Session is designed for professional, want to make first step towards Business Intelligence. Course will give adequate overview of creating Power BI visuals and working with visuals.

  • Prequisities
    • MS-Excel functions knowledge would be an advantage, not mendatory.
  • Duration & Your Takeaway
    • Approximately 10-12 days x 1 hour.
    • One month online/telephonic after training support.
    • Real life/professional dashboards.
    • Creating effective & interactive visuals.
    • Soft copy of course material.
  • Course Content
    • Get Familiar With Tool
      • What is Power BI?
      • Usage of Power BI
      • Installation
      • Licenses
      • Comparision with other BI Tools
    • Architecture
      • Power BI Desktop
      • Power BI Gateway
      • Power BI Mobile Apps
      • Power BI Services
    • Data Types
      • Auto data type mapping
      • Changing data types
    • Supported Data Sources (overview)
      • Flat Flies
      • Database
      • SharePoint
      • MS-Excel (exercies will be done with this)
      • Etc.
    • Reports & Dashboard
      • Difference between report & dashboard
      • Creating visuals
      • In details of each visuals
      • Drill down options
      • Interaction between visuals to make interactive dashboard
      • Web view
      • Mobile view
    • Visuals Covered
      • Bar / Bar stacked
      • Column / column stacked
      • Line / Area
      • Combo
      • Maps
      • Pie / Doughnut
      • Tree
      • KPI
      • Decomposition Tree
      • Gauge
      • Cards / Multi row cards
      • Waterfall
      • Q&A
    • Hierarchies
      • Creating hierachies
      • Using hierarchies in reports
    • DAX Overview
      • What is measures?
      • Usage of measures
      • Creating table columns
      • Few Examples of DAX
    • Creating Dashboard
      • Publishing Reports
      • Creating Dashboard
      • Share Dashboard
    • Bookmarks
      • Creating Bookmarks
      • Usage of Bookmarks
    • Small Project to wrap-up


MS-Office

Session is designed for those who want to learn take first step towards MS-Excel, MS-Word, MS-PowerPoint to enhance their knowledge about tool.

  • Prequisities
    • Designed for fresher. No Prequisites required.
  • Duration & Your Takeaway
    • Approximately 24-30 days x 1 hour.
    • One month online/telephonic after training support.
    • Real life/professional examples.
    • Shortcuts for MS-Office applications
    • Soft copy of course material.
  • Course Content
    • Customized Package
      • Contact us to discuss the requirement and provide customized solution.


MS-SQL

Session is designed for professional, who are looking for operational part for MS-SQL database and want to learn/enhance their skills for query writting to pull and push data.

  • Prequisities
    • Recommened for freshers. No prequisities required.
  • Duration & Your Takeaway
    • Approximately 10-12 days x 1 hour.
    • One month online/telephonic after training support.
    • Working with MS-SQL database
    • Writing queries to pull and push data to database
    • Soft copy of course material.
  • Course Content
    • Introduction
      • What is database?
      • What is MS-SQL?
      • Different versions available for MS-SQL
      • Installation of MS-SQL
    • Database
      • Types of databases
      • DBMS & RDBMS database
      • Other databases in use
    • Database & Table Desiging
      • Create database
      • Create Tables
      • Type of data fields
      • Primary & Foriegn key concept
      • Alter Table
      • Delete Table
    • RDBMS
      • Basic architecture
      • Advantages of RDBMS
      • Rows
      • Columns
    • SSMS
      • What is SSMS?
      • Working with SSMS
    • Introduction to SQL
      • What is SQL (Simple Query Language)?
      • How SQL works
      • Benefits of SQL over loops in development
      • SELECT query
      • INSERT query
      • UPDATE query
      • DELETE query
      • Sorting data in SQL
      • Grouping data in SQL
      • Union in SQL
    • Types of SQL Joins
      • What are joins?
      • INNER JOIN
      • LEFT JOIN
      • OUTER JOIN
      • CROSS & SELF JOIN
    • Aggregate Queries
      • SUM Queries
      • COUNT queries
      • Grouping
    • Logical
      • Using IF in SQL
      • Using CASE in SQL
    • Exporting & Importing
      • Exporting data to flat files, Excel
      • Importing data from script


MS-Access

Session is designed for those who are used to managing data in spreadsheet and looking forward to enhancing their skills or first step toward database management system and handling data via queries i.e. SQL.

  • Prequisities
    • Recommened for freshers. No prequisities required.
  • Duration & Your Takeaway
    • Approximately 10-12 days x 1 hour.
    • One month online/telephonic after training support.
    • Working with MS-Access database
    • Writing queries to pull and push data to database
    • Soft copy of course material.
  • Course Content
    • Introduction
      • What is database?
      • What is MS-Access?
      • Types of databases
      • Other database
      • Why use database?
    • Understanding your data
      • Data Modeling
      • Desiging database & tables
    • Overview of MS-Access
      • MS-Access components
      • Creating MS-Access database
      • MS-Access database security
      • Database compression
    • Creating & Handling Tables
      • Data types
      • Atrributes
      • Creating tables
      • Manual editing
      • Importing data from MS-Excel
      • Edit tables
      • Delete tables
    • Relationship
      • Types of relationship
      • Why to create relationship
      • Referential integrity
    • SQL the language
      • What is SQL?
      • Benefits of SQL
      • Types of SQL
      • Select Query
      • Update Query
      • Delete Query
      • Insert Query
    • MS-Access Query Builder
      • Using query builder
      • Examples of select queries with query builder
    • Multi Table Queries
      • Joining Tables
      • LEFT JOIN
      • RIGHT JOIN
      • INNER JOIN
    • Aggregate Queries
      • Grouping
      • SUM, COUNT, etc. queires
    • Overview of Forms & Reports
      • FORMS & report wizard
      • Types of FORMS & reports
    • Introduction to other database
      • MS-SQL
      • MySQL

Send Query