Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0

Provides competency in validating data, creating and modifying list ranges, sorting database and using database functions. Advanced Filter, Automatic Subtotal, PivotTables and Charts. Performing what-if analyses and working with scenarios.

Course Outline
Provides competency in validating data, creating and modifying list ranges, sorting database and using database functions. Advanced Filter,  Automatic Subtotal, PivotTables and Charts. Performing what-if analyses.

Course Outline SECTION 1: Getting The Most From Your Data Lesson 1.1    
Outlining And Grouping Your Data
Using Automatic Outlining
Displaying And Collapsing Levels
Grouping Data Manually
Creating Subtotals
Lesson 1.2    
Pivot Tables
What Is A Pivot Table?
Creating A Pivot Table Frame
Specifying Data In A Pivot Tables
Rearranging Pivot Table Data
Lesson 1.3    
More On Pivot Tables
Modifying Pivot Table Calculations
Formatting A Pivot Table   
Refreshing A Pivot Table   
Charting A Pivot Table       
Creating A Pivot Table Based On Data From An External Database  
Lesson 1.4    
Exploring Scenarios
What Is A Scenario?
Creating A Scenario
Creating A Scenario Summary Report    
Saving Multiple Scenarios 
Lesson 1.5    
What If Analysis
Using A One And Two Input Data Table   
Using Goal Seek     
Using Solver

SECTION 2: Excel And The Internet Lesson 2.1    
Excel And Hyperlinks
Hyperlinks And The Internet
Inserting Hyperlinks
Modifying Hyperlinks
Using The Web Toolbar
Browsing Hyperlinks In Excel
Lesson 2.2    
Excel Workbooks As Web Pages
Interactive And Non-Interactive Web Pages
Saving A Workbook As A Web Page
Saving A Worksheet As A Web Page
Saving A Chart As A Web Page
Saving A Range As A Web Page
Lesson 2.3     
Getting Data From The Internet
Importing From An External Data Source
Creating A Web Query
Saving A Web Query
Refreshing A Web Query
SECTION 3: Advanced Excel Tasks Lesson 3.1     
Creating And Using Shared Workbooks
Sharing A Workbook
Requesting Reviews
Reviewing A Workbook
Tracking Changes
Merging And Revising A Shared Workbook
Lesson 3.2     
Visual Basic And Macros
Adding Code To Your Macro
Adding Comments To VBA Code
Declaring Variables
Prompting For User Input
Iteration Over A Range
Using If Then Else Statements
Lesson 3.3     
Advanced File Management
Identifying File Properties
Searching For Files
Protecting Personal Information
Creating Back Up Files
Changing Auto-Recovery Settings
Lesson 3.4     
Excel Security
Digital Signatures
Macro Security
Protecting Your Workbook With A Password
Lesson 3.5     
Custom And Advanced Features In Excel
Customizing Excel By Changing Options
Using Custom Auto-Fill Lists
What Is Text To Speech?
Using Detect And Repair
Prerequisites & Certificates

Excel Intermediate Level

Certificates offered

Certificate of completion

Cancellation Policy
Commitment of resources and industry standards require that we be notified of any cancellation. As such, you may reschedule any training course up to five (5) working days before the actual training date. Simply call us, and we send you a new registration confirmation without extra charge. If training is rescheduled less than five (5) working days before the training date, a rescheduling fee of 50% of the course fee will be invoiced.

The latest time we accept rescheduling is until noon on the working day before
the training date. "No-shows" without prior notification are charged as if you had attended the course. There are no refunds. We reserve the right to cancel any course and reschedule if attendance is not sufficient to run the course. In this case you will be notified, usually five (5) working days or more prior to the
training day and the training is rescheduled.

Map & Reviews
Careers in Transition
[ View Provider's Profile ]


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 1057 times.