Excel Beginner Practice Workbook with completed solutions

Download Your Excel Toolkit

I’ll send you the practice workbook from the video, including the completed solutions, so you can follow along and check your work.

What Is Microsoft Excel?

Microsoft Excel is a powerful spreadsheet program that helps you organize, calculate, and analyze data.

It’s like a digital table where you can enter numbers, words, or dates. Each box in this table is called a cell, and you can use these cells to track anything—from expenses and budgets to schedules and lists.

Why Use Excel?

Excel is popular because it simplifies data management. With Excel, you can easily add or subtract numbers, sort and filter information, and even create charts or graphs.

Whether you’re managing your personal budget, planning a project, or keeping track of work tasks, Excel makes it easier to stay organized and make informed decisions.

How to Open Excel and Create a New Workbook

Getting started with Microsoft Excel is easy. Follow these simple steps to open the application:

  • Start Menu: Click on the Windows Start button.
  • Search for Excel: Type “Excel” in the search bar.
  • Select Excel: Click on Microsoft Excel from the search results.

Getting Started Overview

After you’ve opened Excel, you’ll see the Getting Started page.

Here, you can:

  1. Start a New Workbook: Begin with a blank sheet if you’re starting from scratch.
  2. Use a Template: Templates come with pre-set labels and formulas, perfect for quick tasks.
  3. Open Recent Files: Quickly access files you’ve recently worked on.
  4. Open Other Files: Find and open files from your computer or external devices

How to Save an Excel Spreadsheet

To start, create a new, blank workbook. Remember to save your work:

  • Click the Save button in the top-left corner.
  • Choose a name and location for your file.
  • Click Save.
Excel Save As dialog showing file name and location fields for saving a new workbook

💡 You can also use the keyboard shortcut Ctrl+S.

What Is the Difference Between a Workbook and a Worksheet?

Once you’ve created and saved your Excel spreadsheet, it’s important to know how workbooks and worksheets function. Here’s a simple guide to help you understand the basics.

What is an Excel Workbook?

An Excel workbook is the file you create when you start a new spreadsheet. Think of it as a book, with each page inside it being a worksheet. A workbook can hold one or many worksheets, depending on how you want to organize your data.

What is an Excel Worksheet?

A worksheet is a single page within your workbook. This is where you enter and manage your data.

  • The worksheet is made up of a grid with rows and columns.
  • Each small box in this grid is called a cell.
Excel worksheet grid showing rows, columns, and individual cells labeled
  • You can enter numbers, text, or formulas into these cells.

What is a Cell Address?

A cell address in Excel is how you find and identify each cell on a worksheet. It’s like the cell’s “name” in the grid.

  • The address is made up of two parts: the column letter and the row number.
  • For example, the D4—is where column D meets row 4.
Excel cell address D4 highlighted where column D meets row 4

Understanding cell addresses is key when you’re entering data or creating formulas in Excel. If you want to reference or locate a specific cell, just look at its address.

💡 Try clicking on any cell in Excel, and you’ll see its address in the Name Box at the top-left of your screen. This is a handy way to keep track of where you are!

Excel Name Box showing cell address of the currently selected cell

How to Use Worksheets in Excel

  • Navigating Worksheets: Look at the bottom of your Excel window. You’ll see tabs labeled Sheet1, Sheet2, and so on. These are your worksheets. Click on a tab to view that sheet.
Excel sheet tabs at bottom of window showing Sheet1, Sheet2 navigation
  • Adding a New Worksheet: Need more space? Click the plus sign (+) next to the sheet tabs to add a new worksheet.
Plus sign button next to Excel sheet tabs for adding a new worksheet
  • Renaming a Worksheet: Keep your workbook organized by renaming each worksheet. Double-click on the worksheet tab, type a new name, and press Enter.
Excel worksheet tab being renamed by double-clicking and typing new name
  • Moving Worksheets: Want to change the order of your sheets? Click and drag a worksheet tab to a new position.

Featured Course

Excel Essentials for the Real World

A hands-on Excel course for professionals who never had formal training. Fill in what got skipped, so you stop doing things the long way without knowing there was a shorter one.
Learn More

How to Enter Data in Excel

To enter data:

  • Click on a cell.
  • Start typing.
  • Press Enter to move down a row or Tab to move across a column.

