Concerned about the latest vaccine mandate? Visit Pryor's free training resource page to learn more about the latest rulings on the national 100+ vaccine mandate.

Microsoft® Excel® 2007 Analyzing Data

FastTrack Microsoft Excel Training Library

Continuing Education Credits: CEU: 0.025 

Train 24/7 with 5,000+ Online Courses via Pryor+

Pryor+ offers a true blended learning approach that includes more than 15,000 learning opportunities for live and online learning.

So much data, so little time! If you are working with large spreadsheets, it can get overwhelming and hard to find the information you need. But don’t worry! Excel has some great, but little-known, secrets for organizing your data that let you look at it in new and different ways. Find information quickly, draw conclusions confidently, and keep your attention focused on what matters most.

What You'll Learn

  • Use the AutoFilter function to show you only the information that matters most without getting distracted by everything else.
  • Re-arrange your data in a way that makes the most sense based on what answers you are looking for.
  • Focus your attention on important information with Microsoft Excel’s extremely flexible conditional formatting tool.