Excel 2016 Advanced

When it comes to creating visual representations of data, Excel is the universal favorite among professionals. This advanced course will help you become proficient in the complex features and functions of Excel 2016.
  • Self-Paced Learning

    Learning Style
  • Advanced

    Difficulty
  • 3 Hours

    Course Duration
Pricing
About Individual Course:
  • Individual course plan gives you access to this course
On Sale!
Now Only $10.00 Regular Price $29.00
Now Only $10.00 Regular Price $29.00
/ Each
When you subscribe, you get:
Learn Subscription Plan gives you access to this course, PLUS:

  • 620+ high impact technical, end user and leadership courses
  • Peer to peer learning and access to expert mentors
  • Learner and Manager Analytics
  • Access to Cognitive Learning Research platform to troubleshoot project issues
On Sale!
Now Only $14.99 Regular Price $24.99
Now Only $14.99 Regular Price $24.99
/ Month
Team
Pricing
  • Buy 5-9 Enrollments And Save 15% ($12.74 monthly.)
  • Buy 10-19 Enrollments And Save 25% ($11.24 monthly.)
  • Buy 20-above Enrollments And Save 40% ($8.99 monthly.)
When it comes to creating visual representations of data, Excel is the universal favorite among professionals. This advanced course will help you become proficient in the complex features and functions of Excel 2016.

About this course:

This course is intended to help you master advanced features of Excel 2016. Gain valuable expertise in things like macros, PivotTables, formulas, data analyzation and more. A basic knowledge of Excel 2016 is recommended before beginning this course.

Microsoft Excel is the standard spreadsheet application for both personal and business use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2016 training course because it covers basic, intermediate and advanced competency levels.

Our Microsoft Excel 2016 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel.

Course Objective:

After completing this course, students will have a working understanding of:

  • Named Ranges - Part 1
  • Named Ranges - Part 2
  • Named Ranges - Part 3
  • IF Function - Part 1
  • Formula Auditing Tools
  • IF Function - Part 2
  • VLOOKUP Range
  • VLOOKUP Range with Nested Functions
  • HLOOKUP
  • SUMIF
  • AVERAGEIF
  • Data Table
  • Turning on the Developer Tab
  • Recording a Macro
  • Editing Macros in VBA & Recording a Second Macro
  • Adding Macros to the QA Toolbar
  • Adding Macro Buttons to the Worksheet

Audience: 

This course is intended for:

  • Anyone who has basic understanding of Excel applications, looking to gain advanced level understanding of complex Excel features and capabilities from a business productivity / analysis standpoint. 

Prerequisites:

It is expected that the students have gained basic to intermediate level knowledge of Excel, either through one of out introductory courses or by applied experience within their work. 

Suggested prerequisites courses:

More Information
Brand Microsoft
Lab Access No
Technology Microsoft
Learning Style Self-Paced Learning
Difficulty Advanced
Course Duration 3 Hours
Language English
VPA Eligible VPA Eligible
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Sales Support

Sales (866) 991-3924

Mon-Fri. 8am-6pm CST

Have Questions? Ask Us.

Why QuickStart

Turn Training Into A Personalized Learning Experience


  • Problem Solving through ExpertConnect & Peer-To-Peer Learning
  • Find The Quickest Path To Learn With Career Paths
  • Access All Courses With Master Subscription
  • Manage Your Team With Learning Analytics
  • Virtual Classroom Training & Self-Paced Learning
  • Integrate With Your LMS Through API's