OCP Q&A Sessions are held for the benefit of the Offices of the Chancellor and Provost staff and units on their network.
Use of OCP technology and systems are covered under the following policies:
- Acceptable Use Policy (http://manuals.ucdavis.edu/ppm/310/310-16a.htm)
- Principles of Community (http://principles.ucdavis.edu)
- Electronic Communications Policy (http://manuals.ucdavis.edu/ppm/310/310-16.htm)
- UCOP Electronic Communications Policy (http://www.ucop.edu/ucophome/policies/ec/)
- Federal and state statutes (http://email.ucdavis.edu/federalstatelaws.html)
Applications
Access, Communicator (IM), Connect Pro, Excel, Fonts, IE 7, iTunes,
Office 2007,
Outlook, PDF Creator, Picture Manager, PowerPoint, Security, Voicemail, WebDev,
Web Editing Requirements, Windows, Word
Devices/Equipment
Access
Communicator (IM)
- Instant Messaging (IM) is a form of real-time communication between two or more people based on typed text. The text is conveyed via computers connected over a network.
- Instant messaging is NOT recommended for communications which have lasting business value. For long-term storage of communications, use e-mail and/or electronic document management systems. NOTE: Instant message conversations are NOT archived.
- Instant messaging is a "presence" technology, meaning that your device (e.g., computer) is identified when you connect to the network.
- OCP's IM system only connects to staff using OCP's network resources.
-
Communicator 2007 introduction (online training) (30-40 minutes)
- Communicator 2007 tour
- Communicator 2007 Getting Started Guide
- Communicator 2007 Help and How-to
- What do the presence buttons mean?
- Presence
Survival Guide
- Presence
Survival Guide
- Conferencing
in Office Communicator
- How to be
visible to defined contacts only
Connect Pro
- 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
iTunes
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 |
- How to Change Your Default Font
- Microsoft Access Tips for Serious Users
- Access 2007 FAQ
- Access 2007 in Pictures
- Access 2007 Videos (YouTube)
- Access 2007 Training Courses (Microsoft)
- How to Change Your Default Font Settings
- How to Configure LDAP Outlook 2007: Smart Scheduling (Video: approximately 7 minutes)
- Office 2007 Test Drive
- 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
- Exchange 2007 Upgrade - Improvements to Outlook Web Access (Word)
- Discontinued Features and Modified Functionality in Outlook 2007
Outlook
- Five Quick and Simple Microsoft Word Timesavers (Create outlines out of lists; Add a Save All option; Shift your paragraphs around; apply formatting via keyboard shortcuts; Start where you left off)
- Determine the Size of Your Outlook Mailbox
- Importing email into a specific folder
- Personal Folder File (.PST)
- Searching for Large Sized Emails
- 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
- 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
- Attach to additional mailbox Outlook 2007
- 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
- Outlook Sharing Access (Word Document)
- 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
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
- Password Change Information/Importance of Not Sharing (PDF)
- UCOP: Computer Security Basics Online Training
- E-Mail Spoofing
- Want good campus IT security? It all relies on you. Bob Ono explains
- Anti-Phishing Phil Can you tell real from fake (phishing) messages?
- Consumer Reports Phishing Trip How well can you tell real from fake (phishing) messages? Take this 12-step quiz.
- USPS: Protect Yourself from Identity Theft (Tips)
- Deter-Detect-Defend: Avoid ID Theft Federal Trade Commission (Video)
- Mission: Laptop Security (Game/Quiz)
- The Case of the Cyber Criminal (Game/Quiz)
- Beware of Spyware (Game/Quiz)
- ID Theft Faceoff (Game/Quiz)
- Spam Scam Slam (Game/Quiz)
- Phishing Scams - Avoid the Bait (Game/Quiz)
- Invasion of the Wireless Hackers (Game/Quiz)
- IET's Security Web Site
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/
- 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