How to Enter a Formula in Excel

Entering a formula in Excel is a simple way to perform calculations automatically. Here’s how you can do it:

  • Select a Cell: Click on the cell where you want the result of your formula to appear.
  • Start with an Equals Sign (=): Every formula in Excel begins with an equals sign (=). This tells Excel that you’re entering a formula, not just text or a number.
  • Enter Your Formula: After the equals sign, type in the formula you need. For example:
    • To add two numbers, type =A1 + B1
    • To subtract, type =A1 - B1
    • To multiply, type =A1 * B1
    • To divide, type =A1 / B1

Once you’ve typed your formula, press Enter. Excel will calculate the result and display it in the selected cell.

🔗 For more details about how to master basic math with formulas in Excel check out this article.

Formula Bar in Excel

If you need to edit what you’ve typed, click on the cell and use the Formula Bar at the top of the screen.

This is especially useful for editing long text or complex formulas.

Excel Formula Bar at top of screen showing cell contents for editing

How to Select Rows, Columns, and Multiple Cells

To select a row or column, click the applicable row or column header.

Excel row header and column header selected showing full row and column highlight

How to Select Multiple Rows in Excel

Selecting multiple rows in Excel is a quick way to manage your data more efficiently. Here’s how you can do it:

Mouse: Click and Drag:

  • Click on the row number of the first row you want to select.
  • Hold down the mouse button and drag your cursor over the rows you want to select.
  • Release the mouse button when you’ve selected all the needed rows.

Mouse: Click and Shift:

  • Click the first row number.
  • Hold the Shift key and click the last row number in your range. All the rows between will be selected.

Keyboard: Shift + Arrow Keys:

  • Click the first row number to select it.
  • Hold down the Shift key, then press the Down Arrow or Up Arrow to extend your selection to more rows.

Selecting Non-Adjacent Rows

If the rows you want to select aren’t next to each other:

  • Hold the Ctrl key.
  • Click on each row number you want to select.

This allows you to pick individual rows without selecting everything in between.

What Is a Range in Excel?

A range in Excel is a group of cells that you select to work with all at once. Instead of dealing with cells individually, you can select a range to format, calculate, or analyze data more efficiently.

How to Identify and Select a Range

A range is identified by the cell addresses of its first and last cells.

For example, if you select cells from A1 to B5, the range is written as A1:B5.

Excel range A1:B5 selected and highlighted showing range identification

This covers all cells in the area from A1 to B5.

To select a range:

Using Your Mouse:

  • Click the first cell in the range.
  • Hold down the mouse button and drag to the last cell.
  • Release the button to select the entire range.

Using Your Keyboard:

  • Click the first cell.
  • Hold Shift and use the arrow keys to extend the selection.

How to Move a Cell in Excel

Moving a cell in Excel is easy and can be done in a few simple steps. Here’s how:

Select the Cell:

  • Move your mouse pointer over the cell you want to move.
  • The pointer will turn into a large white plus sign.
Excel cell with white plus sign cursor indicating cell selection mode

Drag to Move:

  • Click and hold the cell: Move the pointer to the edge of the cell, and it will change to a smaller, black arrow.
  • While holding the mouse button, drag the cell to its new location.
  • Release the mouse button to drop the cell in place.
Excel cell being dragged to new location with black arrow cursor

How to Use the Excel Fill Handle to Auto-Fill Data

The Fill Handle in Excel is a powerful tool that can save you a lot of time when entering data. Here’s how it works:

What is the Fill Handle?

The Fill Handle is a small green square at the bottom-right corner of a selected cell or range of cells.

Excel Fill Handle green square in bottom-right corner of selected cell

When you hover your mouse over this square, the cursor changes from a large white plus sign to a thin black plus sign.

Excel cursor changed to thin black plus sign over Fill Handle

How to Use the Fill Handle

Select a Cell:

  • Click on the cell that contains the data you want to extend.

Drag the Fill Handle:

  • Move your cursor over the Fill Handle (the small green square).
  • When the cursor changes to a thin black plus sign, click and drag it down or to the right.
  • Excel will automatically fill the cells with data based on the pattern of the original cell.

What Can the Fill Handle Do?

