When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Effective use of Excel 2013 in real life
Learn how to effectively use Microsoft Excel 2013 in real-life business scenarios.
This Course Includes
udemy
4.4 (618 reviews )
1.5 total hours 
english
Online - Self Paced
course
Udemy
About Effective use of Excel 2013 in real life
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 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.