– Website creation
– Blog Creation
– Internet Marketing Tools
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.
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.
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.
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.
Click here for more information.