Introduction

Interface, Data Entry, Formatting, Math, Print

S M L XL FS | Slo Reg Fast 2x | Bookmark

Welcome to Microsoft Excel Beginner Level 1. In this course we will introduce you to the Excel interface and cover foundational skills such as using the ribbon, Quick Access Toolbar, and formula bar. You will learn how to enter and edit data, format spreadsheets, perform basic math operations, and manage files by saving, loading, and printing. We will discuss recommended prerequisites, explain the structure of Excel courses from beginner to developer, and outline each lesson's topics to help you get started with Microsoft Excel. Guidance on using student forums and effective learning strategies is also provided.

Navigation

Prev: B01
Next: Lesson 01

Keywords

TechHelp Excel, Excel 2010, Excel beginner, Excel interface, ribbon, Quick Access Toolbar, formatting spreadsheets, basic math operations, formulas, cell alignment, saving workbooks, printing spreadsheets, entering data, editing data, rows columns cells

Subscribe to Introduction
Get notifications when this page is updated

Intro

Transcript

Welcome to Microsoft Excel 2010 Beginner, level 1, brought to you by ExcelLearningZone.com. I am your instructor, Richard Rost.

For those of you who are beginners, our goal for today is to get you up and running with Excel 2010 as quickly as possible. The first hour of tutorials will cover using Excel 2010's interface, including the ribbon, the Quick Access Toolbar, and more. You will learn how to enter data into a spreadsheet and then edit that data. You will learn how to format a spreadsheet to make it look more professional. You will also learn to perform some basic math operations in a spreadsheet. Finally, you will learn how to save your spreadsheet to disk, load it back up again, and print it to your printer.

This class is designed to be used with Microsoft Excel 2010, a part of Microsoft's Office 2010. If you are using an older version of Excel, you should visit my website at ExcelLearningZone.com and look for my older tutorials covering Excel 2000 through 2007. If you are using Excel 2007, you should have little difficulty following along as most of the topics covered in this course are the same.

If you are using Excel 2003 or earlier, you really should either upgrade to Excel 2010 or purchase a tutorial for your version of Excel, which again you can find on my website.

Before taking this course, I strongly recommend that you take one of my beginner Windows courses, either Windows XP, Vista, or Windows 7, depending on which version you have. You should have a good understanding of how to use Windows before taking this course. You should be familiar with such topics as how to log on to Windows, how to use the keyboard and mouse, how to launch programs, how to maximize and minimize a window, how to use the scroll bars, and you should know the difference between the backspace and delete keys. All of these things are essential for understanding Excel. If any of these concepts seem unfamiliar to you, please stop now and take one of my beginner Windows courses first.

If you are planning to learn Microsoft Word in addition to Excel, I recommend that you take my Word 2007 beginner course first, then move on to Excel. Microsoft Word, and word processing in general, is easier to learn than working with spreadsheets. If you are new to computers, you will find it is easier to get some experience and practice using Word first, then move on to Excel. Learning the Word interface will help you to learn the Excel interface, as many features such as the ribbon are very similar. In my Word 2010 Beginner Level 1 course, you will learn how to use the Word interface, enter and edit text, format text, use the clipboard, save and load files, and lots more.

This is the Beginner Level 1 course for Microsoft Excel 2010. This class is for the novice user who has little or no experience with Excel. In today's course, we will cover just the most basic features of Excel and teach you how to edit spreadsheets effectively. Our goal for today is to get you up and running quickly with a simple Excel spreadsheet.

My courses are broken up into four groups: beginner, expert, advanced, and developer. My beginner courses are for novice users who have little or no experience with Microsoft Excel. They are designed to give you an overview of the basic features of Excel and cover just what you need to know to be productive.

When you finish the basics, it is time to move up to the expert series, which is designed for users who are already comfortable with Excel. Expert classes are designed to teach you more about all the standard features of Excel that people use from day to day, and will go into more depth about each topic than the beginner classes. You will learn all about the options, alternatives, shortcuts, tips and tricks, and extra features that we might have skipped over in the beginner lessons.

When you have mastered the expert classes, the advanced lessons are for Excel power users. You will learn how to record macros, build user forms, create your own templates, and many more advanced features that not everyone will use, but they really add enhanced functionality and professionalism to your spreadsheets.

