Name: Microsoft Excel for Finance
Brand: The WallStreet School
SKU: 5dd2e1c5e4b08715204aeec1
Price: 1990 INR
Availability: InStock

Microsoft Excel for Finance

Instructor: The WallStreet School

Language: English

Validity Period: 180 days

Max Viewing Hours: 35 Hours

₹5000 60% OFF

₹1990 including 18% GST

Description
Courses Content
How to Use

Who is this Course for?

The course is not just for people who want to enhance their Excel skills from Beginner to Pro Level, but also for all the candidates who want to specifically to make an entry into Core Finance Job roles.

Essential Features?

Remove the habit of using a mouse with a keyboard
Formulas, Shortcuts, Functions, Charts, Dashboards, etc
Linkage of MS Excel with Finance Job Roles in Practice
Ready-made Excel templates for practice and reference
HD Video content developed by Investment Bankers
View videos on Android, IOS or Website from anywhere
Assignments and Quizzes at the end of the course
Essential Job-specific skills apart from Just MS Excel

Other Courses


	Basic MS Excel Videos
		Introduction to Excel
		Sum, Count, Average, Median, filter, Max, Min, Sort, Advance filters, Transpose, Arrays
		Text functions, concatenate, cell freezing, sensitivity analysis, Data Table
		EMI Calculation, introduction to developer tab, goal seek, Use of scroller
		If condition, Multiple Ifs, If or, If and or, Conditional formatting, date and time formulas
		If condition examples, Sumif(s), Countif(s), Averageif(s), rank of numeric and alphanumerics, CAGR - Annual, Monthly & Daily data
		Basic Charting Rules of Bar Chart, Making chart with secondary axis + Cheat sheet for revision
	Basic MS Excel Working File
		Basic Excel Working File
	Advance MS Excel Videos
		Introduction to Vlookup + Example of Vlookup + CAGR, Usage of exact range, approximate range
		Advance Usage of Vlookup, introduction match formula, limitation of Vlookup, using a combination of Vlookup +Match, Introduction to Hlookup, combination of Hlookup and Match
		Complex Usage of Vlookup + Match, Hlookup + Match
		Introduction to Index, Offset with granular understanding , combination of Index and Offset, Index and Offet superceding Vlookup
		Advance complexity of Index and Offset in mathematical functions
		Using Formulas learnt to make dynamic charts, highlighting months with highest and lowest sales, making dynamic doughnut chart using scroller showing product wise sales for multiple years
		Advance Level Dynamic Charting though the use of formulas, how to compare industry with company products through dynamic charting, use of scroller to control what financial data should be seen and not seen
		Usage of Choose Formula and making Basic Dashboards for showing financial data dynamically through charting , rebasing of stock price data for parity and comparison
		Use of formulas learnt above for creation of advance Dashboards and how to use conditional formatting to get the desired results for a blunt data pull
	Advanced MS Excel Working File
		Advance Excel Woking File
	Assessment Test for Advanced Microsoft Excel Certification

Sign Up

Log In

You may also be interested in

Microsoft Excel for Finance

₹1990 including 18% GST

Who is this Course for?

Essential Features?