Pivot tables can be used for many things however their best function is served by collating data for you. This is easier to create when the data is presented in log format. What we mean by this is that you should log each transaction individually and not...
Search results
Pivot TablesIntroduction to pivot tables
Excel provides a feature that is intended to split a single column of data into multiple columns. For instance, if you had a column of full names (first and last) and needed to separate these out into two columns:
Text to Columns'Text to columns' is found in the 'data'...
Excel - Find and Replace
Find and/or replace is a powerful feature that allows you to search for a text string within your data set. It will show you all of the times that Excel can see the text string in your document, allowing you to be taken to the next word by clicking the 'next' button. If...
=Sort Function
The SORT function sorts the contents of a range or array.
In this example we are sorting an array of sales which currently unordered. When =SORT(B3:E51) is used we will see the array now sorted by the first column, in this case A-Z of the Item column:
... =Filter Function
The FILTER function allows you to filter a range of data based on criteria you define.
Syntax=FILTER(array,include,[if_empty])
arrayThe array or range to filterincludeThe array from which you'd like to filter results by[if_empty] (optional)The value to return if all... Resizing Columns and Rows in Excel
There are several ways to re-size a column or row, each has a specific use and will benefit you in different ways depending on what you wish to accomplish.
Click and drag a column or row header's boundary:To resize an individual column or row you can click...
Freeze Panes
Freeze Panes can be used to lock specific columns or rows in place so that you may see them where-ever you are within the data.
In the view tab of the ribbon you will find the "freeze panes" drop down menu:
Ribbon1.png
This menu...
Creating a TableTable data can be sorted and filtered faster and at the table...
When you input data into Excel it is initially a 'data array' and although it is perfectly fine to leave data in this format it is sometimes easier or better to convert it to Table for the following reasons;
What is a Mathematical operator?
This page will guide you through using Excel to create basic mathematical operations. This is very similar to creating a function or formula except that we are not using the function's operative such as (=Sum) or (=Average) or...
Wrap Text & Merge and CentreWrap Text
Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. But this will prevent you from a cell potentially taking up...