Finally, my developer level courses are designed to teach you how to program in Visual Basic for Applications with Microsoft Excel. This will allow you to create Excel-based programs for your users, automate your spreadsheets, and integrate Excel tightly with other Microsoft Office applications.

Each of my series is broken down into different levels. For example, the beginner series starts with level 1 - that's this class - and is followed by levels 2 through 5. Each level teaches you new and different topics in Microsoft Excel, building on the lessons learned in the previous levels. When you finish all the beginner classes, move up to the expert series, then advanced, and finally developer.

Now let's take a more detailed look at what we are going to learn in today's class.

In lesson 1, we're going to begin by learning about the Excel interface. We'll learn how to start Microsoft Excel, we'll learn about the title bar, the window controls, and the file tab.

In lesson 2, we're continuing our look at the Excel interface. We'll look at the ribbon, ribbon tabs, groups, commands, and dialog box launchers.

Continuing on with the Excel interface, in lesson 3, we'll learn about the Quick Access Toolbar, the status bar, the zoom control, and the scroll bars.

In lesson 4, we're going to finish our look at the Excel interface. We'll start with the formula bar, then learn about the parts of the spreadsheet, including rows, columns, and cells. We'll learn about the mouse pointer, and the different sheet tabs.

In lesson 5, we're going to learn how to enter data into our first spreadsheet.

In lesson 6, we'll learn how to edit the data that we entered into our spreadsheet in the last lesson.

In lesson 7, we're going to start looking at how to format our spreadsheets to make them look more professional. We'll learn about cell alignment, cell ranges, bold, italics, and underline.

In lesson 8, we're going to continue learning about formatting our sheets. We'll learn how to change the font and the font size. We'll learn how to resize rows and columns, and we'll learn how to change the foreground and background colors.

In lesson 9, we'll learn how to perform calculations in Excel. We'll learn how formulas work, and we'll learn about the basic math operators.

In lesson 10, we're continuing on with basic math and Excel. We'll learn how to add multiple cells together, take an average of a group of cells, and we'll learn about the order of operations in mathematics.

In lesson 11, we'll learn how to save our workbook to our computer hard disk, load it back up again, and print our spreadsheet to the printer.

If you need help with the topics covered in today's lessons, please feel free to post your questions in the Excel Interactive Student forums. If you're watching this course using my custom video player software, or online in my web theater, you should see the student forum for each lesson appear in a small window next to the class videos, if you have an active internet connection. Here, you will see all of the questions that other students have asked, as well as my responses to them, and any other comments that other students have made. I encourage you to read through these questions and answers as you start each lesson, and feel free to post your own questions and comments as well.

If you're not watching your lessons online, you can still visit the student forums later by visiting ExcelLearningZone.com/forums.

To get the most out of this course, I recommend you sit back, relax, and watch each lesson completely through once without trying to do anything on your computer. Then replay the lesson from the beginning, and follow along with my examples. Actually create the same spreadsheet that I make in the video. Build a spreadsheet with me step by step. Don't try to apply what you're learning right now to other projects until you've mastered the sample spreadsheet. If you get stuck or don't understand something, watch the video again from the beginning, or tell me what's wrong in the student forums.

Most importantly, keep an open mind. Excel might seem intimidating at first, but once you get the hang of it, you'll see that it's really easy to use.

Quiz

Q1. What is the primary goal of this Excel Beginner Level 1 course?
A. To get students up and running with Excel as quickly as possible
B. To master advanced programming in Excel
C. To learn about every feature in Microsoft Office
D. To become an expert in computer networking

Q2. Which of the following will students learn about in the first hour of tutorials?
A. Making websites in Excel
B. Using the Excel interface, ribbon, and Quick Access Toolbar
C. Programming in Visual Basic
D. Creating PowerPoint presentations

Q3. If you are using Excel 2003 or earlier, what is the recommended action?
A. Continue the course with no changes
B. Upgrade Excel or purchase a tutorial for your version
C. Skip to developer level courses
D. Use only the online forums

Q4. What prerequisite knowledge is recommended before taking this course?
A. Using Photoshop
B. A good understanding of Windows basics
C. Advanced Excel programming
D. Setting up network servers

Q5. Why is it suggested to learn Microsoft Word before Excel if you are new to computers?
A. Word is more entertaining
B. Word processing is generally easier to learn than spreadsheets
C. Word has more features than Excel
D. Excel and Word have unrelated interfaces

