Excel for Business › Module 1
Opening a workbook, naming the parts, typing, formatting, your first formula, and printing without embarrassment.
What is in this module
| Segment | Mini-lecture |
|---|---|
| XLB-0100 | Module 1 overview: what to expect |
| XLB-0101 | Why a spreadsheet, and when not to use one |
| XLB-0102 | Workbooks, worksheets, cells: what you are looking at |
| XLB-0103 | Starting an Excel workbook from scratch |
| XLB-0104 | The ribbon, Tell Me, and the toolbar you build once |
| XLB-0105 | Moving and selecting without the mouse |
| XLB-0106 | Text, numbers, and dates: what Excel does to what you type |
| XLB-0107 | Number formats and the rounding illusion |
| XLB-0108 | Making it readable: alignment, borders, shading, cell styles |
| XLB-0109 | Your first formula: SUM and the order of operations |
| XLB-0110 | Print setup that does not embarrass you |
| XLB-0111 | Spreadsheet design rules for accountants |
Twelve segments: an overview and eleven mini-lectures. Most run under ten minutes. Each one is a single idea with a demonstration, so you can stop after any of them and come back without losing your place.
Downloads
You need one file. Download BAYLINE_Core.xlsx and it carries you through the whole module.
- BAYLINE_Core.xlsxStart here. The workbook the whole module runs on.Download
If you missed a lecture
Every mini-lecture also has a rejoin file: the workbook exactly as it stood at the end of the previous lecture. Open the one for where you are and pick up without redoing anything. You do not need these if you are working straight through.
- XLB-0102_start.xlsxRejoin at mini-lecture 2.Download
- XLB-0103_practice.xlsxCheck your work after mini-lecture 3. Not a start file: you build this one from an empty workbook, which is the lesson.Download
- XLB-0104_start.xlsxRejoin at mini-lecture 4.Download
- XLB-0105_start.xlsxRejoin at mini-lecture 5.Download
- XLB-0106_start.xlsxRejoin at mini-lecture 6.Download
- XLB-0107_start.xlsxRejoin at mini-lecture 7.Download
- XLB-0108_start.xlsxRejoin at mini-lecture 8.Download
- XLB-0109_start.xlsxRejoin at mini-lecture 9.Download
- XLB-0110_start.xlsxRejoin at mini-lecture 10.Download
- XLB-0111_start.xlsxRejoin at mini-lecture 11.Download
- BAYLINE_Core_M01-final.xlsxFinished state. Module 2 starts here.Download
Everything at once
If you would rather grab it all now and sort it out later, or you are on a connection you do not trust, take the zip.
- XLB-M01_all-files.zip All 12 Module 1 workbooks in one file. Download
About mini-lecture 3. It has no start file on purpose. You build that workbook from an empty screen, and handing you a finished one would remove the lesson. What is listed above is the finished version, so you can check your work against it after you have built your own.
Bayline USA is a fictional company created for instruction. Every name, figure, and document in this material is invented, and identifying numbers are masked. This material is for educational use only. It is not accounting, tax, or legal advice, and it is not a substitute for a professional engaged on the facts of a real business. Tax rates, wage bases, filing thresholds, and forms change; verify current authority before applying anything here to real facts. Full notices.
Files on this site are offered under a free student tier: personal, individual use only. No redistribution, no reposting, and no classroom or training use without a written license. Teaching from this material at an institution or inside a company requires a license.