OCP Q&A Sessions are held for the benefit of the Offices of the Chancellor and Provost staff and their Satellite Units.
Applications
Access, Communicator, Connect Pro, Excel, Fonts, IE 7,
IE 6, iTunes, Office 2003,
Office 2007,
Outlook, PDF Creator, Picture Manager, PowerPoint, Security, Voicemail, WebDev,
Web Editing Requirements, Windows, Word
Devices/Equipment
Access
Communicator
- Communicator 2007 introduction (online training) (30-40 minutes)
- Communicator 2007 tour
- Communicator 2007 Getting Started Guide
- Communicator 2007 Help and How-to
Connect Pro
- Adobe Connect Professional at UC Davis (IET)
- Features
- Overview (requires audio)
- Tips and Tricks
- Best Practices When Presenting
- Discovering Templates
Excel
- Cell Formatting
- Change the Default Number of Worksheets
- Charts-Changing Chart Item Color
- Combining Columns
- Conditional Formatting
- Formulas
- Keyboard Shortcuts
- Row Formatting
- Sorting and Auto Filter
- Security Options
- Spreadsheet Links
- Text to Columns
- View the Formula Bar
- Viewing Spreadsheets
Fonts
Internet Explorer 7.0
- New Interface
- Multiple Homepages
- Tabbed Browsing
- Tab Groups
- Quick Tabs
- Enhanced Search
- Change Default Search Engine
- Enhanced Printing
- RSS Feeds
- Take a Tour
- Keyboard Shortcuts #1
- Keyboard Shortcuts #2
Internet Explorer 6.0
- Change How a Web Page Looks When it Prints
- Changing the Home Page
- Favorites-Exporting/Importing
- Keyboard Shortcuts
- Internet Search Tips
iTunes
Office 2003
Office 2007
|
Office 2007 Videos |
Duration |
| New Microsoft Office User Interface Video | 13:12 |
| Getting Up To Speed with Power Point 2007 | 7:21 |
| Getting Up To Speed with Outlook 2007 | 6:39 |
| Getting Up To Speed with Excel 2007 | 6:55 |
| Getting Up to Speed with Word 2007 | 6:43 |
Windows Media Player required to play videos.
|
Helpful Information from Microsoft |
| Excel 2007 Find your favorite commands |
| Word 2007 Find your favorite commands |
| PowerPoint 2007 Find your favorite commands |
| Office Enterprise 2007 Training Notebook |
- Office 2007 Test Drive
- Office 2007 Fluent User Interface Overview (aka the "ribbons")
- Basic Training for the Ribbon
- Screenshots of the Office 2007 User Interface
- More Screenshots (from Microsoft)
- Better Together: Do More with Microsoft Office Outlook 2007 and Microsoft Exchange Server 2007
- Discontinued Features and Modified Functionality in Outlook 2007
- Installing/Upgrading Office 2007 When you're ready to upgrade!
Outlook
- General
- Archiving Email
- Add/Remove PST to Email Profile
- Creating an Archive Folder
- Determine the Size of Your Outlook Mailbox
- Importing email into a specific folder
- Personal Folder File (.PST)
- Searching for Large Sized Emails
- Calendaring
- Calendar Permissions Defined
- Changing the Calendar Work Week
- Changing the Calendar Fonts
- Changing the Calendar Work Week
- How to use Group Schedules
- Issuing Meeting Invitations Instead of E-mailing Announcements for Gatherings
- Meeting Labels and Automatic Formatting
- Preventing Response Requests for Meeting Invitations
- Scheduling Meetings with Colleagues Outside of OCP
- Shared Calendars
- Viewing Non-Consecutive Days
- Contacts
- Deleted Items
- Email Messages
- Add a Picture to Your Signature Block Without Displaying an Attachment Icon
- Auto-Complete Listings - How to handle after employee leaves the OCP Exchange organization
- Delay Email Message Delivery
- How To Report Offensive E-Mail Messages And/Or SPAM
- How To Determine If A Message Is A Hoax Or A Scam
- Editing Email Messages
- Odd Characters in an Email
- Recalling a Message
- How Message Recall Works
- Recalling a Message
- Searching for Email Items
- Send to "Undisclosed Recipients"
- Signature Fonts
- Searching Logos
- Using the Expiration Option with Messages to OCP/Satellite Unit Colleagues
- Voting Buttons
- Mailbox Settings (Server)
- Accessing Outlook Web Access
- Auto Forward Rule
- Delegates
- Mail Rules and Alerts (sorting email automatically)
- Organizing Emails: Using Color and Fonts
- Out of Office Messages
- Remapping Campus Email Address
- Sharing Folders
- Spam Filtering
- Permissions
- Outlook 2003 Sharing Access (Word)
- Profile Settings (Local Computer)
- Automatic Outlook Profile Creation
- Adding an Additional Mailbox
- Changing E-Mail Field Views in Outlook Mailbox
- Creating Email Signatures
- Creating Outlook Profiles
- Delete An Auto-Filled Email Address
- Email Alerts
- Emptying Deleted Items Folder upon Exiting
- Search Folders
PDF Creator
Picture Manager
PowerPoint
- PowerPoint 2003 Shortcut Keys When Running a Slideshow
- PowerPoint Presentation Tips
- Inserting a Movie, Sound, or Image File into a Presentation
- Saving a PowerPoint Presentation on a USB Memory Device
Security
WebDev
Web Accessibility
- HTML Markup Validation - http://validator.w3.org/
- Cascading Style Sheet (CSS) Validation - http://jigsaw.w3.org/css-validator/
- Accessibility (Section 508) - http://www.cynthiasays.com/fulloptions.asp
- Dreamweaver 8 Accessibility - http://www.adobe.com/resources/accessibility/dw8/
- Visual Studio Accessibility Checker - http://msdn2.microsoft.com/en-us/vstudio/aa718457.aspx
- UCD PPM 310-70 World Wide Web Standards - http://manuals.ucdavis.edu/ppm/310/310-70.htm
- Web Accessibility at the University of California - http://www.ucop.edu/irc/itaccessibility/resources/techtopics.html
- University Communications Standards - http://ucomm.ucdavis.edu/pubguide/web_templates.html
Voicemail
Windows
- Windows Keyboard Shortcuts
- Change Location of "My Documents"
- Data Measurement Chart
- Placing computer in Stand by
Word
- Creating and Inserting AutoText Entries
- Email Merge
- Excel to Word Labels
- Outlines
- Paste Options
- Ruler Measurement Settings
- Table Header
- Turning Off Track Changes
Devices/Equipment
203 Mrak
Blackberry
Conference Phone
Printers
- Adding a Network Printer
- Printing Two-Sided Documents on the 5th Floor Color Printer
- Setting a Default Printer