Excel Essential Training (Microsoft 365)
4.6 /5- Offered byLinkedin Learning
Excel Essential Training (Microsoft 365) at Linkedin Learning Overview
Duration | 3 hours |
Total fee | ₹1,400 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Excel Essential Training (Microsoft 365) at Linkedin Learning Highlights
- Earn a sharable certificate
Excel Essential Training (Microsoft 365) at Linkedin Learning Course details
- This course 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
Excel Essential Training (Microsoft 365) at Linkedin Learning Curriculum
Introduction
Getting started with Excel for Microsoft 365
The future of Excel
1. Getting Started with Excel
What is Excel used for?
The Ribbon menu and the Quick Access Toolbar
Shortcut menus and the Mini toolbar
Understanding workbooks and worksheets
Use Excel Help
2. Entering Data
Exploring data entry, editing, and AutoFill
Working with dates and times
Using Undo and Redo
Use 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, borders, and color backgrounds
Applying numeric formats
Adjusting row heights and column widths
Applying numeric formats
5. Adjusting Worksheet Layout and Data
Rows and columns: Insert, delete, hide, and unhide
Moving, copying, and inserting data
Finding and replacing data
6. Adjusting Page Layout and Printing
Page Layout view and commands
Using Page Break Preview and print setup options
7. Charts
Creating charts
Exploring chart types
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
Opening, closing, and saving workbooks
10. Data Management Features
Sorting data
Using filters
Creating PivotTables
11. Security and Sharing
Protecting worksheets and workbooks
Sharing workbooks and tracking changes
Conclusion
Continuing your Excel journey
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?