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.01 Working with Text Boxes
- 4.02 Text Box Behavior
- 4.03 Word Wrap with Text Boxes
- 4.04 Autosize Placeholders
- 4.05 Changing Line Spacing in a Text Box
- 4.06 Replacing Text
- 4.07 Replacing Fonts
- 4.08 AutoCorrect
- 4.09 AutoFit Options
- 4.10 Introduction to the Spell Checker
- 4.11 Changing Case
- 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.03 Changing Shapes
- 7.04 Adding Text to AutoShapes
- 7.05 Adjusting AutoShape Fill and Line Attributes
- 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
-
5
Computer Basics
- 1.01 For the absolute computer beginner (Windows 2003/XP to 10).
-
6
Using the Mouse
- 1.02 The Windows Desktop
- 1.03 The Mouse and its Components
- 1.04 Moving the Mouse and How the Mouse Detects Movement
- 1.05 Making Selections with the Mouse
- 1.06 Right Clicking and Context Menus
- 1.07 The Drag-n-Drop Technique
- 1.08 Double Clicking vs Single Clicking
- 1.09 Double Clicking a Program Icon and Closing a Window
- 1.10 Double Clicking a Picture
-
7
Using the Keyboard
- 1.11 The Keyboard and How it is Laid Out
- 1.12 Locating the Home Row Keys
- 1.13 Typing F and Using Repeat
- 1.14 Typing J
- 1.15 Typing Home Row Keys
- 1.16 Creating Space in Documents with the Spacebar
- 1.17 Alphabetical Keys
- 1.18 The Shift Key
- 1.19 The Caps Lock Key
- 1.20 The Number Keys and Special Characters
- 1.21 Accessing Symbols and Punctuations
- 1.22 Correcting Errors with the Backspace Key
- 1.23 Using the Enter Key in a Word Processor
- 1.24 Using the Tab Key in a Word Processor
- 1.25 How Tab Stops Affect the Tab Key in a Word Processor
- 1.26 Using the Arrow Keys to Move Around in a Document
-
8
Windows Desktop
- 1.27 Desktop Icons Explained
- 1.28 Icons Types and Properties
- 1.29 How Icons Link to Actual Items
- 1.30 Benefits of Program Shortcut Icons
- 1.31 How Computers Store Data
- 1.32 How Computers Organize Data
- 1.33 The Desktop and Changing the Desktop Background
- 1.34 Scrollbars and How they are Used
- 1.35 Scrolling and Paging with Scrollbars
- 1.36 The Windows Taskbar Sections and Properties
- 1.37 The Quick Launch Bar
- 1.38 Moving the Taskbar to a Different Side of the Desktop
- 1.39 Changing the Date and Time Properties
- 1.40 The Start Button and the All Programs Menu
- 1.41 The Most Frequently Used Programs List
- 1.42 The Pinned Items List
- 1.43 Pinning and Unpinning Items
- 1.44 Files and Folders
- 1.45 Standard Windows Menu Structure
-
9
Computer Hardware
- 1.01 Main Uses of a Computer
- 1.02 INPUT
- 1.03 OUTPUT
- 1.04 A Close Look at the Front of the Case
- 1.05 Floppy Disks and CD-ROMs
- 1.06 The Back of the Computer
- 1.07 Hooking Up the Monitor
- 1.08 Connectors that Look Alike
- 1.09 The Sound Card
- 1.10 Connecting Devices to the Sound Card
- 1.11 The Keyboard and Mouse
- 1.12 USB Connector Types and Devices
- 1.13 The Power Supply Unit and its Components
- 1.14 Functions of the Power Supply
- 1.15 Computer Programs and How Computers Use them
- 1.16 The Hard Drive
- 1.17 What is RAM and How is it Used
- 1.18 How RAM Affects Computer Performance
- 1.19 A Closer Look at How Computers Use RAM
- 1.20 The CPU and the Motherboard
- 1.21 CPU Speed and How it is Measured
- 1.22 How the CPU Speed Increases Performance
- 1.23 Keeping the CPU Cool
- 1.24 Understanding the System BIOS
- 1.25 Functions of the BIOS
- 1.26 BIOS Tests and the Boot Process
- 1.27 BIOS Chips and Flashing the BIOS
- 1.28 BIOS and Calculator Comparison
- 1.29 Review of the System BIOS
- 1.30 The Operating System and the Roles it Plays
- 1.31 A Look at Software Compatibility
- 1.32 Computer Shopping Tips for Typical PC Shoppers
- 1.33 Course Review
-
10
Internet
- 1.01 The Internet and How it Began
- 1.02 How the Internet is Used Today
- 1.03 How Computers Communicate Over the Internet
- 1.04 Launching and Closing Internet Explorer
- 1.05 The Internet Explorer Interface and How to Change the Address
- 1.06 Using the Back and Forward Navigation Buttons
- 1.07 How Search Engines Work and How to Use them
- 1.08 The Home Page and How to Change the Default Home Page
- 1.09 Using Favorites and How to Add Site to Your Favorites
- 1.10 Identifying and Clicking Text and Image Links
- 1.11 Configuring Internet Options
- 1.12 Spyware Trojans and Worms
- 1.13 Introduction to Outlook Express and Setting up an Account
- 1.14 Getting Started with Outlook Express
- 1.15 Receiving and Opening Email
- 1.16 Replying to Received Email
- 1.17 Creating and Sending Email
- 1.18 Deleting Email and the Deleted Items Folder
- 1.19 Spams Scams Viruses and Attachments
-
11
Windows Basics (Start from 2003/XP to today)
- 1.01 Course Introduction
- 1.02 Taskbar Windows Commands
- 1.03 Unlocking and Resizing the Taskbar
- 1.04 Adding Toolbars to the Taskbar
- 1.05 Customizing the Start Menu Properties
- 1.06 Customizing the Notification Area
- 1.07 Customizing Your Desktop and Video Settings
- 1.08 Using the Standard Windows Programs
- 1.09 Creating a Grocery List with WordPad and Paint
- 1.10 Installing a Program
- 1.11 Installing a Printer
- 1.12 Multiple Users
- 1.13 Navigating in Windows Explorer
- 1.14 Folder Views
- 1.15 The Tasks Pane
- 1.16 Opening Items with Special Keys
- 1.17 Working With Files and Folders
- 1.18 Creating and Deleting Shortcuts
- 1.19 The Disk Defragmenter Tool
- 1.20 The Disk Cleanup Tool
- 1.21 The Check Disk Tool
- 1.22 Scheduling Tasks
- 1.23 Working with System Restore
- 1.24 Program Compatability Mode
- 1.25 Introduction to the Control Panel
- 1.26 Accessibility Options
- 1.27 Add Hardware and Add Remove Programs
- 1.28 Automatic Updates
- 1.29 Folder Options
- 1.30 Registered File Types
- 1.31 Fonts
- 1.32 Keyboard and Mouse
- 1.33 Phone Modem
- 1.34 Power Options
- 1.35 Sound
- 1.36 System Properties
- 1.37 The Windows Firewall
- 1.38 The Internet and How it Began
- 1.39 How the Internet is Used Today
- 1.40 How Computers Communicate Over the Internet
- 1.41 Launching and Closing Internet Explorer
- 1.42 The Internet Explorer Interface and How to Change the Address
- 1.43 Using the Back and Forward Navigation Buttons
- 1.44 How Search Engines Work and How to Use them
- 1.45 The Home Page and How to Change the Default Home Page
- 1.46 Using Favorites and How to Add Site to Your Favorites
- 1.47 Identifying and Clicking Text and Image Links
- 1.48 Configuring Internet Options
- 1.49 Spyware Trojans and Worms
- 1.50 Introduction to Outlook Express and Setting up an Account
- 1.51 Getting Started with Outlook Express
- 1.52 Receiving and Opening Email
- 1.53 Replying to Received Email
- 1.54 Creating and Sending Email
- 1.55 Deleting Email and the Deleted Items Folder
- 1.56 Spams Scams Viruses and Attachments
-
12
Windows Basic Tips (Start from 2003/XP to today)
- 1.01 Course Introduction
- 1.02 Configuring Outlook Express to Start Automatically
- 1.03 The All Users Folder
- 1.04 Program Grouping
- 1.05 The Windows Registry
- 1.06 Modifying Internet Explorer from the Registry
- 1.07 Modifying the Default Thumbnail Size from the Registry
- 1.08 Modifying Program Tooltips from the Registry
- 1.09 Sorting Start Menu Programs
- 1.10 Safely Removing USB Devices
- 1.11 Password Recovery
- 1.12 Creating Custom Keyboard Shortcut
- 1.13 Customizing the Search Companion
- 1.14 Accessing and Using the Microsoft Narrator
- 1.15 Keyboard Shortcuts with the Window Key
- 1.16 Accessing and Using the On-Screen Keyboard
- 1.17 Special Click and Drag Techniques
- 1.18 Using the Windows Backup Utility to Create a Backup
- 1.19 Using the Windows Backup Utility to Restore a Backup
- 1.20 Monitoring System Performance with Task Manager
- 1.21 Increasing System Performance
- 1.22 Increasing System Performance
- 1.23 Increasing System Performance
- 1.24 Increasing System Performance
- 1.25 Windows XP File Systems
- 1.26 Networking Basics Introduction
- 1.27 Equipment Needed for Networking
- 1.28 Verifying Network Connectivity
- 1.29 Connecting to a Wireless Network
- 1.30 How to Share a Printer on the Network
- 1.31 Sharing Files and Folders on the Network
- 1.32 Networking Tips and Tricks
- 1.33 Upgrading to Windows XP
- 1.34 Checking System Compatibility with Windows Upgrade Advisor
- 1.35 Preparing for the Upgrade to Windows XP
- 1.36 Performing the Upgrade to Windows XP
- 1.37 System Requirements Overview
- 1.38 Meeting Minimum System Requirements
- 1.39 System Requirements for a Word Processor and a 3D Video Game
- 1.40 System Requirements for a CAD Program
- 1.41 System Requirements vs Recommended Configuration
-
13
Windows Vista & 7
- 1.01 Overview and Introductory Look at Vista
- 1.02 Vista Product Line Overview
- 1.03 Logging On and Off
- 1.04 The Welcome Center
- 1.05 Using the Mouse
- 1.06 Orientation to the Desktop
- 1.07 Using The Sidebar
- 1.08 Sidebar Gadgets
- 1.09 Orientation to the Taskbar
- 1.10 Orientation to the Start Menu
- 1.11 Using the Search Box to find Applications
- 1.12 Using the Search Box to Locate Files
- 1.13 Introducing a Typical Window
- 1.14 Minimizing and Maximizing a Window
- 1.15 Moving Windows
- 1.16 Resizing Windows
- 1.17 Running Applications
- 1.18 Selecting Applications from the Taskbar
- 1.19 The Taskbar Grouping Feature
- 1.20 Introduction to Folders
- 1.21 Creating Folders
- 1.22 Creating Files
- 1.23 Organizing Pictures in Folders
- 1.24 Organizing Data in Folders
- 1.25 Renaming Files and Folders
- 1.26 Deleting and Restoring Files and Folders
- 1.27 Moving Files and Folders
- 1.28 Copying Files and Folders
- 2.01 Customizing the Start Menu
- 2.02 Displaying the Run Command
- 2.03 Recently Used Programs List
- 2.04 Turning Off Internet and Email Pinned Items
- 2.05 Pinning Items to the Start Menu
- 2.06 Removing Items From the Start Menu
- 2.07 Resetting Defaults in the Start Menu
- 2.08 Customizing the Desktop
- 2.09 Changing Color and Appearance
- 2.10 Changing the Background
- 2.11 Changing the Screensaver
- 2.12 Changing Sounds
- 2.13 Changing Mouse Pointers
- 2.14 Working with Themes
- 2.15 Changing Display Settings
- 2.16 Customizing the Taskbar
- 2.17 Changing the Date and Time
- 2.18 Creating Desktop Shortcuts
- 2.19 Changing Power Management Options
- 2.20 Adding a Printer
- 2.21 Changing Printer Settings
- 2.22 Adding a User
- 2.23 Changing the Account Image
- 2.24 Creating a Password
- 2.25 Changing a Password
- 2.26 Removing a Password
- 2.27 Removing a User
- 2.28 Adding Gadgets to the Sidebar
- 2.29 Online Gadgets
- 2.30 Configuring Gadgets
- 3.18 Introduction to Word Processing
- 3.19 The Interface
- 3.20 Basic Features
- 3.21 Creating Your First Letter
- 3.22 Enhancing Text with Attributes
- 3.23 Changing Fonts
- 3.24 Adding Images to Your Document
- 3.25 Saving Your Documents
- 3.26 Printing Basics
- 3.27 System Maintenance
- 3.28 The Disk Defragmenter
- 3.29 Disk Cleanup
- 3.30 Creating a System Restore Point
- 3.31 Launching System Restore
-
14
Windows 10*
- Coming Soon.