Excel Essential Training (Office 365/Microsoft 365)
Learned in-depth formulation and abilities of Microsoft Excel. Followed along with Excel expert Dennis Taylor as he demonstrated how to efficiently manage and analyze data with this powerful program. Learned how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells, and data. Other lessons covered how to work with multiple worksheets, build charts and PivotTables, sort and filter data, use the printing capabilities of Excel, and more.
Summary of Knowledge Earned
- 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.