Lessons

Resources

Full Course Outline
Skills Test Quiz - Under Construction
Certificate of Completion
Post-Class Survey

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.

Subscribe to Excel 2003 Expert 232
Get notifications when this page is updated

Intro

In lesson 232 you will learn how to create custom number and date formats in Microsoft Excel, as well as how to manipulate text using a variety of text functions. This lesson builds on concepts from previous courses but can be taken on its own, and all examples are compatible with most versions of Excel.

Transcript

Welcome to Microsoft Excel 232, brought to you by excellearningzone.com. I am your instructor, Richard Rost.

Today's class has two main focuses. We are going to learn custom number and date formats, and we are going to learn how to manipulate text using text functions.

This class follows Excel 231; however, you do not necessarily have to have taken 231 to benefit from the lessons in this class. They are not exactly one following the other. I do recommend you finish all of my 100-level classes, especially Excel 104.

I'll be using Excel XP 2002. However, all of the functions that are in this class should work in any version of Excel.

As always, I recommend you sit back, relax, and watch the lesson through once, and then try the examples on your own. There is a sample Excel spreadsheet that you can download off the website. Here is the address: excellearningzone.com?goxl232. That's goxl232.

While you are there, feel free to post your questions, comments, and other thoughts about the class with other students and me on the website. Of course, if you need help, you can contact me at excellearningzone.com/contact.

Quiz

Q1. What are the two main focuses of this Excel 232 class?
A. Custom number and date formats, and manipulating text using text functions
B. Chart creation and pivot tables
C. Macros and VBA scripting
D. Data analysis and conditional formatting

Q2. According to the instructor, is it necessary to take Excel 231 before taking this class?
A. Yes, it is required
B. No, but it is highly discouraged
C. No, but completing the 100-level classes, especially Excel 104, is recommended
D. Yes, and also Excel 201 is required

Q3. Which version of Excel is demonstrated in the lessons?
A. Excel 2010
B. Excel XP 2002
C. Excel 2019
D. Excel 365

Q4. Are the functions taught in this class compatible with other versions of Excel?
A. Only with Excel XP 2002
B. Only with Excel 2019 and newer
C. No, they are unique to this version
D. Yes, they should work in any version of Excel

Q5. What does the instructor recommend you do before trying the examples?
A. Try the examples before watching the lesson
B. Watch the lesson through once, then try the examples on your own
C. Skip to the practice exercises
D. Only read the provided manual

Q6. What additional resource is available to accompany the class?
A. A downloadable sample Excel spreadsheet
B. Free coaching sessions
C. Printed textbook
D. Practice quizzes only

Q7. Where can students post their questions and comments about the class?
A. Only via email
B. On the excellearningzone.com website with other students and the instructor
C. On a Facebook group only
D. In the downloadable spreadsheet

Answers: 1-A; 2-C; 3-B; 4-D; 5-B; 6-A; 7-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 focuses on two important topics in Excel. First, I am going to cover custom number and date formats. You will learn how to control the way numbers and dates are displayed in your spreadsheets, allowing you to present your data exactly how you want. Next, I will introduce you to a set of powerful text functions that let you manipulate and modify text inside your worksheets. These tools can help you extract characters, join text together, change case, and much more.

This class follows Excel 231, but you do not have to take that course before this one. The material in this lesson stands well on its own, so you can jump in and start learning right away. That said, I strongly recommend you go through all of my 100-level Excel lessons, especially Excel 104, if you are new to the program or want a solid foundation.

For this series, I am demonstrating using Excel XP 2002, but all of the functions and techniques you will see here also work in later versions of Excel.

As always, my advice is to watch the entire lesson first to get a sense of how everything works. Once you feel comfortable, try out the sample exercises on your own. A sample Excel file is available for download from my website at excellearningzone.com?goxl232. Use this file to follow along and practice the skills you learn in the video.

If you have any questions, comments, or want to share your experience with other students and me, you are welcome to interact through the website. And of course, if you need more help, you can always contact me directly at excellearningzone.com contact.

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

This is an introductory message and class overview for a Microsoft Excel tutorial video, explaining the main topics to be covered and providing general course information.