Microsoft Excel 365 Intermediate

Learn to navigate large Excel workbooks quickly by jumping between worksheets, creating hyperlinks and buttons, and using shapes and icons with screen tips to reach the right worksheet fast.

Learn to accelerate data entry in Excel by using forms to input data quickly, add new records, and manage invoice data within a table via the Quick Access toolbar.

Format data as an Excel table, designate input cells B, C, D, F, compute sales tax in column E at 20%, and add records via Quick Access toolbar forms button.

Learn to use the IFS function as a shorter alternative to nested ifs in Excel 365, intermediate course, for calculating employee bonuses by job rating and comparing methods.

Learn how to use HLOOKUP for horizontally organized data, compare it with VLOOKUP, transpose data, create a named range, and retrieve year, rating, and genre with row index numbers.

Explore Xlookup and Xmatch to simplify lookups beyond Vlookup and index and match, using optional arguments and exact or bottom-up searches.

Practice using lookup functions with a data validation drop-down in cell H3 to retrieve an athlete's bib number, route, and finish position, with error checking for NA errors.

Master multi-column sorting in Excel 365 by sorting department, business unit, and country using the sort dialog, add levels, and sort by cell or font colors.

Find duplicates with conditional formatting and highlight unique values to identify attendees who didn't attend both webinars. Use go to special row differences to compare two data lists.

Practice finding duplicates by adding a formula to compare two country lists in columns b and c, identifying the countries that appear in both lists in column d.

Practice statistical functions in Excel by calculating the average score, the median score, and the scores that appear most often, then rank players in ascending order by their scores.

Practice rounding values by calculating a 1.2% bonus and the new salary in Excel 365 intermediate. Ensure the total salary is rounded to the nearest 100.

Master custom formatting in Excel by using four-part, semicolon-delimited rules to define positive, negative, zero, and text displays, including placeholders and currency formatting.

Practice calculating the difference between test scores and apply custom formatting to show positives in green with an up arrow and negatives in red with a down arrow.

Practice date and time functions by calculating project durations for Olivia’s working days and setting today’s date in C4 to generate invoices on the last day of the finish month.