Excel Basics for Busy People

Learn the foundations of Excel to level up your career. Learn how to enter and edit data in Excel and Visualize your data with charts and graphs.

Excel Basics for Busy People Course content

6 sections • 28 lectures • 1h 26m total lengthExpand all sections

Getting to know Excel3 lectures • 6min

  • Downloading Excel01:40
  • Launching and Starting Excel01:10
  • Tour of the Excel Interface02:57

Entering and Editing Data and Formulas4 lectures • 23min

  • Entering Text, Numbers, and Formulas in Excel06:57
  • Using Tabs, Cut, Copy, and Paste03:06
  • Cell Refrences and Ranges04:36
  • Intro to Formulas and Functions in Excel08:27

Basic Excel Functions6 lectures • 18min

  • COUNT and AVERAGE03:31
  • MIN and MAX01:36
  • Logical Operators and Functions in Excel08:20
  • Text Functions in Excel02:31
  • Data Manipulation Functions in Excel01:41
  • Date Functions in Excel00:50

Modifying and Formatting in Excel6 lectures • 18min

  • Using Alt as a Shortcut02:56
  • Font Size, Changing the Width and Height of Cells02:38
  • Inserting and Deleting Rows and Columns03:33
  • Borders and Background Colors02:31
  • Font Formatting04:02
  • Hiding and Unhiding Rows and Columns02:00

Filtering, Sorting, and Replacing Data5 lectures • 12min

  • How to Freeze Rows in Excel01:33
  • How to Sort Lists03:48
  • How to Use Filters03:09
  • Sorting and Filtering Shortcuts02:06
  • Using Find, Find and Replace01:33

Charts and Pivot Tables in Excel4 lectures • 10min

  • Intro to Excel Pivot Tables03:32
  • Basic Charts – Bar Charts01:28
  • Intermediate Pivot Tables02:42
  • Intermediate Charts – Line Charts01:53

Requirements

  • An eagerness to learn Excel

Description

Are you in a time crunch and need to learn Excel quickly? This quickstart tutorial teaches the foundational Excel skills and principles needed for your work, your school, or your personal life.

Throughout the course, lessons will be taught using hands-on, real-world examples. These examples will demonstrate the core concepts, functionalities, and shortcuts that you need to become an effective Excel user.

This course will allow you to:

  1. Familiarize yourself with the Excel Interface
  2. Learn how to enter and edit data into Excel
  3. Leverage Excel functions to streamline your workflow
  4. Use filtering and sorting to make sense of your data
  5. Use formatting and layout to build neat spreadsheets
  6. Familiarize yourself with Excel Pivot Tables
  7. Visualize your data with charts and graphs

This course not only focuses on the core functionalities of Excel, but also the shortcuts you can use to become faster. Shortcuts are an especially important part of Excel that you must know if you want to become a power user. Lots of time in this course is dedicated to learning shortcuts.

This is the first online course that I have created, so any feedback would be greatly appreciated. I tried to make it as hands-on and engaging as possible, but there are always ways in which I can improve. Thank you all very much for your time, and I hope that you enjoy the course!

Who this course is for:

  • Working Professionals
  • Job Seekers
  • Students
Share Post

Leave a Comment