Essentials of Financial Analysis using MS Excel

Rapid Skillz

Preis auf Anfrage

Wichtige informationen

  • Short course
  • Beginner
  • Online
  • Dauer:
    1 Year
  • Wann:
    Freie Auswahl

In this ever-changing business environment, being able to accurately analyze economic inputs is a critical skill for business users. Microsoft Excel comes with several built-in financial functions which perform many of the commonly used financial calculations. Whether you are new to Excel or an advanced user, course will cover what you need to know to become an expert in using Microsoft Excel as a sophisticated Financial Analysis tool. 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.

Wichtige informationen
Welche Ziele verfolgt der Kurs?

The Objective of this course is to enable understudies to understand and 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.

Voraussetzungen: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment


Wo und wann

Beginn Lage
Freie Auswahl

Was lernen Sie in diesem Kurs?

Microsoft Excel
Financial Training
Microsoft excel training
using Excel
MS Excel


This Course Consists of the following Contents -1.Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP, 2.Reverse Lookup techniques – using INDEX and MATCH, 3.Effective Error handling – using ISERROR/IFERROR, 4.Tracing formula dependents and precedents, 5.Using formula auditing tools to avoid errors, 6.Creating Pivot Tables using complex datasets, 7.Generating Pivot Charts Instantly, 8.Implementing Slicers to build Interactive dashboards, 9.Grouping and Sub Total of Data in Pivots, 10.Beautifying reports / tables using Sparklines. Through these subjects skills are developed and knowledge is acquired in order to fulfil a position or job efficiently and with confidence. Our online methodology makes it easier to combine your professional and personal life. Even you have a busy day to day live, this course adapts itself to your routine. Should you have any doubts, please do not hesitate to ask for more information through Emagister, leading educational portal.

Zusätzliche Informationen

This Course is made for Students and the Professionals can able to perform all Data Manipulation, Formatting & Navigation techniques easily on any financial analysis data. Gain good opportunity in investment banking, financial analysis and consulting companies with good hike in salary, As per the Microsoft survey, Excel programmers are earning more than their colleagues. At the end of the day, everything an financial analyst does is all about dollars and cents and best way to calculate that bottomline is to organize those numbers is a spreadsheet and to work on it.