Intermediate Microsoft Excel 2013

Intermediate Microsoft Excel 2013

Take your skills to the next level, and harness the full power of Excel. This hands-on course will help you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2013 functions.
6 weeks / 24 Course Hrs
SHARE
  • Details
  • Syllabus
  • Requirements
  • Instructor
  • Reviews

Details

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.

Enrollment Options:
Instructor-Led
6 weeks Access Course Code: nx8
Start Dates*Nov 13 | Dec 11 | Jan 15 | Feb 12
*Choose start date in cart
$109.00
Self-Paced
3 Months Access Course Code: T9253
No Instructor, Start Anytime
$115.00

Syllabus

In your first lesson, you will discover why Excel 2013 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.

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.

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.

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.

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.

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.

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.

Requirements

  • 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.

Requirements:

Hardware Requirements: 

  • This course can be taken on either a PC or Mac.
  • This course is not suitable for Mac users who are using the Office Mac Home versions.

Software Requirements: 

  • PC: Windows 7 or later.
  • Mac: OS X Snow Leopard 10.6 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
  • Any of the following (not included in enrollment):
    • Microsoft Excel 2013
    • Microsoft Office 2013
    • Office Home and Student 2013
    • Office Professional Plus 2013
    • Office Standard 2013
    • Office Home and Business 2013
    • Office 365, Office 365 ProPlus
    • Office 365 Home Premium
    • Office 365 University
  • Note that the "Starter Version" and "Web App" versions of Microsoft Excel 2013 will not work with the full version of Excel taught in this course.
  • Adobe Flash Player. Click here to download the Flash Player.
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Software must be installed and fully operational before the course begins.

Other:

  • Email capabilities and access to a personal email account.

Prerequisites:

There are no prerequisites to take this course.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Instructor

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.

Reviews

This is the second Microsoft Excel 2013 class that I've taken with Chad Wambolt and I continue to be very impressed. The new skills that I've learned will be 100% applicable to my current job. Thanks!

Thank you for a great course. This was my first online course. I was always scared to start an online class, but this was truly a fun class and I would recommend this to any one. Thanks again, I feel confident in using Excel now.

Wonderful instructor! Chad breaks down the concepts and information step-by-step so that it can be easily absorbed and understood. The FAQs, quizzes, and supplemental information are all wonderful tools to emphasize what we're learning. Also, the discussion has proven to be very helpful when there is any confusion. I have recommended and will continue to recommend classes, especially if they are taught by Chad!

Chad's writing style is fabulous. The lessons were fun and very entertaining.

I thoroughly enjoyed this course. I liked the way the instructions were presented since the level of difficulty was challenging at times. He explained the latter chapters very well, since I had no experience with Solver, Goal Seeker, SUMIFS, or COUNTIFS. I can't wait to use these at work! I would definitely recommend this for anyone wanting to learn more. Thank you!

I found the course to be extremely helpful and informative. I particularly like the Sparklines and goal seek tools and have already used them. There was so much information! I would definitely recommend this course.