Learn how to customize the Excel ribbon by adding and removing tabs and commands, such as enabling the Developer tab and removing unwanted options.

Learn to save and open an Excel workbook using ctrl+s, name your file, choose a location like desktop or OneDrive, and open saved workbooks via file open or double-click.

Input values into Excel cells using month labels and numbers, navigating with the arrow key. See how text aligns left and numbers align right, and adjust alignment with alignment feature.

Customize the quick access toolbar to house frequently used tools, such as new, open, save, undo, redo, and sort, and learn to add or remove items with a double click.

Learn to format cells in Excel by adjusting alignment, bolding headers, increasing font size, applying fill colors and font colors, and adding borders to sharpen data presentation.

Learn basic mathematical calculations in excel, including summing quarterly data with the plus operator. Subtract the previous quarter to compute changes, then use multiplication and division for percentage change.

Learn about absolute, relative, and mixed cell references in Excel. See how absolute references use a dollar sign to keep values constant, while relative and mixed references change with copying.

Learn to sort data in Excel using the data ribbon, choose ascending or descending order, and apply multi-criteria sorts with fields like brand, megapixel, and quantity.

Learn to filter data in Excel with the data tab, apply drop-down filters, and use text and number filters to narrow results with conditions such as between and greater than.

Explore advanced data validation in excel, including numeric ranges, dates, times, text, and custom rules, with min and max values and configurable input and alert messages.

Learn to customize Excel charts by adjusting elements and categories, switching rows and columns, changing chart types, and moving charts between sheets.

Learn to change chart styles in Excel using built-in quick layouts, adjust colors, legends, data table visibility, and background design to format charts.

Learn how to compute averages in Excel using average, average if, and average ifs, with examples calculating acquisition cost across ranges, criteria for Fuji and Japan, and multi-criteria averaging.

Learn how the subtotal function performs multiple calculations in a single formula—average, count, counta, max, mean, standard deviation, and variance—adapting to selected references.

Learn how to use the upper, lower, and proper functions in Excel to convert text strings to uppercase, lowercase, and proper case, where proper capitalizes each word.