3 Things You Didn't Know Microsoft Excel Could Do - Tech Learning

3 Things You Didn't Know Microsoft Excel Could Do

Here are three things you might not have known Microsoft Excel could do:
Author:
Publish date:

by Amy Schoenrock

Are you utilizing Microsoft® Excel® to its fullest? Here are three things you might not have known Microsoft Excel could do:

1) Sparklines
With Sparklines in Excel 2010, you are able to provide a more in-depth view of the data other than just simply using the numbers. Use Sparklines to show trends such as increases and decreases or economic cycles. 
Learn how to create Sparklines

2) Pivot Charts 
Pivot Charts allow you to provide a picture for the data in your Pivot Table. Use Pivot Charts to help better explain data to your intended audience.
Learn how to add a Pivot Chart

3) Conditional Formatting
By using conditional formatting, you are able to apply cell formatting based on specific conditions or criteria. Use conditional formatting to help make your data clear and easy to read, helping your team make more informed decisions.
Learn how to utilize conditional formatting

PD Tips courtesy of Atomic Learning

Featured

Related

Working with Comments in Excel 2007

  Do you know how to work with comments in Microsoft Excel 2007 Review mode? Learn here   If you're unable to play the video below, you can view it on YouTube here.    Quickflicks courtesy of Atomic Learning

101 Things You Can Do in the First Three Weeks of Class

101 Things You Can Do in the First Three Weeks of Class This site advcates that the first three weeks of school are the most important for setting "the mood" for learning and instruction. The site outlines a guide to follow. Use these suggestions to prepare for a new school year or for a new teaching

Image placeholder title

Video Tutorial: Mastering Excel 2010

This course can help you get the most out of Excel® 2010, which allows you to do multiple useful tasks, from formatting your grocery list to calculating complex ROI values.

Excel in Excel

 Duffy Ventures, LLC has launched Excel Everest, an interactive Microsoft Excel tutorial that automatically grades you as you learn.

Excelets: Excel's Excellent Adventure

from Educators' eZine --> If you have numerical data of any variety, Microsoft Excel is a great way to plot a graph – be it a Bar Graph, Pie Chart, or Scatter Plot! Excel's next capability is to develop a mathematical model

Excel 08: Working with Comments #2

 Using the Comment feature in Excel helps explain the contents of any cell to other users.  If you can't view the video below, view it on Youtube here.  Quickflicks  courtesy of Atomic Learning   

Getting to Know You

Tip: Here is an idea to use if you will be doing Professional Development with the same group for several sessions. Each time it is good to begin the session with some opening activity where the participants have a chance to talk and to move around. Two Truths and a Fib (First Session) This works best if the