How to Use Slicers in Excel
Slicers act as visual filters, allowing you to filter and visualise your data as either in a table or as…
Read moreSlicers act as visual filters, allowing you to filter and visualise your data as either in a table or as…
Read moreIn the example below there are 7 employees A to G and their monthly sales total. This is how you…
Read moreExcel isn’t just for numbers, data and formulas. Surprisingly the data analysing, number crunching software can be used to create,…
Read moreBeing able to check that the criteria of data entered in to a cell range is useful function in Excel,…
Read moreThe formula you use to merge cells in excel is typing &” “& between each selected cells and then press…
Read moreTo calculate the Standard Deviation in Excel, you start by clicking on the formula tab on the ribbon and then…
Read moreA Gantt chart template for Excel will allow the user to schedule tasks in a specific project that will chart…
Read moreUsing the IF function in Excel can be very useful in a spreadsheet. The IF function will allow you…
Read moreMaking a graph in a Excel spreadsheet is fairly simple and can be used to show data in a more…
Read moreIf you want to insert random numbers into an Excel spreadsheet, Excel has two inbuilt Random Number Generator functions that…
Read more