Tutorials for Beginners

Tutorials for Beginners

02/22/12

Windows XP	Windows 7 (and Vista)

Beginners Guide to Going Wireless	Outlook Express Email

Excel 2007 to 2010 Tutorials Section One - Make a Start with Excel Section Two - A more complex Spreadsheet Section Three - Excel Charts Section Four - Formulas in Excel Section Five - Functions in Excel Section Six - Conditional Logic in Excel Section Seven - Processing Data in Excel Section Eight - Advanced Excel	Microsoft Word 2007 to 2010 Tutorials Section One - Get Started with Microsoft Word Section Two - Document Formatting Section Three - Copy and Paste Section Four - Clip Art Section Five - Multi-Page Documents Section Six - How to Create a Booklet Section Seven - Word Shapes Section Eight - Letterheads and Templates Section Nine - Mail Merge Section Ten - Microsoft Word Tables Section Eleven - Document Collaboration Section Twelve - Word Options

Windows 7 Backup

> Windows XP Tutorials		> Windows 7 (and Vista) Tutorials
	1 The Windows XP Desktop 2 Exploring the Start Menu 3 How to Create a Desktop Shortcut 4 The Hard Drive Explained 5 How Big is your Hard Drive? 6 The Windows Explorer tool 7 How to Create a New Folder 8 Moving Folders on your Hard Drive 9 Copy from a CD to a Hard Drive 10 Finding Files with Windows XP 11 Windows XP and Wallpapers 12 How to change your Screen Saver 13. Zip and Unzip files with WinZip	1 The Windows 7 Desktop 2 Desktop Wallpaper 3 The Taskbar 4 Setting the Date and Time 5 Toolbars 6 The Windows 7 Start Button 7 Share your computer with others 8 Setting Parental Controls in Windows 7 9 hard drives explained 10 The importance of file extensions 11 Copying Pictures to a New Folder 12 Adding Information to an Image 13 Sorting Images 14 How to take a Screenshot in Windows 7

▲ Back to top

> Beginners Guide to Going Wireless
1 The Basics of Going Wireless 2 Wireless Adaptors - you need one! 3 Wireless Routers Explained - all the Jargon! 4 What are wireless signals? 5 Are Wireless Signals Dangerous?	6 Going Wireless - What to Buy 7 Belkin Wireless G+ MIMO Modem Router 8 US Robotics Wireless MAXg 9 Belkin Broadband Wireless Router 10 Buffalo AirStation G54 High Power

▲ Back to top

> Outlook Express Email Tutorials
1 How to Set up a new email Account 2 How to Add Email Attachments 3 How to Backup Emails in Outlook Express 4 How to Restore your Outlook Express Emails 5 Backup an Outlook Express Address Book	6 Backup an Outlook Express Email Account 7 Setup a Second Outlook Express Account 8 Add a Signature to all outgoing Emails 9 Outlook Express Stationary 10 Create your own Stationary

▲ Back to top

> Section One - Make a Start with Excel
1 A first look at Excel 2007/2010 2 Excel Rows and Columns 3 Enter text and numbers in a Cell 4 How to Edit text in a Cell 5 How to Center text and numbers 6 Font Formatting in Excel 2007/2010	7 How to change the color of a Cell 8 How to Save your work in Excel 9 Currency Symbols in Excel 2007/2010 10 How to Merge Cells 11 Review Number One

▲ Back to top

> Section Two - A more complex Spreadsheet
1 Introduction to Section Two 2 How to use AutoFill in Excel 2007/2010 3 Entering Simple Addition Formula 4 The SUM Function in Excel 5 The SUM Function Continued 6 Copy and Paste	7 How to use Paste Special 8 How to Multiply in Excel 2007/2010 9 Finishing your spreadsheet for this section 10 How to Add a Comment to a Cell 11 Review Number Two

▲ Back to top

