Excel linking sheets and combining data from multiple sheets.

Excel linking sheets and combining data from multiple sheets.
Link Excel work sheets to combine data and save time Excel linking sheets and working with data from multiple sheets. In this Excel video tutorial I will discuss Excel linking sheets and combining data from multiple sheets. To enter  data on multiple spreadsheets in the same workbook.0pen all spreadsheets concerned by CTRL-click for non-adjacent and ...

Excel tutorial basic formulas and functions

Excel tutorial basic formulas and functions
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

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 ...