Excel - Beginner to Advanced in 4 Hours

Explore relational data by identifying primary keys as unique identifiers and foreign keys as references to related tables, using employee and location examples to illustrate.

Format cells in Excel with number formats for dates, times, currency, percentages, fractions, and custom formats. Use format painter, decimals, thousand separators, and options for negative numbers and color.

Master the text to columns feature to split semicolon-delimited data from a web page into separate columns in Excel, using the data tab and delimiter settings.

Discover how to apply the upper, lower, and proper functions in Excel to transform text. See examples converting A2 text to uppercase, lowercase, and proper case to capitalize each word.

Learn to use index and match to retrieve quantity available and cost per unit, replacing vlookup with nested functions, exact matches, and dynamic ranges.

Explore the iferror function in Excel to handle division by zero and other errors, returning a safe value; apply it with vlookup across inventory lists to compute cost and profit.

Learn to use sumif, countif, and averageif for NBA box scores, and extend to sumifs, countifs, averageifs, maxifs, and minifs with multiple criteria.

Learn to visualize and compare data using bar and pie charts, create and customize charts, compare budgeted versus actual sales, and build pivot charts for large data sets.