Excel in 5mins

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.

05/01/2016

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)

16/12/2015

Why did I start 'Excel in

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!