Description
Get up to speed with Microsoft Excel, the world's most popular spreadsheet program. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program. Learn how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells, and data. Plus, check out Excel’s newly revamped Accessibility Checker that helps you adjust fonts and colors to be more readable and add alt-text for images, to make your workbooks more accessible to people with disabilities. Other lessons cover how to work with multiple worksheets, build charts and PivotTables, sort and filter data, print in Excel, use Microsoft Copilot with Excel, and more.
Course Objectives
- Describe the process for adding a command to the Quick Access toolbar.
- Cite the shortcuts for Undo and Redo.
- Name the keys commonly used to move, copy, and insert data.
- Explain how to create a chart.
- Summarize the process for freezing and unfreezing panes.
- Describe methods for sorting data.
- Explain how to create Pivot Tables.
Level
This is a Beginner and Intermediate level learning activity.
Length
The total duration of assets in this course is 2h29m.
Structure
Topics:
- Getting started with Excel
- Entering data
- Formulas and functions
- Formatting
- Adjusting worksheet layout and data
- Adjusting page layout and printing
- Charts
- Adjusting worksheet views
- Multiple worksheets and workbooks
- Data Management features
- Security and sharing
Author & Release date
This course was produced by Dennis Taylor for Lynda.com on Sep 4, 2019, updated July 28, 2023.
Contact details
For course-related issues please contact LinkedIn Learning.