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...
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...
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...
What our students tell us:
I just wanted to share with you that I was just offered a three month contract with good potential to get hired on, at Crosscom. They are an IT consulting firm for Kohl's department store. Just thought I would share the good news with you. Thank you for all of your advice, especially with the internship course, over the past couple of years! Thank you, Justin Peterson, (June, 2015)
"I cannot stress enough how much I enjoyed my experience at MATC IT Computer Support Program. I have made so many friends and good people. Along with that I received knowledge to help me with my career. I really enjoyed many of these classes. I really like the mobile device classes. I am not sure where technology will go but I am along for the ride and this program helped get me on my way!!! “ Andrew Jones, (May, 2015)
"I believe IT Computer Support Specialist at MATC is a great program. I enjoyed everything from the easiest things to the most challenging things, it all added to my learning experience. All the necessary materials were provided from me to finish the course sufficiently and all my needs were met with in the program. This program is a great start for any person trying to pursue a career or interest in the IT world.!!! “ Matthew Spain, (December, 2015)
“The sharing of ideas and experiences is what makes the classrooms both enjoyable and worth the time to attend. “ Bob Schneidler, (May, 2014) letter
“Thanks to all of the instructors and fellow classmates with whom I've worked; it was a great learning experience.” Brian Wilson, (May, 2014) letter
“Thank you very much for everything you have done. Last Friday was my graduation and I am truly honored and proud to be part of MATC. I have to be honest, my experience here in MATC was just one of kind and will be definitely always be thankful. “ Ben Azcueta, (December, 2015) letter
“I just wanted to reach out and thank you for your help at MATC - there were many bumps in the road - I was just offered a new job in support - and the salary is $47,000 a year - I am overwhelmed that an associates would yield this sort of compensation. Again thank you and I'll be in touch for more schooling at some point I am sure.” Chris Taschner, (June, 2014) text message
“I’ve learned more about the business of IT than I ever knew; concepts which will likely come to underpin my further progress.” Justin Schroeder, (June, 2014) letter