Excel Basics for Beginners: Quick Tips & Formulas for Excel

Learn how to quickly format, view, and organize your Microsoft Excel data using easy formulas and built-in tools.

   Watch Promo

Microsoft Excel is used by millions of people around the world every day. It is an extremely powerful tool that allows individuals and businesses to easily sort, search, and review large sets of data.

While there are endless possibilities for how to use Excel, there are a number of basic formulas and built-in tools that everyone should know. You can learn these basic tips in under an hour and once you’ve mastered them you’ll be using Excel faster and more efficiently than ever before.

In this course I’m going to show you how to use the following:

  1. Section 1: Must Know Formulas
    1. Text To Column
    2. Remove Duplicates
    3. VLOOKUP
    5. ‘IF’ Function
    6. Average/Sum/Median
  2. Section 2: Filters & Conditions
    1. Create a Pivot Table to better view large sets of data
    2. Use Conditional Formatting to visualize your data
    3. Freeze Top Row and First Column
    4. Filter A-Z, by Date, and Numerically
  3. Section 3: Making a Chart
    1. Create your basic chart using Pivot Table data
    2. Create a chart with a Secondary Axis to compare two sets of data at once

This course is perfect for those looking to get a leg-up on their peers, those who use Excel for any function, and those looking to better understand how to take control of their data.

Your Instructor

Ben Silverstein
Ben Silverstein

I'm an award winning digital media professional with over a decade and a half of experience working in the digital space. I've managed hundreds of millions of dollars for local, national, and international brands including Six Flags Amusement Parks, Giorgio Armani, Cafe de Columbia, William Grant & Sons, and the FDA Real Cost which won a 2015 gold Effie in the Disease Awareness and Education category.

Since 2015 my online courses have been taken by over 60,000 students around the world, with thousands of five-star reviews.

When I'm not teaching, I work full time in the advertising space, speak at conferences, or I'm at home in NYC watching the Buffalo Bills!

I can't wait to see you in class!

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!