Course Code: ix7
Develop a solid understanding of the Excel interface, discover the best way to correct just about any mistake you might make in Excel, and learn to move from cell to cell while leaving behind expertly written labels, numbers, and formulas. Then, learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.
Learn a wide variety of useful shortcuts and the art of file management, so you'll have no trouble saving, retrieving, printing, and emailing your worksheets, or copying, renaming, and even deleting files. Then, focus on writing sophisticated formulas that can help ease you through some rather sticky scenarios.
Gain hands-on experience in the construction of three-dimensional workbooks that goes beyond just rows and columns. Then, you'll not only learn how to build a database in Excel, you'll also learn how to subtotal, sort, and filter.
Build your first graph and learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart. Then, find out how to personalize your charts with photographs, text labels, and drawings, and discover the best ways to print or otherwise display the truly impressive charts that you'll be creating.
Find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers. Then, learn to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation as well as how to calculate the monthly payment on just about any type of loan, and how long it will take to pay off your credit cards. You'll even create an amortization table just like lenders use to track a loan's payoff amount over time.
Learn how to automate just about any task you find tedious or time-consuming. Finally, you'll teach Excel not only how to make decisions, but also how to act upon those decisions.
Chad Wambolt is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. He has spent his entire professional career in the finance field, working for both privately and publicly held companies with sales ranging from $500 million to $3 billion. Through the course of his career, Chad has become an expert user of Microsoft Excel. His knowledge of Excel's capabilities has helped organizations streamline processes and save countless hours of labor. Chad has taught Excel to students of varying skill levels since 1997.
There are no prerequisites to take this course.
Instructional material requirements:
A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!
Once a session starts, two lessons will be released each week, for the six-week duration of your course. You will have access to all previously released lessons until the course ends.
Keep in mind that the interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.
The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.
I think this is the best course I have ever taken."
This class was so much easier to comprehend than any text on the market!"
Well Done! Thorough and easy to understand."
Wow! I learned so much in this class. It was informative and fun at the same time. I feel confident enough now to say that I know Excel."
As an older person looking for a different career, I knew I needed new skills. I was worried I was too old to manage class learning, but it worked out great! The class was so clear and easy to follow. I can't believe the amount of knowledge I've gained. Thanks!"
I really enjoyed this course and its "work at your own pace" design. I look forward to expanding my knowledge of Excel with an intermediate course in the future."
This has been one of the most interesting and informative Excel classes. I enjoyed learning everything. I was going to start off with Intermediate Excel but glad I didn't. That will be my next venture with Excel. I enjoyed taking this class and now I have a better understanding of Excel and how many of the function works. I can't wait to sign up for the next level."
This course was extremely helpful and delivered information in just the right "bites". It is well organized, and easy to refer back to when you move on to working with your own data and worksheets. It quickly gave me more confidence in navigating through Excel. Thank you."
Thank you for putting this course together! It has been so nice to fit it into my schedule as I needed. Excel is awesome and I've just seen the tip of the iceberg!!"
Our instructor, Chad Wambolt, was great! His friendliness and pleasant attitude made learning enjoyable. Throughout the lessons, Chad included encouraging words to keep us going. Thank you so much for doing a great job!"