Q6. Which group of users is the beginner course designed for?
A. Users who are experienced with Excel macros
B. Novice users with little or no experience with Excel
C. Professional Excel developers
D. Graphic designers

Q7. What is not covered in the beginner level of this Excel course?
A. Basic editing and formatting of spreadsheets
B. Programming Visual Basic for Applications
C. The Excel 2010 interface
D. Simple math operations

Q8. What is covered in lesson 7 of the course?
A. Creating advanced data charts
B. Formatting spreadsheets including cell alignment, ranges, and text styles
C. Writing complex VBA code
D. Importing data from external sources

Q9. What is the recommended way to get help with the course material?
A. Only use the printed manual
B. Post questions in the Excel Interactive Student forums
C. Email your classmates
D. Call Microsoft technical support

Q10. How should students approach watching the course lessons for the best results?
A. Try to apply the lesson to a personal project immediately
B. Watch the lesson once all the way through, then follow along step by step
C. Only watch the introduction
D. Memorize the script without practicing

Q11. Which of the following is included in lesson 11?
A. Writing VBA code
B. Saving, loading, and printing workbooks
C. Sending spreadsheets via email
D. Recording macros

Q12. In the course curriculum, which series comes after the beginner series?
A. Developer
B. Expert
C. Advanced
D. Starter

Q13. What are some features you will learn about the Excel interface in lessons 1 through 4?
A. Ribbon, Quick Access Toolbar, Status Bar, Formula Bar, Rows, Columns, and Cells
B. Video editing tools
C. Cloud integration
D. Audio recording functions

Q14. What is the suggested response if a student is unfamiliar with concepts like using the keyboard and mouse?
A. Continue with the Excel course
B. Enroll first in a beginner Windows course
C. Take the advanced Excel class instead
D. Skip to the developer tutorials

Answers: 1-A; 2-B; 3-B; 4-B; 5-B; 6-B; 7-B; 8-B; 9-B; 10-B; 11-B; 12-B; 13-A; 14-B

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Excel Learning Zone is designed for absolute beginners to Microsoft Excel 2010. My goal in this session is to get you comfortable working in Excel as quickly as possible. Over the span of the first hour, I will introduce you to Excel's interface, including the ribbon, the Quick Access Toolbar, and some other essential elements. You will learn how to enter and edit data in a spreadsheet, format your sheets so that they look more professional, carry out some very basic mathematical calculations, and finally, how to save, load, and print your work.

This course is specifically crafted for users of Microsoft Excel 2010, which is part of Office 2010. If you are working with an older version of Excel, such as anything from Excel 2000 to 2007, you can visit my website where I have older tutorials available for those versions. If you're using Excel 2007, you should not have much trouble following along here since most of the features discussed are still the same. However, if you're using Excel 2003 or an even earlier edition, it's best for you to either upgrade to a newer version or seek out a tutorial designed for your version, which you can also find at my website.

Before you tackle this Excel course, I strongly recommend that you take one of my beginner Windows courses - choose Windows XP, Vista, or Windows 7, depending on what you have. You should be comfortable with things like logging in to Windows, using the keyboard and mouse, starting programs, maximizing and minimizing windows, using scroll bars, and knowing the difference between the backspace and delete keys. If you are not already familiar with these basic skills, it's best to pause here and spend some time on those skills first. Mastery of Windows basics is essential for making the most out of Excel.

For those planning to learn both Word and Excel, I suggest starting with my Word 2007 beginner course before tackling Excel. Word and word processing are generally easier for new computer users, and becoming familiar with Word's interface will make learning Excel's layout less overwhelming. Both programs use features like the ribbon, which will give you a head start. In my Word 2010 Beginner Level 1 course, you will cover everything from the user interface and formatting text to using the clipboard, saving, loading files, and more.

This beginner level 1 course is specifically for those who have little or no experience with Excel. Today's lessons are all about making sure you can use the basic features of Excel and manage your spreadsheets effectively. My aim is to have you confidently up and running with your own simple spreadsheet by the end of this course.

I've organized all my courses into four main groups: beginner, expert, advanced, and developer. Beginner classes like this one are for newcomers and provide a solid overview of Excel's most fundamental features. Once you are comfortable with these basics, you can move up to the expert series. Those classes are for people who already know their way around the basics. In the expert lessons, I explore all the everyday features of Excel in more detail and share additional options, shortcuts, and tips.

