Handouts  / Pod Casts / Video / Code / Microsoft Test Info for 2007, 2010, and 2013 Office  & SharePoint

  New Handouts added often! (Last updated:  3-21-14)

 

OFFICE 2003 Handouts

 

      Word 2003 Handouts

 

      Access 2003 Handouts

        2003 FILES

       Excel 2003 Handouts

      PowerPoint 2003 Handouts

      Outlook 2003 Handouts

 

Office 2003 Files

 ALL - Code Files 

 
 
     OFFICE 2007 and SharePoint 2007 Handouts
     
      Word 2007 Handouts

   Excel 2007 Handouts

     PowerPoint 2007 Handouts

          NEW


      SharePoint 2007 Handouts

          NEW

SharePoint 2007 Book & Files


 

      Outlook 2007 Handouts


      General Handouts

 

      NEW

   Excel Coding

Cash Flow Management

   Files for these exercises (below)

  Amortization I - Intro

  Amortization III - Straight Line

  Amortization V - Double Declining Bal Dep

 

   ECU Project:  Excel Resources

(This is an ECU project site I have placed on the ECU server for an assignment, however, you may find some useful Excel information here)  This site should remain current through September 1, 2013...after which if it is useful I will place on my own server.

 

Video Conversion

http://www.onlinevideoconverter.com

OVC for URLs only

 

http://www.zamzar.com

Note: 

ZamZar for uploads and URLs

but...no YouTube videos allowed

      POWERPOINT MACRO EXAMPLES

SITES WITH CODE TO TRY for ADVANCED USERS to practice

 (code involved)

Tired of Just PowerPoint?

Try ~

- Recording Smart Screen actions, or Prezi, Capzles, Zoom, QWiki, Video, SchoolTube, TeacherTube, Viddler, Vimeo, Flickr, DropEvent, ZangZing, Animoto, StupeFlix, xtranormal, yola, Weebly, Screencast and Capture, Jing, Screencast-o-matic, CampusBug, WallWisher, Wiggio, Stixy, GoogldDrive, WikiSpaces, Glogster, Wordpress, EduPress, Skype, Audacity, and so many more are worth the research and trial...


      Access 2007 Handouts

          NEW

 

2007 FILES  Office 2007 files  -  Access Project Files Zipped - Outlook 2007 Files 
   

TODAY'S HIGHLIGHT: FREE TRAINING (Academic)

FREE online courses are taught by regular college faculty from places like Stanford and some of the top Universities, and are highly interactive. Enrollees do not get that particular university credit for their work, but they do receive a statement of accomplishment if they successfully complete a course. The classes are delivered on a number of different platforms. THIS is a wonderful opportunity for those who want to learn more on a diverse number of subjects and did I mention it's FREE?

Visit COURSERA.ORG

Another Free Course Site:

Education-Portal (for Academic studies)

     
 

 Office 2010 & SharePoint 2010 Handouts & Video Training

   To download the files

  • Right click on the desired file name below
  • Choose Save Target As from the menu that appears
  • Save them to your desktop or other convenient location
  • Right click on the file once downloaded and choose Extract Here to install.

   Note:  You will need the WINRAR program to extract them.  Get that program here for free.

 

  Office 2010

  ALL 2010 STUDENT FILES

 

Office 2010 Student Access Files

Office 2010 Student Excel Files

Office 2010 Word Files

Office 2010 PowerPoint Files

 

