COMPUTER TRAINING
Microsoft Excel
®
1
Microsoft Excel
®
2
Introduction
Discover many time saving features as you
Learn how to build spreadsheets like Excel to Photoshop
®
learn about the features of Excel.
intended. You will be amazed at how much
Topics include:
This class will teach you everything you need
time you can save by setting up worksheets
• What is Excel and what can it do for me?
to know to get started in Photoshop CS, from
correctly in the beginning. Learn about:
• AutoFill and RangeFill
an exhaustive tour through the toolbox to an in
• Formatting Cells
• The Excel Window
depth look at color gamut and why what you
• Formatting pages
• Saving, Closing, Opening, Saving As
see on your monitor is not what prints.
• Moving and Copying Data
• Sample Budget, Formulas and AutoSum
• Why resolution matters
• Formulas and Cell Addresses
• Entering Data: values, labels, formulas
• Creating a New File
• Functions
“Microsoft Windows XP
®
” or equivalent
• Work Space Overview
• Creating Charts
experience is recommended prior to this
• Toolbox
“Excel 1” is recommended prior to this class.
class.
• Palettes
Select One 4-hour Class
Select One 4-hour Class: • Power tools for making selections
541L18 Tue Nov 04 1:00-5:00 pm
542L18 Tue Nov 11 1:00-5:00 pm • Color Modes, Adjustments & Masking
541L28 Fri Nov 21 6:00-10:00 pm
542M18 Tue Dec 09 8:30 am-12:30 • Drawing, Painting & Editing Tools
541M18 Tue Dec 02 8:30 am-12:30
542M28 Sat Dec 13 8:30 am-12:30
Select One 4-hour Class:
541M28 Sat Dec 13 8:30 am-12:30
542A19 Sat Jan 10 1:00-5:00 pm
596L18 Sat Nov 15 1:00-5:00 pm
541A19 Tue Jan 06 8:30 am-12:30
542A29 Tue Jan 13 8:30 am-12:30
596M18 Thu Dec 11 6:00-10:00 pm
541A29 Sat Jan 10 8:30 am-12:30
542A39 Fri Jan 30 6:00-10:00 pm
596A19 Tue Jan 20 1:00-5:00 pm
541A39 Thu Jan 29 6:00-10:00 pm $77.00 Early Bird Special*
$97.00 Early Bird Special
$77.00
$87.00 Regular Price
Early Bird Special* $107.00 Regular Price
$87.00 Regular Price
Intermediate
Microsoft Excel
®
3
Microsoft Excel
®
4
Photoshop
®
Learn the true power features of Excel. To
Let Excel Do the work for you. If you’re
Explore the application even more and
really get the most out of Excel, you need
thinking it...chances are Excel does it. Learn
build upon the knowledge gained from the
to know not only how to accomplish certain
how to take advantage of the finer functions of
introduction to Photoshop curriculum.
tasks but how to accomplish them efficiently.
Excel to make your life easier. Learn about:
• Menus & options
Learn about:
• Data Lists
• Using and editing layers.
• Excel as a database: Named Ranges
• Subtotals for Data Lists
• Color Correction tools
• Functions with Named Ranges
• Forms for Data Lists
• Filters
• Sorting and Filtering
• Validating Input
• Creating Contact sheets
• Linking Worksheets and Workbooks
• Data Tables & Database Functions
• Tricks & Tips
• Password Protecting your Worksheets
• Pivot Tables
• Modifying the Toolbars
• Macros
Select One 4-hour Class:
“Excel 2” is recommended prior to this class.
“Excel 3” is recommended prior to this class.
597L18 Tue Nov 25 6:00-10:00 pm
597M18 Thu Dec 18 6:00-10:00 pm
Select One 4-hour Class:
Select One 4-hour Class:
597A19 Tue Jan 27 1:00-5:00 pm
543L18 Tue Nov 18 1:00-5:00 pm
544L18 Tue Nov 25 1:00-5:00 pm
543A19 Tue Jan 20 8:30 am-12:30
544A19 Tue Jan 27 8:30 am-12:30
$97.00 Early Bird Special
$107.00 Regular Price
$77.00 Early Bird Special*
$77.00 Early Bird Special*
$87.00 Regular Price
$87.00 Regular Price
Microsoft
New Advanced Excel See Page 15
FrontPage
®
Learn to plan and implement your web site with
FrontPage. Topics covered include: FrontPage
Microsoft Access Database
®
Consultations
views, creating pages, adding and formatting
text, using shared borders and navigation bars,
We can provide the following expertise:
adding images, creating hyperlinks, inserting
• Design and build customized Access database systems to fulfill your business requirements
and formatting tables, and creating a business
• Resolve problems with existing Access database systems
web site with the wizard. “Microsoft Windows
• Enhance and refine operation of existing Access systems
XP
®
” is recommended prior to this class.
• Convert and reconfigure your EXCEL information into an Access Database System
• Provide computer systems analysis and design training to enhance Access skills required to
Select One 4-hour Class:
fulfill your own customized business needs with Microsoft Access.
581L18 Thu Nov 06 8:30 am-12:30
581M18 Sat Dec 06 8:30 am-12:30
Our automation consultant has over 40 years experience in data processing and has served as an
581A19 Wed Jan 21 1:00-5:00 pm
Automation Consultant in Microsoft Access database systems for over 15 years.
$77.00 Early Bird Special*
Contact The Knowledge Shop at 407-671-9505 for further information.
$87.00 Regular Price
Providing the Highest Quality Classes, Seminars and Workshops for 18 years.
13
Page 1 |
Page 2 |
Page 3 |
Page 4 |
Page 5 |
Page 6 |
Page 7 |
Page 8 |
Page 9 |
Page 10 |
Page 11 |
Page 12 |
Page 13 |
Page 14 |
Page 15 |
Page 16 |
Page 17 |
Page 18 |
Page 19 |
Page 20 |
Page 21 |
Page 22 |
Page 23 |
Page 24