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
- Identify two navigational features within the Excel interface.
- Distinguish the best approach to managing data in cells.
- Recognize how Excel processes simple formulas.
- Describe the different ways to access formatting features.
- Identify page layout parameters for printing worksheets.
- Determine the best approach to creating charts.
- Explain how best to manage multiple worksheets and workbooks.
Content
Content
- Getting Started with Excel
- Entering Data
- Creating Formulas and Functions
- Formatting
- Adjusting Worksheet Layout and Data
- Printing
- Charts
- 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
Duration: 8 H 53 M
Duration: 8 H 53 M
Target: All Employees
Other References & Resource
Page updated
Google Sites
Report abuse