PDP Url

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 Style

Advanced

Difficulty

3 Hours

Course Duration

Course Info

Download PDF

Certificate

See Sample

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 and over 841 other popular courses
On Sale!
Now Only $39.99 Regular Price $44.99
Now Only $39.99 Regular Price $44.99
/ Month
Team
Pricing
  • Buy 5-9 Enrollments And Save 68% ($12.74 monthly.)
  • Buy 10-19 Enrollments And Save 72% ($11.24 monthly.)
  • Buy 20-above Enrollments And Save 78% ($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.

Course Information

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:

Outline

More Information

More Information
Brand Microsoft
Subjects Business Productivity
Lab Access No
Technology Microsoft
Learning Style Self-Paced Learning
Difficulty Advanced
Course Duration 3 Hours
Language English
VPA Discount VPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Contact A Learning Consultant


click here