Note: VIDEO FOR POWERPOINT

          (Right-mouse video and choose,

           Save Target as from the menu

 

          Wildlife

          Dolphins

          Military Fire

 

SharePoint 2010 Files

 

 

2010 Office Exam Prep Information

 

 

Outlook 2010 Handouts

 10 Things to Know About Outlook 2010

 Outlook 2010 Enhancements

 80 Outlook Keyboard Shortcuts - NEW!

 Create a Group Contact List - New!

 Calendar Groups - Sharing Calendars - New!

 Conditional Format Email (Color Code) New!

 Share Folders - New!

 Export Excel to Outlook Contacts - New!

 Mail Merge with Outlook - New!

 

 General Office 2010 Handouts

 Customizing the Ribbon in Office 2010

 10 Things to Know About Backstage

 10 Office 2010 Annoyances

 10 Must Knows about Office 2010

 10 Things to Know about Office 2010 Protection

 10 Tweaks for Office 2010

  Office 2010 New Features

  Backstage View - New!

  Top 10 Add-ons - New!

 

 PowerPoint 2010 Handouts    

 

 Remove Background from Photo right in PowerPoint 2010 (V)

 Sneak Peak at the Exciting New PowerPoint 2010 Transitions (V)

 10 Things Hard to Find in PowerPoint 07 and 10

 Speaking about Presenting (Olivia Mitchell) New!

 What will your Audience Remember? New!

 Jon Thomas's 20 Points for PowerPoint Design New!

 PowerPoint Alternatives New!

 What to do When Your Losing Your Audience New!

 Free PowerPoint Templates New!

 Lose Your PowerPoint File? New!

 

 Word 2010 Handouts

 Better Design in Word 2010

 10 Things to Know Working with Word Graphics

 10 Ways to Work with Word Templates

 10 Ways to Share Word Documents

 10 Ways to Customize Word 2010

  Mail Merge for 2010 - New!

  Labels in Word 2010 - New!

  Auto Text Building Block for Multiple Return Addresses - New!

  10+ Do's and Don'ts for using Office Templates - New! 

  Let Word read the contents of your document to you - New!

  Create Labels in Word - New!

  Navigation Pane in Word - New!

  TOC Show more than 3 Headers - New!

 

  Excel 2010 Handouts

  Excels 2010 Solid Enhancements

  Excel Savings Calculator (zipped)

  10 Ways to Show Off Your Data - Excel 2010 - New!

  Customize Conditional Formatting Exercise Example - New!

  Spark lines worksheet example - New!

  Subtotal Evaluation Values - New!

  What happened to my VBA Calendar controls in Excel 2010? - New!

  Conditional Formatting Rows - New!

  Course Booking form Exercise - New!

  -  (VBA Exercise Form Code Parts)

  IFError-VLookup-RangeName example - New!

  VLookup Class Example w/IFError (Graphic version)- New!

  Protecting Cells w/ Formulas Step-by-Step - New!

  Excel and Word Options - New!

  Simple Data Validation / Info for Cell to User - New!

  Pivot Table Timelines - New!

  Subtotal by Color - New!

Protecting Excel Sheets/Workbooks (MSFT)

Share Workbooks (MSFT)

Track Changes in Shared Workbook (MSFT)

Display Relationships Formula to Cell (MSFT)

Change formula recalculation, iteration, or precision (MSFT)

Excel Functions by Category (MSFT)

Using a 1 or 2 InPut Data Table (MSFT)

Using Spark-lines (MSFT)

Pivot Table Slicers (MSFT)

Hiding/Un-Hide Sheets

Protect/Unprotect VBA

Print Sheets Dialog w/VBA

Quick Start Macro (MSFT)

Create a Macro Button (MSFT)

 

 Access 2010 Handouts

 Access 2010 Web Abilities

 Access 2010 FAQ

 Access 2010 Parts

 Access 2010 How-Tos

 10 Database Design Mistakes

 10 Reasons to Like Access 2010

 10 Reasons to Hate Access 2010

 10 Things to Know Before Building your Database

 10 Things to Know About Query Design

 10 Things Broken in Access

 10 Things to Keep your Database in Shape

 10 Tips about List Controls

 10 Tips about Splitting your Database

  Converting the Legacy Switchboard to Navigation Controls (HTML)   

  Free Ribbon Customizer (HTML page)

  Extreme Ribbon Builder (HTML page)

  Multi-Value Field Options

  Form Search with VBA Code

  Form Search Code

  Form Example

 

  SHAREPOINT 2010 VIDEOS and PODCASTS

 

  What is SharePoint (PodCast)

 

 

 SHAREPOINT 2010 HOW-TO VIDEOS

 

 SharePoint 2010 Lesson 1 - Getting Started (Creating Sites - Lists)

 SharePoint 2010 Lesson 2 - Part A - Account Setup Users, Lists, Views

 SharePoint 2010 Lesson 2 - Part B - Account Setup Users, Lists, Views

 SharePoint 2010 Lesson 3 - Part A - DocLibrary Basics (Versioning)

 SharePoint 2010 Lesson 3 - Part B - Document Library (Check in & out)

 SharePoint 2010 Lesson 4 - Getting started with Web Parts

 SharePoint 2010 Lesson 5 - Part A - Roles, Groups, & Permissions

 SharePoint 2010 Lesson 5 - Part B - Roles, Groups, & Permissions

 SharePoint 2010 Lesson 6 - Document Management - Site Columns

 SharePoint 2010 Lesson 7 - Document Management - Content Types

 Managing MetaData Column LimitationsNEW!

 For Excellent Peer Support be sure to utilize the SharePoint Users Group

 on LinkedIn, it's worth creating a free account

 

  EXAM INFORMATION FOR OFFICE 2010 EXAMS

 

  OFFICIAL SITE FOR PREP AND OBJECTIVE INFORMATION - NEW!

  SHAREPOINT 2010 EXAM INFORMATION - NEW!

  WORD 2010 CORE EXAM INFORMATION - NEW!

  WORD 2010 EXPERT EXAM INFORMATION - NEW!

  EXCEL 2010 CORE EXAM INFORMATION - NEW!

  EXCEL 2010 EXPERT EXAM INFORMATION - NEW!

  POWERPOINT 2010 EXAM INFORMATION - NEW!

  ACCESS 2010 EXAM INFORMATION - NEW!

  OUTLOOK 2010 EXAM INFORMATION - NEW!

 

 

 SharePoint 2010 Handouts

 

 What is SharePoint?

 Getting Started

 Sub sites and Navigation

 Changing the Look of your site

 Choosing the right site template

 Permissions

 Populating your sites

 Recover from Recycle Bin

 Register a Blog in Word

 Remove a Document Workspace

 SharePoint Tips

 SharePoint Quick Exercises

 Editing in Word, PowerPoint, OneNote

 Extra Notes on Simultaneous Editing 2010

 Content Editor Web Part

 Some thoughts on Workflows in SP 2010

 Column Validation Example - New!

 

 SharePoint & Designer 2010

 

  Create a Basic Workflow w/ conditionsNew!

  Conditions Link to more InformationNew!

  Advanced Workflow SharePoint Designer 2010

  Implementing Workflow using InfoPath &

      SharePoint Designer 2010 - New! (link)

  Video - Building a Leave Request Form - New!

  Leave Request without a Workflow - New!

 5 STEP - Enhanced Workflow

               (long in directives but nicely done) - New!

 Simple WFlow w/Cond & Act (BDAY) 1  New!

 Simple WFlow w/Cond & Act (BDAY) 2 - New!

 

      SharePoint Templates 2010 for: - New!

  • Healthcare

  • Human Resource

  • Information Management

  • Management and Finance

  • Operations

  • Project Tracking

 

Quick Reference Guides - NEW!

 

Office 2010 Quick Reference

Word 2010 Quick Reference

Excel 2010 Quick Reference

Access 2010 Quick Reference

PowerPoint 2010 Quick Reference

Outlook 2010 Quick Reference

Windows 7 Quick Reference

SharePoint 2010 Quick Reference

One Note 2010 Quick Reference

Flash CS3 Quick Reference

Photoshop CS3 Quick Reference

DreamWeaver CS3 Quick Reference

 

Apple Quick Reference Guides

 

Excel 2011 Quick Reference

Word 2011 Quick Reference

Outlook 2011 Quick Reference

 

Windows Handouts

 

100 Windows 8 Keyboard Shortcuts - NEW!

SharePoint Exercise Manual Sample

 

CIS110 Stuff

Practice Quiz for Recall (Computer Concepts)

Practice Quiz for Recall (Computer/Internet Ethics)

Video on Malicious Software

How Computer Virus's Work

PREZI: How to choose between Excel and Access

Access Exam Review Presentation

DOVE IMAGE

 

Student Example Files

IFS Worksheet

Basic Functions

Conditional Formatting

Goal Seek File

Goal Seek Example Graphic

Chart File (USA Sales)

Absolute Cell Reference 1

Absolute Cell Reference 2

Spark lines

Basic Formulas (L1)

Minute Paper

Europe

Mail Merge Source

 

CIS 110 ACCESS FILES

  1. Company

  2. Training

 

PREZI How-To's

 

Instructor and Trainee Manual (w/video links)

Personal Prezi Page examples

PowerPoint for Workshop Use

Prezi Example

Prezi Manual Sample

 

 
  Office 2013 and Office 365 is out and Handouts and links to information will be added as created or found...
  

  WORD 2013

 

  Section Breaks with Demo Link - New!

  Sharing your Word Building Blocks with others - New!

  Adding Speak to Words QAT 2010 and 2013 - New!

  Table Time Savers - New!

  10 Word Formatting Tips! - New!

  10+ Do's and Don'ts for using Office Templates - New! 

  TOC Show more than 3 Headers - New!

 

  EXCEL 2013

 

  Quick Analysis in Excel 2013 - New!

  3D Reference Technique to Summarize Excel Worksheets - New!

  SumIF() and Helper Column - New!

  SumIF() and Wild Cards - New!

  SumIF() and Negative Values - New!

  SumIF() and Naturally Occurring Values - New!

  Auto fill Shortcuts for Excel - New!

  New Flash Fill - New!

  Transposing Data - Fixed and Live - New!

  Finding Duplicates in Excel - New!

  Multiple Subtotals - New!

  10 Subtotal Tips - New!

  Building a Relationship between Excel Sheets - New!

 

 

 

 

 

  ACCESS 2013

  POWERPOINT 2013

  Dynamic PowerPoint Transitions - New!

 

 

  OUTLOOK 2013

  Color Coding Appointments - New!

  Saving Multiple Contacts at one time - New!

  Multiple Addresses and AutoText - New!

  Total Number of Emails - New!

  SHAREPOINT 2013

 

  EXAM INFO

  2013 Prep Guides for Office 2013 and Info - New!

  2013 Kaplan Self-Test Software

  2013 Measure Up Testing Software

 

  2010 Exam Prep Information

You can no longer buy Office, Microsoft’s flagship product, on removable media. You can’t even download offline installer files for the three retail editions of Office: Home and Student, Home and Business, and Professional. Read Ed's Blog to learn more.

 
 

Thinking of Quitting Cigarette Smoking? No Smell, No Smoke, Same great flavor and experience without Tobacco, smoke and all those chemicals.  Simple as that!

Blucigs works! 

EJuice Vapes Review

                  Convince a friend to quit and save even more $$$

 blu_colada_468x60
       

 

4RX Blog   XLCanada 4RX Online XLPharmacy-Online  XLPharmacy US

Copyright MicrosoftWord.biz -  2007 - All Rights Reserved.

This site in no way is affiliated with Microsoft in any manner. Only the Presenter is a Microsoft Master Certified Authorized Instructor, and is Microsoft Master Certified in Word, Excel, Access, PowerPoint & Outlook.

Old site  Sponsor - c Canada Online Blog Meds US