Microsoft Excel for Financial Analyst Career

Quick introduction before 1st lecture.

In this lecture you will learn how to format cells and how to navigate through the sheet. You can just open blank excel sheet and work in it.

In this lecture you will learn how to manipulate with the sheet - adding new sheet, moving, copying, etc.

In this lecture you will learn how to quickly move around the sheet using keyboard shortcuts. It will save you a lot of time while working on daily tasks. 

In this lecture you will learn how to insert various objects into Excel. Usually, on the job you will have to insert some kind of justification emails. 

In this lecture you will learn how to use various pasting options. This is essential function in Excel and you will learn useful tricks how to use it more effectively.

When working with large set of data, this function will be very useful for creating lists with unique values.  

In this lecture you will learn how to filter large set of data to get only values you need.

This lecture shows you how to sort data in alphabetic order and from smallest to largest number.

With this lecture we will start with formulas. For the beginning just couple of fundamentals information about formulas. In the later lectures we will move to more complex formulas. 

Here we will go through basic task you will need to perform working as Accounting analyst. You will learn how to change amounts from debit to credit side.

In this lecture you will learn how to create formula that sum amounts. 

This lecture will teach you how to find average value from list of amounts. In the reporting tasks you will often perform this function to find average value of sales, revenue, profit, etc. 

This lecture will explain you how and why to link cells in the report you will do on your job.

This lecture will teach you how to connect two cells into one, using two different methods. 

This video will show you how to round numbers to specific number of decimals. When you will be uploading your calculation to some Oracle or SAP system, you will need to round the numbers in order to make it work. In this short video you will teach the most easiest way how to round numbers.

Left or Right function is used when you want to extract part of the characters in the cell starting from left or right.  

With this lecture we will move to a little bit more complex functions. Function IF is used when you want to give some condition, and then based on the result you can choose which actions will happen. 

This lecture is about using Sum If function. This function will sum amounts based on single criteria.

Sum Ifs functions will sum amounts based in multiple criteria's. In the excel sheet you have real life example of what could be asked from you on the real job.

This lecture will teach you how to use one of the mostly used functions - Vlookup. 

Pivot tables are used when you want to manipulate with large set of data and in this lecture you will get knowledge how to create and use pivot tables.