Ms Excel/Excel 2025 - The Complete Introduction to Excel

master the basics of excel by creating new workbooks from templates, formatting cells, working with borders and colors, building tables and charts, and using basic formulas and data tools.

Master relative and absolute cell references in Excel. Use drag to fill formulas and dollar signs to lock cells for correct totals and taxes.

Learn the difference between a formula and a function in Excel, using the average example to show manual calculations versus built-in functions.

learn the four basic excel formulas and how to perform addition, subtraction, multiplication, division, and if functions using a small database, with auto-updating results.

Learn to use basic Excel formulas to manage fruit stock, calculating stock left from stock in minus stock out, and explore addition, subtraction, multiplication, division, and a simple average.

Explore how Excel functions simplify formulas, using sum, average, count numbers, min, and max to analyze data.

Master the if function in Excel by learning its three parts: logical test, value if true, and value if false. Use nested if with or and iferror to handle errors.

Master the VLOOKUP and HLOOKUP functions in Excel by building a sample database, selecting a lookup value, and returning data from a chosen column or row.

Learn to build a small sales database in Excel, using sum, average, max, min, if, and VLOOKUP to compute totals, averages, best and worst sales, with cell locking.

Learn to visually represent data in excel by building an employee database, creating a table with months and using calculations to prepare data for charts.

Create charts in Excel from monthly sales data, add totals, and learn to use recommended charts to compare employees. Customize chart types and titles, refresh data, and explore simple dashboards.

Import weather and stock market data from the web into Excel, using sites like weather.com and investing.com, and refresh for real-time updates.

Learn to import web data into Excel, create stock charts from open, high, low, and close prices, and analyze price movements for the sp 500.

Learn to analyze a database with pivot tables and pivot charts in Excel, using a car dealership example to reveal brand, color, mileage, cost, price, and profit insights.

Create an Excel app to build a grade book with two sheets, recording student names, time studied, and grades, then explore correlation between hours studied and scores.

Compute average, max, and min with Excel functions, then use nested if statements to categorize hours, lock cells with dollar signs, and transfer data across sheets for a dashboard.

Learn to build a green book in Excel by importing data, naming fields, and creating pivot tables and charts to analyze time studied and averages.

Wrap up this complete introduction to Excel by equipping beginners with basics, formulas, functions, charts, data manipulation, and pivot tables, including a final project that ties everything together.

Build a tax calculator in Excel by generating a biweekly income, converting it to yearly income, and applying tax brackets.

Advance the Excel tax calculator by computing taxes per bracket, the amount left to tax, and taxes owed for a two-week income, using if functions across multiple brackets.

Learn to build a budgeting app in Excel that tracks money in and out, calculates two weeks salary with overtime, investments, side hustle, and taxes, then converts to monthly income.

Create a budgeting app in Excel by calculating bills, rent, groceries, car payments, and other spendings, then compute net income, total spendings, and monthly balance.

Build a simple project management worksheet in Excel, defining tasks, dates, durations, and status with formulas, randomization, and conditional formatting.

Learn to calculate task metrics in Excel using average for task length, if for finished status, and sum and count to compute totals and percentages.

Learn to build a simple Excel portfolio model that converts monthly returns to yearly, tracks starting capital and monthly deposits, and projects capital growth and monthly profit over years.

Build and compare two financial scenarios in Excel with a chart of dates and end-of-month capital, then adjust return rate and deposits to visualize differences.

Create an Excel stock portfolio by selecting companies, retrieving stock data (current price, 52 week high/low, sector), and computing total value and profit or loss with conditional formatting.

Compute a total with sum, format profit figures with conditional formatting, and explore max/min metrics. Build a stock portfolio in a table, filtering by sector and name.

Create a real estate dashboard in excel by generating raw data, calculating profit, and using vlookup with geography mode to assign cities and compute key metrics.

Create a real estate dashboard by applying countif to tally sales per city, averageif for city profits and home prices, and max/min to identify top and bottom metrics.

Create a simple, visual city information dashboard in Excel using data validation and vlookup to pull city, office, and phone data, then build charts of sales, profits, and prices.

learn to build a mortgage calculator in Excel that computes loan amount, payments per period, and a supporting chart, using home price, down payment, interest rate, amortization, and insurance rules.

Learn to build an Excel mortgage calculator: use IF to block undersized down payments, apply PMT for monthly payments, and compute taxes, utilities, insurance, and fees for total per-period payments.

Create a mortgage calculator in excel by building a periodized database that tracks start balances, capital, interest, extra payments, end balances, and total spend.

Learn to extract five-year weekly stock data in Excel using stock history for Apple, Nvidia, and Tesla, including date, close, open, high, low, volume, to analyze volatility.

Learn to build a Tesla stock analysis in Excel using stock history data, calculating daily changes, percentage changes, and weekly averages and volatility for Nvidia, Apple, and Tesla.

Build a stock analysis dashboard in Excel by creating a stock database. Show five-year and 52-week data, including price, open, highest high, lowest low, volume, market cap, beta, and volatility.

Learn to use the stock history function to pull five years of daily, weekly, and monthly stock data in Excel, then compute daily changes, averages, volatility, and high/low prices.

Create a comprehensive stock analysis dashboard in Excel by calculating daily, weekly, and monthly average change and volatility, and visualize data with a chart.

Create a 2025 Excel task manager with a dynamic task list, due date, duration, start date, status, and an auto calendar, plus data validation and conditional formatting for urgent tasks.

Learn to apply conditional formatting in Excel to color code task rows: green when finished, red for urgent not started or started, using formulas, relative references, and today’s date calculations.

Apply conditional formatting with formulas to color cells red or green based on status values, and build a calendar in Excel that maps tasks to dates across months.

Create a date-driven task tracker in Excel using the if function and the text join function to display date-specific tasks and apply conditional formatting.

Create a dynamic calendar in Excel by using conditional formatting to color non-blank cells and auto-fill the calendar from a task database.

Develop an online business Excel project by building a database with date, transaction number, price, and country. Generate random data, convert countries to geography, and set up a map chart.

Extract country-wise sales from a database using sumif and countif, compute total transactions and total sales for 2025, and visualize results with a map chart to build a dashboard.

Create a Microsoft Excel roulette simulator by listing numbers 0–36 and assigning red, black, or green colors. Use data validation for bets yes/no and conditional formatting to show outcomes.

Create an Excel roulette betting table, set money bets, format cells, and compute odds (1/37) and payout (36x) with potential win and win/loss calculations.

Set up an Excel roulette betting project focusing on red or black, excluding green zero, calculate odds and payouts, and reference cells to track bets and potential wins.

Generate a number between 0 and 36, record it as num, determine row with if or function, then use vlookup fetch color and is odd, classify as odd or even.

Create an Excel roulette tracker by using IF statements to determine win or loss for each bet, lock cells with F4, and sum totals for total bet and total win/loss.

Build a car dealership logbook in Excel by listing brands, generating year-based purchase prices, and applying depreciation with absolute references and simple formulas.

Craft an Excel project to estimate car purchase value by generating random car data, using vlookup for brands, rand between for years, and calculating purchase price, fixes, and total investment.

Apply conditional formatting to highlight when purchase price is higher or lower than the price, then compute sold price, profit and loss, and profit margin using sum and percentage formatting.

learn to extract key metrics from a car database by building a brand-based table and dashboard, calculating sales, sales in dollars, investments, and reparations using countif and sumif.

Create an Excel dashboard that extracts key metrics from car sales data, including total investment, total sales, total reparations, total profit, best and worst sales, and average profit per sale.