I enjoyed the way Mr. Wambolt taught his class. I took both the Basic and Intermediate Excel classes that he taught and I would highly recommend his class to others.
The instructor's writing style, coupled with colored screenshots, made this a very effective learning experience.
This was the second Excel course I have taken, and again it was a great course. I learned many valuable things that I can apply to my job and home business. Thank you for your time and effort in teaching this course.
Great class and instructor! I learned a lot.
I have made a great impression on my boss by using the formatting techniques that I have learned so far in your class. He is dumb-founded by what I am creating. Just a few months ago, he asked me about creating charts, pies, graphs, and I seriously thought about taking a leave of absence, but no more.
This was the first online class I have ever taken and I was really worried about being able to keep up. I can't believe how easy it was to access and keep up, plus the instructor made it fun and easy. I would recommend this class to anyone. Thank you!
Thanks so much for a great course! I learned a lot from this course and have already incorporated many of the things I was taught into my work day. I plan to take the advanced excel course very soon.
I really enjoyed this class. Excel was one of the programs that I had very little knowledge of, but I found I was using it more and more in my job. I now feel as if I can create formulas and databases to suit my needs. Thank you, it was great!
I really enjoyed this class. I feel that it was definitely worth the price and time I spent. The things I learned will help me to be more productive on my worksite. Thank you!
I really like the way the course is set up. The lessons are clear and easy to follow, I have time to learn at my own pace, and have access to an instructor if need be.
Course Code: nx0
Find out how to choose the right chart for telling your story with numbers, and then how to create, format, and edit your chart to help others clearly visualize that story. Then, explore some of Excel’s lesser known charting options and how they can add tremendous value to your worksheets in the right situations.
Learn how to use Auto Filter to limit your table information to just the records you want. Then, you’ll learn how to use Goal Seek to display the information you need when your formula isn’t returning the answers you want.
Practice creating a PivotTable and discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. Then, you’ll move on to more advanced Pivot Table features including a new Excel 2010 PivotTable tool called Slicer.
Learn how to use Solver to solve a complex problem based on the criteria and constraints we provide it. You’ll also explore in detail how to create all three types of Sparklines, as well as formatting options for each and gain the skills to create dashboard-like mini charts sure to make you the envy of your office.
Find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Then, receive a quick overview of all the categories of functions and the different methods you can use to create them.
Dig a little deeper into using some of the slightly more complex functions that you'll find in the Math & Trig category, specifically the SUMIF and COUNTIF functions. Finally, learn how to use the extremely popular VLOOKUP function as well as INDEX and MATCH functions.
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, and Microsoft Excel 2010 or Microsoft Excel Home and Student 2010 or Microsoft Office 2010 (the Home and Student Edition or Standard Edition of Microsoft Office 2010 is acceptable).
Please be sure to install the software on your computer before the course begins.
This course is not suitable for Macintosh users or for users of older versions of Microsoft Excel.
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.