Microsoft Excel 2016: Part 3 (Expert Level)

person icon Sonic Performance

Microsoft Excel 2016: Part 3 (Expert Level)

Become an Excel Superstar!

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Sonic Performance

architecture icon Office Productivity,Microsoft Excel


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

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

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


What will you learn in this course:

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


What are the prerequisites for this course?

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

Microsoft Excel 2016: Part 3 (Expert Level)


Check out the detailed breakdown of what’s inside the course

Working with Multiple Worksheets and Workbooks
7 Lectures
  • play icon Course Overview 02:11 02:11
  • play icon Use Links and External References – Introduction 01:04 01:04
  • play icon Use Links and External References 05:37 05:37
  • play icon Use 3-D References – Introduction 00:49 00:49
  • play icon Use 3-D References 04:23 04:23
  • play icon Data consolidation – Introduction 00:31 00:31
  • play icon Consolidate Data – Introduction 05:01 05:01
Using Lookup Functions and Formula Auditing
6 Lectures
Sharing and Protecting Workbooks
5 Lectures
Automating Workbook Functionality
7 Lectures
Creating Sparklines and Mapping Data
5 Lectures
Forecasting Data
10 Lectures

Instructor Details

Sonic performance

Sonic performance

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.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us