Site in transition - https://wiki.rice.edu/confluence/display/RAD/RADAR+Home

Excel

User Tips and Tricks

Level = Introduction

Level = Beginner

NCURA 'Naming Cells and Tables for use in Formulas' (naming groups of cells or tables so they can be referenced elsewhere)

Level = Intermediate

Level = Advanced

XLOOKUP

VLOOKUP vs INDEX MATCH

=SUBTOTAL

NCURA 'Excel Tips: Subtotal Function' (using the 'subtotal function' to subtotal specific data in tables without using pivot tables)

Level = Introduction

Level = Beginner

NCURA 'The Zero Effort Way to Maintain your Pivot Tables' (ensuring an existing pivot table can be updated using similar data (copy, paste, refresh))

Level = Intermediate

NCURA 'Simplifying Grant Closeouts with Pivot Tables' (manipulating table fields to introduce automated calculations)
NCURA 'Quick-Hitting Research Admin Specific Pivot Table Functionalities' (Slicers, Pivot Charts)
NCURA 'From Hating Your Source System... to loving it with Pivot Tables' (grouping data by time periods, organizing data presentation hierarchies)
Kenji Explains 'Advanced Pivot Table Tricks ONLY Experts Know' (Percentages of Grand Totals, Timelines, Top 10 filtering, Grouping, Slicers, Report Filters) - not really 'advanced, but very useful intermediate knowledge and worth a watch.

Level = Advanced

Leila Gharani 'Advanced Pivot Table Techniques: Combine Data from Multiple Sheets in Excel' (Data models, Power Query, Power Pivot)
Kevin Stratvert 'How to use Power Query' (automated data cleaning (most effectively used in conjunction with a Data Model and Power Pivot))

Report abuse