Embedded Files
Overview
Overview
Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.
Objectives
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
Content
Introduction
Creating Formulas and Function
Adjusting Worksheet Views
Multiple Worksheets and Workbooks
IF, VLOOKUP and Power Functions
Security and Sharing
Data Management Features
Data Analysis Tools
PivotTables
Introduction to Macros
Conclusion
Duration: 1H 05 M
Duration: 1H 05 M
Target: All Employees
Other References & Resource
Page updated
Google Sites
Report abuse