5 Must-Have Excel Skills Every Professional Should Know

Have you always wanted to get better at using Excel but never had the time? Improve your Excel skills fast with this 5-day beginner-friendly course featuring quick video tutorials and practice exercises with real-world data.

Featuring Chris Hadley, Ph.D. , wikiHow's Excel Expert

5
Format
Each lesson is designed to cut straight to the chase and give you a spreadsheet superpower you’ll use in any job where you have to use Excel. Every lesson includes a video tutorial and a practice exercise using real government datasets.
Duration
This course lasts 5 days, with one lesson per day delivered to your inbox.
Time
Each lesson takes 10-15 minutes to read.

What you will learn

  • How filters and conditional formatting will help you quickly find and display crucial data
  • Using the powerful VLOOKUP function to link up massive amounts of data
  • Getting comfortable with two of Excel's most useful functions, COUNTIF and SUMIF
  • Common mistakes you might run into when applying these skills
  • How to use these skills with real-world data

Why should you take this course?

  1. You've been getting by with little or no Excel knowledge. You want to get better at working with spreadsheets at work or school, even though you've been managing to flail by for a while.
  2. You're tired of Googling about Excel. Sometimes you don’t even know what to search for and when you do, the results feel like they’re in another language.
  3. Excel skills can give you more earning power in your career. Most professional jobs require working knowledge of spreadsheets, so level up your professional skill set with this course.


Course Overview

5 Lessons

Get Rid of the Data You Don’t Need with Filters
Find Duplicates in Any List Quickly and Easily
Count Occurrences of a Name or Number with COUNTIF
Add up Numbers When a Certain Condition Is Met with SUMIF
Pull Info From Multiple Tables with VLOOKUP


Meet the Expert

Chris Hadley, PhD
PhD in Cognitive Psychology, University of California, Los Angeles
Chris Hadley earned his PhD in Cognitive Psychology from UCLA in 2006. Chris' research has been published in numerous scientific journals. During his time at UCLA, he was awarded a Kirschstein-NRSA Fellowship from the National Institutes of Health to fund his doctoral research. Chris has worked on improving content quality at wikiHow since 2007. His role on the content team focuses on quality control and content innovation. He works with our editors to ensure accuracy on all wikiHow articles, as well as advising on content strategy.
Show more


Frequently Asked Questions

How are wikiHow courses different from typical wikiHow articles?
How will I receive this course?
How much experience do I need for this course?
What is wikiHow's refund policy?


What are others saying?

Halynna

These lessons were so helpful. Knowing these tips and tricks would have saved me so much time in school. I wish I had known them sooner!

Mo

The step by format was appreciated, it was very helpful.

Hamid

Short. Easy. I got exactly what I needed from this course. I can't wait to take others like it.

Disclaimer: The wikiHow service is provided without warranties of any kind, including that the content is accurate, reliable, correct or will meet your requirements. Use of any information provided is at your own risk. See our full Terms of Use for more information.