📚 05 Resources¶
Reference material and links that support the notes, exercises, and projects.
Free Online References¶
| Resource | What it covers | Link |
|---|---|---|
| Microsoft Excel Help & Learning | Official documentation and function reference | support.microsoft.com/excel |
| Excel Functions (A–Z) | Every built-in function, alphabetically | Function list |
| Excel Easy | Beginner-friendly tutorials (this curriculum follows a similar topic order) | excel-easy.com |
| Kaggle Datasets | Free public datasets for practice | kaggle.com/datasets |
Keyboard Shortcut Cheat Sheet¶
| Shortcut | Action |
|---|---|
Ctrl + C / Ctrl + V |
Copy / Paste |
Ctrl + Z / Ctrl + Y |
Undo / Redo |
Ctrl + Arrow |
Jump to edge of data region |
Ctrl + Shift + Arrow |
Select to edge of data region |
Ctrl + T |
Create a Table |
Alt + = |
AutoSum |
F4 |
Toggle absolute/relative reference (while editing a formula) |
Ctrl + ; |
Insert today's date |
Ctrl + Shift + L |
Toggle filters |
F2 |
Edit the active cell |
Practice Datasets¶
The projects include sample CSV datasets you can import into Excel to follow along. For more, search for "sample sales data CSV" or browse Kaggle Datasets.