📊 Lesson 1.2: Setup, the Ribbon Interface & Your First Workbook

Getting In: Excel for the Web vs the Desktop App

Before we can tour the interface, we need Excel open in front of us. There are two honest paths, and this course teaches on the free one by default so nobody is left out.

Path 1 — Excel for the web (free, recommended for this course)

Open your browser and go to microsoft365.com (office.com also works and redirects there). Sign in with a free Microsoft account — if you don't have one, you can create one for free with any email address. Once you're in, you'll see the Microsoft 365 home page with a strip of app icons; click the green Excel icon. From there you can start a Blank workbook or pick a template. Your files save automatically to your free OneDrive cloud storage and open on any device with a browser. This is genuinely free and covers the core of this entire course.

Path 2 — the desktop app (paid, more powerful)

If you have a Microsoft 365 subscription (or a one-time Office / Office LTSC purchase), you can open the installed Excel app on Windows or Mac. It launches to a Start screen where you choose a blank workbook, a template, or a recent file. The desktop app is faster on large files, works fully offline, and has the complete feature set — we'll flag the desktop-only bits as we reach them.

Whichever path you take, the moment Excel opens on a blank workbook, you're looking at the same fundamental anatomy — a ribbon on top, a grid in the middle, and sheet tabs at the bottom. Let's make sense of it. But first, one idea that trips up nearly every beginner: the difference between a workbook and a worksheet.

Workbooks vs Worksheets

These two words sound alike and get mixed up constantly, so let's nail them down once and for all — the rest of the course depends on it.

• A workbook is the whole file — the single .xlsx document you save, open, and share. Think of it as a binder.
• A worksheet (also called a sheet or tab) is one page inside that binder — a single grid of cells. A workbook can hold many worksheets, and you switch between them using the tabs at the bottom.

So one workbook file might contain a Data sheet, a Calculations sheet, and a Dashboard sheet — three worksheets, one file. This is exactly how we'll organize the projects later in the course: raw data on one sheet, formulas on another, the finished view on a third. Keeping related work in one workbook across several sheets — rather than scattering it across many files — is a habit that will make your spreadsheets far easier to manage.

Anatomy of the Excel Window

Open a blank workbook and look at the window from top to bottom. It can feel busy at first, but it's really just a handful of pieces, each with a clear job. Here's the tour, and you can point to each part on your own screen as we go.

The two pieces beginners overlook most are the Name Box and the formula bar, and they're worth a closer look because they answer the two questions you'll ask all the time: where am I and what's really in this cell?

The Name Box — "where am I?"

Click any cell and glance at the Name Box on the left. It shows that cell's address. Click cell C7 and it reads C7. This is your GPS in a big grid. Even better, you can type an address into the Name Box and press Enter to jump straight there — type A100 and you're instantly at row 100, no scrolling. Later you'll also use the Name Box to create and jump to named ranges, but for now think of it simply as "where am I, and take me there."

The formula bar — "what's really in this cell?"

This one matters enormously. A cell can display one thing but contain another. If a cell shows 15 but was produced by the formula =B2+B3, the cell displays 15 while it contains the formula. The formula bar always shows the true contents — so when you're wondering "is that a typed number or a calculated result?", the formula bar tells you. To edit a cell's contents precisely, you can click into the formula bar, or press F2, or double-click the cell.

The Ribbon and Its Tabs

The ribbon is the wide toolbar across the top, and it's organized into tabs. Each tab gathers related commands into groups. You don't need to memorize where every button lives — you need to know which tab to look on, and the tab names map neatly onto the course's mental model of Data → Formulas → Analysis → Visualization → Dashboard.

You'll also see contextual tabs that appear only when they're relevant. Select a chart and a Chart tab pops up; click inside a Table and Table Design appears; then they vanish when you click away. Don't panic when tabs come and go — Excel is just showing you the tools that fit what you've selected.

One practical tip: if the ribbon takes up too much room, you can collapse it. On the desktop there's a small caret at the ribbon's right edge (or press Ctrl+F1) to hide and show it; the web has a similar ribbon-display option. Collapsing it gives you more grid to work in and expanding it back is one click away.

Working with Sheet Tabs

The sheet tabs at the bottom left are how you manage the worksheets inside your workbook. A new blank workbook usually starts with a single sheet named Sheet1. Here's everything you'll do with tabs, and it's the same idea on web and desktop with only small differences in wording.

Add a sheet

Click the + (plus) button just to the right of the last tab to add a new blank worksheet. Add as many as your workbook needs.

Rename a sheet

