+91 8130 80 2001

+91 9267 97 4043


Join Now

The next level of your career starts here.

Estimated Time
3 Months

Students, Fresher's
Working Professional

Training Mode
Offline, Online

Full Fees
₹ 6,000/-₹ 9,000/-
You Save - ₹ 3,000/-

What you will learn

Introduction to Data

Create and manage professional documents using Word.

Create and manage high impact presentations using PowerPoint.

Create Multiple MIS Reports - (Daily, Monthly, Quarterly and Year).

Analyze, manage and present data using Excel.

Advanced Excel Tools & Techniques for Analyzing Data.

Create interactive dashboard in excel.

Communicate and manage tasks, contacts and appointments using Outlook.


Microsoft Word

MS Word is a word processor developed by Microsoft. It has advanced features which allow you to format and edit your files and documents in the best possible way.

  • Introduction to Ms Word.
  • Apply pre-designed Styles and format text with fonts and colors.
  • Work with bullets, indents and line spacing.
  • Set up page layout for margins, columns and printing.
  • How to Use Table Using Multiple Formats.
  • Will learn control page formatting, Flow with sections and page breaks.
  • Create and update an automated Table of Contents.
  • Mail merge to envelopes, labels, emails and form letters.
  • Various techniques to create dynamic layouts.

Advanced Excel

The focus of this advanced excel course is to equip the participants with all the knowledge, understanding, and practice they need to use MS Excel easily, effectively, and efficiently. In this course, we cover the entire range of topics, from the very basics to the advanced topics.

  • Introduction to Advanced Excel
  • Understanding cell references and range name
  • Data Selection and various selection techniques
  • Separate Discussion on Shortcut keys
  • Data/Report Formatting and tips and tricks
  • Working with simple formula and functions
  • Copy and paste in detailed discussion
  • Number formatting and custom number formatting advanced
  • Row and column Insert/Delete tips and tricks
  • Protection Workbook, Worksheet and Range/Cell
  • Flash fill, Data Shorting, Data filter tips and tricks
  • Find, Replace and Goto Special tips and tricks
  • Understanding the concept of a formula
  • Understanding the Mathematical operators & Comparative operators
  • Mixed Reference Style (Row Freeze & Column Freeze)
  • Text Functions: Concatenate, Concat, Dollar, Fixed, Left, Mid, Right, Len, Lower, Upper, Proper, Replace, Rept, Find, Search, Substitute, Trim, Trunc, Convert. Char, Code, Clean, TextJoin, Value, Number Value,
  • Logical Functions: IF, IFS, AND, OR, XOR, SWITCH, NOT, IFNA and IFERROR
  • Date and Time Functions: Date, Datevalue, Day, Day360, Minutes, Hours, Now, Today, Month, Year, Yearfrac, Time, Timevalue, Weekday, Weeknum, Workday, Workday,Intl, Networkdays, Networkdays.intl, Datedif, Eomonth, Edate, Datedif. Isoweeknum,
  • Lookup and reference Functions: Vlookup, Hlookup, Lookup, Index, Offset, Choose, Match, Row, Rows, Column, Columns, Transpose, Indirect, Hyperlink, Address, Areas.
  • Math & Trig Functions: ABS, Aggregate, Power, Product, Rand, Randbetween, Round, Rounddown, Roundup, Subtotal, Sum, Sumif, Sumifs, Sumproduct, Ceiling, Ceiling.Math, Even, Odd, Fact, Floor, Gcd, Int, Lcm, Mod, Mround, Quotient, Roman, Sqrt,
  • Statistical Functions: Average, AverageA, Averageif, Averageifs, Count, CountA, Countblank, Countif, Countifs, Max, Maxa, Maxifs, Median, Min, Mina, Minifs, Mode, Rank, Small, Large.
  • Information Functions: Cell, Error.Type, Info, Isblank, Iserr, Iserror, Iseven, Isformula, Islogical, Isna, Isnontext, Isnumber, Isodd, Isref, Istext, N, Na,
  • Database: Daverage, Dcount, Dcounta, Dget, Dmax, Dmin, Dproduct, Dsum,
  • Financial Functions : Pmt, Ppmt, Pv, Rate, Nper, Ipmt, Fv, Cumprinc, Cumipmt.
  • Discussion of Errors and handling of multiple errors like. #DIV/0! , #N/A, # REF, #NAME, #VALUE, # NULL, #NUM and ########Error.
  • Use of Name Manager: Creating, Editing, and Deleting of Names.
  • Magic With Array Formulas
  • Writing of the Complex formulas for improvement in formulas writing skills
  • Interview Question and Answerer Session
  • Doubts Session
  • Start With Pivot Table, Do the Multiple Field Setting in Pivot Table.
  • Organizing and analysing large volumes of data
  • Creating Groups, Insert additional Calculated Field in Pivot Table.
  • Perform the % calculation on the basis of multiple fields
  • Insert slicer in Pivot Table and Pivot charts.
  • Dynamic Dashboard
  • Data Modelling and relationship
  • Working with multiple Data Source like PowerQuery, PowerPivot, SQL Server, Notepade.
  • Detailed discussion on graphically presentation of Data by using Charts.
  • Presentation with different kind to Basic charts like Column Charts, Line Charts, Pie Charts, Bar Charts, Scatter Charts
  • Preparation of Advanced Level of Charts: Gnatt Chart, Bubble Chart, Speedo Meter Chart. Pareto Chart, Waterfall Chart
  • Introduction to Multiple switches and buttons: Like Form Control, Combo Box, Check Box, Spin Box, List Box and Option Box.
  • Tips and Tricks to enhance dashboard designing
  • Working on Dynamic Charts in Excel
  • Use of Sparkline to your Sheet, Interactive Sparklines
  • What is Format as Table
  • Differences between normal range and FT
  • Structural references in FT and how this feature enable you to write effective formulas
  • Illustrations, Header and Footer, Hyperlink, Textbox, Symbol, WordArt, Object Etc.
  • Printer Properties and Page Setup (Page, Margin, Header/Footer and Sheet) for Printing.
  • Inserting, Deleting, Moving, and linking the data in between the multiple sheets.
  • What is Conditional formatting & how to change the existing formatting using this feature.
  • Quick format technique to highlight Duplicate/Unique values
  • We will discuss more than 25 real time examples of Conditional formatting
  • Writing Complex Conditional Formatting rules using formulas
  • Text to column
  • Remove Duplicates
  • Consolidate
  • Data Validation
  • Scenario Manager
  • Goal Seek
  • Data Table and Forecast Sheet
  • Group/Ungroup and Subtotal.
  • Daily/Weekly/Monthly and Yearly Sales MIS Report
  • Daily/Weekly/Monthly and Yearly Collection MIS Report
  • MIS Report for Monthly Meeting/Review

