Effective use of Excel 2013 in real life (Udemy.com)
Learn how to effectively use Microsoft Excel 2013 in real-life business scenarios.
Created by: Ulrika Hedlund
Last updated June 2015
What you will 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
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.2 out of 5higher than 8% of them
- Reviews618#212 of 356 by number of reviews
- Length1.4 hoursshorter than 91% of them
- Last updatedJune 2015earlier than 98% of them
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.
Instructor Details
- 4.2 Rating
618 Reviews
Ulrika Hedlund
Are you bored of lengthy, feature-based product training? Do you believe that learning something new should be exciting and fun? I do! That's why I left my career at Microsoft to create a new type of learning experience where the focus is on the value - not the features. I'm passionate about technology and storytelling, and I thrive to share my experiences of how technology can effectively be used to work smarter - in a more engaging way. I'm the founder of two companies - Business Productivity and Storyals, the mother of three, Swedish and live in Dubai.
More courses by Ulrika Hedlund
Eye-catching presentations using PowerPoint 2013
4.5 (6,116 Reviews)
Provider: Udemy
Time: 1.9h
$19.99
The ultimate real-life Office 365 productivity course (2020)
4.3 (5,413 Reviews)
Provider: Udemy
Time: 3h
$39.99
Eye-catching presentations using PowerPoint 2010
4.3 (3,138 Reviews)
Provider: Udemy
Time: 1.2h
$19.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Anonymized User on 8/21/2020
Information provided was very useful but it was too fast to be able to follow along.
By Anonymized User on 8/5/2020
Good course, plenty of examples and highlighting the new features in 2013 that I was unaware of or their functionality.
By Evelyn Valdez on 6/29/2020
I can't open the resources for this section.
By Juanita Withrow on 5/18/2020
The pace is very good. Short quizzes, and I pause the video & practice the techniques frequently. She is giving me a deeper understanding of the excel templates I use for work. Great Course and instructor.
By Aleli Tirados on 5/14/2020
Interesting course. Hopefully I'll be able to apply what I learned here in my line of work. Most of the examples used here are related to finance. However, some of the functions might be quite useful for me.
By Nancy Lorenz on 8/16/2019
I like the simple explanations and screens. But the sound is a distracting; the sound is like listening to someone who is in a tunnel or empty room
By Anonymized User on 11/21/2017
very informative and explained very well however it was done to fast to follow along for someone new to Excel. Much of the information was more than I would ever use but interesting to see.
By Mubashir Sheikh on 7/10/2017
Amazing and to the point explanations; Instructor knows her stuff and is makes it easy to relate to practical life effortlessly (showing how much effort she must have put behind the scene). Highly Recommended!
By Carlton Seymour on 4/12/2017
This is an incredible course that is project oriented. Its clear the author has spent a lot of time and thought in designing this course. The learner gets to learn excel with real life excel use examples.
By Owen Davies on 9/21/2015
In the final quiz, there were several questions that were worded in a way that made two answers applicable. One may have been better but it was not clear which one that would be based on the wording of the questions. The instructor did a great job of staying engaging throughout the videos. It was at a slow enough pace to hear all of her words but not so slow that it was boring. I liked that there was an assumed user level in the excel tutorial as such we didn't have to go over every click to understand what was being described. The content was useful and productive. It was a good introduction to the new features of Excel 2013.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 84 / 100












