Excel linking sheets and combining data from multiple sheets.

Excel linking sheets and combining data from multiple sheets.
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 Shift-click for adjacent spreadsheets on the tabs with the spreadsheet ...

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

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

Excel beginners quick start, create your first spreadsheet in minutes

Excel beginners quick start, create your first spreadsheet in minutes
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, ...