MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# 5 Powerful Excel Skills - That Will Set You Apart

### Course Summary

Want to command more attention in the office? Invest in learning these 5 skills & you'll be shocked at HOW EASY IT IS!

• +

### Course Syllabus

• Course Introduction and Overview of the Practice Dataset Used
• PROOF! Watch these 5 skills complete the course tasks in LESS THAN 5 MINUTES!
• Course Intro Slides
• Overview of the Dataset
• The First Request from The Boss - Covered by VLOOKUP, Filters & Pivot Tables
• The First Request from our Boss
• The First Request from our Boss (PDF) & Course Practice Excel Files
• VLOOKUP - The first step in fielding our boss' requests!
• Getting Started: VLOOKUP Slides
• What is VLOOKUP?
• Intro to VLOOKUP
• VLOOKUP - Example 1
• VLOOKUP - Example 2
• Filters - We need these to complete our boss' first request!
• Getting Started: Filter Slides
• What are Filters?
• Applying Filters
• Using Filters to Sort
• Using Filters - Example 1 - to View Only Zeros
• Using Filters - Example 2 - to View Only Non-Zeros
• Using Filters - Example 3 - to Filter by Multiple Criteria
• Pivot Tables - These will help us tackle our boss' second and third requests!
• Getting Started: Pivot Table Slides
• What are Pivot Tables?
• Intro to Pivot Tables
• Creating a Pivot Table
• Organizing a Pivot Table
• Calculating in a Pivot Table
• Formatting a Pivot Table
• Sorting a Pivot Table
• Filtering a Pivot Table
• An Additional Request from The Boss - Covered by Pivot Charts & Recording Macros
• The Second Request from our Boss
• The Second Request from our Boss (PDF)
• Pivot Charts - They'll make our boss' additional request a piece of cake!
• Getting Started: Pivot Charts Slides
• What are Pivot Charts?
• Applying Pivot Charts
• Working with Pivot Charts
• Formatting Pivot Charts
• Recording Macros - Now we're just showing off!
• Getting Started: Recording Macros Slides
• What are Recorded Macros?
• Intro to Recording Macros
• Creating and Using a Macro - Example 1
• Creating and Using a Macro - Example 2
• Using Buttons to Run a Macro!

Course Fee:
USD 39

Self-Study

### Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts: