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:

## Microsoft Excel

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software