Effective use of Excel 2013 in real life

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

4.55 (618 reviews)

Udemy

platform

English

language

Microsoft

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

Why take this course?

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.

Reviews

Christina

August 24, 2020

Yes this course has been a great match for me so far. I love the helpful download resource sheets as well.

Ian

August 5, 2020

Good course, plenty of examples and highlighting the new features in 2013 that I was unaware of or their functionality.

Radhika

June 4, 2020

A really good training with excellent explanations for excel for someone who just starting out to figure things out. The resources are very helpful. Thank you.

Joaquin

May 20, 2020

Profundiza en operativas del EXCEL que no se dan en otros cursos de este software. Bien exsplicado y estructurado.

Juanita

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

Aleli

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

Thomas

April 27, 2020

The course shows you how to save time when you are using a large spreadsheet and need to obtain key information. This is a plus.

Mubashir

July 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!

May 23, 2017

I appreciate the amount of info. shared in the instructions. Great presentations and screen shots. Thanks

Carlton

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

Dhayalan

January 9, 2016

Right to the point and very practical. This excellent course covers just about everything that would otherwise take 3-4 days to learn within a few hours with practical scenarios. I was looking for a course where I could learn more with as little investment of my time and at the same time very practical and I found it right here in this course.

Carolyn

November 13, 2015

The instructor is so clear and uses examples that are easy to understand. I had never heard of pivot tables before and do not use excel at this level. I am now going back and to the 2010 excel class and taking that, but it should have been first. The nice thing is the videos can be reviewed as I try to apply some of the learning. I have gone back to other videos by this instructor as I needed to review something. I really like seeing all that excel can do and most of this was new to me. Great class, again.

Owen

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

Robert

July 1, 2015

it is obvious she is very well knowledgeable about this subject and has enthusiasm for teaching this kind of content. I mean I am not the most passionate about Excel, and I got to say, I have learned alot about Excel, that I never knew existed! Thank you for an excellent course.

Sarah

June 8, 2015

I've taken a number of Ulrika's courses before and I've never been disappointed. This course delivers the same high quality. The lectures are well structured and in a relatively short time you get a very comprehensive view of how to use Excel. I have been using Excel 2013 for a while but I had completely missed Flash Fill! Thank you for a great course!

Charts

Price

Rating

Enrollment distribution

Effective use of Excel 2013 in real life - Distribution chart