Excel tips and tricks ← Basic Lowdown.. No waffle ← Page 3

Excel tutorial basic formulas and functions

Oct

23

2020

Master Excel with a few minutes study In this Excel tutorial I work through basic formulas and functions. I demonstrate how to use the following Excel formulas. Sum and basic Add, subtract, divide and multiply Max and MinAverageCount and count ifExcel If – function Remember all excel functions and formulas start with the ‘=’ sign. ...

Create an Excel template from an existing spreadsheet and save time

Oct

7

2020

In this tutorial I am going to discuss how to create an Excel template from an existing Excel spreadsheet that you use often and are happy with but which only needs new data entered for each new period. Very often with Excel we find ourselves using the same basic spreadsheet over and over just adding ...

Excel tips and tricks: how to draw a floor plan

Oct

1

2020

Floor plan drawn to scale with Excel In this tutorial I discuss some Excel tips and tricks on how to draw a floor plan. This is a fun project and the advantage of using excel for this is that Excel makes it easy to draw your floor plan to scale. You could use this floor ...

Excel beginners quick start, create your first spreadsheet in minutes

Sep

23

2020

In this video tutorial on how to Quick Start Excel and create your first spreadsheet in minutes. We will only be discussing the basics of Excel so that you can have your first spreadsheet up and running and functional in minutes. Excel is a very powerful and complex programme but don’t let that scare you, ...