This was a great course. I learned a lot. The lessons, assignments and quizzes were clear, concise and extremely relevant to the final. I enjoyed the instructor's teaching style as well.
Great course! I am much more confident of my Excel abilities and learned something new in every lesson. They were just about the perfect length too, as I have very limited free time. I’m looking forward to the intermediate class this fall.
This course was amazing! I never could have believed that I could have gained so much knowledge and skill with the program in only 12 lessons. I can't say enough good things about the professional presentation of the course. The explanations were simple and easily understood with pictures to support them. Mr. Wambolt’s communication was professional yet friendly.
I have never had any Excel training and this course was absolutely wonderful. It opened my eyes to the many things that can be done with Excel. I am so very happy I took this course and the instructor was FANTASTIC!
This is my first time taking an on-line class. It was a great experience. The lessons were easy to understand and follow. I liked that I was able to do them at my convenience. I have recommended it to many friends and I would definitely do it again.
This was the perfect course for my skill level. I learned so much!
Excellent course! I've used Excel in business but didn't know many of the tricks taught in the class.
I enjoyed this course and can’t wait to use it for my business!
This was exactly what I needed! I have always needed to learn Excel but never took the time, so I just had others do it for me. I found this course to be extremely well done and I really learned a lot. I am excited to put it to use.
I just wanted to thank you and let you know that the day after I took my exam I did some job testing with a temp agency; out of six tests I did best on the ones dealing with Excel and Word. I know I did better on my Word test because of things I learned in this Excel class. I'm already working through the Intermediate Excel course and will be taking the Advanced next. My hat is off to you for being able to teach Excel in such a way that I enjoyed it in spite of myself: Well done.
Course Code: ixt
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 for this course.
Microsoft Windows 8, Microsoft Windows 7, Vista, or XP
Microsoft Excel 2010 or Microsoft Office 2010 (the Home and Student Edition, Home and Business Edition, or Professional Edition) of Microsoft Office 2010 are all acceptable.
This course is not suitable for Macintosh users, users of older versions of Microsoft Excel, or users of OpenOffice.
Note: "Starter Version" and "Web App" versions of Microsoft Excel 2010 will not work with the full version of Excel taught in this course.
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.