Главная
Study mode:
on
1
) Introduction
2
) Intro Song
3
) Download Files and Create Class Folder
4
) Change File Extensions in Windows Explorer
5
) Color Coding Conventions for Class
6
) Rows, Columns, Cells, Worksheets, Sheet Tabs, Workbooks
7
) Naming Convention for all objects in class
8
) Tabs in the Excel Ribbon
9
) Quick Access Toolbar = QAT. Build Custom QAT
10
) Navigating through Workbook
11
) Keyboards: Desktop or Laptop?
12
) Keyboard Shortcuts
13
) First Formula: SUM function using a keyboard
14
) Cursors
15
) Data & Alignment and how Default Alignment Helps
16
) Second and Third Formulas yield an error
17
) Why Default Alignment is important: Fourth & Fifth Formulas
18
) Default Alignment to track down errors
19
) Don’t Use Center Alignment!!!
20
) What Excel Does: Hold Data, Calculations and Data Analysis
21
) Summary
22
) Closing and Video Links
Description:
Learn the fundamentals of Microsoft 365 Excel in this comprehensive video tutorial. Begin by setting up your workspace, understanding file management, and learning essential color-coding conventions. Explore the Excel interface, including rows, columns, cells, worksheets, and workbooks. Master naming conventions, navigate the ribbon, and customize the Quick Access Toolbar. Discover efficient navigation techniques, keyboard shortcuts, and the importance of proper data alignment. Practice creating formulas, including the SUM function, and learn to identify and troubleshoot errors. Gain insights into Excel's primary functions for data management, calculations, and analysis. Download accompanying files to follow along and reinforce your learning experience.

Introduction to Microsoft 365 Excel and Conventions for Class

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Computer Science #Information Technology #Data Management
0:00 / 0:00
1 of 22

) Introduction