Instructor is very knowledgeable and makes learning fun, too."
I really enjoyed this class and having used Excel 2003 at work and home, it was nice to be taught the newly added features with Excel 2007. I really think that the ribbon format is a very nice feature and that the options and tools to use in Excel 2007 are easy to find. I look forward to using what I learned at work and home. I would have liked to learn a little more with macros and functions but hope that the advanced Excel course will touch a little more on these concepts. The discussion areas were a nice feature to have if I encountered any problems with assignments since maybe other students were having the same issues. Overall, I really enjoyed the class and look forward to taking the advanced Excel course to learn even more. Thank you."
I enjoyed this course, and the instructor, so much that I plan to take the Advanced Excel course!"
I have been an Excel user for many years and wanted more exposure to Excel 2007. This was a great help. The course guided me through the new user interface expertly."
I thought this was a great paced course as I work full time and was still able to spend the time needed to complete this course and the assignments. The instructor was very knowledgeable and helpful and provided supplemental information which will be useful to refer back to later on."
Great course. Very relevant topics and well presented for an online course. Thanks!"
I have thoroughly enjoyed the class. I took this class for my personal improvement. The class itself, has exceeded my expectations. The instructor was very responsive with class participation and the materials are easy to read (not as stuffy as the normal text book.) I am glad that I signed up for this class. Enjoyed it thoroughly!!!!"
The convenience of the online course allowed me to continue sessions while on travel."
The course was excellent - Chad's writing style was very engaging. I am an experienced excel user and wasn't sure if this was the right level for me. I took it because I wanted the experience of an on-line course. The experience was great. I was looking for more depth in the macro and functions area. The charting section helped me to visual better which charts are best for the purpose. Loved the ability to group items in the pivot table and then collapse the view this has been very valuable already."
Awesome Instructor, very helpful and very knowledgeable!"
Course Code: nx7
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 how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart.
Learn how to use and master Solver to solve a complex problem based on the criteria and constraints we provide it in hands-on exercises.
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 has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
There are no prerequisites to take this course.
The instructional materials required for this course are included in enrollment and will be available online.
A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits.
Once a course 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.
The interactive discussion area for each lesson automatically closes two 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 two weeks plus 10 days (24 days total) to complete the final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.