**** 2000+ Students enrolled ****
To get the most out of Excel in the quickest time, you should learn the most useful formulas first. This course is aimed at teaching you the functions that you are most likely to use and that you will get the most benefit from.
The course is divided into 5 sections:
Each lecture includes the spreadsheet used in the lecture, which you can download and use. The course also includes a summary and quiz at the end of each section.
This course is not aimed at advanced users, but rather at those new to Excel or those who are still not confident about using functions in Excel such as lookups (VLOOKUP, SUMIF) or logical tests (IF,AND,OR).
Each lecture is concise and to the point - we don't waste time on theoretical discussions, but concentrate on building essential Excel skills.
The SUM formula - the most basic and widely used formula.
SUBTOTAL - how and when to use this formula, that is better than SUM when we deal with subtotals.
A very useful function for counting items in a list.
AVERAGE, MIN and MAX - functions that you will want to use frequently when analysing a table of figures.
Summary of the concepts learned so far.
Understand how Excel using relative formula referencing and how to use this function.
How and when to fix the row reference when copying a formula
How and when to fix the column reference for a formula
How and when to fix both the column and row references for a formula
DAYS-a very useful function for payroll or other business calculations based on 2 dates
A useful function that allows us to work out days worked and to automatically deduct holidays/vacations simply by listing the dates.
Two very useful functions to convert Arabic to Roman numerals and vice versa.
Functions that are valuable when we need to correct the format of text.
Useful functions for extracting data from a string of text or figures.
More useful data extraction tools: LEN and RIGHT
CONCATENATE - joining different bits of text
Using VLOOKUP with the TRUE condition
Using VLOOKUP with the FALSE condition to find an exact value
Using HLOOKUP for horizontal lookups
SUMIF - for adding numbers based on a specified condition
SUMIFS-adding a range of numbers based on two or more conditions.
OFFSET - a function that lets us select a range eg create a table for a year-to-date profit and loss statement
A summary of this section; VLOOKUP to OFFSET.
One of the most useful functions in Excel - the logical IF function
Taking the IF statement a step further and adding another condition
Formatting cells based on specified conditions
AND - the logical test that requires more than one condition
OR-the logical function that looks for more than one possible condition
Using IFERROR to avoid errors when we divide by zero
PMNT-finding the payment for a loan based on certain inputs
Finding the PV of a loan - useful for determining the size of a loan that can be afforded
NPER-number of periods of an investment - useful for finding out how long an annuity will last
FV-future value, used for finding the future value of an investment
My name is Andrew and I'm originally from South Africa. I have a two degrees in Accounting and Business Management and I qualified as a Chartered Accountant. I gained extensive experience as a CFO and Financial Manager in several industries from manufacturing to diamond mining to fashion clothing. I have always enjoyed Excel and financial modelling, and honed my skills at companies listed in New York and London. I have several courses on Udemy and enjoy sharing my skills with others..