Double-click the tab (or right-click it and choose Rename), type a clear name, and press Enter. Meaningful names like Expenses, Summary, or Dashboard beat Sheet1, Sheet2, Sheet3 every time — your future self will thank you.

Color a tab

Right-click a tab and choose Tab Color to give it a color. This is purely visual, but it's a brilliant organizing trick: color your data sheets one color and your dashboard another, and you can find the right sheet at a glance.

Move, copy, hide, and delete

Drag a tab left or right to reorder it. Right-click for the full menu — Move or Copy (duplicate a sheet, handy for reusing a layout), Hide, and Delete. Switch between sheets by simply clicking their tabs.

Creating, Naming & Saving a Workbook

Creating a workbook is simple; saving it is where web and desktop differ most, so let's be precise and honest about both.

Create

On the web, from the Excel home at microsoft365.com click Blank workbook (or a template). On the desktop, from the Start screen choose Blank workbook, or use Ctrl+N to create a new one anytime.

Saving on the web — AutoSave to OneDrive

This is the big, pleasant surprise for newcomers: Excel for the web saves automatically. Your workbook lives on your free OneDrive from the moment it exists, and every change is saved for you continuously — you'll see a saving status (such as Saved) next to the file name at the top. At the time of writing the web app has no AutoSave on/off switch like the desktop app's — saving is simply always on. There's no "Save" button to hunt for and nothing to lose if your browser closes. To name the file, click the auto-generated title (often "Book" or "Book1") at the top of the window and type a real name. Because it saved automatically all along, the file is already there in OneDrive under that name.

Saving on the desktop — Save and Save As

The desktop app still has the traditional flow. Press Ctrl+S (Save) the first time and you'll be asked where to save and what to call it — that's the Save As step. If you save to OneDrive, the desktop app can also turn on AutoSave just like the web. If you save to your local drive, you keep pressing Ctrl+S as you work (a good habit). Use Save As (or F12 on Windows) whenever you want to save a copy under a new name or in a different place.

🎯 Project: Your First Workbook

Enough touring — let's make something real. In this short project you'll create a workbook, give it a proper name, rename and color a sheet, and type a few labels. It's deliberately tiny, because the point is to get comfortable doing these actions, not to build anything fancy yet. This is the file we'll pour data into in Lesson 1.3, so use the through-line dataset you named in your Excel Plan.

Workbook name: My Excel Practice   (saved to OneDrive / your drive)

Sheet tab: Expenses  (colored)      Sheet tab: Notes

Cell A1:  My Weekly Expenses
                A          B          C            D
   Row 3:   Date       Item       Category     Amount

Best Practices for Getting Set Up

✅ Do's

• Name your workbooks and sheets meaningfully. Expenses and Dashboard beat Book1 and Sheet2 — you'll find things instantly.
• Keep related work in one workbook across several sheets. Data on one sheet, calculations on another, the finished view on a third.
• Learn the Name Box and formula bar early. They answer "where am I?" and "what's really in this cell?" — the two questions you'll ask most.
• Use the Search / Tell Me box when a button has moved instead of hunting through tabs.

❌ Don'ts

• Don't memorize button positions. The ribbon differs between web and desktop and shifts over time; learn which tab, not which pixel.
• Don't delete a sheet without checking it. It usually can't be undone and takes all its data with it — hide it if unsure.
• Don't assume every ribbon feature exists on the web. Full Power Query and the VBA editor are desktop-only; we'll flag those.

📓 Learning Journal

📝 Lesson Summary

🎉 What You've Accomplished

You're no longer staring at an unfamiliar window. You can get into Excel on the web or the desktop, point to every important part of the interface, tell a workbook from a worksheet, manage sheet tabs, and — most importantly — you've created, named, and saved a real workbook of your own. That file is the foundation for the rest of Module 1. This is the "learning to drive the car" step, and you've done it.

❓ Common Questions at This Stage

🔭 Looking Ahead

In the next lesson — Lesson 1.3: Entering, Editing & Formatting Data — Types, Fill & Number Formats — we start filling that workbook with real data. You'll learn the data types Excel recognizes (and why text, numbers, and dates behave differently), how to enter and edit efficiently, the magic of AutoFill and Flash Fill, and how number formats change how a value looks without changing what it is. It's where "clean data first" becomes a hands-on habit.

✅ Before the Next Lesson

• Have your named, saved practice workbook ready with its renamed Expenses sheet
• Make sure you can confidently switch between sheet tabs and read a cell's address in the Name Box
• Write your Learning Journal entry for this lesson

📚 Additional Resources

• microsoft365.com — open Excel for the web
• Microsoft Excel Help & Learning (Microsoft Support)
• Microsoft 365 & Office Help (Microsoft Support)