Training Level: Intermediate/Advanced Prerequisites: Access Foundation or equivalent experience Course Length: 3 hours Price: $100.00 View Course Outline Course Objectives: Review simple queries Understand query types Create queries from multiple tables Create calculated query fields Use the Expression Builder Understand complex expressions Summarize groups of records Use display and find queries Understand and create special …
Category Archive: Advanced Modules – Microsoft Office 2010
Permanent link to this article: http://windowwalk.com/advanced-queries-access-2010-2/
Advanced Forms – Access 2010
Training Level: Intermediate/Advanced Prerequisites: Access Foundation or equivalent experience Course Length: 2 hours Price: $75.00 View Course Outline Course Objectives: Create database forms Understand and use data form fields Understand and use data form controls Edit form control properties Edit form properties Work with multiple controls Create and edit form controls Create calculated controls Understand …
Permanent link to this article: http://windowwalk.com/advanced-forms-reports-access-2010/
Advanced Reports – Access 2010
Training Level: Intermediate/Advanced Prerequisites: Access Foundation or equivalent experience Course Length: 2 hours Price: $75.00 View Course Outline Course Objectives: Create reports Modify and edit a report Understand and use report fields Use report controls Set up page layout Use report sections Format reports Understand and use control properties Training Course Includes: Hands-on instruction Personal …
Permanent link to this article: http://windowwalk.com/advanced-queries-access-2010/
Collaboration Tools – Outlook 2010
Training Level: Intermediate/Advanced Prerequisites: Outlook Foundation or equivalent experience Course Length: 2 hours Price: $75.00 View Course Outline Course Objectives: Requires Microsoft Exchange Network Server Create and monitor meeting requests Set the Free/Busy option Use shared network folders Set and delegate access permissions Take and track votes Assign tasks to other users Send status reports …
Permanent link to this article: http://windowwalk.com/collaboration-tools-outlook-2010/
What-If Analysis – Excel 2010
Training Level: Intermediate/Advanced Prerequisites: Excel Foundation or equivalent experience Course Length: 2 hours Price: $75.00 View Course Outline Course Objectives: Understand and define data scenarios Create a scenario summary report Understand and use one and two-input data tables Understand and use the Goal Seek tool Understand and use the Solver tool Training Course Includes: Hands-on …
Permanent link to this article: http://windowwalk.com/what-if-analysis-excel-2010/
PivotTables & Data Analysis – Excel 2010
Training Level: Intermediate/Advanced Prerequisites: Excel Foundation or equivalent experience Course Length: 2 hours Price: $75.00 View Course Outline Course Objectives: Understand PivotTable data analysis Create and modify PivotTables Use page fields Group PivotTable data Use PivotTable update Use subtotals in PivotTables Understand database functions Use database functions Use data group and outline tools Training Course …
Permanent link to this article: http://windowwalk.com/pivottables-data-analysis-excel-2010/
Tables (Lists) – Excel 2010
Training Level: Intermediate/Advanced Prerequisites: Excel Foundation or equivalent experience Course Length: 2 hours Price: $75.00 View Course Outline Course Objectives: Understand and create lists of data Use the data form Create and modify data records Sort data in lists Use Auto-Filters to sort data Understand and use advanced filters Work with filtered records Understand and …
Permanent link to this article: http://windowwalk.com/tables-lists-excel-2010/
Functions & Formulas – Excel 2010
Training Level: Intermediate/Advanced Prerequisites: Excel Foundation or equivalent experience Course Length: 2 hours Price: $75.00 View Course Outline Course Objectives: Understand formulas and functions in Excel Use multiple operators in formulas Use the Function Palette Use named ranges in formulas Use non-adjacent ranges in formulas Use conditional formulas Display and print formulas Fix errors in …
Permanent link to this article: http://windowwalk.com/functions-formulas-excel-2010/
Charts – Excel 2010
Training Level: Intermediate/Advanced Prerequisites: Excel Foundation or equivalent experience Course Length: 2 hours Price: $75.00 View Course Outline Course Objectives: Create charts from spreadsheet data Understand and use chart types Position charts in worksheets Use chart layouts and styles Understand and use layout options Format chart elements Understand and modify chart source data Use annotation …
Permanent link to this article: http://windowwalk.com/charts-excel-2010/
Outlines & References – Word 2010
Training Level: Intermediate/Advanced Prerequisites: Word Foundation or equivalent experience Course Length: 3 hours Price: $100.00 View Course Outline Course Objectives: Understand and use outline view Create outlines View and modify outlines Numbering outlines Use bookmarks Use footnotes and endnotes Create cross-references Create a table of contents Create indexes Create and use master documents Training Course …
Permanent link to this article: http://windowwalk.com/outlines-references-word-2010/