Designed for users familiar with Excel & want to expand their knowledge. Upon completion of the course, you'll be able to protect & unprotect worksheets & workbooks, use goal seek, auditing toolbar, data tables, scenarios as well as create & edit macros
- Course Outline
This course is designed for users who are familiar with Excel and want to expand their knowledge. Participants must have good working knowledge of Excel Introduction and Excel Intermediate.
Upon completion of the course, you will be able to protect and unprotect worksheets and workbooks, use goal seek, auditing toolbar, data tables, scenarios as well as create and edit macros.
SECTION 1: Getting the Most From Your Data
Lesson 1.1: Outlining and Grouping your Data
Lesson 1.2: PivotTables
Lesson 1.3: More on PivotTables
Lesson 1.4: Exploring Scenarios
Lesson 1.5: What if Analysis
SECTION 2: Excel and the Internet
Lesson 2.1 Excel and Hyperlinks
Lesson 2.2 Excel Workbooks as Web Pages
Lesson 2.3 Getting Data from the Internet
SECTION 3: Advanced Excel Tasks
Lesson 3.1: Creating and Using Shared Workbooks
Lesson 3.2: Visual Basic and Macros
Lesson 3.3: Advanced File Management
Lesson 3.4: Excel Security
Lesson 3.5: Custom and Advanced Features in Excel
- Prerequisites & Certificates
Participants must have good working knowledge of Excel Introduction and Excel Intermediate.
Certificate of completion
- Cancellation Policy
Compuease Cancellation Policy
We at Compuease work hard to arrange our schedules around your needs. Last minute cancellations put additional strain on our schedules and therefore we have the following Cancellation Policy for our Public Classes. You may cancel or reschedule a registration at any time up to 10 business days before the class without penalty. Canceling or rescheduling a registration within 10 business days requires full payment of the course fee. You are welcome to transfer your seat in a class to another individual at any time before the class.
- Map & Reviews
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 1384 times.