What you'll learn

1. Creating spreadsheets and effectively navigating through them.
2. Managing large data reports using PivotTable tool and Filtering options.
3. Become Guru in using Excel most popular functions such as VLOOKUP, SUMIFS and many others.
4. Become competent to work in financial industry.

Requirements

Be able to use a PC at a beginner level.
To have MS Excel (ideally 2016 version). All exercises can be performed on MS Excel 2010 and newer.

Description

Enrolling this course, you will learn everything you need to know in MS Excel in order to start your career in Financial Industry. As your instructor I will use years of experience in Financial analysis in Excel to guide you step by step to the point where you will be able to execute tasks that are common to Financial industry.

Course starts with some basics functionalities to become familiar with Excel surroundings and with that knowledge you will be able to perform more complex topics. Also, you will be able to learn on real-life examples from Financial Analyst jobs.

After completion of this course you will become competitive for any job in Finance industry and be able to solve all tasks with confidence. Most important topics that you will be able to execute after completion:

Creating spreadsheets and effectively navigating through them
Managing large data reports using Pivot Table tool and Filtering options
Become Guru in using Excel most popular functions such as VLOOKUP, SUMIFS and many others
Become competent for any Finance job

All exercises are up to 3 minutes long, so in case you need to revise some function you can find it very easily.

Who this course is for:

If you are starting to work as Financial or Accounting analyst.
If you are looking for the job in the Financial industry this course is great starting point for you.
If you are looking to improve your Excel skills to be more effective on any job which require Excel knowledge.
If you never used Excel before and you need to master it in a very short time.

Homepage: https://www.udemy.com/course/microsoft-excel-for-financial-analyst-career/