Excel Power User 2013

The Excel Power User course expands on the advanced features of Excel 2013, immersing the student even further in the analytical power of the program. This course is designed for the advanced Excel 2013 user who is looking for more than the run of the mill functions and features available in Excel.
  • Self-Paced Learning

    Learning Style
  • Advanced

    Difficulty
  • 3 Hours

    Course Duration
Pricing
About Individual Course:
  • Individual course plan gives you access to this course
New
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
7-Day FREE Trial
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.)
The Excel Power User course expands on the advanced features of Excel 2013, immersing the student even further in the analytical power of the program. This course is designed for the advanced Excel 2013 user who is looking for more than the run of the mill functions and features available in Excel.

About this course:

The course covers the features and tools that most Excel users would not necessarily need on a daily basis, but that's not you. You are a power user. You need more than the average user. In this course, students will learn how to use advanced functions, such as INDEX and MATCH, as well as the OFFSET function. We'll cover the concept of using Array Formulas and Functions, and discuss the pros and cons of using such functions. You'll learn how to build a Waterfall Chart and how to build your own dynamic ranges, as opposed to relying on simple table formatting. Finally, you will be introduced to VBA programming to augment your macros.

Course Objective:

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

  • The VLOOKUP
  • INDEX & MATCH Functions
  • Array Formulas and Functions
  • Conditional Formatting Formulas
  • Dynamic Ranges
  • Spin Controls
  • Waterfall Charts
  • Pivot Table Calculations
  • Pivot Table Templates
  • Importing Data from the Web
  • Intro to VBA

Audience: 

This course is intended for:

  • People with some Excel experience looking for a refresher on most powerful features and efficiency techniques in Excel

Prerequisites:

  • The students should know the basics of excel.

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