Shortcuts are a great way to save time and energy in Excel, but there are more than 200, so the list can seem overwhelming. In this rapid fire video, we demonstrate more than 30 popular Excel shortcuts you can use to save time every day in Excel. We built this list of shortcuts based on a survey of over 800 Excel users.
In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart for dashboards and other reports.
In this video, we demo how to plot results from a survey question in an Excel bar chart. Along the way, we use the COUNTIF function to build a summary table, and show a simple technique for creating an "other" bucket.
In this video, we look at a step by step approach to randomly assign people to groups with teams using formulas. Along the way, we use three functions (RAND, RANK, and CEILING), helper columns, and nesting. We verify results with the COUNTIF function.
In this video gives a brief introduction to structured references. Structured references is just a fancy name for formulas that use table names instead of normal cell references. This sounds boring, but it's actually cool and useful.