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
What Is A Pivot Table?
Creating A Pivot Table Frame
Specifying Data In A Pivot Tables
Rearranging Pivot Table Data
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
What Is A Scenario?
Creating A Scenario
Creating A Scenario Summary Report
Saving Multiple Scenarios
What If Analysis
Using A One And Two Input Data Table
Using Goal Seek
SECTION 2: Excel And The Internet Lesson 2.1
Excel And Hyperlinks
Hyperlinks And The Internet
Using The Web Toolbar
Browsing Hyperlinks In Excel
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
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
Reviewing A Workbook
Merging And Revising A Shared Workbook
Visual Basic And Macros
Adding Code To Your Macro
Adding Comments To VBA Code
Prompting For User Input
Iteration Over A Range
Using If Then Else Statements
Advanced File Management
Identifying File Properties
Searching For Files
Protecting Personal Information
Creating Back Up Files
Changing Auto-Recovery Settings
Protecting Your Workbook With A Password
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
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 1036 times.