Course curriculum

  • 1
    Word for Beginners
    • 1.01 Introduction to Word - Master
    • 2.01 Typing Basics
    • 2.02 Selecting Text
    • 2.03 Saving Documents
    • 3.01 Using the Backspace Key
    • 3.02 Word Wrap
    • 3.03 The Delete Key
    • 3.04 Applying Text Attributes
    • 3.05 Removing Text Attributes
    • 3.06 The Spell Checker
    • 3.07 Introduction to the Grammar Checker
    • 3.08 Save Frequently
    • 4.01 Opening a File
    • 4.02 Recently Opened Files
    • 4.03 Copy and Paste
    • 4.04 Cut and Paste
    • 4.05 Pasting Pictures
    • 4.06 Fonts
    • 4.07 Font Size
    • 4.08 Text Alignment
    • 5.01 Views
    • 5.02 Zooming
    • 5.03 Margins
    • 5.04 Line Spacing
    • 5.05 First Line Indent
    • 5.06 Hanging Indent
    • 5.07 Paragraph Alignment
    • 6.01 Introduction to Numbering
    • 6.02 Bullets
    • 6.03 Turning Bullets and Numbering Off and On
    • 6.04 Print Preview
    • 6.05 Page Orientation
    • 6.06 Print Options
    • 7.01 Creating a Table
    • 7.02 Moving Around in a Table
    • 7.03 Entering Text and Numbers
    • 7.04 Selecting a Row
    • 7.05 Selecting a Column
    • 7.06 Adding Rows to the End of a Table
    • 7.07 Deleting Rows
    • 7.08 Deleting Multiple Rows
    • 7.09 Adding Columns
    • 7.10 Deleting a Column
    • 7.11 Using the Tab Key in a Table
    • 7.12 Aligning Text in Cells
    • 7.13 Resizing Columns
    • 7.14 Working With Page Breaks
    • 7.15 Table Autoformat
    • 8.01 Types of Mail Merge Documents
    • 8.02 Creating a Mail Merge Document
    • 9.01 Inserting Clipart
    • 9.02 Inserting Photographs
    • 9.03 Insert Photo from File
    • 9.04 Resizing Images
    • 9.05 Brightness and Contrast
    • 9.06 The Crop Tool
    • 9.07 Text Wrap
    • 10.01 Inserting the Date and Time
    • 10.02 Inserting Page Numbers
    • 10.03 Headers and Footers
    • 10.04 Adding a Header
    • 10.05 Word Count
    • 10.06 Introduction to Macros
    • 10.07 Control Arrow
    • 10.08 Control Home and End
    • 10.09 The Shift Key
    • 10.10 Autocorrect
    • 10.11 Autocorrect Options
  • 2
    Excel for Beginners
    • 1.01 Course Introduction
    • 1.02 What Is A Spreadsheet
    • 1.03 Columns And Rows
    • 1.04 Entering Data
    • 2.01 Section Introduction
    • 2.02 The Excel Window
    • 2.03 Moving Around In Cells
    • 2.04 The Task Pane
    • 2.05 Toolbars
    • 2.06 Customizing Toolbars
    • 2.07 The Excel Menu
    • 2.08 Saving A File
    • 2.09 Opening Files
    • 2.10 Creating A New Workbook
    • 2.11 Using the Mouse
    • 2.12 Keyboard Basics
    • 2.13 Section Conclusion
    • 3.01 Section Introduction
    • 3.02 Selecting Cells
    • 3.03 Entering Data Into Cells
    • 3.04 Moving Cells
    • 3.05 Deleting Values and Cells
    • 3.06 Formatting Numbers as Text
    • 3.07 Section Conclusion
    • 4.01 Section Introduction
    • 4.02 Changing Fonts
    • 4.03 Changing Cell Size
    • 4.04 Justifying Text
    • 4.05 Text Attributes
    • 4.06 Auto Sizing
    • 4.07 Column Width
    • 4.08 Worksheets
    • 4.09 Changing The Enter Key Behavior
    • 4.10 Intro To The AutoSum Function
    • 4.11 Automatic Calculation
    • 4.12 Formatting Numbers
    • 4.13 More Formatting
    • 4.14 Special Formatting Options
    • 4.15 Using Formatting
    • 4.16 Deleting Cells
    • 4.17 Inserting Rows And Columns
    • 4.18 Creating Borders
    • 4.19 Border Styles
    • 4.20 Merge And Center
    • 4.21 Adding Background Color
    • 4.22 Intro To AutoFormat
    • 4.23 Intro To Conditional Formatting
    • 4.24 Session Conclusion
    • 5.01 Section Introduction
    • 5.02 Reference Operators
    • 5.03 Range Reference Part I
    • 5.04 Range Reference Part II
    • 5.05 Range Reference Part III
    • 5.06 Union Reference Part I
    • 5.07 Union Reference Part II
    • 5.08 Mixing Range and Union Reference Part I
    • 5.09 Mixing Range and Union Reference Part II
    • 5.10 Mixing Range and Union Reference Part III
    • 5.11 Mixing Range and Union Reference Part IV
    • 5.12 Introduction to Formulas
    • 5.13 Introduction to Funtions
    • 5.14 More On Formulas and Functions
    • 5.15 Using Formulas
    • 5.16 More On Functions
    • 5.17 Operator Precedence Part I
    • 5.18 Operator Precedence Part II
    • 5.19 Exercises In Formulas Functions And Precedence Part I
    • 5.20 Exercises With Formulas Functions And Precedence Part II
    • 5.21 Exercises With Formulas Functions and Precedence Part III
    • 5.22 Cell Referencing Part I
    • 5.23 Cell Referencing Part II
    • 5.24 Cell Referencing Part III
    • 5.25 Cell Referencing Part IV
    • 5.26 Cell Referencing Part V
    • 5.27 Cell Referencing Part VI
    • 5.28 Cell Referencing Part VII
    • 5.29 Cell Referencing Part VIII
    • 5.30 Cell Referencing Part VIII Supplement
    • 5.31 Mixed Mode References
    • 5.32 Mixed Mode Examples
    • 5.33 Using Mixed Mode
    • 5.34 Why Mixed Mode Works
    • 5.35 Using Mixed Mode and Fill
    • 5.36 Mixed Mode Loan Table
    • 5.37 Cell Referencing Exercises
    • 5.38 Section Conclusion
    • 6.01 Section Introduction
    • 6.02 Introduction to the SUM Function
    • 6.03 More on the SUM Function
    • 6.04 Using the SUM Function
    • 6.05 Selecting Cells with the Keyboard Part I
    • 6.06 Selecting Cells with the Keyboard Part II
    • 6.07 Selecting Cells with the Mouse
    • 6.08 Selecting Cells with Keyboard and Mouse
    • 6.09 Using The Fill Handle
    • 6.10 Filling Right
    • 6.11 Filling
    • 6.12 Fill Overwrite
    • 6.13 Using Fill with Formulas
    • 6.14 Auto Function Introduction
    • 6.15 Using The AutoSum Function
    • 6.16 The Average Function
    • 6.17 The Count Function
    • 6.18 The Max Function
    • 6.19 The Min Function
    • 6.20 Comparison Operators
    • 6.21 Using Comparison Operators
    • 6.22 The IF Function
    • 6.23 How The IF Function Works
    • 6.24 Advanced IF Topics
    • 6.25 Section Conclusion
    • 7.01 Introduction to PivotTables and Reporting
    • 7.02 Large Amounts of Data Filtered
    • 7.03 PivotTable Options
    • 7.04 PivotTable Theory
    • 7.05 PivotTable Customization
    • 7.06 More PivotTable Customization
    • 7.07 Introduction to Charts
    • 7.08 Chart Creation
    • 7.09 Other Chart Types
    • 7.10 Chart Options
    • 7.11 More Chart Options
    • 7.12 Step 4 of the Chart Wizard
    • 7.13 Modifying Charts
    • 7.14 Customizing Chart Options
    • 7.15 Charts are Dynamic
    • 7.16 Section Conclusion
    • 8.01 Freezing Panes
    • 8.02 Closing All Open Workbooks
    • 8.03 Opening a Workspace
    • 8.04 Using Constants
    • 8.05 Selection Calculation
    • 8.06 Smart Fill
  • 3
    PowerPoint for Beginners
    • 1.01 Starting PowerPoint
    • 1.02 PowerPoint Interface
    • 1.03 Creating a Shortcut
    • 1.04 Blank Presentation
    • 1.05 Turning the Task Pane Off and On
    • 1.06 Expanding Menus
    • 1.07 Opening and Closing a Presentation
    • 1.08 Saving a New Presentation
    • 1.09 Navigating the Save As Dialog
    • 1.10 PowerPoint Views
    • 1.11 Creating a New Presentation
    • 1.12 AutoContent Wizard
    • 1.13 Design Template
    • 2.01 Text Placeholders
    • 2.02 Working with the Outline
    • 2.03 More on Outlines
    • 2.04 Saving Your Presentation
    • 2.05 Slide Layout
    • 2.06 The Slide Sorter
    • 2.07 Notes and Notes Page View
    • 3.01 Working With Outlines
    • 3.02 The Zoom Box
    • 3.03 Show Formatting
    • 3.04 Editing in Outline View
    • 3.05 Rearranging Items in an Outline
    • 3.06 Formatting Text
    • 4.02 Text Box Behavior
    • 4.03 Word Wrap with Text Boxes
    • 4.04 Autosize Placeholders
    • 4.01 Working with Text Boxes
    • 4.05 Changing Line Spacing in a Text Box
    • 4.06 Replacing Text
    • 4.07 Replacing Fonts
    • 4.09 AutoFit Options
    • 4.10 Introduction to the Spell Checker
    • 4.11 Changing Case
    • 4.08 AutoCorrect
    • 4.12 The Thesaurus
    • 5.01 Applying a Design Template
    • 5.02 Working With Master Slides
    • 5.03 Formatting Text and Bullets on a Master Slide
    • 5.04 Saving a Design Template
    • 6.01 Changing Color Schemes
    • 6.02 Choosing Colors Outside of the Color Scheme
    • 6.03 Creating a Custom Color Scheme
    • 6.04 Background Attributes
    • 7.01 Working with AutoShapes
    • 7.02 Copying and Pasting AutoShapes
    • 7.04 Adding Text to AutoShapes
    • 7.05 Adjusting AutoShape Fill and Line Attributes
    • 7.03 Changing Shapes
    • 7.06 Adding a Shadow to an AutoShape
    • 7.07 The Format Painter
    • 7.08 Guides and Grids
    • 7.09 Connectors
    • 7.10 Changing Connectors
    • 7.11 Moving Connected Objects
    • 7.12 Object Order and Grouping
    • 8.01 Adding Clipart
    • 8.02 Resizing and Recoloring Graphics
    • 8.03 Adding Pictures
    • 8.04 Cropping Images
    • 8.05 Enhancing and Compressing Pictures
    • 8.06 Adding WordArt
    • 9.01 Working with Tables
    • 9.02 Working with Charts
    • 9.03 Organizational Charts
    • 10.01 Introduction to Animation
    • 10.02 Modifying Animations
    • 10.03 Slide Transitions
    • 10.04 Adding Sound and Movies
    • 10.05 Adding a Sound Object
    • 10.06 Reordering Custom Animations
    • 10.07 Editing Sound Objects
    • 11.01 Headers and Footers
    • 11.02 Print Preview
    • 11.03 Printing Options
    • 12.01 Packaging for a CD
    • 12.02 Navigating and Slideshow Tools
    • 12.03 Hiding Slides and Creating Action Buttons
    • 12.04 Timing Slides and Rehearsing
    • 12.05 Self-Running Presentations
    • 13.01 Creating a Summary Slide
    • 13.02 Hyperlinks
    • 13.03 Publishing for the Web
  • 4
    Outlook for Beginners
    • 1.01 Getting Started
    • 1.02 Setting up an Account
    • 1.03 The Outlook Interface
    • 1.04 Introduction to Attachments
    • 1.05 Moving and Hiding the Reading Pane
    • 1.06 Replying to a Message
    • 1.07 Deleting Messages
    • 1.08 Creating a New Message
    • 1.09 Inserting a Table into a Message
    • 1.10 The Address Book
    • 1.11 Distribution Lists
    • 1.12 Attaching a File to an Email
    • 1.13 Automatic Send Receive
    • 1.14 Multiple Email Accounts
    • 1.15 Printing Messages
    • 2.01 Message Format Types
    • 2.02 Stationary and Formatting Options
    • 2.03 Message Importance
    • 2.04 Sorting Messages
    • 2.05 Views
    • 2.06 Organizing By Color
    • 2.07 Signatures
    • 2.08 Flagging Messages
    • 3.01 Organizing with Categories
    • 3.02 Search Folders
    • 3.03 Filtering Messages
    • 3.04 Rules
    • 3.05 Folders
    • 4.01 Introduction to Calendar
    • 4.02 Appointments and Recurrence
    • 4.03 All Day Events
    • 4.04 Entering and Changing Appointments
    • 4.05 Multiple Calendars
    • 4.06 Work Times
    • 4.07 Multiple Time Zones
    • 4.08 Calendar Coloring
    • 4.09 Printing Calendars