In this hands-on course, you will learn how to utilize Excel’s data analysis tools and AutoFilter commands to create informative, eye-catching charts and graphs. In addition, you will see how easy it is to create macros that let you manipulate data with the push of a button. You will also learn how to use Goal Seek and Solver and apply them to real-world problems. And you will set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel’s other time-saving functions to your repertoire.
EXCEL 2013 CHARTS AND GRAPHS
In your first lesson, you will discover why Excel 2010 is such a powerful and user-friendly charting tool. To you, a workbook’s numbers might tell an interesting story. But to others, that story might not be quite so obvious—they might just see plain old numbers. You will learn how to choose the right chart for your story and then how to create, format, and edit your chart.
MORE EXCEL CHARTS
This lesson continues exploring Excel’s charting options—this time looking at the lesser-known options that are available to you. Even though they may not be well-known, these options can add tremendous value to your worksheets in the right situations.
AUTOFILTER AND SORTING
Working with data in Excel can be quite easy when you know about the tools that are available in a table format. One of these great tools is the Auto Filter command. This lesson will teach you how to use Auto Filter to limit your table information to just the records you want.
If you know what formulas you want, but you just don’t know which formula will get you there, then Excel’s Goal Seek is exactly what you need. In this lesson, you will learn how to utilize this tool to avoid the trial-and-error approach that most Excel users go through to get to the right answer.
This lesson will teach you how to use one of the best features of Excel: the PivotTable. There’s no greater what-if analysis tool to summarize, reorganize, and report data.
ADVANCED PIVOT TABLES
Just like charting, Excel’s Pivot Tables are too big a topic to fit into one lesson. This lesson takes a tour through some of Excel’s more advanced techniques, like the PivotTable filtering tool Slicer. You will also learn how a PivotTable can serve as your source for the PivotChart.
Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you will learn how to use Solver to solve a complex problem based on criteria and constraints.
There’s nothing more exciting than learning how to master a new feature in Excel. This lesson introduces how to create all three types of Sparklines, as well as formatting options for each. By the end of the lesson, you will have the skills to create dashboard-style mini charts.
In this lesson, you will find out how to use macros to turn repetitive and often time-consuming tasks into automated Excel functions. You will also learn how to record a macro that performs time-consuming task in seconds with the click of a button.
INTRODUCTION TO FUNCTIONS
If you have used Excel for a while, you know there are hundreds of functions at your disposal. The last three lessons of this course will cover how and why you would use them. This lesson introduces creating various functions using some from the Text category.
Next to learning how to create macros, most students want to learn as much as they can about Excel functions. This lesson focuses on more complex functions of the “Math & Trig” category, the SUMIF and COUNTIF functions in particular.
VLOOKUP, INDEX, AND MATCH FUNCTIONS
Since functions are such an important and integral part of using Excel, your final lesson will cover some of the more advanced features. In this lesson, you will learn how to use the VLOOKUP, INDEX, and MATCH functions.
Prerequisites / Requirements
There are no prerequisites to take this course.
- This course must be taken on a PC. It is not suitable for Mac users.
- Windows XP or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- 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).
- Adobe Flash Player. Click here to download the Flash Player.
- Adobe Acrobat Reader. Click here to download the Acrobat Reader.
- Email capabilities and access to a personal email account.
- Software must be installed and fully operational before the course begins.
WHEN CAN I GET STARTED?
Instructor-Led: A new session of each course begins each month. Please refer to the session start dates for scheduling.
Self-Paced: You can start this course at any time your schedule permits.
HOW DOES IT WORK?
Instructor-Led: Once a session starts, two lessons will be released each week, for the 6 week duration of your course. You will have access to all previously released lessons until the course ends.
Self-Paced: You have three-month access to the course. After enrolling, you can learn and complete the course at your own pace, within the allotted access period.
HOW LONG DO I HAVE TO COMPLETE EACH LESSON?
Instructor-Led: 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.
Self-Paced: There is no time limit to complete each lesson, other than completing all lessons before your three-month access.
WHAT IF I NEED AN EXTENSION?
Instructor-Led: 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.
Self-Paced: Because this course is self-paced, no extensions will be granted after the start of your enrollment.