Draft learning preview: Quiz scoring happens only in your browser. Results are not saved, no certificate is awarded, and the course is not for sale yet. Lesson text is loaded from the draft database.
Learning progress (this visit only)
Check off lessons as you read them. This progress is not saved to your Academy account.
What you will learn
- Navigate workbooks, sheets and cells
- Format clean tabular data
- Use formulas and references
- Sort and filter records
- Create a small-store inventory sheet
Excel essentials
25 minutes
Workbooks, sheets and cells
Workbooks contain worksheets. Cells are identified using a column letter and row number. B3 means column B, row 3.
Practice: Create a table with Item, Quantity, Price and Total columns.
Clean data and formatting
Keep values numeric and apply currency and date number formats. Save a copy before modifying business data.
Practice: Enter five fictional store products with quantities and unit prices.
Formulas and organization
35 minutes
Calculate with formulas
Formulas begin with =. Multiply two cells using =B2*C2 and sum totals using =SUM(D2:D6).
Practice: Create five line totals and a grand total.
Sorting, filters and references
Sort the complete table to keep related records together. Filter by one or more fields. Absolute references like $B$1 stay fixed when copied.
Practice: Sort by price and filter for low-stock items.
Inventory mini-project
30 minutes
Build a reorder dashboard
Track SKU, item name, quantity, cost, and reorder threshold. Compare quantity to the threshold using IF.
Practice: Prepare five example items and identify which need restocking.
Check and share your work
Manually verify two formulas and a total. Do not share private store data without permission.
Practice: Explain your formulas and prepare an example workbook for review.
Practice quiz
Select one answer for each question. This is a browser-only self-check, not Academy course credit.
Final mini-project
Create a helpful prompt, improve the response and write a short reflection on the accuracy checks you performed.
Submissions will be enabled only after integration with Academy enrollment and mentor review.