Excel tutorial basic formulas and functions

Excel tutorial basic formulas and functions
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. When the = sign is typed Excel ...

Create an Excel template from an existing spreadsheet and save time

Create an Excel template from an existing spreadsheet and save time
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

Excel tips and tricks: how to draw a floor plan
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 ...