+91 8130 80 2001

+91 9267 97 4043

Placement

Join Now

The next level of your career starts here.







Estimated Time
12 Months

Pre REQUISITES
Students, Fresher's
Working Professional

Training Mode
Offline, Online

Full Fees
₹ 18,000/-₹ 25,000/-
You Save - ₹ 7,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.

Automates repetitive and routine tasks.

Reduces the formulas burden used in excel reports.

Automate daily routine tasks within excel.

Learn Email Automation.

Communicate and manage tasks, contacts and appointments using Outlook.

Visualize and analyze data and derive insights from Excel spreadsheets or local databases.

Create, share, collaborate, and benefit from business information with purpose-built dashboards.

Use Salesforce Data, Azure SQL Database, and SQL Server analysis tabular data.

Work on live projects to get hands-on experience.

Curriculum

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

VBA Macros

In this course you'll learn how to create your own macros, automate and simplify multiple tasks in Excel so that you can bring your Excel skills to the next level, and put yourself ahead of the competition.

  • Learn to program in VBA from scratch
  • Understand coding, and the thought process behind it
  • Learn how to automate daily routine tasks within Excel
  • Learn VBA Programming concepts to create dynamic, re-usable code
  • Learn how to write custom VBA Macros to create more robust automation
  • Fully automate Excel using Visual Basic for Applications
  • Create emails and send them automatically
  • Quick Recap of Microsoft Excel
  • Introduction to Developer Ribbon Tab
  • Introduction to VBA
  • What is VBA / Macro in Excel?
  • Introduction to Visual Basic Editor Window
  • Getting Familiar with Visual Basic Editor (VBE)
  • Customizing the VBE Environment
  • The Macro Recorder
  • Executing / Modifying Recorded Macros
  • Saving Macro Workbook
  • Introduction to Sub and Function Procedures
  • Introducing the Excel VBA Object Model (A must-know thing to become a Pro in VBA)
  • Properties and Methods
  • Important and Useful Properties of Application Object
  • Working with Ranges Objects
  • Working with Comments
  • Variable, Data Types, and Constant
  • Finding the Last or Next available Row/Column
  • Selecting Rows/Columns/Table (Normally & Dynamically)
  • Introduction to VBA Loops & Conditional Statements
  • Working with Conditional Statements
  • Working with Loops
  • Working with Message & Inbox Box
  • With-End with Constructs
  • Controlling Program Flow
  • Introduction to Arrays
  • Introduction to Excel VBA Functions and Worksheet Functions
  • Difference between R1C1 and A1 style referencing
  • Difference between Worksheet Functions Vs Active.cell Formula
  • Getting started with VBA Excel Functions
  • Getting started with WorksheetFunction
  • Working with Function Procedures
  • Getting started with User Defined Functions (UDF)
  • Fixing arguments of Formulas in VBA
  • Working and Creating Customize Functions
  • Error Handling & Debugging Techniques
  • User Form Introduction
  • Exploring Form Controls & ActiveX Controls
  • Exploring UserForm Controls
  • Cycle/Sequence to follow to create UserForm
  • Validating User Inputs
  • Testing a UserForm
  • User Form Tricks
  • Understanding User Form Events
  • Working with Pivot Tables
  • Charts
  • Sorting & Filtering
  • Add-Inns
  • Type of different Excel events
  • Starting an application from Excel
  • Interacting with Microsoft Office Apps
  • Controlling Excel from another application
  • Sending Personalized emails via Outlook
  • Sending e-mail attachments from Excel
  • Working with Files & Folders
  • Converting / Saving Excel Files into PDF

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.

Power BI

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
Creating Reports
Visualization
Real-time insights
Dashboarding
Business intelligence workflow

  • Difference between Business Analyst & a data analyst
  • Business Understanding & Data Understanding
  • Data Analysis & Data Visualization
  • Data Cleaning & Preparation & methods used with some examples
  • Tools for Data Analysis & Visualization
  • Some charts & best practice related to them
  • Some data connectors in Power BI (Excel/txt,csv)
  • Basic elements of power BI their differences & use
  • Ways of PBI desktop App installation & system requirements
  • PBI desktop App interface Explanation
  • Modeling Basics
  • Creating Relationships
  • Normalization-Denormalization
  • Dimension & Fact Tables
  • Relationships (Autodetect, Manual & Autodetection settings)
  • Cardinality
  • Active & Inactive Relationships
  • Some Basic Data Cleaning Operations
  • Data Transformation
  • Merge & Append Queries
  • Interview Questions related to query Editor
  • DAX Basics
  • Row & Filter Context
  • Measures & Calculated Columns
  • Some DAX Functions
  • Various Types of Filters
  • Various Types of Visualizations & Formatting Options
  • Story telling & Dashboarding
  • SQL server
  • Odata feed
  • Blank Query
  • MS Access
  • Real Time Data Streaming
  • Web
  • Pdf
  • Folder
  • OLE DB

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.

12 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

Instructor-led

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.

Placement

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.







Learn free on the App
Download the lessons and learn anytime, anywhere from the free courses available on our app

Scan this QR code on your camera app to download the app

OR

Learn free on the App
Download the lessons and learn anytime, anywhere from the free courses available on our app

Scan this QR code on your camera app to download the app

OR