About This Chapter
Introduction to Excel: Chapter Summary
Microsoft Excel is one of the most commonly used office software products in the business world today. Spreadsheets are used for budgets, data collection, schedules, expense tracking and a myriad of other things. In this chapter, you'll explore the toolbar and learn how to customize it to fit your needs. You'll create worksheets and workbooks and learn the ins and outs of cells, rows and columns. And perhaps most importantly, you'll find and learn how to use the help features within the program.
Our short, engaging video lessons introduce you to all the basic functionality of Excel. Screen grabs, graphics and expert instructors present the material in easy-to-grasp segments that simplify learning. You can work at your own pace and review as often as you like. Each lesson concludes with a short, multiple-choice quiz - perfect for quick self-assessment. You'll have a solid start in Excel after completing lessons on these topics:
- Uses for Excel
- Menu bar tools
- Customizing the Quick Access Toolbar
- Worksheets and workbooks
- Formula and status Bars
- Navigation in Excel
- Assigning and modifying shortcut keys
- Exploring help features
(Note: All demonstrations in this chapter will be using Microsoft Excel 2013. Certain features, tools, or displays may be different in other versions.)
Excel is a registered trademark of the Microsoft Corporation, which is not affiliated with Study.com.
1. Common Uses for Excel Spreadsheets
Watch this video lesson to see the different ways an Excel spreadsheet can be used. See how it can be used to keep data in addition to how it is used to make calculations.
2. How to Customize the Quick Access Toolbar in Excel
If you're new to Excel, you may be somewhat bewildered by the power of this program. However, Excel does have a very quick way to do basic operations, such as saving, undoing, and printing--the Quick Access Toolbar.
3. What is a Workbook in Excel? - Characteristics and Options
Excel allows users to organize data, but to organize your information most effectively, you should understand the difference in workbooks and worksheets, and how to use workbooks. Watch this lesson to find out how.
4. Using the Formula Bar in Excel
Watch this video lesson to see how you can use the formula bar to check the contents of a cell in your spreadsheet or manipulate data. Then, test your understanding with a brief quiz.
5. Navigating in Excel
In order to make use of all that Excel has to offer, it makes sense to start by getting used to where everything is at. In this lesson, we learn how to better navigate Excel, from the different cursors to switching between sheets and windows.
Earning College Credit
Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Transferring credit to the school of your choice
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.