DIY VIDEO TRAINING

Tips for a better general layout

We make many spreadsheets for businesses like yours, and we are constantly improving people’s spreadsheets to make them more productive. Although we do achieve more with Excel, there are some simple changes that you can make, in order to improve your spreadsheets. If you would like us to put our experience to good use, please get in touch. If you would like to make your own spreadsheets, then here are 5 tips to help you create a better spreadsheet.

There are 5 videos below (plus a bonus video) to make up the 5 parts of this series. Click on any headers to see the respective video.

Layout

Locking & Unlocking Cells
Conditional Formatting
Design
Hiding Zeros & Errors
5 Common Myths About Spreadsheets

Training for specific functions and formulas

If you’re keen to do your own spreadsheets, you’re in the right place. We have some videos below, which will show you how to do some functions and formulas for yourself. If the solution below is not enough for you, get in touch with us for a bespoke solution. If you’re looking to do your own simple solutions, then watch the videos below, and try it out for yourself. We will add new videos periodically.

The videos below are all rated with a difficulty rating, so you can easily see how they compare when deciding which ones to watch. Once you have watched a few videos, you should get an idea of what type of videos fall in each category. The colour ratings are as follows:

Gold – These videos are the most difficult of the videos. We don’t post any really difficult videos, but the gold ones will be the most difficult of what we post. Usually containing nested formulas and more complicated applications.

Silver – Middle of the road difficulty. If you used Excel often, and are familiar with formulas, you should be alright with these. Watch one silver video, and then you can judge for yourself.

Bronze – These are for beginners. Even if you have never done a formula before, these videos tend to show you simple things that you can do with Excel, and some really basic formulas.

Just click on any of the headers below to reveal that video. The numbers in brackets indicate when that video was released, so the higher the number, the newer the video.

Filtered Drop Down Lists (20)

Highlighting Duplicates (15)

Lookup (Horizontal) (18)

Lookup (Vertical) (3)

Rank Function Alternative (11)

Ranking Numbers (4)

Range Lookup (V & H) (19)

Categorise Sales (2)

Client Follow-Up Alert (1)

Conditional Formatting - Formula (10)

COUNTIF & SUMIF (13)

Basic Conditional Formatting (9)

Creating a Drop Down List (8)

Different Paste Options (6)

Filters & Sorter (16)

Fixed Cell References (7)

Formatting Phone Numbers (21)
Freeze Panes (12)

Locking Cells & Protection (5)

Merging (or Splitting) Cells (14)

Totalling Monetary Values (17)

If you’ve found these videos useful, please use the links below to follow us on social media, where we can keep you up to date.

If you have found these videos useful, please follow us on social media (above this text) or share this page (below). If you would like to see more some DIY training videos, please sign up to receive our newsletter.

We are always looking to do new DIY spreadsheet videos, but we don’t know what you want to know. If you did not find the video you were hoping to, please drop us a message and tell us what you were looking for, and we will consider doing the video of your choice. We will only contact in order to let you know, if we do the video that you have requested.

Your Name (required)

Your Email (required)

Your Video Suggestion

We get quite a bit of spam through this contact form, so please complete these to confirm that you are in fact human.

captcha

Sign up for our monthly email.