Call :+91 9899571617

Our Successful Students :

Aneet Singh (Senior MIS Executive, Barclays, Noida)

I am really thankful to Mukesh Sir, who is the epitome of knowledge and inspiration for me. The real digital horizon of my mind is nothing but a result of an efficient training provided by Excel Guru. I am really happy to be a part of it. Oh! Such a great institute!

Pradeep Upreti (MIS Executive, Exl Services, Noida)

I was so confused in finding out a correct institute, when I decided to learn Advance excel. Luckily, I landed up in Excel Guru, where I found excellent learning environment and teachers who became my mentors.

Pradeep Viswakarma (Sr. Manager, W3webinfotech)

After joining Excel Guru, my career got the correct direction as I realized that Advance excel and this institute in particular has lots to offer in terms of career growth and learning curve.

Vikrant Goel (Senior Executive, Wipro)

  • I always wanted to make MIS as my career choice. However, I did not know how to make a start. Then, I joined Excel Guru to learn the variety of courses it provides. I did not know that I would have such good time while learning this course. I am satisfied that I made the best choice I could make.

    praveen mishra (Assistant Manager, Netambit)

  • I would like to express my gratitude towards Excel Guru as it really helped me in learning about Advance excels. Now I can use my deep knowledge which I gained from Excel Guru. I am now working with a reputed company and I am very happy that I made the correct choice of joining Excel Guru.

    Aditya Sharma (Senior Executive, Hindustan Times)

  • I would really like to thank Mukesh Sir, who gave me the right advice. She became my mentor and helped me a lot. I am happy that I joined Excel Guru and found her.

    Mahesh Yadav  (Executive, TATA Business Service)

  • I was unable to give a proper direction to my career as I did not take any professional course in my graduation. Therefore, the options I was left with were only limited to BPO’s and call centers. I could not understand how to save myself from the hectic night shift jobs. Luckily, I found extremely talented people in Excel Guru, who not only helped me in building up my skills but also in finding out a good job for me. I would happily recommend Excel Guru to everyone who wants to learn about Advance Excel.

    Dashboard Making

    DASHBOARD Making Tutorial:

    Dashboard reports allow user to get high-level overview of the business and help them make quick decisions. Dashboards are often called as Management Information System (MIS), which provides information that organizations require to manage themselves efficiently and effectively.

    Excel dashboards and executive reports are powerful, fairly easy to design and a great way to improve your Excel and data visualization skills. Because of its flexibility, you can virtually design any dashboard in Excel exactly the way you, or the users, imagined.

    To Define KPIs (Key performance Indicator), Customer Service Dashboards or Project Management

    Once you know what will the Excel dashboard be used for and what kind of metrics users expect, there are three major areas that you must address when creating it:

    • How to bring data into your spreadsheets;

    • How to manage the data and link it to the dashboard objects, like charts and tables;

    • How to design the dashboard report.

    Dashboard reports give valuable insights into the key performance indicators of the business, and perhaps most importantly; they’re interactive, which means the reader can filter and change views.

    The good news is that creating Excel dashboard reports is easily done without the need for any other additional software.

     

    Steps to Create Dashboard

    1. Researching Your Dashboard

    * Find out the underlying reason for the dashboard request.
    * Are there specific KPI’s they want to see.
    * Where will the data come from
    * How often will it be updated
    * Who will receive the report and in what format

    2. Draw your Excel Dashboard ( Draw the Prototype on Paper)

    3. Setting Up Your Excel Dashboard File

    * Raw data (you might need more than one of these)
    * Analysis (you might need more than one of these)
    * Dashboard

    4. Analysing your Data

    Get Your Tools Ready with help of Excel formula’s and Funcations key ones are:

    * SUMPRODUCT, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF & COUNTIFS

    * COUNT, COUNTA, MIN, MAX, SMALL, LARGE, RANK

    * Database Functions like DSUM, DAVERAGE, DMAX etc.

    * VLOOKUP, HLOOKUP, INDEX and MATCH

    * IF, Nested IF’s, IFERROR, OR and AND

    * OFFSET, INDIRECT, CHOOSE

    * GETPIVOTDATA

    Other Tools in your Excel Toolbox are:

    * PivotTables

    * Excel Tables

    * Data Validation

    * Conditional Formatting

    * Form Controls

    * Shapes

    * Named Ranges

    5. Start Crunching the Data

    6. Building Your Excel Dashboard

     

    Get in Touch 9899571617

    HTML Logo Excel Guru ji (Mukesh Yadav) is a qualified MCA, BCA and possesses 6 year of diversified industry exposure in the field of Telecom, Insurance, Real estate, Finance, IT, Telecom and healthcare. Currently working as Lead Start Ops. He is professional in handling the Financial Modeling, Strategic in Financial Management, Advance Excel, Excel Dashboard Making & reporting, VBA coding expert.
    Famous for his unique method of teaching, cover the entire topic deeply and have faith in the real scenario only. He is passionate about Data Analytics and Visualization. His Training modules are specially designed to meet the day to day challenges faced by individuals in today's corporate world involving various departments (Operations, MIS, WFM, BSS, Finance, Human Resources, and Quality)
    Request a call back