Essentials of Financial Analysis using MS Excel

Rapid Skillz
Online

Price on request

Important information

  • Short course
  • Beginner
  • Online
  • Duration:
    1 Year
  • When:
    Flexible
Description

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.

Important information
What are the course objectives?

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.

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

Venues

Where and when

Starts Location
Flexible
Online

What you'll learn on the course

Excel
IT
Microsoft Excel
Financial
Financial Training
Microsoft excel training
using Excel
MS Excel

Course programme

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.

Additional information

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.