Training with a personal touch!
Page Title Here
| 3-Hour Courses! |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
Excel - Mastering Formulas and Functions
There are hundreds of different kinds of formulas and functions to use
in Excel – this class will focus on some of the more cross functional
ones that can be used across all types of business to improve
spreadsheet performance and business productivity. Some of the
formulas and functions covered include:
• date & time
• mathematical
• text
• database
• financial
• logic
• lookup and reference functions
• IF statements
Excel - Charts for data visualization
Learn to use Excel to create powerful graphic presentations, including
bar graphs, pie charts, exploded pies, line graphs, scatter plots, and
three-dimensional graphs. Discover how to scale and format graphs,
properly select data ranges, add titles and labels, set up legends, use
grids and color, and make other graphic enhancements. Learn to select
the appropriate graph type for your data and to alter that graph for your
specific needs.
Excel - Painless Pivot Tables
(Prerequisite: Intermediate Applications of Excel or equivalent
experience.) In this quick-paced, introductory course, you will learn how
to save time extracting, organizing, and summarizing meaningful data
from Excel spreadsheets or other sources by creating interactive
PivotTables and PivotCharts. In this course, you will learn to summarize
large amounts of information in a few steps using Excel's PivotTable
and PivotChart Wizard. Create and customize a PivotTable, view
subsets of data, and show or hide details as well as work with
calculated fields. Discover how to create and design a PivotChart to
view the summarized data in graphical format.
Adding A Professional Look with PowerPoint
Do you want to add a little pizzazz to your presentations? Is your
audience falling asleep on you? Find out how to enhance your
presentations using the latest technology in this interactive class
loaded with tips and tricks! Learn the "do's" and "don'ts" of using
PowerPoint 2007 as a presentation tool. Discover how to use animation
features, add sound and narration to slides, imbed video and audio
clips, create links in slides to outside web spaces, insert alternate file
types like PDF and excel workbooks, and use PowerPoint to create
interactive games similar to popular TV game shows.
Word - Mail Merge, Letters & Labels
Have you found yourself confused with the Mail Merge Wizard? Don’t let
it happen again by learning how to use the Wizard and an alternative
way to avoid the Wizard. Topics covered will be:
• How to create a mail merge using the Wizard and Toolbar.
• How to merge information from Access and Excel.
• How to create labels and envelopes.
• How to sort and query information from the data source.
Word- Create and Format Tables
Discover how to use the features of Microsoft Word to create and add
exciting tables quickly and easily. Find out how to create and edit
existing tables, sort tabled data, split and merge cells, as well as
convert tabled data into text and apply borders and shading. Learn how
to insert dates, symbols, clip art, pictures, WordArt objects and
watermarks.
Outlook – Beyond Email
We all use Outlook. It’s easy. You can answer email, keep your
appointments and your calendar, and save your files in various folders.
But are you using it to manage your entire workflow? This class is to
help move you beyond email and help you understand Outlook’s
amazing workflow benefits such as:
• Powerful drag and drop techniques to end typing
• Tricks on how to send notes to a contact or an email to your
calendar
• Creating Notes to minimize interruptions
• Using Outlook to sort your mail
• Organizing your files with flags, colors, categories, emails and
alerts
This class may not change your outlook on life, but it will definitely
change your life on Outlook.
Access Queries in Depth
Learn to create Queries of data using the Query Wizard and by hand.
Learn to create queries to update data, delete data and view data. Some
of the Query topics will be:
There are hundreds of different kinds of formulas and functions to use
in Excel – this class will focus on some of the more cross functional
ones that can be used across all types of business to improve
spreadsheet performance and business productivity. Some of the
formulas and functions covered include:
• date & time
• mathematical
• text
• database
• financial
• logic
• lookup and reference functions
• IF statements
Excel - Charts for data visualization
Learn to use Excel to create powerful graphic presentations, including
bar graphs, pie charts, exploded pies, line graphs, scatter plots, and
three-dimensional graphs. Discover how to scale and format graphs,
properly select data ranges, add titles and labels, set up legends, use
grids and color, and make other graphic enhancements. Learn to select
the appropriate graph type for your data and to alter that graph for your
specific needs.
Excel - Painless Pivot Tables
(Prerequisite: Intermediate Applications of Excel or equivalent
experience.) In this quick-paced, introductory course, you will learn how
to save time extracting, organizing, and summarizing meaningful data
from Excel spreadsheets or other sources by creating interactive
PivotTables and PivotCharts. In this course, you will learn to summarize
large amounts of information in a few steps using Excel's PivotTable
and PivotChart Wizard. Create and customize a PivotTable, view
subsets of data, and show or hide details as well as work with
calculated fields. Discover how to create and design a PivotChart to
view the summarized data in graphical format.
Adding A Professional Look with PowerPoint
Do you want to add a little pizzazz to your presentations? Is your
audience falling asleep on you? Find out how to enhance your
presentations using the latest technology in this interactive class
loaded with tips and tricks! Learn the "do's" and "don'ts" of using
PowerPoint 2007 as a presentation tool. Discover how to use animation
features, add sound and narration to slides, imbed video and audio
clips, create links in slides to outside web spaces, insert alternate file
types like PDF and excel workbooks, and use PowerPoint to create
interactive games similar to popular TV game shows.
Word - Mail Merge, Letters & Labels
Have you found yourself confused with the Mail Merge Wizard? Don’t let
it happen again by learning how to use the Wizard and an alternative
way to avoid the Wizard. Topics covered will be:
• How to create a mail merge using the Wizard and Toolbar.
• How to merge information from Access and Excel.
• How to create labels and envelopes.
• How to sort and query information from the data source.
Word- Create and Format Tables
Discover how to use the features of Microsoft Word to create and add
exciting tables quickly and easily. Find out how to create and edit
existing tables, sort tabled data, split and merge cells, as well as
convert tabled data into text and apply borders and shading. Learn how
to insert dates, symbols, clip art, pictures, WordArt objects and
watermarks.
Outlook – Beyond Email
We all use Outlook. It’s easy. You can answer email, keep your
appointments and your calendar, and save your files in various folders.
But are you using it to manage your entire workflow? This class is to
help move you beyond email and help you understand Outlook’s
amazing workflow benefits such as:
• Powerful drag and drop techniques to end typing
• Tricks on how to send notes to a contact or an email to your
calendar
• Creating Notes to minimize interruptions
• Using Outlook to sort your mail
• Organizing your files with flags, colors, categories, emails and
alerts
This class may not change your outlook on life, but it will definitely
change your life on Outlook.
Access Queries in Depth
Learn to create Queries of data using the Query Wizard and by hand.
Learn to create queries to update data, delete data and view data. Some
of the Query topics will be:
- Design a query using the Query by Example form.
- Create queries that combine data from multiple tables.
- Create queries that update the data in a table, create a new
table, append data to a table and delete data from a table. - Create cross-tab queries and parameter queries