MICROSOFT EXCEL Complete: Zero to Pro Level With 8 Projects

Explore pivot tables in Excel to analyze sales by customer, including total by customer, counts of invoices, and sorting by grand total, with hands-on steps to create and refresh reports.

Explore multilevel fields in pivot tables to build detailed sales reports, combining rows, columns, and values to show sums, counts, or averages by customer, invoice, and date.

Prepare your sales database for richer pivot table insights by adding month and year fields, ensuring up-to-date data sources, and enabling filters by year and country.

Learn how to block cell references with the dollar sign and use vlookup to pull country data from a customers sheet, ensuring accurate, scalable pivot table reports.

Master the vlookup formula to fetch a customer's country from a table, using exact match, fixed table references, and a column index; copy down for new invoices.

Explore data validation, VLOOKUP, and pivot tables to build an employee salary dashboard with a dropdown selector, branch-wise and department averages, and a department percentage chart.

Explore the student grades project in Excel and Google Sheets, calculating test averages, attendance from a separate sheet using if formulas, and dynamic class counts, with formatting tips.

Learn to calculate student attendance in Excel using count and counta formulas, determine total classes, compute attendance rates, and lock references for seamless copying.

Use VLOOKUP to transfer attendance rates into the grade sheet in Excel and Google Sheets. Use exact-match false and lock ranges to prevent misalignment from order changes or duplicates.

Apply excel conditionals to calculate each student's final result. Use if nested with end to test average >6 and attendance >0.7, producing 'succeeded' or 'failed' (also in Google Sheets).

Master nested conditionals in Excel by chaining if statements to assign discount for ages ≤12, free for ≥65, or normal price for others.

Learn to set print layouts in Excel by defining print areas, fitting to one page, adjusting margins, and creating custom headers and footers for professional invoices.

Format Google spreadsheets for printing by exporting the current sheet or selected cells to pdf, then adjust paper size, orientation, scale, margins, and headers or footers.

Learn to use dates and conditional formatting in Excel to track invoice payment status. Add terms and payment date columns, and highlight paid and overdue invoices.

Learn to use sumifs for multi-criteria sales analysis by product and year, compare actual sales to projections, and validate results with pivot tables and manual methods.

Learn to create and customize basic charts in Excel, from selecting data and using recommended charts to line and pie charts, and compare year over year by product.

Replicate sales analysis in Google spreadsheets, copying formulas, creating dynamic projections, and building linked charts; then present findings in Google Docs and export to PDF.

Calculate the percentage of projections sold by dividing actual sales by the projection, then assess year-on-year growth using yearly data, with examples and conditional formatting in Excel.

Create and rename charts to compare projections versus actual sales across products, using data labels and legends. Use growth charts and year-on-year percentages, vlookup and pivot tables to analyze data.

Create an Excel-based meal planner that tracks daily macros and calories using data validation, VLOOKUP, and conditional formatting to visualize when limits are reached.

Apply data validation to create a meals list and use vlookup to fetch calories and macros from the diet plan with exact matches.

Learn to set up data validation and a dynamic foods list in Excel, then use VLOOKUPs to compute calories and macros per gram from quantities.

Use the is blank test with the if function to hide blanks and prevent errors in an Excel table, then copy formulas across while preserving references for VLOOKUP.

Apply conditional formatting with a cell reference to flag calories exceeding the maximum, unblock the column, and copy the rule across cells.

Protect workbooks and worksheets in Excel by applying soft protections like always open read-only, password-protecting sheets, encrypting with a password, and unlocking specific cells to allow selective editing.

Explore a Microsoft Excel-based production cost and final price calculator that computes batch cost, unit cost, and final price from ingredients, quantities, and target profit for handmade soap bars.

Protect the sheet to lock formulas and unlock only input cells. Use isblank and if or logic to show units and compute price from quantity and purchase price.

Analyze team performance in Excel using pivot tables and built-in formulas like VLOOKUP, SUMIF, and AVERAGEIF to compute totals and time per ticket, plus tickets per assignee, with charts.