Advance Excel Training Pune

Course Abstract Etlhive is an industry aligned Bigdata Analytics Corporate training Company in Pune. We have an Expert Trainers for Advance Excel Training Pune. This course has been designed by team of our experts intending to make Advanced Excel tools accessible to developers in a comprehensive manner. Initial lectures would get a developer acquainted towards workbook and worksheet templates as well as Make spreadsheets more efficient and less risky and associated concepts continued by core-functional …

1176 STUDENTS ENROLLED

    Course Abstract

    Etlhive is an industry aligned Bigdata Analytics Corporate training Company in Pune. We have an Expert Trainers for Advance Excel Training Pune. This course has been designed by team of our experts intending to make Advanced Excel tools accessible to developers in a comprehensive manner. Initial lectures would get a developer acquainted towards workbook and worksheet templates as well as Make spreadsheets more efficient and less risky and associated concepts continued by core-functional part of the technology like Functions & SuperPowers, Excel Interactivity, Graphics, Sparklines. At the end of training, hands on project lets the developers experience real time use cases & project adherence.

    Click here for course related details: Click here

     

    Course Syllabus

    1) Design and risk : Get a head start with templates, Set up an Excel template, Create new default workbook and worksheet templates, Efficiency and Risk, Key techniques that reduce risk and increase automation and efficiency

    2) Functions & SuperPowers : Finding the right functions and how they work, Functions with hidden powers – MOD() for patterns, OFFSET() for simple choices, INDIRECT() to manipulate formulae, Array formulae, SUMPRODUCT() – all the gain of an array formula with less of the pain, Tables, Table formulae, Data tools in Tables

    3) Excel Interactivity : Form Controls, Spin Button, Option Button, Visual Basic and Macros, volatile functions, Trigger a macro

    4) Graphics I : Practical Interactivity with VBA, Displaying a Message box, Asking for user input using an Input box, Create an Excel form with a List box containing values, Sample VB projects, Conditional Formatting, Basing conditions on a formula

    5) Graphics II : Choose currency symbols for a whole sheet, Graphical Conditional Formats, Create charts, Mixed chart types, trendlines and projections, Advanced chart techniques, Pictures in chart columns

    6) Sparklines : In-cell charts, The different types of Sparkline, Sparklines based on a dynamic data range, Graphics Tricks and Techniques, Taking dynamic pictures with the Excel camera, Formatting Excel Camera pictures, Power View

    7) Turning data into decisions I : Working with External Data, Get External Data tools, Understand relational databases, Excel 2013 Data Model create relationships, Advanced Uses of PivotTables, Calculated Fields and Calculated items, Using GETPIVOTDATA() and CUBE, Excel 2010 and 2013 Slicers and Timelines, Pivot Charts, Building and interactive dashboard using PivotTables and Slicers, Power Pivot

    8) Turning data into decisions II : The Excel 2010 and 2013, Power Pivot data tools, Calculations in Power Pivot, DAX to create new measures and calculated fields, advanced DAX expressions, Time Intelligence DAX functions, Reporting with Power Pivot, Hierarchies, Perspectives and Sets, Adding Key Performance Indicators (KPIs) to a Power Pivot report, Creating CUBE formulae

     

    Intended Audience

    HSC, MIS background, back office, People from Finance domain, MBA in any domain, B.A, B.COM or graduation from any background. Professionals from Banking domain.

     

    Course Features

    1) 1 on 1 Sessions

    2) VM for Practice

    3) Video Lectures

    4) Free Cloud Access

    5) Free Cloud Storage

    6) Complete Modules

    7) 24*7 Call Support

    8) Microsoft Financial Certification

    9) Multiple Batches

     

    Course Outcome

    Developer will be proficient in

    1) Write moderate complexity codes and queries for Advanced Excel

    2) Clear an Advanced Excel Interview

    3) Get a component level view over Excel

    Course Reviews

    No Reviews found for this course.

    TAKE THIS COURSE10 SEATS LEFT
    • Rs.4,000.00
    • 5 days
    • 10 SEATS

    Contact Us

    top
    ETLHIVE is a Trademark of Itelligence Infotech Pvt Ltd.