MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Intermediate Microsoft Excel 2013

### Course Summary

A new session of this course starts monthly. Take your Microsoft Excel 2013 skills to the next level as you master charts, PivotTables, Slicers, Sparklines, and other advanced Excel features.

• +

## Week 1

### Lesson 01

In our first lesson, you'll 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. So, today, you'll find out how to choose the right chart for telling your story and then how to create, format, and edit your chart to help others clearly visualize that story.

### Lesson 02

There are so many great charting features and enhancements in Excel 2013, there's no way we could cover all of them in a single lesson. So, today, we'll continue exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they aren't well-known, these options can add tremendous value to your worksheets in the right situations. We'll walk through a few of them step-by-step, so you'll see the value for yourself.

## Week 2

### Lesson 03

Working with data in Excel can be quite easy—and sometimes even fun—when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In today's lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color.

### Lesson 04

Normally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want, but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. In this lesson, we'll walk through multiple examples together, exploring several ways to apply this great feature.

## Week 3

### Lesson 05

Today, you'll learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you know what I mean. There's no greater what-if analysis tool to summarize, reorganize, and report data. When we practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective.

### Lesson 06

Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. So, today, we'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart. Last, you'll become an expert in using the Excel 2013 PivotTable filtering tool called Slicer.

## Week 4

### Lesson 07

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'll learn how to use Solver to solve a complex problem based on the criteria and constraints we provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off.

### Lesson 08

There's nothing more exciting than learning how to master a new feature in Excel. In today's lesson, we'll explore in detail how to create all three types of Sparklines, as well as formatting options for each. By the end of the lesson, you'll have the skills to create dashboardlike mini charts sure to make you the envy of your office. If you enjoy creating charts, you'll really enjoy this lesson.

## Week 5

### Lesson 09

Today's topic is a student (and instructor) favorite. In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button!

### Lesson 10

If you've used Excel for a while, you know there are hundreds of functions at your disposal. We're going to spend the last three lessons of this course going over exactly how and why you'd use them. We'll start today by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, we'll ease into creating various functions using some from the Text category.

## Week 6

### Lesson 11

Next to learning how to create macros, most students want to learn as much as they can about Excel functions. In today's lesson, we'll dig a little deeper into using some of the slightly more complex functions that you'll find in the Math & Trig category. Specifically, we'll look at two of my favorites, the SUMIF and COUNTIF functions, and discuss how to use one of the more complex functions, SUMIFS.

### Lesson 12

Since functions are such an important and integral part of using Excel, we'll spend our final lesson going over a few more of them. Today, you're going to learn how to use the extremely popular VLOOKUP function. If you're already accustomed to using VLOOKUP, don't feel short-changed, because we're going to add to the complexity. We're going to use the INDEX and MATCH functions to do something just short of amazing.

• +

### Recommended Background

Requirements

• Internet access

• Email

• One of the following browsers:
o Mozilla Firefox
o Microsoft Internet Explorer (9.0 or above)
o Google Chrome
o Safari
• Adobe PDF  plug-in (a free download obtained at Adobe.com .)

Microsoft Windows 7 or Microsoft Windows 8; Microsoft Excel 2013 or 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) of Microsoft Office 2013 are all acceptable.  A free 30-day trial of Office 365 Home Premium may be available at Office Online. 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 who are using the Office Mac Home versions or for users of older versions of Microsoft Excel. "Starter Version" and "Web App" versions of Microsoft Excel 2013 will not work with the full version of Excel taught in this course.

• +

### Course Format

Online, self-paced, instructor monitored.   Each course contains a discussion area to submit questions to a real instructor.

• +

Course Fee:
USD 99

Instructor-Led

Active

1 Jul 14

31 Dec 16

Related Posts:

## Data Analysis

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software