Desktop Support

Browse Topics

• Access

  • Access Database Displays Security Warning
    

• Adobe Acrobat

  • "Document Could Not Be Saved" Message
    
  • Adobe Acrobat 7.0 Not Compatible with Office 2007
    
  • Adobe Acrobat Displays an X
    
  • Converting EPrint files to Excel
    

• AntiVirus

  • Working with Quarantined Files
    

• Banner

  • 404 Errors when saving Banner report as text file
    
  • Banner: Data Extract Issues
    
  • Instruction/Referenced Memory Error when Accessing Banner
    
  • Internet Explorer encounters an error when logging on to Banner
    
  • Launching Internet Explorer Shortcuts in Separate Windows
    
  • WebFocus: Windows has blocked this software...message
    

• Core Banking

  • Unable to View Check Images in Core Banking
    

• Excel

  • Excel 2007 Documentation

    • Excel 2007
      

  • Charts

    • One Step Excel Charts
      

  • Data Entry

    • Adding Pop Up Notes to Cells
      
    • Converting columns to rows and rows to columns
      
    • Copying Subtotaled Data
      
    • Entering the Same Value in Multiple Cells
      
    • Excel's Data Validation Feature
      
    • Extracting the Year from a Date Field
      
    • Getting a Handle on Autofill
      
    • Inserting Copyright, Trademark and Registered Symbols
      
    • Masking Social Security Numbers in an Excel Worksheet
      
    • Placing the Worksheet Name in a Cell
      
    • Quickly Viewing the Sum of Selected Cells
      
    • Reversing the Order of Last and First Names on a Worksheet
      
    • Separating First and Last Names in a Worksheet Cell
      

  • Editing and Worksheet Navigation

    • Copying a Worksheet to Another Workbook
      
    • Cycle Through Open Workbooks
      
    • Edit Cells Quickly Using the Keyboard
      
    • Moving Between Workbooks and Worksheets
      
    • Moving to the End of a Worksheet
      
    • Navigating Blocks of Data in Excel
      
    • Quickly Accessing Worksheets in a Large Workbook
      
    • Search Across Multiple Worksheets
      
    • See More of Your Workbooks
      
    • Select a Range of Cells
      
    • Using Hyperlinks to Access Worksheets in Large Workbooks
      
    • Viewing Different Parts of a Worksheet
      
    • Working in Page Break Preview
      

  • Excel Demos

    • Excel 2007: Using a Drop Down List for Data Validation
      
    • Excel 2007: Interface
      
    • Excel 2007: Introduction to Pivot Tables
      
    • Excel 2007: Quick and Easy Conditional Formatting
      
    • Excel 2007: Tables, Sorting and Filtering Data
      
    • Excel 2007: Using Custom Views with Autofilter
      
    • Excel 2007: VLookUp Demonstration
      
    • Office 2007: Introducing SmartArt Demo
      

  • Formatting - Excel

    • Adding Bullets to a Worksheet
      
    • Centering a Worksheet on a Page
      
    • Creating New Cell Styles in Excel 2007
      
    • Creating Vertical Text
      
    • Formatting Rows Containing Subtotals
      
    • Hiding Row and Column Headings
      
    • Inserting a Logo or Graphic in a Worksheet Header
      
    • Scaling Worksheets for Printing
      
    • Slanted Column Headings
      
    • Using an Ampersand in an Excel Header or Footer
      
    • Using Conditional Formatting to Alternate Row Shading
      
    • Using Shapes to Highlight Cell Contents
      
    • Zero Padding Numeric Strings in Excel
      

  • Formulas

    • A Formula to Separate First and Last Names in a Worksheet
      
    • Cross Checking Column and Row Totals
      
    • How Excel Calculates
      
    • Selecting All Formulas on a Worksheet
      
    • Show or Hide Formulas
      
    • Subtotaling by Month in a Date Field
      
    • Subtotaling on More than One Field
      
    • Using Excel's SUBTOTAL Feature
      
    • Using IF in Excel Calculations
      

  • Functions

    • Combining Text Values (Concatenate)
      
    • NETWORKDAYS Function
      
    • Using SUMIF for Conditional Calculations
      
    • Using SUMPRODUCT for Conditional Calculations
      
    • Using the Conditional Sum Wizard
      
    • Using the PROPER Function
      

  • Miscellaneous - Excel

    • Adding Send To-Mail Recipient to the Quick Access Toolbar in Office 2007
      
    • Changing Macro Security Settings in Excel 2007
      
    • Compile Error When Opening and Closing Excel 2007
      
    • Converting EPrint files to Excel
      
    • FUPLOAD Template Information
      
    • Introducing AutoFilter
      
    • Open/Save Files to the FTP Server
      
    • Precision Calculations in Excel Worksheets
      
    • Sorting Data that Contains Blank Cells
      
    • Use Text to Speech for Easy Proofreading
      
    • Using Advanced Filtering in Excel 2007
      
    • Using Autoshapes To Link Worksheets
      
    • Using Workspaces
      
    • Working with Comments in Excel
      