> Section Three - Excel 2007/2010 Charts
1 How to Sort Data in Excel 2 Create an Excel Chart 3 Move and Resize your Chart 4 Chart Styles and Layouts 5 Chart Titles and Series Titles 6 Chart Layout Panel in Excel 2007/2010	7 The Format Chart Panel 8 Create a Pie Chart in Excel 9 Add Labels to a Pie Chart 10 Format Pie Chart Segments 11 Create a 2D Line Chart in Excel 12 Format your Axis Titles

▲ Back to top

> Section Four - Formulas in Excel 2007/2010
1 The SUM Function 2 How to Multiply in Excel 3 Subtract and Divide	4 Combining the Arithmetic Operators 5 Budget Spreadsheet

▲ Back to top

> Section Five - Functions in Excel 2007/2010
1 The Average Function 2 The Date Function 3 Time Function in Excel	4 A TimeTable Project 5 Financial Functions 6 The Student Average Project

▲ Back to top

> Section Six - Conditional Logic in Excel
1 The IF Function 2 Conditional Formatting in Excel	3 CountIF 4 SumIF

▲ Back to top

> Section Seven - Processing Data in Excel
1 Data Tables in Excel 2 A Second Data Table 3 Excel Scenarios 4 Goal Seek	5 Absolute Cell References 6 Named Ranges in Excel 7 Excel Pivot Tables 8 Pivot Tables, Part Two

▲ Back to top

> Section Eight - Advanced Excel
1 Data Forms in Excel 2 Drop Down Lists in Excel 3 Add your own Error Messages 4 Excel and Web Integration	5 Hyperlinks in Excel 6 Object Linking and Embedding 7 Reference other Worksheets 8 Insert Drawing Objects

▲ Back to top

> Section One - Get Started with Microsoft Word
1 How to Open Microsoft Word 2 Finding Your Way Around 3 Typing Your First Letter 4 How to Save Your Work	5 Highlighting Techniques 6 Opening Word Documents 7 Add an Address To A Letter 8 Spelling and Grammar Checking

▲ Back to top

> Section Two - Document Formatting
1 Crime Statistics Document 2 Bold Text 3 Italics and Underline 4 Setting Tab Stop Positions	5 Creating Bulleted Lists 6 Working With Fonts 7 Setting Up Page Margins

▲ Back to top

> Section Three - Copy and Paste
1 Techniques for Cutting Text 2 Cut and Paste Techniques	3 Copy and Paste Techniques

▲ Back to top

> Section Four - Clip Art
1 Inserting Clip Art	2 How to Resize and Move Clip Art

▲ Back to top

> Section Five - Multi-Page Documents
1 Downloading a Text File 2 Setting Up Page Margins and Tab Stops 3 How to Insert a Text File	4 Setting Up Headers and Footers 5 Print Preview in Word 2007 and 2010

▲ Back to top

> Section Six - How to Create a Booklet
1 Downloading the Stories 2 Creating Your Own Word Style 3 Page Breaks and Section Breaks 4 Adding a Cover Page	5 Adding a Contents Page 6 Working With Section Breaks 7 Headers And Section Breaks

▲ Back to top

> Section Seven - Word Shapes
1 Word Shapes - Create a Logo 2 Logo Continued	3 Word Art 4 Completing The Logo

▲ Back to top

> Section Eight - Letterheads and Templates
1 Create a Letterhead 2 Adding Columns to a Page	3 Saving Word Documents as a Template

▲ Back to top

> Section Nine - Mail Merge
1 Create a Mail Merge Data Source	2 Create a Mail Merge Letter

▲ Back to top

> Section Ten - Microsoft Word Tables
1 Tables in Microsoft Word	2 Table Styles

▲ Back to top

> Section Eleven - Document Collaboration
1 Document Collaboration	2 Accepting and Rejecting Changes

▲ Back to top

> Section Twelve - Word Options
1 Displaying The Word Options 2 Changing The Language Settings 3 Proofing Options	4 Advanced Options 5 The Quick Access Toolbar 6 Keyboard Shortcuts

▲ Back to top

This site was last updated 02/22/12