2020 ← Basic Lowdown.. No waffle ← Page 3

Excel charts & graphs quick start tutorial for beginners

Nov

6

2020

Learn the basics of charts and graphs in a few minutes How to create charts and graphs in Excel Description In this excel tutorial I will show you the quickest and easiest way to summarise your data in a chart and how to incorporate the charts into a Word document for a written report or ...

Excel linking sheets and combining data from multiple sheets.

Oct

30

2020

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

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