The Fill Handle is incredibly versatile and can perform various tasks:

  • Repeat Text: Quickly copy the same text to adjacent cells.
  • Create Lists of Months: Automatically generate a list of months, such as January, February, March, and so on.
  • Create Weekday Lists: Fill in the days of the week, like Monday, Tuesday, etc.
  • Create Lists of Days: Generate a sequence of dates in a series.
  • Repeat Formulas: Apply the same formula to a series of cells.
  • Repeat Cell Formatting: Copy the formatting of a cell to adjacent cells.
Animated GIF showing Excel Fill Handle auto-filling months and days in cells

What Is the Excel Ribbon and How Do You Use It?

The Excel Ribbon is the toolbar at the top of your Excel window, giving you quick access to all of Excel’s features. Here’s how to navigate and make the most of it:

Exploring Tabs and the Ribbon

The Ribbon is divided into Tabs, each containing groups of related tools:

  • Home Tab: This is where you’ll find the most commonly used features like formatting, alignment, and clipboard functions.
  • Insert Tab: Here, you can add charts, tables, pictures, and other elements to your spreadsheet.
  • Page Layout Tab: Use this tab to adjust settings like paper size, margins, and orientation for printing your spreadsheet.
  • Formulas Tab: Find all the tools you need to create and manage formulas.
Excel Ribbon showing Home, Insert, Page Layout, and Formulas tabs

Learning About Buttons

Not sure what a button does? Simply hover your mouse over it.

A tooltip will appear with a brief description, the keyboard shortcut (if available), and sometimes a link to more detailed information.

Excel button tooltip showing description and keyboard shortcut on hover

Accessing More Features

Some Ribbon groups contain more features than what’s immediately visible.

To access these, click the small arrow in the lower-right corner of a group.

Excel Ribbon group dialog box launcher arrow in lower-right corner

This will open a dialog box with additional options related to that group.

Maximizing Your Workspace

If you need more room to work on your spreadsheet, you can collapse the Ribbon:

  • Click the Collapse Button: In the upper-right corner, click the small arrow to hide the Ribbon, leaving only the Tabs visible.
  • Use the Keyboard Shortcut: Press Ctrl + F1 to toggle the Ribbon on and off.
  • Double-Click a Tab: If the Ribbon suddenly disappears, you might have double-clicked a Tab by accident. Double-click it again to bring the Ribbon back.
Excel Ribbon collapse button in upper-right corner for maximizing workspace

Accessing the Backstage View in Excel

The Backstage View in Excel is where you manage your file’s essential functions.

To access it, simply click the File tab in the top-left corner of your Excel window.

Excel File tab highlighted for accessing Backstage View

What Can You Do in the Backstage View?

Excel File tab highlighted for accessing Backstage View

The Backstage View allows you to perform a variety of file-related tasks:

  • Save the File: Quickly save your current work.
  • Open a File: Browse and open existing Excel files.
  • Close the File: Close the current workbook without exiting Excel.
  • Print the File: Set up and print your spreadsheet.
  • Email the File: Send your Excel file directly from the application.
  • Convert the File: Save your file in different formats, like PDF or CSV.
  • Protect the File: Add a password to open or edit your file for added security.
  • View File Info: Check details like file size, author, creation date, and last modified date.

Essential Excel Keyboard Shortcuts for Beginners

Excel has many shortcuts to help you work faster.

Navigating Excel with Shortcuts

  • Ctrl+Space: Select a column.
  • Shift+Arrow Keys: Select multiple columns or rows.
  • Ctrl+Arrow Keys: Jump to the edge of data or the sheet.

Quick Tips

  • Right-Click Menu: Access options like insert, delete, and formatting by right-clicking a cell.
  • AutoFit Columns/Rows: Double-click the edge of a column or row to resize it automatically.

Shortcuts for Quick Data Entry

Moving In and Out of Edit Mode

  • Enter Data and Move:
    • Press Tab to move right to the next column.
    • Press Enter to move down to the next row.
  • Stay in the Same Cell:
    • Press Ctrl+Enter to enter data without moving to another cell.
  • Edit Existing Data:
    • Select a cell and press F2 to activate Edit Mode. This places your cursor at the end of the cell’s contents, ready for editing.

