|
|
LINDA'S ONLINE CLASSES
Any questions on how to order, etc.?
Click the "HowTo" link above for FULL instructions.
Take a 6 week class with Linda at Eclectic
Academy, in the comfort of your home. One lesson a week
with personal support and instruction. Each
lesson takes no more than two hours and you can
complete the lesson at any time during the week
that is convenient for you. All
this for $30US. A better bargain cannot be
found! My classes cover ALL versions
of Microsoft Office, from 97 to 2003, except Mac
versions.
If you have the Office 2007 versions of these
programs, the
only classes I'm teaching in this version so far
are EXCEL 101 and 201. Sign up now!!
NEXT ONLINE CLASSES START ON May 11, 2008.
NEW! Excel classes now include Excel 2007!
OR, SKIP THE CLASS (and the personal support
and instruction) and just buy the eBook and
learn on your own for $15 to $20 (the eBooks are in .exe format and include all the
lessons taught in the online classes)
DOWNLOAD FREE EBOOK SAMPLER
HERE!
screenshots for preview here
If you skip the class and buy the book,
support is offered for free in my
MS
Office FREE email support group.
***NOTE*** These classes apply to
all versions of these programs, from Office 97
through Office 2003. If you choose to buy the ebooks instead, be sure to buy the ones that
apply to your version.
** Starred eBooks/classes
are included IN FULL on my CD, Linda's MS
Office Tutorial
Click here to order
Learn how to use Access to create and edit
Tables, Forms, Reports and Queries. Add to
an existing database or learn to create your own.
- Week 1
An overview of Access's
interface, menus, and toolbars and what is
included in the software. Navigating through a database
and understanding Tables, Forms, Reports, and
Queries in both their data and design views.
- Week 2
Adding a Table to a database
in various ways.
Understanding the components of a Table.
Editing and Customizing
Tables.
- Week 3
Adding a Form to a database
in various ways.
Understanding the components of a Form.
Editing and Customizing
Forms. Using a
Form to add records to a Table.
- Week 4
Producing a Report based on a
Table in various ways.
Understanding the components
of a Report.
Editing and Customizing Reports.
- Week 5
Creating a Query based on a
Table or Query in various ways.
Understanding the components of a Query.
Editing and Customizing
Queries.
Producing a Report based on a Query.
- Week 6
Importing data into your
database from other sources.
Sorting and Filtering data.
Building a new database from
scratch.
back to main menu
** This
online class now includes Excel 2007 - however
the eBook does not ... yet. **
Learn how to use Excel to create and edit
spreadsheets to produce inventory reports,
invoices, budgets, customer databases, and more.
Topics covered will include a walkthrough of the
Excel interface, creating and editing various
types of spreadsheets, using different formulas,
and creating charts.
-
Week 1 An overview of Excel's
interface, menus, and toolbars and what is
included in the software. Excel's different
mouse pointers and what they do. Understanding
the different "modes" in Excel. How
to save files, open templates, and open
existing files.
-
Week 2 Creating your first
spreadsheet. Adding graphics and colors to
your spreadsheet. Using simple formulas and
Excel's automatic features.
-
Week 3 Formatting cells. Formatting
workbooks and worksheets. Protecting workbooks
and worksheets.
-
Week 4 Creating Charts. Customizing
the data in the chart. Customizing the Chart.
-
Week 5 More formulas. Using formulas
to pull information across sheets and
workbooks.
-
Week 6 Sorting data. Filtering data.
Splitting data across multiple columns.
Creating templates
back to main menu
** This
online class now includes Excel 2007 - however
the eBook does not ... yet. **
-
Week 1 Review of Excel 101. Basic Formatting. Basic Formulas.
Basic Sorting and Filtering. Using forms to input data
-
Week 2 Recording macros. Assigning Macros To Toolbar Buttons and Keyboard Shortcuts.
Intro To Editing VBA Code Made with Macros. Using personal.xls To Make Macros Available in All Workbooks
-
Week 3 Advanced Filtering. Advanced Formatting
(including Conditional Formatting). Using Paste Special.
-
Week 4 Pivot Tables and Pivot Charts.
Consolidation. Creating Web Pages
-
Week 5 Naming Cells, Ranges, and Constants. Advanced Formulas and Nesting Formulas.
Inserting Comments
-
Week 6 Validating Cells. Subtotals. Using Goal Seek To Predict
Outcomes. Printing and Page Setup
back to main menu
Learn how to use Microsoft Outlook for email,
scheduling, and contact management. Understand the
features included in Outlook that are not included
in the email-only programs like Outlook Express.
(This class does NOT cover the features included
in the Corporate version which requires the
Exchange Server.)
-
Week 1 An overview of Outlook's
interface, menus, and toolbars and what is
included in the software. Creating new mail,
replying, replying to all, and forwarding
mail. Understanding the CC and BCC fields and
how to use them. Adding attachments to mail
and opening attachments from mail.
-
Week 2 Creating folders to
organize mail. Organizing mail by creating
rules, filters, and views. Using folder
properties. Using Tools>Options to
correctly configure how your mail and other
features are handled.
-
Week 3 Setting up default fonts
and mail formats. Using Stationery. Creating
Stationery and Templates. Creating and setting
up templates as autoresponders.
-
Week 4 Archiving mail and
creating backups. Understanding your .pst
files and using them to keep your mail and
folders safe. The Inbox Repair Tool. Importing
and Exporting your address book and other
folders. Setting up multiple email accounts.
-
Week 5 Using the calendar and
tasks features to create effective schedules.
Creating reminders. Setting up recurring
events and inviting others. Moving events in
email to your calendar.
-
Week 6 Managing your Contacts.
Creating multiple address books. Creating
groups. Using the Journal. Using Notes.
back to main menu
NOTE: Since PowerPoint 2002 (XP) is very different from the
97/2000 versions, the class includes lessons on both.
However, if you choose to buy the ebook instead, be sure to buy
the correct ebook for the version you are using.
Learn how to create captivating slide show
presentations. Topics will include a walkthrough
of the PowerPoint Interface, creating slides with
bulleted lists, charts, graphics, sounds, tables,
organizational charts, and flow charts. We will
also learn how to effectively transition slides
and animate objects.
-
Week 1 An overview of PowerPoint's
interface, menus, and toolbars and what is
included in the software. Understanding the
preformatted slide layouts and placeholders.
Using Design Templates, Color Schemes, and
Backgrounds.
-
Week 2 Creating a Title Slide.
Creating various Bulleted List slides.
Creating ClipArt slides.
-
Week 3 Creating Chart slides.
Creating an Organizational Chart Slide.
Creating a Table Slide. Creating a Media Clip
Slide.
-
Week 4 Customizing graphics in
slides. Adding Sounds to slides. Using Slide
Sorter view to remove slides, add slides from
one presentation to another, change the order
of slides, and hide slides.
-
Week 5 Using the Slide Master to
create a template for all slides within the
show. Adding Transitions and Animations to the
show.
-
Week 6 Rehearsing timings. Adding
notes and handouts to presentations.
Understanding the various printing options.
Exploring the different saving techniques.
back to main menu
Learn how to do simple desktop publishing with
this easy-to-use alternative to Adobe Pagemaker or
Quark Xpress. Topics covered will include creating
letterheads, newsletters, greeting cards, business
cards and more.
-
Week 1 An overview of Publisher's
interface, menus, and toolbars and what is
included in the software. Using the wizards to
create different Desktop Publishing standards,
such as business cards, greeting cards,
postcards, flyers, calendars, and menus.
-
Week 2 Customizing files created with
the wizards. Creating files from the
Publications By Design feature or the Blank
Publications. Setting up your Personal
Information file for automatic inclusion in
your publications. Using the background and
foreground features, as well as the Scratch
Area.
-
Week 3 Using the Layout Guides and
Ruler Guides to line up frames. Understanding
the "Snap To" features. Creating
Text and ClipArt frames.
-
Week 4 Creating Table, WordArt, and
Picture frames. Using the drawing tools.
Inserting Objects into pages.
-
Week 5 Linking and grouping frames.
Wrapping text around objects. Arranging frames
from front to back.
-
Week 6 Understanding the Commercial
Printing Tools. Exploring the different
options for saving files to be printed
yourself, to be printed by a commercial
service, or to be displayed on a web page.
back to main menu
Learn all the basics of using Microsoft Word to
create letters and stationery, newsletters,
flyers, business cards, term papers, and more.
Topics covered will include a walkthrough of all
the features in the interface, word and paragraph
formatting, using tables and columns, inserting
and formatting clipart, mail merges, wordart and
other graphics, creating tables of contents and
indexes, and making your own templates and default
styles.
-
Week 1 An overview of Word's
interface, menus, and toolbars and what is
included in the software. How to do basic text
formatting. How to save files, open templates,
and open existing files.
-
Week 2 Writing a business letter
Doing a Mail Merge with this letter. Creating
Envelopes and Labels
-
Week 3 Understanding the uses of
Tables. Creating tables. Converting existing
data to a table.
-
Week 4 Formatting documents.
Paragraph formatting. Using Themes,
Backgrounds, and Auto Formatting. Font
formatting, including Change Case and Drop
Caps. Bullets and Numbering.
-
Week 5 Headers and Footers. Page
breaks and Section breaks.
-
Week 6 Inserting Objects (Excel
spreadsheets, Maps, etc.) and Graphics
(photos, ClipArt, WordArt) into a document.
Using the Drawing Toolbar to add effects and
shapes. Creating, using, and editing
templates.
back to main menu
-
Week 1 Review of Word 101. Basic Mail Merge. Basic Styles and Tables of Contents. Basic Headers and Footers and Section Breaks.
Customizing Styles.
-
Week 2 Mail Merges Using Data from Excel and Outlook. Creating Mail Merges for Email.
Using MS Query To Customize Mail Merges. Adding Word Fields To Merge Documents
-
Week 3 Creating Forms. Protecting Forms. Protecting
Documents.
-
Week 4 Track Changes. Inserting Captions and Comments. Creating Indexes
-
Week 5 Recording Macros. Assigning Macros To
Toolbar Buttons and Keyboard Shortcuts. Intro To Editing VBA
Code Made with Macros. Using the Organizer To Make Macros
Available in All Documents
-
Week 6 Columns and Column Breaks. Footnotes and Endnotes. Bookmarks and Hyperlinks.
Creating Web Pages
back to main menu |
|
.