• FTP Server

  • FTP Demonstration
    

• HTML and Expression Engine

  • Changing an Entry's Publication Date in Expression Engine
    
  • Creating Lists with Bullets and Numbers in HTML
    
  • Embedding Windows Media Player Files (.wmv) in an Expression Engine Weblog
    
  • Hiding Weblog Entries in Expression Engine
    
  • Placing an Image on a Web Page
    
  • Revising Hot Topics or Hot Links on Department's Home Page
    

• Internet Explorer

  • Don't Lose Your Place
    
  • Eliminating Run Time Errors
    
  • Internet Explorer 7.0
    
  • Launching Internet Explorer Shortcuts in Separate Windows
    
  • One Word Navigation
    
  • Opening a Link in a New Window
    
  • Print a Page from Favorites
    
  • Resetting your Home Page
    
  • Send Email Directly from Internet Explorer
    
  • Sorting Favorites in Alphabetical Order
    
  • This application has requested the Runtime to terminate it in an unusual way: Error Message
    

• Microsoft On Demand Mini Webcasts

  • Microsoft On-Demand Mini Webcasts
    
  • Microsoft's Guide to the Office 2007 Ribbon
    

• Miscellaneous

  • Blackberry

    • Blackberry Issues and Solutions
      

  • Creating CD’s

    • Creating a Data CD with Roxio
      
    • Creating a Data CD with Sonic RecordNow! Plus
      

  • Java

    • Disabling Automatic Java Update Notifications
      

  • NCAS SmartStream

    • NCAS Smart Stream Connection and Login Instructions
      

  • Novell

    • ITS Admin displays in the login box after you logon to Novell
      

  • One Note

    • Restoring the One Note Icon on the Status Bar
      
    • Taking Screen Shots with MS One Note
      

  • Other

    • 3rd Floor Reese Color Laser Jet Print Driver Instructions
      
    • Changing the Power Save Settings on a Computer
      
    • Dell Optiplex GX 760 Slow to Refresh when Unlocked
      
    • Removing Antivirus 2009 Malware Program
      
    • UNC Charlotte Logo and Branding Information: Desktop Wallpapers
      

  • SIPS

    • Placing a SIPS icon on a computer
      

• Novell Application Launcher

  • Novell Application Launcher Displays Incorrectly
    

