About This Chapter
Using Microsoft Excel - Chapter Summary
Check out these simple and fun video lessons to learn about the fundamentals of Microsoft Excel. As you work through the chapter, you'll learn about basic Excel functions and actions, as well as methods you can use to customize your Excel worksheets. Each lesson comes with a short quiz, and the chapter includes a comprehensive multiple-choice exam. You can also print the lesson transcripts to study offline. When you're finished with the chapter, you should be equipped to:
- Create Excel workbooks
- Import/open files
- Add, copy and move worksheets
- Modify the worksheet tab
- Customize Excel page setup properties
- Insert/delete rows and columns
- Apply/change Excel workbook themes
- Adjust row height and column width
- Insert watermarks, headers and footers in an Excel worksheet
- Perform data validation
- Use a variety of Excel functions, including MID, TRIM, UPPER and CONCATENATE
1. How to Add, Copy, and Move Worksheets Within Excel Workbooks
Excel is a great tool for organizing information and large amounts of data. But how do you organize different worksheets in Excel? Watch this lesson to find out how to add, copy, and move worksheets in Excel.
2. How to Modify the Worksheet Tab in Excel
Excel workbooks can have several pages or worksheets. Each page is identified using a worksheet tab. This lesson will review how to add and remove worksheets, how to rename worksheets and how to change the color of the tab fill.
3. Modifying Page Setup Properties in Excel
When you need to change the orientation, modify the page size, adjust margins or add title rows to printed pages, the Page Setup grouping of commands is the place to get it done. This lesson will guide you through modifying your page setup options.
4. How to Insert & Delete Columns & Rows in Excel
The next time your create a spreadsheet, you will undoubtedly find yourself in need of being able to insert and delete rows and/or columns. This lesson will detail the steps to adding and removing rows and columns in Excel.
5. Workbook Themes: Applying & Changing Themes in Excel
Themes in MS Excel are a collection of colors, fonts and effects designed to provide consistency throughout your workbook. This lesson will discuss how to apply themes to your MS Excel documents.
6. Adjusting Column Width & Row Height in Excel
From time to time, you may need to adjust the column width or row height of an Excel spreadsheet. This lesson will demonstrate different ways to make these adjustments.
7. How to Insert Watermarks in Your Excel Worksheet
Although Excel does not have a feature to automatically add watermarks, similar to Microsoft Word, there is a way to mimic a watermark on a worksheet. This lesson will demonstrate two ways to add a watermark to an Excel spreadsheet.
8. How to Insert Headers & Footers in Excel
Excel has a feature that allows you to add header and footer information that displays on your printed Excel document. Headers and footers help make the document a bit more professional and easier to read.
9. Using Data Validation in Excel
Have you ever wanted to restrict what type of data is entered into an Excel spreadsheet as well as how it's entered? Excel's data validation feature can help you do just that. This lesson will explain data validation and demonstrate how to set limitations on data entered on Excel worksheets.
10. Using the RIGHT, LEFT and MID Functions in Excel
Have you ever needed to capture or extract just a piece of a data string in a cell? For instance, the cell data is RGT123456K9, but all you need is the middle six numbers? The RIGHT, LEFT and MID functions will help you extract just would you need.
11. Using the TRIM & CLEAN Functions to Fix Data in Excel
Have you ever received an Excel file with information imported from another database? Did you find extra spaces? Non-printable characters? This lesson explains how to use the TRIM function and its partner, CLEAN.
12. Using the UPPER and LOWER Functions in Excel
If you need to change the text in a worksheet to uppercase, lowercase, or just return it to proper case, there is a function that you can use to write a formula and Excel will do the work. This lesson will discuss the upper, lower, and proper functions in Excel.
13. How to Use the CONCATENATE Function in Excel
Ever want to combine two columns into one? This lesson will demonstrate how to use the Concatenate function in Excel. Using this function in a formula will allow you to merge multiple columns of data into one.
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.
Other chapters within the Computer Science 103: Computer Concepts & Applications course
- Basic Computer Concepts
- Computer Hardware Components & Functions
- Application & System Software
- Operating Systems for Computers
- Telecommunications Systems
- Understanding Computer Files
- Troubleshooting Computer Issues
- Web Browsers & Technology
- Using Microsoft Word
- Using Microsoft PowerPoint
- Database Fundamentals
- Computer Programming Fundamentals
- Systems Development & Analysis
- Computer Threats & Security
- Technology's Ethical, Legal & Privacy Issues