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?
- 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.
- 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.
- 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
Learn how to take a giant, overwhelming spreadsheet and turn it into a table that only shows the data that’s relevant.
Find Duplicates in Any List Quickly and Easily
Find duplicates quickly so you can spot errors and identify frequent fliers.
Count Occurrences of a Name or Number with COUNTIF
Feel comfortable using the COUNTIF function by practicing on dog license data from Pennsylvania.
Add up Numbers When a Certain Condition Is Met with SUMIF
Save time by only adding up the numbers that fall under your scope of interest.
Pull Info From Multiple Tables with VLOOKUP
Get to know one of the most versatile, useful spreadsheet functions: VLOOKUP.
Meet the Expert
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.
Frequently Asked Questions
How are wikiHow courses different from typical wikiHow articles?
All wikiHow content has been carefully vetted, researched and well-written to teach anyone how to do anything. Our courses go significantly more in-depth on a topic to help you develop a skill that will improve your life. This course provides data tailored to each lesson, with assignments and hints designed to make sure you master each Excel skill.
How will I receive this course?
Once you have completed the enrollment process, you will receive a confirmation email that your course path has begun. You will then receive a lesson in your inbox each day for the next 5 days. Make sure that the email address you provide during enrollment is the email you would like to have the course materials sent to! To make sure you don’t miss any lessons, add learn@courses.wikihow.com to your contact list.
How much experience do I need for this course?
This course is best for people who already know how to calculate sums and find averages – we’re going to go beyond that and teach you a few less obvious ways to take your Excel skills to the next level.
What is wikiHow’s refund policy?
What are others saying?
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!
The step by format was appreciated, it was very helpful.
Short. Easy. I got exactly what I needed from this course. I can’t wait to take others like it.
Source link
