12/01/2016
Inserting a hyperlink in your spreadsheet? Ctrl+K to the rescue!
Insert a hyperlink in no time on your PC or Mac with this Excel 2016 shortcut.
Excel in 5mins
Short video clips
12/01/2016
05/01/2016
If you’re good with Excel, this is the coding language you should tackle first Not all coding languages are created equal.
05/01/2016
One way to not look like an amateur spreadsheet user is simple: Check your formulas!
Finding an error in an Excel worksheet does not have to be like finding a needle in a haystack. Use this shortcut to quickly show all formulas.
23/12/2015
Very useful shortcut to find sums of columns. Keep this!
Repost from Microsoft Excel
Let Excel do the math for you with this AutoSum shortcut on your PC.
21/12/2015
We continue to look at how to use VLOOKUP Part 2 on 'Grouping many into few'. Wonder how you would credit card bill group items as ”discretionary” or "non-discretionary" each month, using Microsoft Excel? Watch the video!
Please LIKE, and TAG someone that will benefit from this video. TELL me in the comments below, what topics or problems you want to solve in the next video!
DOWNLOAD PRACTICE FILE:
http://bit.ly/1Ys9fd3
USEFUL PAST VIDEOS:
1. How to apply "VLOOKUP" - Part 1: Translating Data (http://on.fb.me/1kdd96O)
2. Sorting lists (http://on.fb.me/1mwDI8H)
Why did I start 'Excel in
Excel in 5mins Short video clips
14/12/2015
Wondered how you can figure out daily foreign exchange for business transactions with ease and accuracy, using VLOOKUP? Watch the video!
Please LIKE, and TAG someone that will benefit from this video. TELL me in the comments below, what topics or problems you want to solve in the next video!
*Link to the Reserve Bank of Australia (RBA) historical exchange rates: http://www.rba.gov.au/statistics/historical-data.html -rates
*Download the practice file data and model answer here: http://bit.ly/1NjWQj2
05/12/2015
How do you apply IF functions in Microsoft Excel to review lines and lines of information, like checking your credit card bill? Watch the video!
Please LIKE+TAG a friend. Leave a comment. REQUEST for topics or problems to solve in the next video!
*Download the practice file data and model answer here: http://bit.ly/1N2Bfv7
01/12/2015
Did you know you can sort your lists with minimal hassle using Microsoft Excel? Watch this video
LIKE + Tag someone that will benefit from this video. Don't be shy to TELL me what videos you want me to make in the comments below!
Want your school to be the top-listed School/college in Melbourne?
Click here to claim your Sponsored Listing.
Click here to claim your Sponsored Listing.
Location
Category
Contact the school
Website
Address
Melbourne, VIC