• Outlook

  • Outlook 2007 Documentation

    • Outlook 2007
      
    • Setting up another mailbox to open automatically in Outlook 2007
      
    • Setting up Your Personal Folders in Outlook 2007
      

  • Calendar

    • Changing default meeting reminder time in Outlook
      
    • Color Code Your Appointments
      
    • Customizing Calendar Views
      
    • Display the Calendar in a Separate Window
      
    • Displaying Additional Months in the To Do Bar
      
    • Displaying Non Consecutive Days on the Calendar
      
    • Error when trying to print another user's calendar
      
    • Group Schedule: Scheduling Meetings with Specific Group Members
      
    • Group Schedules
      
    • Making Your Calendar Visible by Default
      
    • Viewing Calendar and Inbox in Separate Windows
      

  • Contacts

    • Easily Add Contact Birthdays to your Calendar
      
    • Flagging Contacts
      
    • Outlook Displays Some Contacts Twice
      
    • Outlook's Mapping Feature
      
    • Quickly Create a New Email Message to a Contact
      
    • Quickly Creating an Appointment with a Contact
      

  • Email

    • "Deleting" Addresses from Auto-Suggest
      
    • Archiving Email and Compacting PST Files
      
    • Cannot View Images in Email (Outlook 2003 or 2007)
      
    • Changing the Default Font in Email Messages
      
    • Configuring the Out of Office Assistant
      
    • Creating and Using Personal Folders in Outlook XP
      
    • Creating Templates in Outlook
      
    • Determining if Read Receipt was Requested by Sender
      
    • Finding Related Messages
      
    • Information service has not been configured message in Outlook 2007
      
    • Opening Multiple Emails at the Same Time
      
    • Quickly Moving Outlook Messages
      
    • Schedule Email Responses on the Calendar
      
    • Sending Distribution Lists to Another User
      
    • Sending Email from Your Desktop
      
    • Stopping RSS Feeds in Outlook 2007
      
    • Turning Off Auto Suggest for Email Addresses
      
    • Unable to Access Outlook Personal Folders
      
    • UNC Charlotte Logo and Branding Information: Email Signature
      
    • Using Quick Parts for Boilerplate Text in Outlook 2007
      

  • General

    • Macro to Forward Spam to StopSpam Email Account
      
    • MS Outlook Keystrokes
      
    • Setting Up a New Outlook Account (Outlook 2003 and Outlook 2007)
      

  • Notes

    • Quicky Creating a New Note
      

  • Outlook Demos

    • Outlook 2007: Adding a Mailbox to Outlook
      
    • Outlook 2007: New Features
      
    • Outlook 2007: Setting Up Personal Folders
      

• Powerpoint

  • Adding Custom Animation to Your Slides
    
  • Copying Slides from one Presentation to Another
    
  • Creating a Web Presentation in Powerpoint 2007
    
  • Custom Animation - Making Objects Disappear
    
  • Easily Type Text Over an Autoshape
    
  • Emailing Powerpoint Handouts
    
  • Inserting Copyright, Trademark and Registered Symbols
    
  • Inserting Non Bulleted Text
    
  • Moving Graphic Images
    
  • Quickly Change Text Size
    
  • Running a Presentation from your desktop
    
  • Some Slide Sorter Tips
    
  • Straight Lines and Perfect Shapes
    
  • Take A Break During Your Presentation
    
  • Two Ways to Quickly Start a Powerpoint Presentation
    
  • UNC Charlotte Logo and Branding Information: Powerpoint Presentations
    
  • Using Powerpoint's Slide Pane
    
  • Using Powerpoints Package for CD Feature
    
  • Using Word to Enhance Powerpoint Handouts
    

• Visio

  • Viewing Visio Files
    

• Word

  • Word 2007 Documentation

    • Word 2007
      

  • Drawing and Clip Art

    • Page Borders and Horizontal Lines
      
    • Preventing Drawing Canvas Display when Inserting Autoshape or Textbox
      

  • Editing

    • Adding a Watermark to a Document
      
    • Aligning Numbered Lists on the Period
      
    • Cycling Through Tabbed Dialog Boxes
      
    • Delete All Comments in a Document
      
    • Deleting Words
      
    • Easily Create Horizontal Dividing Lines
      
    • Finding Your Place
      
    • Inserting Copyright, Trademark and Registered Symbols
      
    • Moving Between Comments
      
    • Quickly Move Paragraphs in Word
      
    • Select a Column of Text
      
    • Selecting Non Consecutive Items in Word
      
    • Synonyms
      
    • Word 2007 Keyboard Shortcuts
      
    • Word's Browser Button
      

  • Formatting - Word

    • Quickly Removing Formatting
      
    • Working with Drop Caps
      
    • Working with Line Numbers
      

  • Mail Merge

  • Miscellaneous - Word

    • Control Key Shortcuts
      
    • Creating "Jump" Points in a Document
      
    • Displaying Gridlines in a Word Document
      
    • Linking a Word Document to an Excel File
      
    • More on Jump Points in Documents: Adding Screen Tips
      
    • Option to Save Word Document as PDF File Not Available
      
    • Quickly Change Line Spacing
      
    • Recently Used Files List
      
    • Saving a Word Document as a PDF File
      
    • Using Word to Enhance Powerpoint Handouts
      

  • Printing

    • Fitting a Word Document on One Page
      

  • Tools

    • Using the Research Pane
      
    • Using Tools, Calculate
      
    • Word Spell Check: Editing the Custom Dictionary
      

  • Word Demos

    • Office 2007: Introducing SmartArt Demo
      
    • Word 2007 Demo