Excel

TWO more Pivot Table sessions!

Remember how we added a second session of Pivot Tables in Excel 2010 to our summer calendar last week, because the first one filled up right away? Well, that one's full now too! Two more sessions have been added to the calendar: Friday July 17, 2015, from 10:00 am to 12:00 pm Wednesday September 2, […]

Learn Pivot Tables in Excel 2010

We have added Pivot Tables in Excel 2010 to our course calendar on Monday, June 8, 2015 from 2:00 pm to 4:00 pm! Find it at the York Employee Learning Calendar now. This course will be of special interest to people who manage large lists of data in Excel, including (but not limited to) financial […]

Tiny tip! Shade alternate rows in Excel

Shading alternating rows in an Excel spreadsheet is a great way to enhance the readability of your data. If you've ever done this job by manually highlighting and shading cells, you know it's tedious and your careful formatting can easily get messed up when you edit, sort and filter your data. Here are two quick […]

Find matching values in Excel

Here's a technique to use when you have two versions of a list and need to find the differences between them based on some common unique data, like a student number or employee number. We'll use the MATCH function in a specific way to quickly identify the items that DON'T match. We have two lists […]