+91 8130 80 2001

+91 9267 97 4043

Placement

Join Now

The next level of your career starts here.







Estimated Time
4 Months

Pre REQUISITES
Students, Fresher's
Working Professional

Training Mode
Offline, Online

Full Fees
₹ 15,000/-₹ 22,000/-
You Save - ₹ 7,000/-

What you will learn

Introduction to Data

Learn how to use statistics and visuals to find and communicate insights. Develop Excel skills to manipulate, analyze, and visualize data in a spreadsheet. Build Excel models to analyze possible business outcomes.

Excel Power Query

Excel Power Query

Excel Power Pivot

Excel Power Pivot

VBA Macros for Report Automation

Learn VBA Macros to automate Excel, dynamic templates, send emails, automate web browsers, PDF form filling and more.

Curriculum

Our leading edge curriculum covers fundamentals and more complex data and analytics concepts.

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

4 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.

Lifetime Placement Assistance

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.