Microsoft PowerPoint

MS PowerPoint is a program that is included in the Microsoft Office. It is used to make presentations for personal and professional purposes.

  • Introduction to PowerPoint.
  • Make Effective and professional presentation.
  • Create engaging and well-designed slides and animations.
  • Export your presentations to a variety of formats.
  • Easily repurpose and edit your presentations, over and over.
  • Add visuals with easy picture-editing tools.

Microsoft Outlook

Microsoft Outlook is the preferred email client used to send and receive emails by accessing Microsoft Exchange Server email. Outlook also provides access contact, email calendar and task management features.

  • Introduction to Ms Outlook.
  • Best practices for sending, receiving and saving attachments.
  • Set up email signatures and explore options such as read receipts and delayed send.
  • Establish goals for email communication, Calendaring, and managing contacts.
  • Determine how to organize folders, incoming mail, and templets.
  • Create rules, Quick Steps, and Quick parts.
  • Schedule appointments and events in your calendar.
  • Create and assign tasks and to-do list activities.
  • Email Etiquette ---(Why is Email Etiquette Important?).
  • Types of Emails.

3 Months

Video Recording

Live Session with industry experts

100% Placement Assistance

Career Scope

  • MIS Executive
  • MIS Analyst
  • Data Analyst
  • Business Analyst
  • Sales Planning
  • Sales Analyst
  • Finance Analyst
  • Market Research Analyst
  • Sales/Project Coordinator
  • Operation Executive
  • Process Associate & Etc...

All Our Programs Include


Live interactive and classroom training will include the practical approach and assessments on regular basis.

Live Case Study

Case study using industry specific data helps you to get hands on with a good exposure.


Lifetime Placement Assistance

24 X 7 Support

We will support If any concern is raised related to the training, assignments, projects, case studies & interview questions.

Download Syllabus

The next level of your career starts here.