The fill handle can be used in a variety of ways that may save you time. From repeating sequences or repeating data to repeating a formula over a large area.
The fill handle is the name given to the green dot found on the bottom right corner of the selected...
Excel can handle lots of different format types of numbers, but you must regularly choose what type of number format you wish to be expressed on the cells containing those numbers. If you don't, you may suffer problem when calculating functions or expressing the data in...
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:
...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:
...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...This page will cover the 5 basic functions found in the auto-sum drop-down menu:
SUM
AVERAGE
COUNT NUMBERS
MAX
MIN
Summation, the addition of a...
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...
Excel can handle lots of different format types of numbers, but you must regularly choose what type of number format you wish to be expressed on the cells containing those numbers. If you don't, you may suffer problem when calculating functions or expressing the data in...
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...
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;
