How to Do Filtering of Data in Microsoft Excel

Filtering data in Microsoft excel is used to display specific rows that meet specific criteria. All other rows of information are hidden. Filtering can be done with more than one column. Each filter added is based off the current filter. Using filters allow you to show your company data regarding specific data for each department separately, and a whole. Step 1: Select the data you want to filter Step 2: Click the arrow in the column header, and then click text or number filters. You may also choose items from a list or search data to filter. Step 3: Click on one of the comparison operators. If you need to show lower upper choose in between for number filters, and for text you can sort by alphabetically, color code. Data before filtering Data after filtering...

How to Create a PowerPoint Slide with a Graph

  Working in the IT support field your position may require you to analyze the departments needs for updates, upgrades, training, or purchase a new system. Your presentation will consist of facts and numbers. The ability to show your number findings, or facts. A graph is one way to illustrate this. This presentation will give you step by step instructions on how to add a chart to your power point presentation. Once you have collected all of the data you would like to graph.  There are various types of charts that can be used. Column chart Displays information in specific ways. Categories are displayed horizontally, and values are vertical. Using this chart works well when showing specific values, and categories are not in a specific order Line chart Data is distributed evenly along the horizontal axis, value is placed vertically. This type of chart is beneficial because it shows continuous data over time on an evenly scaled axis. It allows you to display trends in data of equal intervals such as months, quarters Bar Chart Compares among individual items. Unlike the bar, column chart categories are displayed vertical, values horizontally. This chart should be used when long you have long axis labels, values shown are duration Step 1: Decide the type of power point for your presentation Step 2: Determine the type of chart to display your analysis Step 3: Gather information to place in the chart...

How to Create Mailing Labels for Envelopes using Microsoft Word

Whether you are mailing out your yearly Christmas cards, or sending out letters regarding a new addition to the company’s building. You will need labels to place on the envelopes. Using Microsoft word is the fastest and easiest way to make your labels. You can purchase labels, envelopes from an office supply store, super-center. (Always remember to purchase enough labels to print the delivery address, return address). There is also an option to add E-postage. Step 1: Click on mailing on the toolbar select labels Step 2: Type the mailing address in the address content, along with the return address. You can also change the font size, color, and style Step 3: Select add...