Back

Duration

1.5 hours

Price

Level

Any Level

Certification

Available

Instructor

GreyCampus Inc.

A best course to familiarize with all Ms Excel advanced concepts related to Financial analysis

Expected learning & outcomes

  • Appreciate the usage of Lookup functions – VLOOKUP and HLOOKUP
  • Explore Reverse Lookup techniques – using INDEX and MATCH
  • Handle formula related errors effectively and perform auditing on the same
  • Generate Pivot Tables and Charts from complex datasets, instantly
  • Explore the various components of Pivot Tables and Charts
  • Implement Slicers and Sparklines to build interactive dashboards
  • Learn the techniques to implement Sparklines in reports

    Skills you will learn

    Analysis, Auditing, Financial Analysis, Microsoft Excel, Reporting, Spreadsheets

    About this course

    This course takes the hands-on approach while getting familiarized with some of the Excel’s advanced concepts. The analysis and dash-boarding capabilities are hence practiced to the fullest.

    At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

    • Appreciate the usage of Lookup functions – VLOOKUP and HLOOKUP
    • Explore Reverse Lookup techniques – using INDEX and MATCH
    • Handle formula related errors effectively and perform auditing on the same
    • Generate Pivot Tables and Charts from complex datasets, instantly
    • Explore the various components of Pivot Tables and Charts
    • Implement Slicers and Sparklines to build interactive dashboards
    • Learn the techniques to implement Sparklines in reports

    Each and every topic mentioned above are explained in detail in the Hands-on videos. Exercises and datasets included in this course are useful to practice and implement the concepts learned in this course. For your reference,additional materials are also provided

    This course is is intended for the financial analysts and business users who are willing to explore the advanced tools present in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.

    LORE ADVANTAGE

    Lore delivers value at the intersection of learning, interests and skills.

    Learn from Domain Experts

    Access learning options recommended by industry experts, professionals and thought leaders.

    Search & Compare

    Quickly search, select and add learning options to your learning list.

    Personalize your feed

    Tell us more about yourself to access the latest learning options, curated just for you.