Repeating Data Across Cells

  • Copy Data Across Rows or Columns:
    • Select a cell with the data you want to repeat.
    • Press Ctrl+R to fill the data to the right, or Ctrl+D to fill it downwards.

Restricting Data Entry to a Specific Range

  • Pre-Select a Range:
    • Highlight the range of cells where you want to enter data.
    • Now, as you press Tab or Enter, the cursor will only move within this selected range.
Animated GIF showing Tab key moving cursor within a pre-selected range in Excel

🔗 Explore our complete list of must-know Excel shortcuts and download a handy cheat sheet in this article.

How to Format Cells in Excel (Text, Colors, Borders)

Formatting your data in Excel can transform a basic spreadsheet into a polished, professional report.

Here’s how to enhance your data with easy formatting tricks.

How to Wrap Text in a Cell

When you have long text in a cell, you can use the Wrap Text feature to make it fit neatly within the column width.

Activate Wrap Text:

  • Select the cell or cells with long text.
  • Click the Wrap Text button in the toolbar. Excel will adjust the text to fit within the column, adding line breaks as needed.
Excel Wrap Text button applied to cell showing text wrapped within column width

Toggle Wrap Text:

  • If you want to remove the wrapping, simply click the Wrap Text button again to turn it off.

Centering Titles Across Columns

To make your report look more organized, you can center your title across multiple columns:

  • Select Cells: Highlight the cells where you want your title to be centered (e.g., A1 to G1).
  • Merge and Center: Click the Merge & Center button in the toolbar. Your title will now be centered across the selected columns.
Excel Merge and Center button centering title across multiple columns

Resizing Columns for a Uniform Look

Adjusting column widths can give your data a cleaner appearance:

Auto Fit Columns:

  • Highlight the columns you want to resize (e.g., B to G).
  • Double-click any column divider to automatically adjust the width to fit the content.

Manual Resize:

  • If the auto fit is too tight, manually drag the column divider to your desired width.
  • This will apply the new size uniformly across all selected columns.
Excel column width being adjusted by dragging column divider for uniform sizing

Adding Colors and Borders

Make your data stand out by adding colors and borders:

  • Select Cells: Highlight the cells you want to format (e.g., month names).
  • Apply Formatting: Use the toolbar to change the font style, size, color, or alignment.
    • You can also add borders or fill colors to emphasize certain data.
Excel cells with font color, fill color, and border formatting applied

Copy Formatting in Excel

The Format Painter is a quick way to copy formatting from one cell to others without copying the data:

  • Select the Styled Cell: Click on the cell with the formatting you want to replicate.
  • Use Format Painter: Click the Format Painter button, then click on the cell where you want to apply the same style.
Excel Format Painter button copying cell formatting to another cell

💡 Pro Tip

  • Double-click the Format Painter button to keep it active and apply the style to multiple cells, even if they aren’t next to each other.
  • Press ESC when you’re done.

How to Move a Row in Excel

Moving a row in Excel is simple, and there’s a quick method that can save you time. Here’s how to do it:

Traditional Method (Slower):

Most users move a row by following these steps:

  • Insert a Blank Row: Add a blank row where you want to move your data.
  • Select the Data: Highlight the row you want to move.
  • Cut the Data: Right-click and select Cut (or press Ctrl+X).
  • Paste the Data: Right-click the new location and select Insert Cut Cells.

While this method works, it’s not the quickest option. Try the faster method below instead.

  • Select the Row: Highlight the entire row you want to move (e.g., A7 to G7).
  • Drag and Drop: Click and hold the border of the highlighted cells (avoid the Fill Handle).
  • Move the Row: While holding down the Shift key, drag the row to its new location. A thick green line will appear, showing where the row will be placed.
  • Release: Let go of the mouse button to drop the row in its new position.
Excel row being moved with Shift+drag showing green insertion line indicator

This method is perfect for quickly reorganizing data in a large spreadsheet.

How to Enter Your First Formula in Excel (AutoSum)

Using formulas in Excel is a powerful way to perform calculations quickly.

Here’s a simple guide on how to enter a formula and repeat it across multiple cells.

