Author
Curt Frye
Released
9/24/2018- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
Duration
Views
- [Curt] Excel for Mac 2019 is a powerful tool for evaluating data within your business or organization. Mastering the core skills you need to use Excel effectively will let you work quickly and make great decisions. In this course, I'll use real-world examples to demonstrate how you can apply the incredible power of Excel to your data. I'm Curt Frye. Join me at LinkedIn Learning for an introduction to the essential skills that will let you unlock the power and flexibility that comes with Microsoft Excel.
-
Introduction
-
What you should know1m 11s
-
1. Getting Started with Excel
-
Introduce the ribbon3m 20s
-
Set program preferences4m 12s
-
Get help in Excel3m 16s
-
2. Managing Workbooks
-
Set workbook properties3m 52s
-
Create and modify templates3m 33s
-
3. Working with Worksheets, Cells, and Cell Data
-
Copy and paste cell data4m 17s
-
Create named ranges4m 41s
-
Create an Excel table4m 56s
-
4. Sorting, Filtering, and Managing Worksheets
-
Sort worksheet data3m 23s
-
Create a custom sort order5m 29s
-
Filter worksheet data4m 13s
-
Manage worksheets3m 54s
-
-
5. Summarizing Data Using Formulas and Functions
-
Add a formula to a cell4m 56s
-
Create an AutoSum formula3m 34s
-
6. Formatting Worksheet Elements
-
Manage text alignment5m 29s
-
Copy cell formats2m 30s
-
Manage cell styles4m 31s
-
Manage Office themes3m 14s
-
Manage conditional formats3m 41s
-
7. Working with Charts
-
Create bar and column charts3m 20s
-
Create line charts2m 56s
-
Format chart elements3m 58s
-
Create sparkline charts5m 11s
-
-
8. Working with External Data and Objects
-
Use hyperlinks5m 14s
-
Create and format shapes4m 26s
-
Add and adjust images4m 59s
-
Align and layer objects4m 49s
-
9. Exploring PivotTables
-
Create a PivotTable3m 21s
-
Pivot a PivotTable2m 51s
-
Filter a PivotTable4m 2s
-
-
10. Reviewing and Sharing Spreadsheets
-
Check spelling2m 36s
-
Manage workbook comments4m 19s
-
Set and remove print areas3m 36s
-
-
Conclusion
-
Further information1m 2s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Introduction to Excel 2019 for Mac