Trainsignal-Microsoft Office 2010 Training Package
Course Outline
Excel 2010 Training - Course Outline
- Lesson 1 - Introduction to Excel 2010 Training
- Lesson 2 - Entering Data
- Lesson 3 - Moving Data
- Lesson 4 - Rows & Columns
- Lesson 5 - Auto Fill
- Lesson 6 - Worksheets
- Lesson 7 - Saving a File
- Lesson 8 - The Interface
- Lesson 9 - Number Formatting
- Lesson 10 - Formatting Fonts
- Lesson 11 - Alignment
- Lesson 12 - Conditional Formatting
- Lesson 13 - Page Layout
- Lesson 14 - Printing Worksheets
- Lesson 15 - Introduction to Formulas
- Lesson 16 - Total Values Simply
- Lesson 17 - Relative, Absolute, & Named References
- Lesson 18 - Logical Functions
- Lesson 19 - Lookup Functions
- Lesson 20 - Combine and Separate Text
- Lesson 21 - View Separate Data Simultaneously
- Lesson 22 - Sorting
- Lesson 23 - Filtering
- Lesson 24 - Define Data as a Table
- Lesson 25 - Introduction to Charts
- Lesson 26 - Create a Column Chart
- Lesson 27 - Create a Line Chart
- Lesson 28 - Create a Pie Chart
- Lesson 29 - Using Sparklines
- Lesson 30 - Introduction to PivotTables
- Lesson 31 - Creating a PivotTable
- Lesson 32 - More Fun With PivotTables
- Lesson 33 - Create a PivotChart
- Lesson 34 - Next Steps
Access 2010 Training - Course Outline
- Lesson 01 - Getting Started with Access 2010 Training
- Lesson 02 - Lab Setup
- Lesson 03 - Introduction to Databases and Normalization
- Lesson 04 - Overview of Microsoft Access 2010 Objects
- Lesson 05 - Tour of Microsoft Access 2010
- Lesson 06 - Understanding Object Views
- Lesson 07 - Navigating Microsoft Access 2010 Database Objects
- Lesson 08 - Creating Simple Forms
- Lesson 09 - Form Formatting Basics
- Lesson 10 - Introduction to Queries
- Lesson 11 - Finding Specific Data Using Criteria, Operators, and Wildcards
- Lesson 12 - Creating Parameter Queries
- Lesson 13 - Understanding Joins
- Lesson 14 - Creating Calculated Expressions
- Lesson 15 - Summarizing Data
- Lesson 16 - Introduction to Built-in Functions
- Lesson 17 - Advanced Functions
- Lesson 18 - Creating PivotTables
- Lesson 19 - Creating PivotCharts
- Lesson 20 - Creating Reports
- Lesson 21 - Basic Report Formatting
- Lesson 22 - Advanced Report Formatting
- Lesson 23 - Printing and Exporting Reports
- Lesson 24 - Next Steps
Section 1: Getting Started with Outlook 2010
- Lesson 1 - Getting Started with Outlook 2010 Training
- Lesson 2 - The Outlook 2010 Interface and Views
- Lesson 3 - Customizing the Outlook 2010 Interface and Views
Section 2: Working with Email Messages
- Lesson 4 - Outlook 2010 Custom Signatures
- Lesson 5 - Reading and Sending Email Messages
- Lesson 6 - Reviewing, Replying and Forwarding Messages
- Lesson 7 - Proofing and Reviewing Messages
- Lesson 8 - Working with the Inbox
- Lesson 9 - Printing Messages
- Lesson 10 - Dealing with Junk Email
Section 3: Subscribing and Maintaining RSS Feeds in Outlook 2010
- Lesson 11 - Subscribing to RSS Feeds
- Lesson 12 - Customizing RSS Feeds
Section 4: Techniques for Dealing with Large Amounts of Email
- Lesson 13 - Cleaning Up and Deleting Email Messages
- Lesson 14 - Creating Structure with Folders
- Lesson 15 - Letting Outlook Automatically Handle Email
- Lesson 16 - Using Categories to Color Code Your Outlook 2010 Objects
Section 5: Working with Contacts
- Lesson 17 - Organizing People and Contacts
- Lesson 18 - Using the Address Book
Section 6: Getting Organized with Outlook Calendars
- Lesson 19 - Viewing the Outlook 2010 Calendar
- Lesson 20 - Creating Appointments
- Lesson 21 - Scheduling a Meeting
- Lesson 22 - Replying to a Meeting Request
- Lesson 23 - Updating a Meeting Request
- Lesson 24 - Creating New Calendars
- Lesson 25 - Printing a Calendar
- Lesson 26 - Sharing a Calendar
Section 7: Maintaining a To-Do List with Outlook Tasks
- Lesson 27 - Creating Tasks in Outlook 2010
- Lesson 28 - Assigning Tasks
- Lesson 29 - Working with Flags in Outlook 2010
Section 8: Locating and Archiving Important Outlook Items
- Lesson 30 - Filtering Messages in Outlook 2010
- Lesson 31 - Expanded Search Capabilities in Outlook 2010
- Lesson 32 - Working with Search Tools
- Lesson 33 - Archiving and Saving Messages
Section 9: Keeping Track of Your Day with Outlook 2010 Journals
- Lesson 34 - Working with Outlook 2010 Journal Entries
Section 10: Next Steps
- Lesson 35 - Next Steps
Section 1: Word 2010 Basics
- Lesson 1 - Getting Started with Word 2010 Training
- Lesson 2 - Working With Documents
- Lesson 3 - Moving Text
- Lesson 4 - Basic Formatting
- Lesson 5 - More Text Formatting
- Lesson 6 - Using Find & Replace
- Lesson 7 - Saving a File
Section 2: The Interface
- Lesson 8 - The Ribbon Interface
Section 3: Paragraphs
- Lesson 9 - Aligning Paragraphs
- Lesson 10 - Setting & Using Tabs
- Lesson 11 - Paragraph Indents
- Lesson 12 - Create Numbered, Bulleted, and Multilevel Lists
- Lesson 13 - Line and Paragraph Spacing
Section 4: Tables and Charts
- Lesson 14 - Create a Table
- Lesson 15 - Table Layouts
- Lesson 16 - Formatting a Table
- Lesson 17 - Convert Text to Tables
- Lesson 18 - Sorting Tables and Lists
- Lesson 19 - Create a Chart
- Lesson 20 - Adjust Chart Layouts
- Lesson 21 - Chart Formatting
Section 5: Illustrations
- Lesson 22 - Adding Images
- Lesson 23 - Resize and Crop Images
- Lesson 24 - Image Styles
- Lesson 25 - Adjusting Images
- Lesson 26 - Inserting and Working with Shapes
- Lesson 27 - Create SmartArt
- Lesson 28 - Arrange Your Illustrations
Section 6: Styles
- Lesson 29 - Using Styles
- Lesson 30 - Create New Styles
Section 7: Page Layout
- Lesson 31 - Setting Page Margins
- Lesson 32 - Controlling Page Layout
- Lesson 33 - Create a Document Outline
Section 8: Templates
- Lesson 34 - Using Sample Word Templates
- Lesson 35 - Download and Use Templates from Office.com
- Lesson 36 - Create a Template
Section 9: Mailings
- Lesson 37 - Mail Merge
- Lesson 38 - Create Envelopes and Labels Using Mail Merge
Section 10: Tracking Changes
- Lesson 39 - Using Revision Tracking
- Lesson 40 - Compare and Combine Documents
Section 11: Multi-Page Documents
- Lesson 41 - Create and Use Bookmarks
- Lesson 42 - Footnotes and Endnotes
- Lesson 43 - Insert Captions
- Lesson 44 - Insert and Use Cross References
- Lesson 45 - Create a Watermark
- Lesson 46 - Create Hyperlinks
- Lesson 47 - Inserting a Text Box
- Lesson 48 - Add a Cover Page
- Lesson 49 - Create a Table of Contents
- Lesson 50 - Create an Index
Section 12: Proofing
- Lesson 51 - Spelling and Grammar Check
- Lesson 52 - Using AutoCorrect
Section 13: Printing
- Lesson 53 - Using AutoText and Quick Parts
- Lesson 54 - Adding Headers and Footers
- Lesson 55 - Printing Options
Section 14: Next Steps
- Lesson 56 - Next Steps
SECTION 01 - GETTING STARTED WITH POWERPOINT 2010 TRAINING
- Lesson 1 - Getting Started with PowerPoint 2010 Training
SECTION 02 – NEW AND ENHANCED POWERPOINT 2010 FEATURES
- Lesson 2 - Overview of New and Enhanced Features
- Lesson 3 - Deprecated Features
SECTION 03 – THE MICROSOFT POWERPOINT 2010 INTERFACE
- Lesson 4 - Finding Commands Quickly with the Quick Access Toolbar
- Lesson 5 - Finding Commands Using the Ribbon
- Lesson 6 - Switching Between Presentation Views
- Lesson 7 - Navigating and Editing Slides with the Slides/Outline Pane
- Lesson 8 - Switching to Master Views
- Lesson 9 - Working with PowerPoint Files Through the Backstage View
SECTION 04 – MICROSOFT POWERPOINT 2010 BASICS
- Lesson 10 - Tour of the PowerPoint Blank Template
- Lesson 11 - Adding New Slides and Sections
- Lesson 12 - Adding and Formatting Text
- Lesson 13 - Copying and Pasting
- Lesson 14 - Creating a Presentation from a Template
SECTION 05 - FORMATTING SLIDES
- Lesson 15 - Applying a Theme
- Lesson 16 - Customizing Slide Backgrounds
- Lesson 17 - Adjusting Page Orientation and Size
SECTION 06 – TEXT AND TEXT BOXES
- Lesson 18 - Bullet and Number Lists
- Lesson 19 - Adding a Text Box
- Lesson 20 - Adjusting Text Layout
- Lesson 21 - AutoFit Options
- Lesson 22 - Inserting Symbols
- Lesson 23 - Creating WordArt
SECTION 07 - SHAPES
- Lesson 24 - Creating Basic Shapes
- Lesson 25 - Formatting Shapes
- Lesson 26 - Creating 3-D Shapes
- Lesson 27 - Creating a Custom Shape
- Lesson 28 - Combining Shapes
- Lesson 29 - Editing Points
SECTION 08 - LAYERING, GROUPING, AND POSITIONING OBJECTS
- Lesson 30 - Reordering Layers with the Selection and Visibility Pane
- Lesson 31 - Reordering Objects
- Lesson 32 - Positioning Objects on a Slide
- Lesson 33 - Grouping Shapes and Objects
- Lesson 34 - Using Grids and Guides to Position Objects
SECTION 09 - TABLES AND SPREADSHEETS
- Lesson 35 - Inserting a Table
- Lesson 36 - Formatting a Table
- Lesson 37 - Adding Data to a Table
- Lesson 38 - Copying an Excel Table into PowerPoint
- Lesson 39 - Creating an Excel Spreadsheet in PowerPoint
SECTION 10 - CHARTS
- Lesson 40 - Creating a Chart
- Lesson 41 - Editing Chart Data
- Lesson 42 - Changing the Chart Layout
- Lesson 43 - Applying Chart Styles
- Lesson 44 - Customizing Charts
- Lesson 45 - Animating Charts
- Lesson 46 - Adding a Chart Trendline
SECTION 11 - SMARTART
- Lesson 47 - Creating a SmartArt Graphic
- Lesson 48 - Adding Text and Images to a SmartArt Graphic
- Lesson 49 - Adding or Deleting SmartArt Shapes
- Lesson 50 - Formatting SmartArt
- Lesson 51 - Animating SmartArt
- Lesson 52 - Converting a Slide to SmartArt
- Lesson 53 - Converting a SmartArt Graphic to Shapes
- Lesson 54 - Saving SmartArt as a Picture
SECTION 12 - IMAGES
- Lesson 55 - Inserting Pictures, Clip Art, and Screen Shots
- Lesson 56 - Creating a Photo Album
- Lesson 57 - Resizing, Scaling and Rotating Pictures
- Lesson 58 - Cropping Pictures
- Lesson 59 - Adjusting and Editing Pictures
- Lesson 60 - Removing Picture Backgrounds
- Lesson 61 - Applying Picture Effects
- Lesson 62 - Compressing Picture Size
SECTION 13 - ADDING SOUND
- Lesson 63 - Inserting Clip Art Audio
- Lesson 64 - Inserting Audio from Your Computer
- Lesson 65 - Recording Your Own Audio
- Lesson 66 - Playing and Pausing Audio
- Lesson 67 - Adding and Removing Audio Bookmarks
- Lesson 68 - Trimming Audio
- Lesson 69 - Fading Audio
- Lesson 70 - Adjusting Volume
- Lesson 71 - Controlling When and How Audio Plays
- Lesson 72 - Looping Audio
- Lesson 73 - Audio Bookmarks and Triggers
- Lesson 74 - Recording Your Own Audio Narration
SECTION 14 - ADDING VIDEO CLIPS
- Lesson 75 - Inserting Video
- Lesson 76 - Cropping Video
- Lesson 77 - Formatting Video
- Lesson 78 - Trimming Video
- Lesson 79 - Setting the Poster Frame
- Lesson 80 - Compressing Video
- Lesson 81 - Video Bookmarks and Triggers
SECTION 15 - INSERTING OBJECTS
- Lesson 82 - Introduction to Object Linking and Embedding
- Lesson 83 - Embedding and Linking Files
SECTION 16 - TRANSITIONS
- Lesson 84 - Adding Slide Transitions
- Lesson 85 - Adjusting Transition Timing
- Lesson 86 - Previewing Transitions
SECTION 17 - ANIMATIONS
- Lesson 87 - Creating Animations
- Lesson 88 - Modifying an Animation
- Lesson 89 - Reordering Animations
- Lesson 90 - Saving Time with the Animation Painter
- Lesson 91 - Displaying the Advanced Animation Timeline
- Lesson 92 - Advanced Animations
- Lesson 93 - Triggering Animations
SECTION 18 - SETTING UP YOUR SLIDE SHOW
- Lesson 94 - Rehearsing Your Slide Show Presentation
- Lesson 95 - Creating a Custom Show
- Lesson 96 - Adjusting Slide Show Options
- Lesson 97 - Presentation Keyboard Shortcuts
SECTION 19 - PREPARING HANDOUTS AND OTHER PRESENTATION MATERIALS
- Lesson 98 - Preparing Speaker Notes
- Lesson 99 - Preparing Audience Handouts
- Lesson 100 - Advanced Printing Options
- Lesson 101 - Exporting to Microsoft Word
SECTION 20 - SHARING PRESENTATIONS WITH OTHERS
- Lesson 102 - Sending a PowerPoint Presentation via Email
- Lesson 103 - Saving a PowerPoint File to the Web
- Lesson 104 - Creating a PDF
- Lesson 105 - Creating a Video
- Lesson 106 - Broadcasting a Slide Show over the Internet
- Lesson 107 - Packaging a Presentation for a CD
SECTION 21 - CREATING CUSTOM TEMPLATES
- Lesson 108 - Introduction to Templates
- Lesson 109 - Creating Template Masters
- Lesson 110 - Saving a Presentation as a Template
SECTION 22 - NEXT STEPS
- Lesson 111 - Next Steps
-
-
- View More at trainsignal.com
