Loading...

Course Description

Harness the power of Excel and become a master user of this powerful program. This hands-on course will provide skills using charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2016 functions.

Course Outline

  1. Lesson 01 - Excel Charts and Graphs
    • In your first lesson, you will discover why Excel 2016 is such a powerful charting tool. To you, a workbook's numbers might tell an interesting story; to others, that story may not be obvious. You will learn how to choose the right chart for your story and then how to create, format, and edit your chart.
  2. Lesson 02 - 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.
  3. Lesson 03 - 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.
  4. Lesson 04 - Goal Seeking
    • Learn how to use Solver to solve a complex problem based on the criteria and constraints that you 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.
  5. Lesson 05 - PivotTables
    • 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.
  6. Lesson 06 - Advanced PivotTables
    • Just like charting, Excel's PivotTables 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.
  7. Lesson 07 - Solver
    • 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.
  8. Lesson 08 - Sparklines
    • There's nothing more exciting than learning how to master a new feature in Excel. This lesson focuses on creating 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.
  9. Lesson 09 - Macros
    • 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 a task in seconds with the click of a button.
  10. Lesson 10 - 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 these functions. This lesson introduces creating various functions with the Text category.
  11. Lesson 11 - Math/Trig Functions
    • Next to learning how to create macros, most students want to learn as much as they can about Excel functions. This lesson covers on more complex functions of the "Math & Trig" category, focusing on the SUMIF and COUNTIF functions in particular.
  12. Lesson 12 - VLOOKUP, INDEX, and MATCH Functions
    • Since functions are such an integral part of using Excel, your final lesson will cover advanced features. In this lesson, you will learn how to use the VLOOKUP, INDEX, and MATCH functions.

Notes

This is an asynchronous online course offered through the third party vendor ed2go. This course must be taken on a PC. It is not suitable for Macs. The instructional materials required for this course are included in enrollment and will be available online. There are twelve lessons in the course, and two lessons are released each week on Wednesdays and Fridays. You do not have to be present when lessons are released. You will have access to all lessons until the course ends. However, the interactive discussion area that accompanies each lesson will automatically close two weeks after the lesson is released. As such, we strongly recommend that you 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 to complete all of your course work, including the final exam.
Loading...
Please call our Customer Service Center at 704.330.4223 for information on the next available section.
Required fields are indicated by .