Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel Ultimate BEGINNER Course
Rating: 4.5 out of 5(207 ratings)
4,820 students

Microsoft Excel Ultimate BEGINNER Course

Microsoft Excel Basics, Hacks, Tips & Shortcuts
Created byDavid Fortin
Last updated 8/2023
English

What you'll learn

  • Learn Microsoft Excel Basics
  • Learn Microsoft Excel the fun way, in an engaging way
  • Learn Microsoft Excel Formulas
  • Learn Microsoft Excel Shortcuts
  • Learn Microsoft Excel Hacks to Increase your productivity

Course content

1 section9 lectures44m total length
  • Introduction (Who am I?)1:53

    Who is David Fortin, CPA aka Piggy Bank Accountant.

  • Welcome to Excel0:57

    Going through the big sections of the template

  • Sums & Fills6:29

    Covering basics sums and fill functions & shortcuts

  • Split & Transpose9:19

    Split & Transpose formulas and functions.

  • Sort & Filter7:41

    How to properly sort and filter your data

  • Tables4:51

    How Tables can be useful in your day to day

  • Drop-downs3:33

    Drop Down list to avoid error and group data

  • Analyze & Charts4:44

    Analyze & Charts

  • Pivot Tables5:30

    Pivot Tables your GO TO tool

  • PLEASE LEAVE A REVIEW :)

Requirements

  • No requirements needed, just have a microsoft excel licence

Description

This course is a very basic level entry Microsoft Excel Tutorial. If you are intermediate, you might still learn a few shortcuts or productivity tips.

I am going to go through the Microsoft Excel Built-in Template "Welcome to Excel". That you can open on your computer at the same time as I do it (which I highly recommend that you do in order to solidify the learnings)

I could summarize this video with the followings : Microsoft Excel basics, charts, formulas, your go to place to learn excel from zero. Mainly beginner and intermediate level.


The Welcome to Excel template go through these subjects :


  • Sums & Fill

    • Show you how to do sum, sumifs, tips with CTRL C CTRL V

    • Show you how to drag formulas and the flash fill funciton

  • Split & Transpose

    • Splitting text and copying values from horizontal to vertical is taught here.

  • Sort & Filter

    • Going through different type of filters that will help you (Filter by Color , Filter top performers, bottom performers)

  • Tables

    • Very introductive level on tables and why you should / should not use it.

  • Drop-Downs

    • Drop downs list to help your data entry faster.

  • Analyze & Charts

    • Quick words on analyze and charts

  • Pivot Tables

    • The most excel useful tool ever invented :)

Who this course is for:

  • Beginner to intermediate in Microsoft Excel. Intermediate will learn tricks and hacks for sure