
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement testA free 19-lesson course built from freeCodeCamp.org's 2h 26m of YouTube video. 2 days at 90 minutes a day, with study notes and a quiz in every lesson. A 2-minute placement test skips what you already know.
Taught by freeCodeCamp.org on YouTube. Videos play in YouTube's own player, so the creator keeps every view.
Understand the course structure with six real-life Excel projects and the key skills covered including formulas, charts, VLOOKUP, pivot tables, and text manipulation.
Apply MAX, MIN, AVERAGE, and SUM functions to analyze payroll data, copy formulas across columns, and adjust number formatting for hours vs. currency.
Insert columns, use the IF function to calculate overtime hours (hours over 40), and compute overtime bonus pay at 1.5x rate.
Diagnose relative reference errors when copying formulas across weeks, apply absolute references ($C$4) to lock the hourly wage column, and fill formulas across a large block.
Build a decision matrix with careers and factors, assign importance weights using absolute references, calculate weighted scores, sum for a total, and highlight the top choice with conditional formatting.
Wrap text headers, insert a column, use Text to Columns (Delimited by space) to split full names into first and last name columns, and rename headers.
Calculate profit per transaction, create a tiered commission formula with IF (20% if price > $50 else 10%), and fill down 172 rows using Shift+Click and the Fill Down command.
Use SUMIF to total sales over $50, and SUM for grand total, applying criteria ranges and criteria strings.
Sort data by last name and by sale location, filter to show specific salespeople or price ranges, and create a pivot table summarizing total sales per salesperson.
Import a CSV file via Data > From Text/CSV, handle delimiter options, and correct data entry errors (letter O vs zero) in the imported data.
Use Text-to-Columns (fixed width) to parse manufacturer, model, and year from car IDs; create lookup tables with VLOOKUP for manufacturer and model names; fix VLOOKUP range and data typos.
Calculate car age with an IF formula handling pre-2000 vs post-2000 years, compute miles-per-year with a divide-by-zero fix, and determine warranty coverage with IF (miles <= 50000).
Build a new car ID by concatenating manufacturer, year, model, color (LEFT 3), and last 3 characters of original ID; apply UPPER to force uppercase.
Create a pivot table summing miles per driver, build a scatter chart of car age vs miles, add a trendline, format axis titles, and apply color scales for conditional formatting.
Set up a spreadsheet comparing Chicago, Orlando, and Miami vacation costs per person and fixed hotel costs, calculate subtotals, and create a bar chart to find the cheapest option for Susan and Tim.
Model total cost of ownership for three printers factoring initial price, cartridge cost, page yield, and daily print volume; compute annual and two-year costs for Susan and Tim; chart results.
Calculate lifetime cost for three cars (Spark, Mustang, Escalade) including purchase price, taxes, insurance, license, gas (using MPG, miles/year, gas price), years to 250k miles, and annualized cost; add 40% financing for Tim; create comparison bar chart.