Introduction
Getting started with Excel for Microsoft 36500:01:05
Getting started with Excel
What is Excel used for?00:02:53
The Ribbon menu and the Quick Access Toolbar00:05:09
Shortcut menus and the Mini toolbar00:04:44
Understanding workbooks and worksheets00:03:15
Use Excel Help00:03:52
Chapter 1 Quiz
Entering Data
Exploring data entry, editing, and AutoFill00:05:08
Working with dates and times00:02:43
Using Undo and Redo00:02:48
Use Save or Save As00:02:58
Chapter 2 Quiz
Formulas and Functions
Using simple formulas00:04:23
Copying a formula into adjacent cells00:03:41
Using SUM and AVERAGE00:03:40
XLOOKUP and lookup functions00:04:41
Chapter 3 Quiz
Formatting
Exploring font styles, borders, and color backgrounds00:04:00
Applying numeric formats00:03:30
Adjusting row heights and column widths00:04:48
Applying numeric formats00:04:54
Chapter 4 Quiz
Adjusting worksheet and layout data
Rows and columns: Insert, delete, hide, and unhide00:04:00
Moving, copying, and inserting data00:00:00
Finding and replacing data00:04:02
Chapter 5 Quiz
Adjusting Page Layout and Printing
Page Layout view and commands00:05:37
Using Page Break and print set up and options00:04:34
Chapter 6 Quiz
Charts
Creating charts00:04:04
Exploring chart types00:04:01
Chapter 7 Quiz
Adjusting Worksheet Views
Freezing and unfreezing panes00:04:09
Splitting screens horizontally and vertically00:04:46
Chapter 8 Quiz
Multiple Worksheets and Workbooks
Renaming, inserting, and deleting sheets00:04:42
Moving, copying, and grouping sheets00:03:41
Opening, closing, and saving workbooks00:04:22
Chapter 9 Quiz
Data Management Features
Sorting data00:04:48
Using filters00:04:28
Creating PivotTables00:04:44
Chapter 10 Quiz
Security and Sharing
Protecting worksheets and workbooks00:04:33
Sharing workbooks and tracking changes00:03:39
Chapter 11 Quiz
Conclusion
Continuing your Excel Journey00:00:28