FREE 1-HOUR EVENT, October 20 at noon CST. Diversity & Inclusion: Top Lawsuits Reveal How to Protect Employees and Avoid Liability. REGISTER NOW

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.