Skip to content
UdemyExcelPaid courseAll LevelsCertificate

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

icon
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

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

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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. 

icon
More courses by Ulrika Hedlund

$19.99

$39.99

$19.99

$19.99

$19.99

$19.99

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.2

618 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing all 10 reviews on CourseDuck

Read all 618 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100