Entering a Formula with AutoSum

  • Select the Cell: Click on the cell where you want the total to appear (e.g., cell B8, below the “Jan” values).
  • Use AutoSum:
    • Go to the Home tab on the Ribbon.
    • Click the AutoSum button or press Alt+=
    • Excel will automatically create a formula using the SUM function to add up the numbers in the selected range.
Excel AutoSum button on Home tab inserting SUM formula in selected cell
  • Verify the Selection: A moving dotted line, called the Marquee, will surround the selected cells that are included in the formula.
    • Ensure it covers the correct range.
Excel SUM formula with Marquee dotted line surrounding selected range

Copy Formula in Excel

Once you’ve entered the formula, you can easily repeat it for other months:

  1. Select the Cell with the Formula: Click on the cell containing the formula you just created.
  2. Use the Fill Handle:
    • Hover your mouse over the small green square in the bottom-right corner of the cell (this is the Fill Handle).
    • The cursor will change to a thin black plus sign.
  3. Drag to Copy the Formula: Click and drag the Fill Handle to the right, across the remaining columns (e.g., from B8 to C8, D8, etc.).
Excel Fill Handle dragging SUM formula across columns to copy calculation

Excel will automatically adjust the formula for each column.

Excel showing copied SUM formulas with adjusted cell references per column
Completed Excel spreadsheet with totals calculated for all monthly columns

🔗 For a step-by-step guide on copying formulas in Excel, explore this detailed article.

What Should You Learn After the Basics?

Once you are comfortable with data entry, formatting, and basic formulas, the next skills to build are:

  • Cell references (relative vs absolute) so your formulas work correctly when copied. See our cell references guide.
  • VLOOKUP and XLOOKUP to pull data from one table into another. See our VLOOKUP tutorial and XLOOKUP tutorial.
  • IF, SUMIF, and COUNTIF to calculate values based on conditions. See our COUNTIF guide.
  • Charts and Pivot Tables to summarize and present data visually.
  • Data validation and drop-down lists to control what users can enter. See our drop-down list tutorial.

If you want a structured path through all of these topics with practice files and exercises, the Excel Essentials for the Real World course covers everything from basics through intermediate skills in the order that builds on itself. It is designed for professionals who need to get productive in Excel quickly.

Frequently Asked Questions

Is Microsoft Excel free?

Excel for the web (excel.microsoft.com) is free with a Microsoft account. The desktop application requires a Microsoft 365 subscription or a one-time purchase of Excel 2021 or Excel 2024. Microsoft 365 Personal starts at $6.99/month in the US.

What is the difference between Excel and Google Sheets?

Both are spreadsheet applications. Excel has more advanced features (Power Query, Pivot Tables, VBA macros, the new GROUPBY function) and handles larger datasets better. Google Sheets is free, browser-based, and better for simple real-time collaboration. Most workplaces use Excel.

What is the fastest way to learn Excel?

Start with a specific task you need to accomplish, not a general tutorial. Learn data entry and formatting first, then basic formulas (SUM, AVERAGE, IF), then lookups (VLOOKUP or XLOOKUP). Practice with real data from your own work. A structured course with exercises is faster than watching random YouTube videos in no particular order.

What are the most important Excel formulas for beginners?

The five formulas beginners should learn first are SUM (add numbers), AVERAGE (find the mean), COUNT/COUNTA (count cells), IF (make decisions), and VLOOKUP or XLOOKUP (look up data from another table). These cover the majority of everyday spreadsheet tasks.

Do I need to memorize all Excel shortcuts?

No. Start with five: Ctrl+C (copy), Ctrl+V (paste), Ctrl+Z (undo), Ctrl+S (save), and Ctrl+Shift+L (toggle filters). Add more as you need them. The most productive Excel users know 10 to 15 shortcuts, not hundreds.

Download the Workbook

Download the Beginner Practice File

Master the basics by practicing with the exact workbook and solutions from the tutorial.

Featured Bundle

Black Belt Excel Bundle

This Excel Black Belt Package includes EIGHT of our Popular Courses. You’ll learn high-value, in-depth Excel skills that solve real problems.
Learn More
Excel Black Belt Bundle XelPlus

Leila Gharani

Founder of XelPlus and ten-time Microsoft MVP. Leila helps over 500,000 professionals master Excel, Power BI, and data automation through practical, real-world training.