This was an awesome learning experience. Iearned so many new things and alternative approaches to accomplishing things. The formulas and functions lessons are so helpful and makes that part of Excel much less daunting for me. Thank you so much!
I enjoyed this class tremendously! It was very helpful for me professionally.
This was a very informative class that I found to be at a level that made it easy to learn the course materials. The instructor used a language that was easy for the "newbie" to learn. I will definitely be advising friends and co-workers to take this course. I am looking forward to taking the Intermediate course!
I really liked the instructor and the way the class was set-up. It was very clear and well organized. I would highly recommend this class and I am excited to take the Intermediate Excel course!
This often tedious subject was presented in an interesting and informative manner. I found the screenshots to be extremely helpful. I will recommend Chad Wambolt's courses to anyone who is interested in learning more about Excel. Excellent class. Thank you, Mr. Wambolt for making it as painless as possible!
Course Code: ix6
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 7, Microsoft Windows 8, or Microsoft Windows 10 Microsoft Office Home and Student 2016 or Microsoft Office 365 are acceptable.
A free 30-day trial of Office 365 Home Premium may be available at (https://office.microsoft.com/en-us/try/). Then, a subscription can be purchased for as little as $9.99 per month. Please be sure to install the software on your computer before the course begins.
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 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.