Excel Tutorial for Beginners
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
Видео Excel Tutorial for Beginners канала Kevin Stratvert
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
Видео Excel Tutorial for Beginners канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Microsoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners!How to use Microsoft OneDriveExcel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page SetupHow to use VLOOKUP in Excel - Complete TutorialTop 15 Microsoft PowerPoint Tips & Tricks50 Ultimate Excel Tips and Tricks for 2020Microsoft Word Tutorial🧙♂️ Top 14 Excel Pivot Table Tips & Tricks - TutorialMicrosoft Excel Tutorial - Beginners Level 1The Beginner's Guide to Excel - Excel Basics TutorialExcel Tutorial for Beginners | Excel Made Easy👩💻 Python for Beginners TutorialHow to Filter in Microsoft ExcelTop 20 Microsoft Outlook Tips & TricksTop 10 Most Important Excel Formulas - Made Easy!🏫 Microsoft Teams Tutorial in 10 minTop 20 Microsoft Excel Tips & TricksIntroduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work files