Excel Essential Skills: Excel proficiency in 45 minutes

Master Excel autofill to speed up data entry, fill months and years with the fill handle, and choose options like copy formatting or copy values.

Master how to freeze table headers, sort data by buyer surnames from A to Z, apply and clear filters, and adjust column widths to view all content in Excel.

Learn to use vlookup to pull prices from the products sheet into the order sheet by matching product names for exact matches, returning the price column.

Learn excel formulas: create an amount paid column by multiplying amount and price in orders sheet, add a full name column from given name and surname, and use MONTH function.

Explore essential Excel statistical functions, including count, sum, average, countif, max, and if, through hands-on data from the orders sheet to build a reusable overview table.

Master the Excel if function to display values based on conditions, such as free shipping for orders over 50. Learn to nest if statements to assign quarters by month.

Create pivot tables to summarize orders and payments. Drag full names to rows and amounts to values, then filter by first quarter and arrange products for yearly insights.

Create bar chart in Excel with products on the x axis and amount paid on the y axis from a pivot table, add axis titles, and use clustered column chart.

Apply conditional formatting to highlight amounts paid over 100 and color purchase dates from July 1 to August 31 using light red.

Learn Excel table transformation: copy as values, transpose to switch rows and columns, apply alternating row colors with format painter, and split comma-delimited data with text to columns.