School navigation

Information Technology

QuickBytes: Excel

February 05, 2013

QuickBytes are 20 minute sessions about a specific task or topic, followed by a 5 minute break in which to move between sessions. Mix and match your bytes and focus on the skills you’re most interested in!

Session 1 - Filters & Sorting - Once you’ve got your data in Excel, how do you make sense of it?  Without using any fancy formulas or functions, harness the power of the built-in filters and sorting features to quickly look at only the data you want to, in an order that makes sense to you.

Session 2 - Lookups - One of the most common tasks in Excel is the process of looking up specific values within a data set. Learn how to use VLOOKUP, HLOOKUP and MATCH formulas to find the information you need.

Session 3 - Pivot Tables - Learn how to create a PivotTable report—an interactive table that automatically extracts, organizes, and summarizes your data. You can use this report to analyze the data, make comparisons, detect patterns and relationships, and discover trends.

 

Share this story on

Information Technology

Contact Us