Excel Essential Training (Office 365/Microsoft 365)

Go to class

Write Review

Free Online Course: Excel Essential Training (Office 365/Microsoft 365) provided by LinkedIn Learning is a comprehensive online course, which lasts for 2-3 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Excel Essential Training (Office 365/Microsoft 365) is taught by Dennis Taylor.

via LinkedIn Learning

2-3 hours worth of material

Self Paced

Get up to speed with Microsoft Excel. Learn how to enter and organize data, build charts and PivotTables, sort data, and use other Excel features.

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. Other lessons cover how to work with multiple worksheets, build charts and PivotTables, sort and filter data, use the printing capabilities of Excel, and more.

Syllabus

Introduction
- Getting started with Excel for Office 365
1. Getting Started with Excel
- What is Excel used for?
- Using the Quick Access Toolbar and ribbon menu
- Shortcut menus and the Mini toolbar
- Understanding workbooks and worksheets
- Using Excel Help
2. Entering Data
- Exploring data entry, editing, and AutoFill
- Working with dates and times
- Using Undo and Redo
- Using Save or Save As
3. Formulas and Functions
- Using simple formulas
- Copying a formula into adjacent cells
- Using SUM and AVERAGE
- XLOOKUP and lookup functions
4. Formatting
- Exploring font styles and effects
- Applying borders and color backgrounds
- Adjusting row heights and column widths
5. Adjusting Worksheet Layout and Data
- Rows and columns: Insert, delete, hide, and unhide
- Moving, copying, and inserting data
- Finding and replacing data
6. Printing
- Page Layout view and commands
- Using Page Break Preview and print setup options
7. Charts
- Creating charts
- Exploring chart types
- Working with Excel Ideas
8. Adjusting Worksheet Views
- Freezing and unfreezing panes
- Splitting screens horizontally and vertically
9. Multiple Worksheets and Workbooks
- Renaming, inserting, and deleting sheets
- Moving, copying, and grouping sheets
10. Data Management Features
- Sorting data
- Using filters
- Creating PivotTables
- New data types coming to Excel for 365
11. Security and Sharing
- Protecting worksheets and workbooks
- Sharing workbooks
- Tracking changes
Conclusion
- Next steps

0, based on 0 Course votes at GetYourEducation

Start your review of Excel Essential Training (Office 365/Microsoft 365)

Add review ->

Language

English
Certificate
Certificate Available
Date of Start
24th September, 2018
Price
Free Trial Available
Provider
LinkedIn Learning
Taught By

Dennis Taylor
Share this course