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.

Create pivot tables in Google spreadsheets using the pivot table editor to drag fields to rows and values, sort by sum descending, and enable automatic updates.

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 pivot charts in Excel, including comparisons with Google spreadsheets, created independently or linked to a pivot table to visualize sales by month, country, or customer using types and styles.

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.

Create an employee dropdown with data validation and VLOOKUP. Use VLOOKUP to display salaries and build pivot tables for branch sums, department averages, and a pie chart of department percentages.

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.

use the built-in average formula to calculate each student's final grade in excel and google sheets, set one or two decimal places, and apply formatting and autofill for all rows.

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).

Learn to build conditionals in Excel using the if function with logical tests and comparison operators, combine tests with and or, and apply to age-based access and discounts.

Explore nested if statements in Excel to classify students as pass, fail, or final-test candidates using and conditions on average and attendance; apply conditional formatting for color-coded results.

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

Use conditional formatting in Excel to color students: green for succeeded, red for failed, yellow for final test. Apply to a range and manage rules; this works in Google Sheets.

Learn to build and format an invoice template in Excel and Google Sheets, including seller and customer details, itemized calculations, taxes, totals, and print-ready layouts for PDF export.

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.

Learn to create and repeat a header across multiple printed pages in Excel using rows to repeat at the top, adjust margins, and preview with print.

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.

Explore date data in Microsoft Excel, converting dates to numbers, extracting day, month, and year, and using today and text functions to calculate ages and automate invoices.

Learn to calculate dates in Excel by treating them as numbers, adding and subtracting days, and analyzing delays with formulas, pivot charts, and workday for business days.

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.

Create dynamic management reports by linking Excel data to Word, embedding linked charts and tables that auto-update, and export a print-ready PDF for leadership.

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.

Fill the projections and actual sales for each product using VLOOKUP in the provided tables, applying basic math to complete the assignment with step-by-step guidance.

Learn to build dynamic sales projections in Excel using vlookup, set up robust lookup tables, and anchor references to copy across products while validating results.

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.

Learn to work with comma separated values (CSV) files, export and import data in Excel, and analyze it with pivot tables, maps, and charts.

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.

Learn to order data in an Excel table with the sort function, selecting all columns and preserving headers. Automate the process with macros and a button for one-click ordering.

Record actions in Excel to automate tasks with macros, sort data, name and assign the macro to a button, and protect sheets for safe automation.

Record a macro to add food to the list, unprotect and protect the sheet with password, insert rows, adjust VLOOKUP references, and save as a macro-enabled workbook.

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.

Explore building an excel shipping costs calculator that splits freight across items, calculates fob and cif, per-unit costs, and pricing with profit margins.

Protect the worksheet with a password and unlock cells to preserve formulas. Use isblank and or tests for quantity and unit price, set print area, and ensure 100% totals.

Add checkers to verify that percentages sum to 100% and that line totals equal invoice total FOB. Highlight errors with conditional formatting to prevent editing white cells before printing.

Build a simple Excel stock system to track purchases and sales, update stock with sumif and vlookup, enable multi-line invoices, and auto-fill final prices.

Learn to build a practical stock system in Excel, using average purchase price with average if, item dropdowns with data validation, and a navigable menu to manage stock and sales.

Explore team performance analysis using Jira exports to Excel and CSV, creating pivot tables and pivot charts to track tickets by assignee, type, priority, and month.

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.