Excel: Advanced
Course description
Overview: Students will learn various advanced techniques for analyzing & manipulating data in Excel.
Prerequisites: Windows Introduction, Excel Level 1 - Worksheets, Excel Level 2 Charting & Organizing
Data, or equivalent knowledge.
Course Length: 1 Day
Upon successful completion of this course, students will be able to:
Customize toolbars and create styles and templates.
Create decision-making functions.
Analyze worksheet data by creating pivot tables.
Compare and contrast workbook files and file links.
Outline and consolidate worksheets and analyze worksheet data by using the Scenario
Manager.
Display and protect worksheet data by locking cells.
Record and modify macros by using the Visual Basic Editor.
Create and work with interactive Web documents.
Course Content: Excel Advanced
Lesson 1: Customizing the Work Area Lesson 5: Consolidating and Analyzing Data
Working with Built-in Toolbars Consolidating Data from More Than One
Using Custom Toolbars Worksheet
Creating and Using Styles Using the Goal Seek and Solver Utilities
Using Templates Using Scenario Manager to View a
Worksheet with Different Input Values
Lesson 2: Advanced Formula Construction
Using Names Lesson 6: Using Protection and Display
Using the IF Function Options
Using the VLOOKUP Function Using Comments
Using IS Functions and the Auditing Protecting Workbooks
Features Using Custom Views
Lesson 3: Using Pivot Tables Lesson 7: Introduction to Macros
Creating Pivot Tables Running Macros
Modifying Pivot Tables Recording a Macro
Grouping and Summarizing Data in a Viewing and Editing VBA Code
Pivot Table
Creating Interactive Pivot Tables for the Lesson 8: Working with Interactive Excel Web
Web Documents
Saving Excel Worksheets as Web
Lesson 4: Working with Multiple Worksheets Documents
Working with Workbooks Spreadsheet Web Component
Linking Cells in Different Workbooks
Workbook Versus Links and
Workspaces
Sharing and Merging Workbooks
Learning@ComputerLinkTraining.com
ComputerLINK Training Solutions 1-207-651-0610