Excel Tutorial for Beginners
Автор: Kevin Stratvert
Загружено: 20 сент. 2019 г.
Просмотров: 531 378 просмотров
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-whIMkJ...
Other Excel Tutorials, including Pivot Tables, Conditional Formatting, Formulas and Functions, etc.: • ❎ How to use Excel
Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com
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

Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: