Master Excel With Your Keyboard

Pivot tables, Vlookup/Hlookup/Index/Offset with Match, Formatting, If functions, Filtering, Financial Analysis & more.

What you'll learn:

• How to use keyboard shortcuts to speed up how quickly you perform tasks in Excel
• Combining lookup functions (like Hlookup and Vlookup) with the Match function to make them even better
• Creating Pivot Tables and using them to quickly glean insights about your data through 2 practical examples
• Advanced conditional formatting to highlight data entries which match a range of criteria
• Essential Excel formulas: the Sumproduct formula, the If function, the nested If function, the AND function, the OR function and numerous text functions etc.
• Financial functions like the Net Present Value, Internal Rate of Return and Future Value etc.
• Data analysis skills such as how to conduct linear regression
• Mathematical formulas such as Sum, Covariance, Variance, Average, Round etc.
• A range of topics related to finance such as asset pricing models (CAPM and Fama-French 3-factor model), bond valuation and the time value of money etc.
• Solving business problems using tools like Goal Seek and Solver

If you're a beginner level (or intermediate level) Excel user, this course is for you. This course will introduce you to a range of skills and functions that are vital for any office job. Not only will this course make you more knowledgeable, it will make you a much faster Excel user too through a heavy focus on using the keyboard (instead of the mouse) wherever possible.

By the end of this course, the key skills that you will have learned are as follows:

• Quickly format your Excel workbooks using a range of easy-to-remember keyboard shortcuts to improve the presentation of datasets.

• Use advanced conditional formatting to quickly highlight entries in your dataset which match a range of criteria.

• Use If functions and nested If functions to help you categorise your data.

• Use a range of lookup functions (and combine them with the Match function) in order to quickly pull up relevant data in your Excel worksheet.

• Use Pivot Tables to quickly extract insights from your dataset.

• Learn mathematical functions and also learn how to conduct linear regression in your Excel workbook to measure and quantify relationships between variables.

• Learn about financial functions in Excel which will then be applied to bond valuation problems.

• The many uses of the Sumproduct formula.

You will be introduced to all these key skills and more through watching videos and you will have an opportunity to consolidate and apply these skills through a number of assignments (there are 7 main assignments) that are included in the course.