Excel has a feature that allows you to format a cell so that it may only contain certain answers you have specified. These will be displayed as a drop-down list that displays when a cell with the formatting on is selected. This is useful for removing things such as...
Search results
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...
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'...
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...
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;
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...
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...
PowerPoint has a feature which allows you to remove the background from an image. There are limitations such as needing a high-resolution, decent quality image and a clearly defined background/foreground, It still has many uses and can allow you to bypass the need for you to search for a 'cut-...
While giving a PowerPoint Presentation you can make use of something called Presenter view, this mode allows the projector* to display your presentation full screen without your notes showing to the audience. The second monitor* will show a ...