Customer Care → Systems, Tools, & Applications

Excel Essential Training (Office 365/Microsoft 365)


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. 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.

Learning 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.
Content
  • Getting started with Excel for Office 365
  • 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
  • Exploring data entry_ editing_ and AutoFill
  • Working with dates and times
  • Using Undo and Redo
  • Using Save or Save As
  • Using simple formulas
  • Copying a formula into adjacent cells
  • Using SUM and AVERAGE
  • XLOOKUP and lookup functions
  • Exploring font styles and effects
  • Applying borders and color backgrounds
  • Adjusting row heights and column widths
  • Rows and columns_ Insert_ delete_ hide_ and unhide
  • Moving_ copying_ and inserting data
  • Finding and replacing data
  • Page Layout view and commands
  • Using Page Break Preview and print setup options
  • Creating charts
  • Exploring chart types .mp4
  • Working with Excel Ideas
  • Freezing and unfreezing panes
  • Splitting screens horizontally and vertically
  • Renaming_ inserting_ and deleting sheets
  • Moving_ copying_ and grouping sheets
  • Sorting data
  • Using filters
  • Creating PivotTables
  • New data types coming to Excel for 365
  • Protecting worksheets and workbooks
  • Sharing workbooks
  • Tracking changes
  • TEST
Completion rules
  • All units must be completed