Excel Crash Course by FinXcel Academy

[mitsumi]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 10 lectures (57m) | Size: 421.8 MB

Covers most used functions in excel

What you'll learn:
Data Importing, analysis and presentation in excel with examples and solved problems
Data importing, filter, sorting, charts, pivot charts,
Functions like NPV, IRR, VLOOKUP, IF, ADD etc

Requirements
Very Basic knowledge of excel
Access to Microsoft excel

Description
This course covers most commonly used functions in excel in a very simple and structured manner. The examples and structure of the course has been designed by a finance professional with 15 years of working experience with Excel. Excel is one of the best available tools in the market to analyze and summarize data. While this course is useful for beginners across all fields; this is particularly recommended for those studying or working in finance.

It covers all the key functions available in excel including data import, sort, filter. The course also covers key Maths functions like ADD, SUBTRACT etc and finance functions like NPV, IRR etc besides introducing the commonly used VLOOKUP and IF functions. There is a lecture on Pivot Tables also which are extensively used to summarize data .The course ends with examples of basic visualization of data in excel through Charts functionality.

The course should be particularly useful for someone starting to learn Excel and/or someone who is looking to refresh his/her excel skills. The course is designed in a simple manner with examples and also has a problem sheet (with solutions) at the end for the students to practice. We also encourage the learners to take out more practice questions and practice. Excel is best learned with practice.

Who this course is for
Anyone looking to learn excel most used formulas and functions
Financial /Equity Research Analysts
Financial Modelling

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction