Effective use of Excel 2013 in real life

Learn how to effectively use Microsoft Excel 2013 in real-life business scenarios.
4.4 (19 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
641 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 12
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English Closed captions available

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

What are the requirements?

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

What am I going to get from this course?

  • 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

What is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:23

In this lecture instructor Ulrika Hedlund gives you a quick introduction to the course.

01:30

This lecture includes some tips for how to optimize your course experience.

03: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.

Section 2: Viewing data
09: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.

2 questions

Answer these two True/False statements to make sure you are learning.

09: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.
2 questions

Answer these two True/False statements to make sure you are learning.

Section 3: Cleaning and modifying data
09: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.

2 questions

Answer these two True/False statements to make sure you are learning.

09: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.
2 questions

Answer these two True/False statements to make sure you are learning.

Section 4: Analyzing and visualizing data
09: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.

2 questions

Answer these two True/False statements to make sure you are learning.

09: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.
2 questions

Answer these two True/False statements to make sure you are learning.

Section 5: Using formulas to perform calculations
09: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.

2 questions

Answer these two True/False statements to make sure you are learning.

09: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.
2 questions

Answer these two True/False statements to make sure you are learning.

Section 6: Closing
Summary
Preview
01:07
Check what you've learnt in this course
18 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Business Productivity, Results-focused training

Are you bored of lengthy, feature-based product courses? We are, and that's why we founded Business Productivity. Business Productivity offers unique scenario-based courses showcasing real life business results. Our instructor, Ulrika Hedlund, has years of experience helping organizations improve productivity by combining workplace best practices with effective use of technology.

Ready to start learning?
Take This Course