All Courses Microsoft Courses

Excel Basics: Helpful Tips & Formulas for Excel

Excel Basics: Helpful Tips & Formulas for Excel

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

What you’ll learn

Excel Basics: Helpful Tips & Formulas for Excel

  • How to use Text to Columns
  • How to Remove Duplicates
  • Learn how to use VLOOKUP
  • How to use Concatenate
  • IF functions
  • How to use Average/Sum/Median
  • How to create and use Pivot Tables
  • Learn how to create Conditional Formatting
  • Freezing top rows and first columns
  • Filter from A-Z
  • Creating a graph/chart
  • Creating a graph with a secondary axis


  • Be able to open a basic excel spreadsheet


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:

  • Section 1: Must-Know Formulas
    • Text To Column: Split the text into multiple columns based on pre-determined breakpoints
    • Remove Duplicates: Easily clean up large lists and columns.
    • VLOOKUP: For a specified value, the function finds (or ‘looks up’) the value in one column of data, and returns the corresponding value from another column
    • CONCATENATE: link (things) together in a chain or series
    • ‘IF’ Function: An if statement is a programming conditional statement that, if proved true, performs a function or displays information
    • Average/Sum/Median: Quickly get basic information about your data
  • Section 2: Filters & Conditions
    • Create a Pivot Table to better view large sets of data
    • Use Conditional Formatting to visualize your data
    • Freeze Top Row and First Column
    • Filter A-Z, by Date, and Numerically
  • Section 3: Making a Chart
    • Create your basic chart using Pivot Table data
    • 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.

I’ve been teaching classes on business subjects like Digital Advertising & Marketing, Public Speaking, Email Marketing, and more. Here are some real-life review from other classes:


Digital Advertising & Marketing 101

★★★★★ “The real-world examples almost makes it self-explanatory. Professionally done and author speaks with authority – i.e. he knows what he’s talking about and it shows.” – AJ Du Toit

★★★★★ “Thought this was an excellent introduction course. Working in the industry without a huge amount of experience in this area, it was a great way to familiarize myself with topics in ongoing conversations internally and externally. I will be taking 201 to further my understanding.” – Jocleyn Armour

★★★★★ “It is advertised as a 101 course and it did exactly that and very well, touching on the building blocks of Digital Advertising and Marketing. Good job Ben.” – Jean C


Digital Advertising & Marketing 201

★★★★★ “When combined with Ben’s 101 course, the two classes make for a thorough and well-organized primer on digital media today. Perfect for marketing people and agency folks (creative, account) who are not immersed in a media agency. It will give you a foundation for how digital media is structured, a clear explanation of the jargon and acronyms you’ll hear bantered about, and a better understanding of the opportunities available. The 201 course goes into important detail about some of the key changes that have taken place in digital advertising recently. Ben explains the concepts clearly and succinctly. Definitely worth the time investment.” – Shawn E Fraser

★★★★★ “This course is amazing. I do affiliate marketing and always wanted to learn about programmatic advertising and this course me taught that. I completed this for an interview and the employer was really impressed by the knowledge I had. Hope there is another in-depth version of this course. Where he goes into ad platforms or ad servers and teaches the real-world applications.” – Suryameet Singh

★★★★★ “Comprehensive overview…detailed!” – Kaithlean Crotty-Clark


Introduction to Programmatic Advertising

★★★★★ “I’m in advertising sales and have been looking for a clean easy way to explain and also test my root knowledge of the programmatic ad space. It was very helpful and simple to understand which is hard to do with this topic.” – Raul Bonilla

★★★★★ “Being an advertising agency media planner and buyer, having this hands-on information helps when we face a decision to go into the digital advertising space. Your 101 and 201 was extremely informative and truly like your overviews in a very simplistic explanation. Thank you and look forward to your future courses.” – Diane Tody


Who this course is for:

  • Anyone working in a sales role
  • Students working in Excel
  • Anyone who’s job requires reporting in Excel
  • Any data-heavy jobs
  • Anyone interested in becoming more efficient in using Excel
  • Last updated 6/2019

Excel Basics: Helpful Tips & Formulas for Excel

download course
Content From:

Other available download links: