Excel for Finance Training

Excel for Finance Training

Course Details

  • Modules :                                                                                                     6
  • Projects :                                                                                                   10
  • Eligibility :                                                                                       HSC/SSC
  • Learning Mode :                                                           Online / Classroom
Enroll Now


ONLINE COURSE


CLASSROOM COURSE

INTRODUCTION

Topics include Microsoft Excel, Charts & Graphs, Power Excel, Financial Functions In Excel, Microsoft Excel for Financial Analysis, Power Pivot, Excel Simulations, Excel Reports.

CURRICULUM

Before we talk about the prerequisites, the target audience, FAQs, and career benefits, let’s look at the curriculum of the Excel for Finance Course briefly –

Sr. No. Course Name No. of Hours Course Description
1 Microsoft Excel Course – Beginners 3 This is the first module of the course. In this course, you will learn the fundamentals of MS Excel course. This is important if you’re learning MS Excel for the first time. You will learn about functions, formulas, charts, pivot tables, freeze, split, Count-If, Sum-If etc. You need to watch 30 videos to cover the module.
2 Microsoft Excel – Advanced 6 This is the extension of the previous module. In this module, you will learn about a few useful excel functions, data function, What If Analysis, arrays, names & dynamic range, form controls, advanced charts etc. You need to watch 61 videos in total to cover the whole module.
3 Microsoft Excel Charts and SmartArt Graphics 7 In this Excel for Finance Course, you will enter the nitty-gritty of how a financial analyst should know about MS Excel. In this module, you will learn about pictures, clip arts, excel chart, data table, pie chart in excel, line charts, bubble chart, surface chart, pyramid charts, aspects of scatter plot, etc. You need to watch 51 videos in total to cover the module.
4 Power Excel Training 5 In this module, you will learn about functions, VLookUp, future value function, business information, database information, data comparison & filter, pivot chart, power view etc. You need to watch 47 videos to cover the module.
5 Microsoft Excel Reports 9 This Excel for Finance Course module is dedicated to how you can create a report using MS Excel. You will learn the shortcut functions, excel functions, vertical lookups, financial function, and average if function. You need watch 56 videos in total to cover the module.
6 Microsoft Excel Simulation Training 2 In this Excel for Finance Course, you will learn about data simulation. You will learn in length about data simulation, goal-seek, table simulations, data validation, macro filters, and Monte Carlo simulations. You need to watch 19 videos to cover the whole module.
7 Financial Functions in Excel 2 In this Excel for Finance Course, you will learn the nitty-gritty of financial functions. You will learn about future value, Si, Ci, PV, NPer, Rate, the value of an investment with multiple cash flows, calculating the rate of return, analyzing loans and payments, and bond valuation. You need to watch 23 videos in total to cover the entire module.
8 Pivot Table 1 In this module, you will learn about the features, layouts, and updating data in Pivot. You will also learn about pivot tables, formatting multiple files etc. You need to watch 9 videos in total.
9 Power Pivot in Microsoft Excel 2016 3 In this Excel for Finance Course, you will learn about the power pivot GUI, data import, formatting, pivot chart example, pivot table example, and inserting slicer. You need to watch 21 videos to cover the whole module.
10 Advanced Excel 2016 – Some Important Features 4 In this module, you will learn a brief overview of the advanced features of MS Excel. We will also talk about the shortcuts, excel control, cell comments, named ranges, and also advanced formulas. You need to watch 19 videos to cover the entire module.
11 Microsoft Excel Solver Tutorial 1 In this short module, you will learn about the introduction to excel solver and about describe solver. Then, we will go through a solver example and discuss the solver in excel for simultaneous and minimizing shipping. You need to watch 7 videos in total to cover the entire module.
12 Mastering Microsoft Excel Date and Time 3 As we always start a module, we will start with a brief introduction. Then, you will learn about the date value, time value in the excel, and date & time formats. Finally, we will discuss functions related to MS excel date & time like timed-if, dated-if. You need to watch 31 videos in total to cover the module.
13 Date and Time Functions Microsoft Excel Training 3 This Excel for Finance Course is focused on date & time functions of MS Excel. First, we will start with a brief overview and then, we will talk about date format & function, and day function. You need to watch 15 videos in total to cover the whole module.
14 Building Dynamic Heat Map in Microsoft Excel 2016 1 In this module, we will start with a brief introduction to a heat map, an example, and formatting rules for the dynamic heat map in excel. Then, we will discuss how to create a heat map using sales data and how to display data using a channel. This entire module will need you to watch 9 videos.
15 Microsoft Excel for Financial Analysis 1 In this last module, you will get the crux of this entire Excel for Finance Course. You will learn the basics of financial analysis – NPV & PV function. You will also learn about IRR, Max-Min, Sum If, and also about loan schedule. You need to watch 6 videos in total to cover this module.

TARGET AUDIENCE

  • Students of Finance: If you’re a student of finance (no matter what – graduate or undergraduate), this Excel for Finance Course would be the perfect one for you. And we encourage you to do it before you apply for any job. Doing this course will allow you to have an edge over others and you would master spreadsheets for finance.
  • Finance Professionals: If you have been running the show in finance for a long time (or maybe for a few years), you know what role MS Excel plays in getting things right. If you do this Excel for Finance Course, this may act as a refresher and you also may learn a thing or two about the spreadsheet management.
  • Entrepreneurs: When you’re starting out a business, spreadsheet is your friend. And by all means, you need to make sure that your numbers are right so that you can raise the money for your venture. Doing this course would be a critical step toward making things right and as a new entrepreneur you would learn a lot about getting the numbers right through MS Excel.

Alert: You are not allowed to copy content or view source !!