admin-ajax

blurred-colors-abstract

Advanced Excel

Get a Callback!



Course Features

 

    1 on 1 sessions


    Free cloud access


    24*7 call support

    VM for practice.


   Free cloud storage


   Microsoft Financial                 Certification

    Video Lectures


    Complete modules


    Multiple batches

 

One Stop Solution!

Syllabus

 

Design and risk

  • Get a head start with templates

  • Set up an Excel template that will save you an hour each time you create a new workbook

  • Create new default workbook and worksheet templates

  • Learn how modular templates can make your spreadsheets more consistent and much quicker to set up

  • Your Excel, your way: customize the Excel interface to put the tools that you need at your fingertips.

  • Efficiency and Risk

  • Make spreadsheets more efficient and less risky

  • How to build in checks and controls from the outset

  • Key techniques that reduce risk and increase automation and efficiency

 

Functions & SuperPowers

  • Functions with superpowers

  • Finding the right functions and how they work

  • Functions with hidden powers – MOD() for patterns, OFFSET() for simple choices, INDIRECT() to manipulate formulae

  • Making references to ranges of cells adapt automatically for new data

  • Array formulae

  • One formula, one million calculations

  • SUMPRODUCT() - all the gain of an array formula with less of the pain

  • Tables – structure comes to Excel

  • Why Tables are so much more than just a new format

  • Make your spreadsheets more automatic with a single command

  • Table formulae – instant readability

  • Data tools in Tables

Excel interactivity

  • Form Controls
  • Use Form controls to make life easier for users

  • Use a Spin Button to choose a value easily

  • Use an Option Button to choose with a single click

  • Choosing from lists

  • Visual Basic and Macros

  • Create macros by writing Visual Basic code

  • A macro that performs one or more actions on selected cells

  • Write your own Excel functions with VB code

  • Understanding volatile functions

  • Trigger a macro when a particular cell is changed

  • Handling errors elegantly

 

Graphics I

  • Practical Interactivity with VBA

  • Exchanging information with VB code

  • Displaying a Message box

  • Asking for user input using an Input box

  • Create an Excel form with a List box containing values from a range of cells

  • Sample VB projects: an automatic index to sheets, printing selected ranges

  • Avoiding macros when they’re not really necessary

  • Conditional Formatting

  • Conditional Formatting

  • Basing conditions on a formula and deciding whether a batsman is out or not

 

Graphics II 

  • Choose currency symbols for a whole sheet by changing a single cell

  • Getting your rules in the right order and knowing when to stop

  • Graphical Conditional Formats

  • Using invisibility to your advantage

  • Charts that Inspire

  • Create charts to inspire

  • What makes a good chart

  • Simple steps to make your charts clearer

  • Why small can be better than large

  • Are pie charts evil?

  • Why 3D charts can be 50% worse

  • Mixed chart types, trendlines and projections

  • Advanced chart techniques

  • Pictures in chart columns

 Sparklines

  • In-cell charts

  • Careful with that Axis

  • The different types of Sparkline

  • Sparklines based on a dynamic data range

  • Graphics Tricks and Techniques

  • Further graphics tips and techniques

  • Taking dynamic pictures with the Excel camera

  • Use the Excel camera to combine areas from multiple sheets on the same sheet of paper

  • Formatting Excel Camera pictures

  • Power View

Turning data into decisions I

  • Working with External Data

  • Getting at your data using the Get External Data tools

  • Understand relational databases

  • Excel 2013 Data Model create relationships

  • Advanced Uses of PivotTables

  • Use advanced PivotTable techniques

  • Calculated Fields and Calculated items

  • Using PivotTables as the calculation engine

  • Using GETPIVOTDATA() and CUBE

  • Excel 2010 and 2013 Slicers and Timelines

  • Working with Pivot Charts

  • Building and interactive dashboard using PivotTables and Slicers

  • Power Pivot

Turning data into decisions I

  • The Excel 2010 and 2013

  • Power Pivot data tools

  • Calculations in Power Pivot

  • DAX in table columns

  • DAX to create new measures and calculated fields

  • Understanding advanced DAX expressions

  • the Time Intelligence DAX functions – why you need a table containing all possible dates

  • Reporting with Power Pivot

  • Creating powerful reports with Power Pivot

  • Hierarchies, Perspectives and Sets

  • Adding Key Performance Indicators (KPIs) to a Power Pivot report

  • Creating CUBE formulae

  • Use all these techniques

 

 companies that hire

 

 

  1. Freshers who have completed their Graduation
  2. Database Developers working with Oracle,Sybase DB2 etc
  3. Mainframe developers working with IBM mainframe or AS400
  4. Application Developers working with JAVA,C# etc
  5. ETL developers or BI consultants (informatica, datastage, cognos, etc)
  6. Testing professionals working with Manual or Automation testing
  7. SAP professionals

 

 

FAQ's

 

Q: What if I do not know  Excel & Spreadsheet?

Ans: We will provide you complete support  Excel & Spreadsheet

 

Q: What if I miss a lecture?

Ans: We have multiple batches running simultaneously, so if u misses a lecture u can attend it in next lecture.

 

Q: Do you have multiple centers?

Ans: Yes, we have multiple centers.

 

Q: Would you provide Job assistance?

Ans: Your profile would be evaluated by experts, your resume would be rated and you would start getting calls after completion of your module.

CLICK HERE TO PAY REGISTRATION FEE ONLINE

Advance Excel Training in Pune

 Microsoft Excel lets you turn your raw data into a variety of charts and graphs. Using this feature, you can visually summarize numerical information and display any trends or patterns that are present Charts and graphs can help make your data more meaningful and easier to understand. Advance excel doesn’t mean knowing how to use visual basics and use excel as database but advance excel means knowing all the functions making graphs, pivot charts, vlookups, truncating text, if statements etc. Excel is a greatest piece of software ever developed. The economy rely on the program and becoming skilled at excel has become a license to print money in business. Need for more demand of excel advance is growing rapidly in the business field. Looking at the market requirement Itelligence is specialists in offering expert training courses to learn Advanced Excel.
As part of our Advanced Excel training, students will gain the necessary knowledge required for the efficient of the tools and other exciting software has to offer, and so ensure client’s optimum use of Excel. In turn, to learn Advanced Excel through Itelligence means that you will go from being a meager novice to an expert user in just a couple of days.
There are many features which Advanced Excel has to offer to its user. The in depth training which we give to our clients in order to learn Advanced Excel as such focuses on each and every feature and tool included in this supreme software. Itelligence training institutes leaves no stone unturned when it comes to making sure that our clients learn the Advanced Excel software effectively and efficiently. In this way you will have the capabilities and required knowledge to really unleash the great power of Advanced Excel.
top
ETLHIVE is a Trademark of Itelligence Infotech Pvt Ltd.
19th Feb FREE DEMO(P.SAUDAGAR)|Data Science-12:00 PM||18th Feb FREE Demo(P.SAUDAGAR) Hadoop-02:00 PM | | Informatica-03:00 PM|Selenium-09:30 AM| Angularjs 10:30AM| (NALSTOP)-Hadoop-04:00 PM |Informatica-11:30AM ||AngularJs-03:00 PM (KHARADI)- Hadoop-09.00 AM || AngularJs 04:00 PM | Selenium -03:00 PM