Effective use of Excel 2013 in real life

Name: Effective use of Excel 2013 in real life
Rating: 4.2 (618 reviews)

Learn how to effectively use Microsoft Excel 2013 in real-life business scenarios.

Created byUlrika Hedlund

Last updated 6/2015

English

What you'll learn

Know what you need to know to be effective using Excel 2013 in day-to-day business scenarios
Have a good overview of the major highlights of Excel 2013
Know how to effectively navigate large data sets, sheets and workbooks
Know how to sort and filter data to find answers hidden in data sets
Know how to modify and re-arrange data in a spreadsheet to meet various needs
Know how to effectively use a PivotTable to analyze data to see it from various perspectives
Know how to use Flash Fill to quickly modify data as well as traditional formulas to change how data is presented
Know how to use formulas to perform basic calculations
Know how to use IF statements, VLOOKUP and Named Cells to perform more advanced calculations

Course content

6 sections • 12 lectures • 1h 24m total length

Welcome to this course2:23
In this lecture instructor Ulrika Hedlund gives you a quick introduction to the course.
Enhance your course experience1:30
This lecture includes some tips for how to optimize your course experience.
An introduction to Excel 20133:10
If you are new to Excel 2013 it might be useful with a quick overview of the major changes. In this lecture you will learn about some of the highlights.

Effectively navigate a spreadsheet9:53
In this lecture you'll learn how to quickly get a good overview of the contents of a spreadsheet, how to freeze rows and columns, how to navigate between different worksheets and how to compare worksheets side by side.
Check what you've learnt in this lecture
Sort and filter data to find answers9:54
In this lecture you'll learn how to sort and filter data to find answers to specific questions. You'll learn how to sort data by multiple columns, how to sort by color and how to filter using different data types.
Check what you've learnt in this lecture

Rearrange and clean up your data9:02
In this lecture you will learn how to re-arrange data, how to spot and remove duplicates and how to change data types for easier analysis.
Check what you've learnt in this lecture
Modify your data using Flash Fill9:45
In this lecture you will learn how to use the new, powerful tool Flash fill. You will also learn how to use traditional tools and formulas to modify your data.
Check what you've learnt in this lecture

Analyze data using a PivotTable9:52
When you are analyzing data it helps to look at it from different perspectives. For instance, how much did we sell last month? Or how much did we spend this year compared to last? A very powerful tool for analyzing data that you quickly want to summarize is the PivotTable in Excel. In this lecture you'll learn how to use a PivotTable to analyze data.
Check what you've learnt in this lecture
Visualize data using charts9:48
If you have a lot of numbers in a spreadsheet it really helps to visualize your data using charts. In this version of Excel, it's a lot easier to select appropriate charts since Excel analyzes your data and recommends charts for you. In this lecture you'll learn how to use charts to spot trends and how to use the updated charting tools to make your charts really stand out.
Check what you've learnt in this lecture

Use simple formulas to fill out a budget9:21
Excel is a fantastic tool for calculating numbers. You have a wide range of functions and formulas you can use. In this lecture you'll learn how to use basic calculations in Excel to fill out a marketing budget template. You'll also learn some shortcuts for how to quickly fill your spreadsheet with numbers, how to calculate sums and how to use absolute and relative references.
Check what you've learnt in this lecture
Use Lookup formulas to fine-tune your spreadsheet9:07
Sometimes when you are doing calculations you need to base your numbers on a certain criteria. For example, the amount you pay your employees might depend on how well they have performed. In this lecture you will learn how to use lookup functions in Excel to fine-tune your calculations.
Check what you've learnt in this lecture

Requirements

Students will need to have basic knowledge in using Microsoft Office applications. Viewers who have Microsoft Excel 2013 will benefit the most.

Description

Do you wish you knew how to effortlessly navigate a spreadsheet and easily find trends and abnormalities in the data? Do you wish you could create informative reports that really show off your numbers? Do you wish you could save time by knowing how to effectively use Excel to re-arrange and clean up your data? If so, this is the right course for you!

Instead of walking through individual features of Microsoft Excel one by one, this course focuses on the end result and shows you how to accomplish typical business scenarios by effectively using Excel 2013.

The course is structured into 6 sections with a total of 11 lectures. Each lecture is taught by Productivity Expert and ex-Microsoft employee, Ulrika Hedlund who shares her extensive knowledge of using Microsoft Excel 2013 effectively. Each lecture contains high-quality, High-Definition tutorial videos showing step by step how to accomplish the covered scenario. Sample spreadsheets are provided where necessary to enable students to follow along and perform the steps covered in the lecture. Full transcripts with screenshots (so called "User Guides") are available for download so that the steps covered in the lectures can be referenced at any time. To keep you focused and to provide a way for you to test your learning, quizzes are available after lectures and after the course as a whole.

Who this course is for:

This course is intended for all business professionals who want to learn how Excel 2013 can be used in various work-related scenarios and who want guidance on how to use Excel 2013 more effectively.

Effective use of Excel 2013 in real life

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 7min

Viewing data2 lectures • 20min

Cleaning and modifying data2 lectures • 19min

Analyzing and visualizing data2 lectures • 20min

Using formulas to perform calculations2 lectures • 18min

Closing1 lecture • 1min

Requirements

Description

Who this course is for: