Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Microsoft Excel 2016: Part 3 (Expert Level)

Become an Excel Superstar!
4.2
4.2/5
(15 reviews)
450 students
Created by

7.7

CourseMarks Score®

6.4

Freshness

7.6

Feedback

8.6

Content

Platform: Udemy
Video: 1h 37m
Language: English
Next start: On Demand

Table of contents

Description

Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Many roles will require you to be proficient to this level.
The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will help you to create accurate worksheets and stand out from the crowd.
•Work with multiple worksheets at the same time•Learn how large workbooks work and trace errors•Using the LOOKUP function are very useful, but can sometimes be a bit tricky so let’s demystify and master them. •Sparklines are small in cell charts. Learn how they allow you to compare data in a visual way and when they are better than Charts. •Automate some repetitive tasks in Excel with macros.•If you have historical time-based data, you can use it to create a forecast.This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.

You will learn

✓ Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

Requirements

• This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features.

This course is for

• Those who need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.
Training Company
SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review. 
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 1h 37m
Language: English
Next start: On Demand

Students are also interested in