Skip to main content
by learnformula
Explore courses
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
Explore courses
  1. Courses
  2. /Office Productivity
  3. /MS 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.

Created byBen Silverstein
BeginnerUpdated Apr 28, 2020

What You'll Learn

  • check_circleHow to use Text to Columns
  • check_circleHow to use VLOOKUP
  • check_circleHow to use Concatenate
  • check_circleCreating a graph with a secondary axis

About This Course

Microsoft Excel is one of the most widely used tools for managing and analyzing data—and once you know a few key functions, you’ll be amazed at how much faster and smarter you can work. This beginner-friendly course shows you the most important formulas and built-in tools that anyone using Excel should know. In less than an hour, you'll be able to clean up data, find information fast, and even build charts that bring your numbers to life.

You'll learn essential formulas like VLOOKUP, IF, and CONCATENATE, as well as tools like PivotTables, Conditional Formatting, and Text to Columns. We’ll also walk through how to create basic and dual-axis charts for effective data storytelling. If you're looking to gain a solid Excel foundation quickly and confidently, this course is for you.

Course Content

5 activities • 15 videos • duration: 46m

  • videocamIntroduction: What we’re going to cover in this course
    Duration 2:29
  • videocamCourse outline and sections, and a quick tip
    Duration 3:30

Your Instructor

Ben Silverstein

Digital Media Professional

menu_book8 courses
star744 reviews

I'm an award winning digital media professional with over a decade and a half of experience working in the digital space. In that career I've negotiated countless contracts as both a buyer and seller. I’ve even negotiated multi-million dollar contracts with Fortune 500 brands, some of which took over a year to finalize. 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!

Credit Information

Professional development requirements vary by profession, country, and regulatory body. Before enrolling, review the course details and confirm that the content, learning format, and any listed credits meet your specific requirements. You are responsible for confirming eligibility with your regulator or professional association and keeping the records required for reporting.

What Students Are Saying

4.6 out of 5
Student's Choice
84 reviews
  • AC
    Alec C.
    starstarstarstarstar

    fun, easy to understand

  • IP
    Iryna P.
    starstarstarstarstar

    good overview of excel basics

  • ML
    Marie-Claude L.
    starstarstarstarstar

    Thank you this course was really helpful :)

  • PG
    Patricia G.
    starstarstarstarstar

    Good tips, need to spend some time now reviewing with my own data

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(601 reviews)
    2 CPD hrs
  • Finance: NASBA - Finance

    Sensitivity Analysis and Scenario Planning

    starRated5.0out of 5,(151 reviews)
    1.5 CPD hrs
  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(682 reviews)
    2.5 CPD hrs