The Premium A to Z Microsoft Excel Bundle Ft. Alan Jarvis & Chris Dutton

20 Reviews
2794 Enrolled
10 Courses & 43 Hours
$39.99$49.99$1,732.00
Price Drop - Extra 20% off
Save 97% -

What's Included

Excel Pro Tips: Productivity Tools
  • Certification included
  • Experience level required: All levels
  • Access 21 lectures & 1 hour of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

21 Lessons (1h)

  • Getting Started
    Course Structure & Outline1:41
    DOWNLOAD: Course Resources
    Setting Expectations1:45
  • Productivity Tips
    Introduction0:29
    Customizing the Footer4:03
    CTRL Shortcuts8:01
    ALT Key Tips6:53
    "Go To" Special Options4:36
    Removing Blank Rows3:17
    Data Validation Drop-Downs7:11
    Autofill & Flash Fill8:26
    Customizing the Ribbon6:53
    Splitting Text to Columns7:39
    Synchronous Scrolling2:58
    Extracting Unique Values4:06
    Named Range & Table References8:12
    Protecting Cells & Formulas8:09
    Multi-Level Row & Column Sorting10:54
    Advanced Filter Criteria9:27
    QUIZ: Productivity Tips
  • Wrapping Up
    Resources & Next Steps

Excel Pro Tips: Productivity Tools

EM
Excel Maven

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics, and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 150,000+ students in more than 190 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Description

The Excel Pro Tips: Productivity Tools course will improve your current productivity. This 2-hour course will cover a range of topics to help you save time and work more efficiently, including keyboard shortcuts, autofill and flash fill, data validation, cell protection, named ranges, multi-level sorting, advanced filters, and much more. By the end of this course, you'll be ready to supercharge your productivity and absolutely revolutionize your Excel workflow.

63,046 positive reviews from 248,923 students

  • Access 21 lectures & 1 hour of content 24/7
  • Learn & practice Excel's productivity tools using keyboard shortcuts, autofill & flash fill, and data validation
  • Easily sort your data using cell protection, named ranges, multi-level storing, advanced filters & more
  • Supercharge your productivity & improve your Excel workflow

Note: Software NOT included.

"I must say that I was extremely impressed with how well the course was presented. I was pleasantly surprised to see just how much was covered in this one course by an exceptional instructor. " – Daulton Brent Cotten

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: all levels

Requirements

  • Microsoft Excel 2007-2019 or Office 365 recommended
  • Designed for Windows users (some tools may not be available for Mac)

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.