Microsoft Excel: Learn Excel by Creating Diverse Projects

Explore the basics of Microsoft Excel, including the interface, cells, formatting, and formulas. Learn to enable the Developer tab, record macros, and understand VBA for automation.

Build a coffee shop database and a dashboard in this project-based Excel course, using seven employee variables, random data generation, calculations, and charts to visualize insights.

Learn to build a coffee shop employee database in Excel by creating seven variables, using rand between and VLOOKUP to assign names and positions, and calculating weekly salary.

Build a simple Excel dashboard to track employees, salaries, and hours, using if, sum, and average formulas to show full-time vs part-time counts and totals with charts.

Create dashboards in Excel by building charts from a simple database; learn to insert and customize charts for employees and hours worked, with a dashboard that updates on refresh.

Project two builds a seven-day income database and a dashboard in Excel, using five variables (bill number, item, quantity, unit price, total), with item lists, vlookup, if functions, and charts.

Continue project two income in excel by building an invoice model with foods and drinks, quantities, prices, and a total using vlookup and random data.

Build an Excel coffee shop dashboard that computes daily income and totals for five days. Identify the most popular drink and food using sum-based calculations.

Continue building five daily dashboards in Excel, computing average sales, max and min invoices, and total daily sales, then identify the most popular drinks and foods using HLOOKUP and VLOOKUP.

Create a five-day sales database in Excel, sum category totals, and use hlookup to identify the most popular drink and food, then assemble a focused dashboard.

Create an Excel project that tracks itemized expenses and fixed costs, reusing the database from project two, and build daily and weekly dashboards with embedded calculations.

Build project three expenses in excel by setting fixed expenses, converting monthly costs to daily, linking data across sheets, and calculating expenses per unit with vlookup and a 10% rule.

Build and analyze daily and weekly expense dashboards in Excel, calculating fixed and variable expenses, totals, averages, and extreme values per invoice.

In project four, build a single profits dashboard by consolidating income and expense dashboards on one page, add a daily profit chart, and automate weekly saving with VBA.

build a weekly income, expense, profit dashboard in Excel by importing dashboards from projects two and three, calculating profits and margins, adding a chart, and automating saves with macros.

Build a large Excel income management database for multiple coffee shops, add variables and random elements, then automate dashboards with templates and macros for one-click insights.

Create a five-store sales database in Excel with store, location, city, dates, and synthetic drink data; use vlookup to fetch location details and set drink prices.

Build a dashboard in Excel with data, visualization, and objectives, creating table models for income per store, location, and product daily, and total daily income, with macros to automate generation.

Learn how to build multiple Excel databases and fill template tables to compute income per store daily and income per location daily using sum and if/or functions.

Create a daily income per product table by building a new data set, using if functions to map product numbers to prices, and aggregate daily and total income across stores.

Create a dynamic excel dashboard by building data visualizations, selecting charts, and recording macros for income per store daily, income per location daily, and income per product daily.

Record, test, and assign macros for income reports, then add buttons and references to automate daily metrics. Create a dashboard for income per store, location, product, and total income.

Master the basics of Microsoft Excel through project-based learning, explore many functions, and plan practical next steps like dashboards and continued practice.