Excel 2021 Tips and Tricks

Excel 2021 Tips and Tricks

Save time in Excel with these awesome tips

What you'll learn

  • How to remove duplicates
  • Finding the Max Length of Values in a Column
  • Create metadata for importing to other programs (like Salesforce)
  • Automatically Bring External Data from a Website
  • Automating Tasks with Macros
  • Analyzing Data with Pivot Tables
  • Trapping Errors in Formulas
  • Finding Values Above Threshold
  • Categorizing Values with Formulas

Preview

About this course

Tired of repeating tasks in Excel that take hours? I was too, so early on when I started working in Excel (over 20yrs ago!) I began searching for ways to automate things or even do things simpler so they took fewer steps.

In this quick course, I want to share with you the latest round of tips and tricks that I've found to save me time in Excel. This course is loaded with tips and tricks all geared at doing just that, saving you a few clicks each day that add up to hundreds of hours across a year. There really is no better investment if you ask me, not just for your time but also for your sanity!

Who is this course for?

  • Anyone that hates wasting time in Excel
  • Business people that want to be more productive
  • Data Analysts looking to speed up their workflows

What do I get when I sign up?

When enrolling in our academy you'll instantly be granted access to our entire course library of hard and soft skills training.