Excel tips and tricks ← Basic Lowdown.. No waffle

Excel charts & graphs quick start tutorial for beginners

Nov

6

2020

Easy Excel charts 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 a PowerPoint presentation Summary of work sequence. Select data to be included including headings. This can ...

Excel linking sheets and combining data from multiple sheets.

Oct

30

2020

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

Oct

23

2020

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

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