Learn how to effectively use Microsoft Excel 2013 in real-life business scenarios.
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.
What are the requirements?
Students will need to have basic knowledge in using Microsoft Office applications. Viewers who have Microsoft Excel 2013 will benefit the most.
What am I going to get from this course?
Over 12 lectures and 1.5 hours of content!
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
What 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
(Buy premium account for maximum speed and resumming ability)