Private Training Class for NRC
- Course Outline
As per your quote.
# of Participants: 4
- Monique Huot
- Lucie Lacroix
- Genevieve Legault
- Julie Lalonde
Microsoft Excel 2007 " Advanced Concepts
EXPLORE THE Excel 2007 USER INTERFACE
Office Button (2007)
Shortcut Key Tips
Change Excel Options
Use Automatic Outlining
Display and Collapse Levels
Manually Group Data
Create a Pivot Table
Change and Rearrange Pivot Table Data
Modify Pivot Table Format and Structure
Chart a Pivot Table
Create a Pivot Table from External Data
Use Slicer to Filter Pivot Table Data*
Use the PowerPivot Add In*
USING EXCEL WITH OTHER PROGRAMS
Link to an Access Database
Transform Excel into an Access Database
Import and Export Data to and from Text and CSV files
Import Data from External Sources
Link and Embed from Other Sources
Create and Use Scenarios
Create a Scenario Summary Report
Save Multiple Scenarios
Use a One and Two Input Data Table
Use Goal Seek
Use the Solver
EXCEL AND THE INTERNET
Add, Modify and Remove Hyperlinks
Save Workbooks, Sheets, Charts and Ranges as Webpages
Create, Save and Refresh a Web Query
Publish to a Document Server
Use Sharepoint Server
Create, Open and Edit a Shared Workbook
Track Changes in a Shared Workbook
Create, Use and Modify Custom Lists
Record and Play a Macro
Record and Run a Relative Reference Macro
Assign a Macro to a Keystroke or Quick Access Toolbar
Create a Blank User Form
Add and Use Form Controls
Assign a Macro to a Control
- Prerequisites & Certificates
An understanding of basic and intermediate excel topics.
Certificate of completion Course includes access to online assessments, e-books, management e-books, printed course ware and online practice labs. After sales support - email and web chat (9:00am - 5:00pm) for 6 months
- Cancellation Policy
Cancellations less than 2 business weeks before the expected delivery date are eligible for a 50% refund, or a credit voucher will be provided for regularly scheduled courses (choice being that of the registrant). Credit Vouchers are transferable within the same company. Please send your cancellation notice to firstname.lastname@example.org.
- Map & Reviews
Itplanit Services Corp.
[ 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 238 times.