Course Code: ix8
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 appreciate what I learned and I gained some new skills in Excel 2013. I learned a lot about the new features and what makes Excel easier to work with, so that was a plus. Thank you for this wonderful course."
Thank you for the awesome lessons! I learned a lot and enjoyed the last three lessons the most. I love Excel and I certainly will recommend this course to everyone."
I found this course to be among the best I have ever taken and I feel like my proficiency, as a result, is going to only improve!"
Thank you for a great course. It exceeded my expectations. I learned more about Excel than I thought I ever could. I am really pleased that I decided to take to this course. Thank you, again."
This was truly an informative course for a beginners' course. The instructor's lesson content was organized and well-thought-out for easy comprehension."
The instructor did a great job of breaking down the material to a very understandable level. I was timid and nervous about Excel before taking this course, and now I feel a lot more comfortable because of the notes and descriptions in each chapter. Thank you, Chad."
I have taken other online, self-paced Excel courses before, but this was by far THE BEST. Having an instructor available to answer my questions is unlike anything else on the market. I enjoyed learning at my own pace, but still having an Excel expert willing to provide help when needed. In the Discussion Area, I learned a lot from my fellow students as well."
I am so glad I signed up for this class! Chad Wambolt is well-versed in Excel 2013 and has put together an interesting, informative, and thought-provoking class. I can't wait to sign up for his next-level Excel 2013 class!"
I'm not a data or a numbers expert, but what your class helped me see is that I don't have to be in order to benefit from working in Excel. Just using simple spreadsheets for a few everyday functions, such as sorting and filtering, can make my work life run a lot more smoothly! Thank you!"