After the expert courses, the advanced series is intended for power users. Here, you'll learn about recording macros, building user forms, creating your own templates, and advanced tools that add real professionalism to your work. Finally, my developer courses will show you how to program using Visual Basic for Applications (VBA) in Excel. This allows you to automate tasks, develop Excel-based tools, and connect your spreadsheets with other Office applications.

Each training group is broken into levels. The beginner series, for example, starts with level 1, which you are taking right now, and then continues through levels 2 to 5. Each new level builds on what you learned before, introducing more topics and helping you gradually master Excel. Once you have completed all the beginner courses, you can step up to expert, then advanced, then developer.

Now, let's go over the specific lessons that are part of today's class.

Lesson 1 focuses on getting started with the Excel interface. You will learn how to launch Excel, and become familiar with key elements such as the title bar, window controls, and the File tab.

Lesson 2 continues exploring the interface, looking at the ribbon, ribbon tabs, groupings, commands, and how to access dialog boxes.

In lesson 3, you'll learn more about the interface, including the Quick Access Toolbar, the status bar, zoom controls, and scroll bars.

Lesson 4 completes the overview of the Excel environment. We'll go over the formula bar, walk through the structure of spreadsheets, explaining rows, columns, and cells, and cover how to use the mouse pointer and sheet tabs effectively.

Lesson 5 is where you will enter your first data into an Excel spreadsheet.

Lesson 6 covers how to edit and modify the data you have entered.

Lesson 7 moves into formatting your spreadsheets so they look more polished. This includes cell alignment, working with cell ranges, and using formatting options like bold, italics, and underline.

Lesson 8 expands on formatting, showing you how to change fonts and font sizes, resize rows and columns, and update foreground and background colors.

In lesson 9, we start working with calculations. I will show you how formulas operate and introduce you to the basic math operators inside Excel.

Lesson 10 builds on this by teaching how to add groups of cells together, find averages, and how the order of operations works in mathematical formulas.

Finally, lesson 11 demonstrates how to save your workbook to your hard drive, open it again later, and print your spreadsheet.

If you ever have questions about the material in these lessons, I invite you to use the Excel Interactive Student forums. If you are watching this class on my video player or through my web theater with an internet connection, you will see the student forum next to each lesson, where you can read questions and answers from other students as well as my feedback. You are encouraged to go through these and participate by adding your own questions and comments.

You can always access the forums later by visiting ExcelLearningZone.com/forums, even if you are not watching these lessons online.

For the best results, I suggest watching each lesson all the way through first before trying anything on your computer. Then, replay the lesson and follow along with me step by step. Make the same sample spreadsheet with me so you can practice as you learn. Only try to apply these new skills to your own projects after you've gotten comfortable with the examples from the videos. If you ever get lost or confused, simply watch the video again from the start, or post your questions in the student forums.

And most of all, approach Excel with an open mind. Although it might seem a bit overwhelming at first glance, once you spend some time with it you will find that it is actually quite easy to use.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Starting Microsoft Excel
Excel interface overview
Title bar and window controls
File tab usage
Ribbon overview and navigation
Ribbon tabs, groups, and commands
Dialog box launchers
Quick Access Toolbar customization
Status bar features
Zoom control
Using scroll bars
Formula bar introduction
Spreadsheet parts: rows, columns, cells
Mouse pointer functions
Sheet tabs usage
Entering data into a spreadsheet
Editing data in a spreadsheet
Cell alignment formatting
Selecting and using cell ranges
Formatting with bold, italics, underline
Changing font and font size
Resizing rows and columns
Changing cell foreground and background colors
Performing calculations with formulas
Using basic math operators
Adding multiple cells together
Calculating averages of cell groups
Math order of operations in Excel
Saving workbooks to disk
Loading workbooks
Printing spreadsheets

Article

Welcome to a beginner's guide to Microsoft Excel. If you are new to Excel, this article will help you get started and explain all the essential features you need to become comfortable and productive using spreadsheets. Whether you have never used Excel before or just need a reminder of the basics, you will find everything explained clearly and simply.

Before you start learning Excel, it is helpful to have a working knowledge of Microsoft Windows. You should already know how to log on to Windows, use the keyboard and mouse, launch programs, maximize and minimize windows, use scroll bars, and understand how the backspace and delete keys differ. These basic skills will make your journey with Excel much smoother.

