The Beginner’s Guide to Excel – Excel Basics Tutorial

Learn the basics of using Microsoft Excel. How a spreadsheet is setup, and how you can enter data in Excel. Learn useful Excel shortcuts. Understand how the menu bar (the Excel Ribbon) works and where to find different features. Learn formatting in Excel to display your data better. This basic tutorial is for all versions of Excel (Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Office 365).

Looking for more Excel basics videos? Check out this playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0

Time Stamps
00:00 Learn the Basics of Microsoft Excel
00:27 Anatomy of a spreadsheet in Microsoft Excel
01:20 What is a Cell in Microsoft Excel
03:50 What is a Range in Microsoft Excel
04:41 Excel Cursor and Mouse Pointer Shapes
05:48 How to Change Size of Rows and Columns in Excel
07:26 How to Use the Ribbon in Microsoft Excel
09:25 How to Enter Data in Microsoft Excel
11:47 How to Format Data in Microsoft Excel

*** Complete Excel Essentials course for beginners: https://courses.xelplus.com/p/learn-excel-essentials

⯆ The full article to Excel for beginners: https://www.xelplus.com/learn-excel-beginners/

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel #Excel

Learn or review the basic Excel functions that everyone needs to know: SUM, AVERAGE, MAX, MIN, COUNT, and COUNTA. ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents My entire playlist of Excel tutorials: http://bit.ly/tech4excel Here’s the practice file that goes with the video: https://bit.ly/functionsinexcel #excel #exceltutorial

Learn how to use Excel with this step-by-step tutorial. As full disclosure, I work at Microsoft as a full-time employee.

Here’s the workbook I used throughout this tutorial: https://1drv.ms/x/s!AmxrofZZlZ-whIMkJyovG7A6mX8Qjg

Other Excel Tutorials, including Pivot Tables, Conditional Formatting, Formulas and Functions, etc.: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

I walk through the following in this video (includes timestamps if you want to jump through the video):

— Intro, What is Microsoft Excel and how do spreadsheets help you analyze data? 0:00
— How to get Microsoft Excel 1:14
— Navigating the home screen 4:30
— Orientation to the main screen of Excel (including how to reference cells) 6:53
— Formatting (including accounting, comma style, wrap text, and merge and center) 8:20
— Adjust cell size, column size, and row size. 10:30
— Basic formulas (including addition, subtraction, multiplication, division, count, max, sum, and auto sum) 12:10
— Fill series (including absolute references and relative references) 15:57
— Split data 19:18
— Filter and Sort 20:28
— Tables 22:24
— Quick Analysis 23:50
— Ideas 24:40
— Charts 25:30
— Freeze Pane 27:03
— Pivot Tables 28:15

Lean how to use Microsoft Excel from the beginning by creating 6 real-world projects. Most of the content applies to Google Sheets as well.

You will learn how to
— enter data,
— navigate through a spreadsheet,
— create formulas to solve problems,
— create charts and graphs,
— understand relative vs absolute references,
— import and export data,
— implement VLOOKUP,
— use pivot tables,
— split and concatenate text,
— and more.

✏️ Course developed by Shad Sluiter. Check out his YouTube channel: https://www.youtube.com/user/shadsluiter

⭐️ Course Contents ⭐️
⌨️ (0:00:00) Intro
⌨️ (0:04:14) Payroll
⌨️ (0:39:35) Gradebook
⌨️ (0:57:22) Decision Factors
⌨️ (1:04:40) Sales Database
⌨️ (1:23:13) Car Inventory
⌨️ (1:59:29) Problem Solving Templates

⭐️ Special thanks to our Champion supporters! ⭐️
🏆 Loc Do
🏆 Joseph C
🏆 DeezMaster

—

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news

And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp

If you like this video, here’s my entire playlist of Excel tutorials: http://bit.ly/tech4excel
Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it’s easier to read and use, and more. This tutorial was made using Excel 2016, but is applicable to older versions of Excel and newer versions too.
***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents

Click below for more information about some of the movies mentioned in this tutorial:
Dirty Rotten Scoundrels: http://amzn.to/2xTpck1
Ladyhawke: http://amzn.to/2xOhLsA
Stardust: http://amzn.to/2yjJvs9
Young Sherlock Holmes: http://amzn.to/2xaJJNv