In this lesson
Build a small baseline and choose a next lesson based on the work you need to repeat.
Example
A weekly list that may become a larger workflow
Enter Region and Amount in A1:B4: West 120, East 80 and West 100. Today you need a quick summary. Later you may receive repeated imports or need consistent report formatting. Choose the next tool for that next job.
How it works
Match the tool to the task. A formula can handle a small stable calculation; Power Query helps repeat supported import steps; VBA can automate suitable desktop actions.
Keep a result and a note about what still needs testing. A practice log makes it easier to choose the next exercise than a list of advanced features alone.
Steps
Create the three records as a table named PathData and enter =SUM(PathData[Amount]) outside it. Check 300 and write what one record represents.
Use =SUMIFS(PathData[Amount],PathData[Region],"West") for a regional summary, then repeat for East. Compare West 220 and East 80 with the source.
Create a separate PivotTable of Region and Sum of Amount. Compare it with the formulas and note its Refresh command.
Add North 50 on a copy. Check that the table extends, recalculate and refresh the PivotTable. The full total becomes 350; a summary listing only West and East still covers those two regions only.
Write the next job’s source format, volume, frequency, recipient platform and output. Choose formulas for a stable calculation, Power Query for repeated supported imports or desktop VBA for a suitable repeated action.
Choose one next lesson and note its starting requirements and result check. For Power Query, try the table-based source first. For VBA, use supporting desktop Excel and a reserved practice output area.
Make a log with Task, Result, Issue and Next test. Save the source and summaries so you can repeat the same input change as you develop the workflow.
Try it yourself
- For a monthly team that receives three CSV exports, choose a route and describe the checks needed before combining the files. Include record count, type consistency, duplicate keys and a control total.
- For a browser-only colleague, choose a complete non-VBA path for the three-row summary and demonstrate the 300-to-350 source-change test without requiring a desktop macro.
Show expected result
- The original summary is West 220, East 80 and total 300. Adding North 50 creates total 350 while West and East remain unchanged.
- The practice log names a completed result, an observed limit and the next specific test. A route is justified by source and platform requirements rather than by a generic advanced label.
If something goes wrong
- The recipient cannot run the chosen workflow.
- Read the next lesson’s platform note and use its supported alternative. A file can open in a browser without offering VBA or model authoring.
- You have marked a lesson complete but have no result to check.
- Repeat its small input-and-output exercise and save the result. Note whether you have read the lesson, tried it or checked the output.
Quick check
Try these questions after the exercise. Check the result in your app before marking the lesson complete.
Choose an answer for all 3 questions to check your understanding.
Optional: try it with Copilot
If you have Copilot, try this after the exercise. Keep the original file and compare its suggestions with your own result.
Recommend one next Excel lesson for this source format, frequency and recipient platform. Explain the choice and give a clear result to check when I finish.
More from Microsoft
These Microsoft guides cover the tools used in this lesson.
Loading your progress…