Excel is a spreadsheet application, which means it is designed to help you organize, analyze, and present data, usually in the form of numbers, lists, and calculations. Spreadsheets are useful for tasks such as managing a budget, tracking sales, creating invoices, schedules, or any scenario where lists and numbers need to be organized.

When you first launch Excel, you will see a window that introduces you to the Excel interface. At the very top is the title bar, which shows the name of your current file. Just below this are the window controls that let you minimize, maximize or close the Excel window.

On the left, you will see the File tab. Clicking this reveals the backstage view, which lets you work with files, such as opening, saving, printing, or creating new spreadsheets.

One of the main navigation tools in Excel is something called the ribbon. The ribbon is a strip of buttons and icons that runs across the top of the screen. It organizes commands into tabs, such as Home, Insert, Page Layout, and so on. Each tab contains groups of related commands, like formatting tools or data operations. When you click a command, it performs an action or opens a dialog box, which lets you specify more options. Some groups have a small arrow in the corner, called a dialog box launcher, which gives you even more detailed settings.

You will also find the Quick Access Toolbar above or below the ribbon. This customizable toolbar lets you put your most frequently used commands within easy reach, such as Save, Undo, and Redo.

At the bottom of the window, you will see the status bar. It gives you information about your spreadsheet, like whether you are in edit mode and provides shortcuts for common operations. The zoom control and scroll bars help you adjust your view and move around your spreadsheet easily.

Let us talk a little bit about the structure of a spreadsheet. The main area is made up of rows and columns. Columns are labeled with letters across the top, and rows are numbered down the side. Where a column and row intersect, you get a cell. Each cell has a unique address, like A1 or C7. You enter your data into these cells.

Moving around your spreadsheet is easy with your mouse or keyboard. You can use the arrows keys to move the active cell, or click directly in any cell with the mouse. If you want to select a group of cells, click and drag your mouse across them.

Now, let us enter some data. Click in cell A1 and type some text, like "Sales", then press Enter. You will notice the active cell moves down to A2. You can enter numbers, such as "1500", or other data in other cells. If you want to edit something you typed, double click the cell or select it and use the formula bar at the top of the window to make your changes. Press Enter when you are done.

Formatting your spreadsheet makes it look more professional and easier to read. For example, you can select a range of cells, then use the bold, italic or underline buttons in the Home tab to make headings stand out. You can also align text or numbers within a cell to the left, center, or right, depending on your needs.

Changing the font or font size is easy. With your cells selected, choose a new font or adjust the size using the drop-down menus in the ribbon. You can also resize columns and rows by dragging the lines between the column letters or row numbers. If you want to add color, select a cell or range, then choose a fill color or change the font color.

Excel is powerful because it lets you do calculations and analyze data quickly. To start, you can type a formula right into a cell. For instance, if you want to add two numbers, type =A2+B2 in another cell. Excel will calculate and show you the answer. You can also perform subtraction, multiplication (use the asterisk symbol), and division (use the slash symbol). Excel follows the order of operations in math, so multiplication and division happen before addition and subtraction.

To work with groups of numbers, you can use built-in functions. For example, if you want to add up a series of numbers in A2 through A6, type =SUM(A2:A6) in another cell. To find an average, use =AVERAGE(A2:A6). Formulas and functions can save you a lot of time and prevent errors.

When you are done working, you should save your workbook. Click the File tab, then choose Save or Save As, and give your file a name and location on your hard drive. You can open it again later, make changes, and save your progress as often as you like. When you are ready to print, choose the Print command in the File tab, adjust your options, and print out your spreadsheet.

As you practice with Excel, you will start to remember where things are and how to use them. It might seem a little tricky at first, but as you get used to the interface and the different commands, things will get easier. Start by following along with simple examples, like building a basic list or budget. Do not worry about trying to apply everything you learn to complex projects right away. The more you practice, the more comfortable you will become.

Excel also has additional resources, such as online forums and help guides, where you can ask questions if you get stuck. Many users have similar questions, so you will often find answers and helpful tips from the community.

If you want to go beyond the basics, Excel offers more advanced features in later lessons, such as charts, macros, templates, and even programming with Visual Basic for Applications. But for now, focus on mastering the fundamentals discussed here: navigating the interface, entering and editing data, formatting, using simple formulas, and saving and printing your work.

With these skills, you will be ready to use Microsoft Excel for your everyday tasks, track data effectively, and set the foundation for more advanced learning in the future. Keep practicing, stay curious, and enjoy exploring what Excel can do for you.