Microsoft Office And Windows Training Course Outline - Absolute Solutions
Cell: 27 (0)822 1023 18, Office/Fax: 27 (0)31 – 765 3227 JL Goddard t/a Absolute Solutions E-Mail: justin@AbsoluteSolutions.co.za Suite 2C, 8 Old Main Road, Hillcrest, 3650, Durban, South Africa Web: www.AbsoluteSolutions.co.za P.O. Box 2546, Hillcrest, 3650, Durban, South Africa Microsoft Office and Windows Training Course Outline Below is the course outline for Microsoft Office and Windows Training. The outline is split into different modules which can be completed individually. The modules are as follows: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. Windows 7 Introduction Microsoft Word Basic Microsoft Word Intermediate Microsoft Word Advanced Microsoft Excel Basic Microsoft Excel Intermediate Microsoft PowerPoint Basic Microsoft PowerPoint Advanced Microsoft Outlook Basic Microsoft Outlook Intermediate Microsoft Outlook Advanced Internet Basics Each module is approximately 6 hours depending on learner needs. Each module will be customized to suit learner and job requirements. Those learners attending multiple modules should attend the training sessions in the order of the modules listed above, although learners need not attend all modules. It is recommended that each learner complete a pre-assessment before attending the first training session. Please add any specific information you would like covered during training when booking your training. Use the Microsoft Office and Windows Training Booking Form to request training. Please see the Microsoft Office and Windows Training Resource List for ordering course material or software. Absolute Solutions will provide computer training onsite, and will bring a maximum of 5 laptops with the necessary software already installed for the purposes of training. All learners who attend any course will benefit from ongoing support via email. For any further information, please email Justin Goddard at justin@absolutesolutions.co.za. Page 1 of 15
Microsoft Office and Windows Training Course Outline About Your Trainer Justin started programming while still at school. After getting Microsoft Certified in 2001 he began training at IT Intellect, a Microsoft Partner college. In 2003 he became a contract lecturer and trained for various colleges and businesses including Derivco, a leading developer of software for the online gaming industry. For over seven years he trained a variety of Diploma courses for Varsity College which included end-user, computer technician and computer programming subjects. Justin currently specializes in building custom web-based applications. Justin is a registered Assessor in the FP&M Sector. He is also certified in the following: Page 2 of 15
Microsoft Office and Windows Training Course Outline Windows 7 Introduction 1. Explore Windows 7 Logging On to Windows 7 Exploring the Desktop Using the Start Menu o Quick Access to Windows Functionality Using the Windows Taskbar o Taskbar Buttons o Notification Area Exploring Control Panel o Control Panel Categories o Accessing Individual Control Panel Items o Different Ways of Opening Control Panel items o Understanding User Account control Finding Information About Your Computer System Updating Windows System Files o Types of Updates o Windows Update Options Ending a Computing Session Understanding User Accounts and Permissions o User Accounts Types o User Account Control Creating a User Account o Switching Quickly Among Users Managing a User Account o Be Safe Now, Not Sorry Later Limiting Computer Access o Playing Safely Disabling or Deleting a User Account Connecting to a Network o Home and Work Network Settings o Public Network Settings o Wireless Network Security Creating a Homegroup Working with a Homegroup o Joining an Existing Homegroup o Homegroup Settings for Shared Computers Page 3 of 15 Working with Windows o Sizing, Moving, and Arranging Windows o Hiding and Displaying Windows Understanding Files, Folders, and Libraries o File Types o Windows System Folders o Folder Windows Features o Displaying and Hiding Panes Finding Your Way Around Your Computer Connecting to Network Resources o Navigating to a Shared Folder o Mapping a Network Drive Finding Specific Information o Windows Search o Windows Search Parameters 5. Manage Folders and Files 3. Manage Your Network 4. Navigate Windows and Folders 2. Manage User Accounts o Leaving a Homegroup Sharing Files on Your Network o Public Folders o Homegroup Resources o Individual Files, Folders, and Libraries o Storage Drives Managing a Network Connection Viewing Folders and Files in Different Ways o Grouping Folder Content o Sorting and Filtering Folder Content o Changing Folder Options Working with Folder and File Properties o File Properties o Folder Properties Creating and Renaming Folders and Files Moving and Copying Folders and Files o Compressing Folders and Files o Folder Templates in Libraries Deleting and Recovering Folders and Files o Recycle Bin Size Creating Shortcuts o Desktop Shortcuts o Start Menu Pinned Items o Taskbar Pinned Items o Favorites Group
Microsoft Office and Windows Training Course Outline Microsoft Word Basic 1. Explore Word 3. Changing the Look of Text Working in the user interface Creating, editing text and saving documents o Creating a new blank document o Entering text o Saving the document o Saving into a new folder o Compatibility with older versions Opening, Moving around in and closing Documents Viewing documents in different ways o Switching between different views o Displaying non-printing characters o Zooming in the document o Switching between different word documents o Arranging windows of open documents o Displaying rulers in document window Accessing help feature 2. Editing and Proofread Text Making text changes o Selecting text o Deleting text o Drag and drop o Cut, Copy and Paste o Paste Options o Undo and redo Office clipboard Find and replace text o Using find and replace o Navigation pane Fine-tuning text o Thesaurus o Mini-translator Correcting spelling and grammatical errors o Spell check o Auto Correct Viewing document statistics Inserting saved text o Building Blocks o Create a new building block Inserting one document into another 4. Organizing Information in Columns and Tables Page 4 of 15 Quickly formatting text o Paragraph styles o Character Styles Changing a documents theme o Switching between different themes o Saving a new theme Manually changing the look of characters o Changing font, font size and font colour o Bold, Italic and Underline o Using the Mini Toolbar o Format Painter o Font dialog box o Highlight text o Clear Formatting Manually changing the look of paragraphs o Indenting o First Line and hanging indents o Paragraph alignment o Setting up Tabs o Adjusting line spacing o Paragraph spacing o Borders and Shading Character formatting and case considerations Find and replace formatting Creating and modifying lists o Bullets and Numbering o Customizing bullets and numbering o Sorting lists Formatting text as you type Presenting information in columns o Inserting columns o Justify paragraphs o Column options Creating tabbed lists Presenting info in tables o Inserting a table o Inserting and deleting columns and rows o Resizing columns o Merge cells o Table alignment o Converting text to table Performing calculations in tables Other layout options Formatting tables
Microsoft Office and Windows Training Course Outline o o Table style Manual formatting o Insert Word Art into the document o Wrap text around Word Art Formatting the first letter of a paragraph 5. Add Simple Graphic Elements 6. Preview, Print and Distribute Documents Inserting and modifying pictures o Insert Picture o Resize and crop a picture o Picture corrections and picture styles o Artistic effects About ClipArt Changing a document background Inserting Building Blocks o Inserting a Cover page o Inserting Page Numbers o Headers and Footers Drawing text boxes Adding Word Art Page 5 of 15 Previewing and adjusting page layout o Adjusting Page size and orientation o Setting up margins Controlling what happens on each page o Page breaks o Section breaks Printing documents Preparing documents for electronic distribution o Document properties o Document inspector o Marking a document as final
Microsoft Office and Windows Training Course Outline Microsoft Word Intermediate 1. Creating Diagrams 3. Use other Visual Elements Creating and Positioning a diagram Using the text pane Inserting shapes into a diagram Promoting and Demoting shapes in diagram Change a diagram’s layout, colours and shapes Use picture diagrams to show photographs Adding text and graphic watermarks Insert a symbol Building an equation and add it to the equation gallery Draw and manipulate shapes Insert a screen clipping 2. Insert and Modify Charts 4. Organize and Arrange Content Insert a chart into a document Customize a chart, and save it as template Plot Excel data in a chart Formatting a chart Changing chart types Adding axis titles and labels Page 6 of 15 Reorganize a document but adjusting its outline Arranging multiple pictures Insert and format nested tables 5. Creating Documents For Use Outside of Word Save files in different formats Creating and modifying web documents Create and publish blog posts
Microsoft Office and Windows Training Course Outline Microsoft Word Advanced 1. Explore More Text Techniques 4. Collaborate on Documents Adding hyperlinks Inserting fields Adding Bookmarks and Cross References 2. Use Reference Tools for Longer Documents Adding Footnotes and End notes Creating and Modifying Table of contents Table of figures Table of Authorities Creating and modifying indexes Adding Sources and compiling bibliographies Creating Master Documents 3. Work with Mail Merge Understanding Mail Merge Preparing Data Sources Using an Outlook Contact List as a Data Source Preparing Main Documents Merging Main Documents and Data Sources Printing Envelopes Sending Personalized Emails to Multiple Recipients Creating and Printing Labels Page 7 of 15 Co-authoring Documents Sending Documents Directly from Word Adding and Reviewing Comments Tracking and Managing Documents Changes Comparing and Merging Document Changes Password-Protecting Documents Restricting Who Can Do What to Documents Controlling Changes 5. Working in Word More Efficiently Working with Styles and Templates Default Program Options Customizing the Ribbon Customizing the Quick Access Toolbar Macros in Word o Enabling Macros o Recording a New Macro o Running a Macro o Copying a Macro from one Document to another
Microsoft Office and Windows Training Course Outline Microsoft Excel Basic 1. Setting up a workbook Creating Workbooks o Excel Terminology o Excel Environment o Customizing Quick Access Toolbar o Creating a New Workbook o Entering Data into Workbook o Saving a workbook o Open a workbook o Zoom o Insert a new worksheet o Renaming a new worksheet o Changing the tab colour of worksheet o Rearranging the order of worksheets o Move or Copy worksheet o Hide/Unhide Worksheet o Switch Windows Modifying Workbooks and Worksheets o Changing column widths and row heights o Insert Columns/Rows o Delete Columns/ Rows o Hide/Unhide columns or rows o Insert Cells o Moving Data by dragging Customizing Excel o Arranging multiple workbook windows o Customizing the ribbon o Minimizing the ribbon 2. Working with Data and Excel Tables Entering Data Copy, Cut and Paste Pick from drop down list Find and Replace data Spell Check Thesaurus Defining an Excel Table Page 8 of 15 o Format as table o Table design Basic Formulas o How to create a basic formula o Operators o Copy Formula down o Absolute cell reference Basic Functions o What is the difference between formulas and functions o Insert a function o AutoSum, sum, min, max and average 3. Changing Workbook Appearance Format Cells o Changing Font, Font size and Font Colour o Borders o Bold, Italic and Underline o Fill Colour Themes Format Numbers as percentage, currency and general Insert a Picture Picture Styles, remove background, picture effects Insert Background 4. Printing Inserting Headers and Footers Print Preview Page Setup Page break preview Print active worksheets Print entire workbook Print Selection Print titles Set Print Area Centre data on page
Microsoft Office and Windows Training Course Outline Microsoft Excel Intermediate 1. Performing Calculations 3. Reordering and Summarizing Data 1. 2. 3. 4. 5. Naming groups of Data using Named Ranges Creating Formulas to Calculate Values Summarizing data meets specific condition using If function Formula Auditing o Adding a watch Window o Tracing Formula Errors o Tracing Precedents and Dependent cells 4. Combining Data from Multiple Sources 2. Changing workbook appearance Defining Styles Making Numbers easier to read Transposing data Changing Cell Orientation and Merging Cells Change appearance of data based on its value Focusing on specific data by using filters o Inserting Filters o Sort A to Z using Filters o Number Filters o Clear Filters o Advanced Filtering (Criteria Range) o Summarizing worksheets with hidden and filtered rows (subtotal and aggregate functions) Data Validation Page 9 of 15 Sort Data Custom Lists Organizing data into levels using subtotals Creating an outline Lookup Functions Using Excel’s Built-in Templates Using workbooks as templates for other workbooks Linking to data in other workbooks Consolidating data Saving workbooks as a workspace Comments in cells and workbooks o Viewing Comments in a worksheet o Adding and Removing comments o Adding comments to a workbook Protection o Password protect a worksheet and workbook o Unlock cells and protecting part of a worksheet Track Changes Mark a workbook as final
Microsoft Office and Windows Training Course Outline Microsoft PowerPoint Basic 1. Explore PowerPoint 4. Format Slides Working with the user interface Creating and saving presentations Compatibility with earlier versions Opening, Moving around in, and closing presentations Viewing presentations in different ways Appling themes Using different theme colours and fonts Changing the slide background Changing the look of placeholders Changing the alignment, spacing, size and look of text 2. Working with Slides 5. Add Simple Visual Enhancements Adding and Deleting slides Adding slides with ready-made content Slide Libraries Exporting presentations as outlines Dividing presentations into section Rearranging slides and sections 3. Working with Slide content Entering text into placeholders Adding text boxes Changing the default font for text boxes Editing text Clipboard Correcting and sizing text while typing Checking spelling and choosing the best words Research information Find and Replacing text and fonts Page 10 of 15 Insert Picture and ClipArt images Inserting Diagrams Graphic formats Converting existing bullets into a diagram Inserting charts Inserting shapes Connecting shapes Adding transitions 6. Review and Deliver Presentation Setting up a presentation for delivery Previewing and Printing Presentation Preparing speaker notes and Handouts Enhanced Handouts Finalizing Presentation Setting up presenter view Delivering a presentation
Microsoft Office and Windows Training Course Outline Microsoft PowerPoint Advanced 1. Add tables 6. Share and Review Presentations Inserting tables Formatting tables Inserting and updating excel worksheets 2. Fine Tune Visual Elements Editing pictures Customizing Diagrams Formatting Charts Arranging Graphics Alt Text 7. Create custom Presentation elements 3. Add Other Enhancements Adding WordArt Text Inserting Symbols and Equations Insert Screen Clipping Creating Hyperlinks Attaching the same hyperlink to every slide Attaching actions to text or objects 4. Add Animation Using Ready Made Animation Customizing animation effects Creating theme colours and fonts Viewing and changing slide masters Creating slide layouts Saving custom design templates 8. Prepare for Delivery Adapting presentations for different audiences Rehearsing presentations Recording presentations Preparing presentations for travel Saving presentations as videos 9. Customize PowerPoint 5. Add Sound and Movies Collaborating with other people Broadcasting presentations Saving presentations in other formats Sending presentations directly from PowerPoint Password Protecting Presentations Adding and Reviewing Comments Merging presentations versions Inserting and playing Sounds Inserting and playing Videos Inserting videos from web sites Page 11 of 15 Change default program options Customizing the ribbon Customizing the Quick Access Toolbar
Microsoft Office and Windows Training Course Outline Microsoft Outlook Basic 1. Get started with Outlook Connecting to Email Accounts Connecting to Hotmail account Troubleshooting Connection Problems Connecting to Exchange Accounts Connecting to internet Accounts Single Key Reading Viewing Message Participant Information Presence Icons Contact Cards The People Pane Responding to Messages 4. Store and Access Content information 2. Explore the Outlook Window Working with the Outlook Program Window Outlook Program Window Outlook Modules Working with the Ribbon and Backstage View Backstage View Modules and Item tabs Working in the Mail Module Navigation Pane Content Mail Module Views The Ribbon Message Windows Working in the Calendar Module Calendar Module Content Calendar Item Window Working in the Contacts Module Contacts Module Content Contact Record Window Working in the Tasks Module Task Module Content Task Window 3. Send and Receive E-Mail Messages Creating and Sending Messages Addressing Messages Troubleshooting Message Addressing Entering Content Saving and Sending Messages Attaching Files to Messages Troubleshooting File Types and Extensions Viewing Messages and Message Attachments Viewing Conversations Configuring Reading Pane Behaviour Viewing Reading Pane Content Marking Messages as Read Page 12 of 15 Saving and Updating Contact Information Creating Contact Records Address Books Communication with Contacts Initiating contact information from contact records Selecting message recipients from Address Books Displaying different views of Contact Records User Defined Fields Printing Contact Records 5. Manage Scheduling Scheduling and Changing Appointments Adding National Holidays to Calendar Creating an appointment from a message Scheduling and Changing Events Scheduling Meetings Updating and Cancelling Meetings Responding to Meeting Requests Displaying Different Views of a Calendar Views Arrangements Using the Date Navigator 6. Tracking Tasks Creating Tasks Creating tasks from scratch Task options Creating tasks from Outlook items Updating tasks Removing tasks from the task list Managing Task Assignments Tasks you assign to others Tasks other people assign to you
Microsoft Office and Windows Training Course Outline Displaying Different Views of Tasks Finding and Organizing Tasks Sharing Calendar Information Sharing calendar with co-workers Sharing calendar information outside your organization Printing Calendar Microsoft Outlook Intermediate 1. Organize your Inbox Working with conversation view Split conversation Viewing conversations Conversation view settings Managing conversations Troubleshooting conversation view Arranging Messages in Different ways Marking messages and read and unread Organizing Outlook Items by Colour Categories Recording information using Outlook Notes Organizing Messages into folders Managing messages by using Quick steps Quickly locating messages Using search folders Printing Messages Deleting Messages 2. Managing Your Calendar Defining your available time Configuring time zones Specifying Appointment Time Zones Working with Multiple Calendars Connecting to internet calendars Page 13 of 15 3. Work with your Contact List Creating Additional Address Books Importing and Exporting Contact Records Creating Contact Groups Quickly locating contact information Personalizing electronic business cards 4. Enhance Message Content Personalizing the appearance of Message Text Formatting Message Text Adding signatures to Messages automatically Embedding and Modifying Images Inserting Pictures Inserting ClipArt and Shapes Capturing Screen Images Modifying Images Creating and Formatting Business Graphics Changing Message settings and Delivery options
Microsoft Office and Windows Training Course Outline Microsoft Outlook Advanced 1. Manage Email Settings 3. Customizing Outlook Working with New Email Notifications Creating rules to process messages Blocking Unwanted Messages Working with Junk Email Messages Configuring Junk Email Options Securing Your Email Digital Signatures Encryption Plain Text Messages Information rights management’ Blocking External Contents to Protect Your Privacy 2. Work Remotely Working with outlook items while offline Public Folders Setting Cached Exchange Mode Options Managing Download Options for slow connections Choosing to work offline Managing an Offline address book Automatically replying to messages Page 14 of 15 Personalizing the Outlook environment Creating and Managing Quick Steps Customizing the Ribbon Customizing the Quick Access Toolbar Customizing the Status Bar Personalizing the Office and Outlook Settings Mail Calendar Contacts Tasks Notes and Journal Search Mobile Language Advanced Add-ins Creating Outlook Forms 4. The Notes and Journal folders Notes Creating notes Forwarding Customizing Notes
Microsoft Office and Windows Training Course Outline Internet Basics 1. Internet Introduction How Does the Internet Work? A Tour of a Typical Website To empty the Temporary Internet Files folder (cache) Clear the browsing history To save a webpage onto your computer Bookmarks 2. Browser Basics 4. Searching Using Multiple Windows Using Tabs Using the Search Box Downloading o Saving pictures and files o Using a Download Manager Printing a webpage 5. Internet Safety 3. Internet Explorer Search Engines Finding what you need Useful websites Menu Bar Change your home page To add a new search provider Page 15 of 15 Storing your passwords and login details Allowing and blocking pop-ups InPrivate mode Parental Controls Viruses and Trojans
Microsoft Excel Basic 1. Setting up a workbook Creating Workbooks o Excel Terminology o Excel Environment o Customizing Quick Access Toolbar o Creating a New Workbook o Entering Data into Workbook o oSaving a workbook o Open a workbook o Zoom o Insert a new worksheet o Renaming a new worksheet o 3.Changing the tab colour of worksheet
The Windows The Windows Universe Universe Windows 3.1 Windows for Workgroups Windows 95 Windows 98 Windows 2000 1990 Today Business Consumer Windows Me Windows NT 3.51 Windows NT 4 Windows XP Pro/Home. 8 Windows XP Flavors Windows XP Professional Windows XP Home Windows 2003 Server
AutoCAD 2000 HDI 1.x.x Windows 95, 98, Me Windows NT4 Windows 2000 AutoCAD 2000i HDI 2.x.x Windows 95, 98, Me Windows NT4 Windows 2000 AutoCAD 2002 HDI 3.x.x Windows 98, Me Windows NT4 Windows 2000 Windows XP (with Autodesk update) AutoCAD 2004 HDI 4.x.x Windows NT4 Windows 2000 Windows XP AutoCAD 2005 HDI 5.x.x Windows 2000 Windows XP
Windows 8.1 *6 Windows Server 2003 *7 Windows Server 2008 *8 Windows Server 2012 *9 Mac OS X *10: Supported *1 Printer drivers support both 32-bit and 64-bit Windows. *2 Microsoft Windows XP Professional Edition/Microsoft Windows XP Home Edition *3 Microsoft Windows Vista Ultimate/Microsoft Windows Vista Enterprise/Microsoft Windows Vista Business/
Microsoft Windows 7, 32-bit and 64-bit Microsoft Windows 8 & 8.1, 32-bit and 64-bit Microsoft Windows 10, 32-bit and 64-bit Microsoft Windows Server 2008 R2 Microsoft Windows Server 2012, 64-bit only RAM: Minimum 2 GB for the 32-bit versions of Microsoft Windows 7, Windows 8, Windows 8.1, and Windows 10.
FireEye Network Security specifications, integrated appliance. NX 2500 NX 2550 NX 3500 NX 4500 NX 5500 NX 10450 NX10550 OS Support Microsoft Windows Mac OS X Microsoft Windows Mac OS X Microsoft Windows Mac OS X Microsoft Windows Mac OS X Microsoft Windows Mac OS X Microsoft Windows Microsoft Windows Mac OS X Performance * Up to 50 Mbps or 100
Microsoft Windows Server 2008 R2 SP1 Standard Edition Microsoft Windows Server 2008 R2 SP1 Datacenter Edition Microsoft Windows Server 2012 Family SAS 9.4 Foundation is supported on the following editions of the Windows Server 2012 family with SAS 9.4 TS1M1 and higher: Microsoft Windows Server 2012 Foundation Edition Microsoft Windows Server .
Microsoft Windows XP Home Edition operating system. Windows Vista is an abbreviation for Microsoft Windows Vista Ultimate operating system or Microsoft Windows Vista Business operating system. Windows 7 is an abbreviation for Microsoft Windows 7 Ultimate operating system or Microsoft Windows 7 Enterprise operating system.
A computer with at least a 450MHz Pentium CPU with 128 MB of RAM, running Windows 2000, Windows XP, Windows Server 2003, Windows Vista, Windows Server 2008, Windows 7, Windows 8/8.1, Windows 10, Windows Server 2012, Windows Server 2016 or Windows Server 2019 platforms. Instal
