Effective use of Excel 2013 in real life
4.7 (45 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.
724 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Effective use of Excel 2013 in real life to your Wishlist.

Add to Wishlist

Effective use of Excel 2013 in real life

Learn how to effectively use Microsoft Excel 2013 in real-life business scenarios.
4.7 (45 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.
724 students enrolled
Created by Ulrika Hedlund
Last updated 6/2015
English
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 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.
Compare to Other Excel Courses
Curriculum For This Course
12 Lectures
01:24:52
+
Introduction
3 Lectures 07:03

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

Preview 02:23

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

Preview 01:30

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.

Preview 03:10
+
Viewing data
2 Lectures 19:47

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.

Preview 09:53

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

Check what you've learnt in this lecture
2 questions

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.
Sort and filter data to find answers
09:54

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

Check what you've learnt in this lecture
2 questions
+
Cleaning and modifying data
2 Lectures 18:47

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.

Rearrange and clean up your data
09:02

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

Check what you've learnt in this lecture
2 questions

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.
Modify your data using Flash Fill
09:45

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

Check what you've learnt in this lecture
2 questions
+
Analyzing and visualizing data
2 Lectures 19:40

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.

Analyze data using a PivotTable
09:52

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

Check what you've learnt in this lecture
2 questions

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.
Visualize data using charts
09:48

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

Check what you've learnt in this lecture
2 questions
+
Using formulas to perform calculations
2 Lectures 18:28

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.

Use simple formulas to fill out a budget
09:21

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

Check what you've learnt in this lecture
2 questions

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.
Use Lookup formulas to fine-tune your spreadsheet
09:07

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

Check what you've learnt in this lecture
2 questions
+
Closing
1 Lecture 01:07

Check what you've learnt in this course
18 questions
About the Instructor
Ulrika Hedlund
4.4 Average rating
1,013 Reviews
12,486 Students
13 Courses
Productivity Advisor and Founder of Business Productivity

Are you bored of lengthy, feature-based product courses? I am, and that's why I left my career at Microsoft and founded Business Productivity. Business Productivity is a production company that is focused on creating scenario-based, results-focused, story-based training that inspires and motivates. In my videos I share best practices with effective use of technology for the best possible outcome. Our tutorials are scenario-based, to-the-point and efficient  - I'm all about productivity so I don't want to waste your valuable time!