Excel & Google Sheets for Beginners: Formulas, Pivot Tables & Projects

Getting Comfortable with the Spreadsheet

You opened a spreadsheet, saw a wall of tiny gray boxes, a ribbon packed with icons you have never clicked, and a blinking cursor in a cell called A1. Maybe a job posting asks for "proficiency in Excel." Maybe your manager just sent you a file and said "can you update the numbers by Friday?" Maybe a class project needs a chart and you have no idea where charts even live. You are not behind. Almost everyone who uses spreadsheets well today started exactly where you are, staring at the same grid and wondering where to click first. This section gives you a map. By the end of it you will know what every part of the screen is called, how Excel and Google Sheets differ, how to move around without getting lost, and how to save and organize a file so you never lose work. Every later chapter assumes you know this vocabulary, so take your time here. ### Excel or Google Sheets: which one should you learn? Short answer: learn the shared core once and you can work in both. About 90 percent of what you do day to day (typing data, writing formulas, sorting, filtering, charts, pivot tables) works the same way in both programs. The formulas in this guide are written so they work in both unless a note says otherwise. Here is how they compare in practice: | Question | Microsoft Excel | Google Sheets | |---|---|---| | Where does it run? | Desktop app (Windows, Mac), plus Excel for the web and mobile | In a web browser, plus mobile apps | | Cost to you | Paid through Microsoft 365, though Excel for the web is free with a Microsoft account | Free with a Google account | | Where files live | On your computer, or in OneDrive or SharePoint | In Google Drive, always online | | Saving | Manual save, or AutoSave when the file is in OneDrive | Saves automatically after every change | | Collaboration | Strong when the file is in OneDrive, weaker with emailed copies | Built in from day one, very easy | | Power features | Deeper: Power Query, Power Pivot, more chart types, macros | Lighter but growing; great for shared trackers | | What employers mean by "Excel" | Usually the desktop app | Often accepted as equivalent for basic tasks | Use this decision rule: 1. If a job description names Excel, practice in Excel. Excel for the web is free and handles everything in this guide except a few advanced extras. 2. If you work with a team that lives in Google Workspace, practice in Google Sheets. 3. If you are not sure, start with whichever you can open today. The skills transfer. > Pro tip: You do not need to buy anything to follow this guide. Go to office.com and sign in with a free Microsoft account to get Excel for the web, or go to sheets.google.com with a Google account. Both are enough for every exercise in these chapters. ### Workbooks, worksheets and cells: the three words that matter most A spreadsheet file has a structure, and once you see it the screen stops being confusing. - Workbook: the whole file. In Excel it is usually saved as .xlsx. In Google Sheets it is called a spreadsheet and lives in Drive. - Worksheet (or sheet): one page inside the workbook. You see the sheet tabs along the bottom of the screen, named Sheet1, Sheet2 and so on. A workbook can hold many sheets. - Cell: one box in the grid. Every cell has an address made of its column letter and row number. The cell where column C meets row 5 is C5. - Range: a block of cells. You write a range as the top left cell, a colon, and the bottom right cell. A1:D10 means every ...