Text Only

VSU Directory

Select a VSU Department Academic Affairs Access Office Accounting and Finance Admissions Adult & Career Education Adult Degree and Military Programs Advancement Services Advancement, University African American Studies Air Force ROTC Alcohol & Other Drug Education Alumni Relations Anthropology Program Art Arts & Sciences, College of Arts, College of the Astronomy Athletics Auxiliary Services Biology BlazeFM: WVVS (90.9 FM) BlazeNet Board of Regents Bookstore Bursary (Tuition Cost & Fee    Payment) Business Admin. Grad Programs Business Admin., Langdale College    of Business Services Campus Activities Board Campus Alert System Campus Recreation Campus Wellness CampusConnect Career Services Catalogs, Undergraduate &    Graduate Center for Applied Research Center for Business and Economic    Research Center for Economic Education Chemistry Commencement Communication Arts Communication Disorders Communications Unit Conflict Resolution Continuing Education Cooperative Education Council of Department Heads Council on Staff Affairs Counseling Center Crime Stats Criminal Justice Curriculum & Instructional    Technology Curriculum, Leadership, and    Technology Department Dance Deaf Education Dean of Students Debate Team Dining Services Disability Services Distance Learning Early Childhood & Special    Education eCore Education, College of Educational Leadership Employee and Organizational    Development Employee Self Service Login Engineering Studies Engineering Transfer to Georgia    Tech (RETP) English English Language Institute Enterprise Application Services Environmental and Occupational    Safety Environmental Geosciences Environmental Issues Committee European Council Evening Program Event Services Faculty Research Grants Faculty Scholarship Faculty Senate Finance and Administration Financial Aid Financial Services Freshman Learning Communities Freshmen Year Experience General Studies Geosciences Governor's Honors Program Graduate School Graduation Grants & Contracts Greek Life HallNet Health Promotions Health Services Helpdesk, Information Technology History Honors Program Hotline Housing & Residence Life HUB Learning Cooperative Human Resources Information Technology Institutional Planning Committee Institutional Review Board for the    Protection of Human    Subjects Internal Audits International Programs International Students Journalism Kinesiology & Physical    Education Kings Bay Naval Submarine Base Leadership Programs Legal Affairs Management Marketing & Economics Marriage & Family Therapy Mass Media Master of Library & Info    Science Master of Social Work Program Mathematics & Computer Science Media Center Middle Grades Education Modern & Classical Languages Music Native American Studies Network Services Nursing, College of OASIS Odum Library Off-Campus Credit Program Info Office of Social Equity One Card Services Organization & Mission Orientation Parent Resource Center Parking & Transportation Peach State Summer Theatre Perspectives Philosophy and Religious Studies Physics Planned Giving Planning and Budget Council Plant Operations Police Department Policies Political Science President's Office Prior Learning Assessment (PLA) Psychology & Counseling Public Administration Public Services Publication and Design Services Quality Enhancement Plan (QEP) Reading Education Records Policy Registrar Religious Studies SACS Accreditation Satellite Services Science Seminar Secondary Education Small Business Development Center Social Work, Division of Sociology, Anthropology, Criminal    Justice South Georgia College Entry Program Special Education Spectator Speech Communication Sponsored Programs & Research    Administration Strategic Research & Analysis Student Affairs Student Conduct Office Student Development Organization Student Employment Student Government Association Student Handbook Student Life Student Organizations Student Success Center Student Union Tech Shop Telecommunications Testing Theatre Training and Development Undergraduate Research Council University Advancement University Assessment Committee University System of Georgia Upward Bound Valdosta Educators Credit Union Vending Services Veteran's Affairs Video Production Services Volunteer Services VSU Foundation VSU TV VSU TV Live WebCT Wireless Internet for VSU Women's and Gender Studies WVVS 90.9

Prospective Students | Current Students | Faculty & Staff | Alumni & Friends | Parents & Visitors | Portals

Home > Administrative Offices > Information Technology > Helpdesk > Guides > Office 2007 Tutorials > Office 2007 Advanced Tutorials

Office 2007 Advanced Tutorials

• Common Microsoft Office 2007 Features
  • Clip Art
    • Adding to the Microsoft Clip Organizer
    • Importing Clip Art from the Web
    • Manipulating Clip Art
    • Using Clip Art
  • Customizing Office 2007
    • Customizing Quick Access Toolbar
  • Drawing
    • Drawing in Office 2007
    • Manipulating Objects
    • Modifying Objects
    • Using Fill Effects in Word
    • Working With Text Boxes
  • General
    • Converting Documents to 2007 Format
    • Cutting, Pasting, and The Clipboard
    • Formatting with the Painter
    • How Do I Convert a Word 2007 Document to a Portable Document File?
    • How Do I E-mail a 2007 Document?
    • Keyboard Shortcuts
    • The Office 2007 Environment
    • Using Microsoft Office Help
    • Working With Spell Check
  • WordArt
    • Editing WordArt in Word
    • Using WordArt in Word

• Microsoft Excel 2007
  • Charting With Excel
    • About Charting
    • Charting Extras
    • Creating a Basic Chart
    • Formatting Your Chart
    • Getting Ready to Chart
    • Guidelines For Charting
    • Working With Chart Elements
  • Frequently Used Favorite Functions
    • Functions: Concatenate
    • Functions: Rank
    • Functions: Subtotal
    • Functions: Countif and Sumif
    • Inserting Dates and Times
  • Getting Started
    • Calculating Subtotals
    • Calculating With Functions
    • Editing Cell Contents
    • Formatting Cells
    • Formatting Numbers
    • Getting Started With Excel
    • Importing an External Data File
    • Working With Conditional Formatting
    • Working With Rows and Columns
  • Macros
    • Automating Excel with Macros
  • Managing Excel Worksheets
    • Cell References
    • Correcting Circular References
    • Navigating Your Large Workbook
    • Organizing Worksheets
    • Performing Calculations With Formulas
    • Protecting Your Files and Worksheets
    • Referencing Cells With Names
    • Working With Groups of Worksheets
  • Printing With Excel
    • About the Page Setup Dialog Box
    • Adding Headers and Footers
    • Customizing Page Layout
    • Modifying Headers and Footers
    • Other Printing Options
    • Printing Basics
    • Using Print Preview
    • Using Printing Options
  • Special Features
    • Hiding Columns
    • Separating Cell Data
    • Sorting Data
    • Using the Fill Command
    • Using the Find and Replace Features
    • Using the Paste Special Feature
    • Working With Comments
  • Working With Tables
    • Analyzing Your Tables With Functions
    • Creating Tables
    • Establishing Criteria
    • Filtering Your Table
    • Tables Overview
    • Working With PivotTables

• Microsoft PowerPoint 2007
  • Background Information
    • PowerPoint Terminology
    • The PowerPoint Views
  • Basics
    • Basic PowerPoint Tasks
    • Making Your Presentation
    • Viewing Your Presentation Outline
    • Working With a Slide Master
    • Working With Bullets and Numbering
    • Working With Handouts
    • Working With Text
  • Customization
    • Capturing Images
    • Customizing a Slide Master
    • Customizing Slide Elements
    • Using Sounds and Video
    • Using the Slide Sorter View
    • Working With Design Themes
  • More PowerPoint Features
    • Adding Links
    • Charting Information
    • Making Your Presentation Portable
  • PowerPoint Diagrams
    • Animating SmartArt
    • SmartArt Formatting Options
    • Working with SmartArt
    • Working with SmartArt: An Overview

• Microsoft Word 2007
  • Automating Your Work
    • Automatic Page Cross-References
    • Creating an Index
    • Creating Macros
    • Generating a Table of Contents
    • Managing Bibliographic Sources
    • Using the Find and Replace Features
    • Working With Bibliographic References
    • Working With Macros
    • Working With Templates
  • Bullets & Numbering
    • Customizing Bulleted & Numbered Lists
    • Using Bulleted Lists
    • Using Numbered Lists
  • Curing Auto Headaches
    • AutoCorrect: AutoFormat
    • AutoCorrect: Corrections and Replacements
  • Customizing Word 2007
    • Adding a Dictionary
    • Changing Word Default Selections
    • Removing Hyperlink Formatting From URLs
    • Working With File Properties
  • Inserting Fields and Text
    • Summary of Word Fields
  • Labels & Envelopes
    • Additional Options For Creating Envelopes
    • Creating Labels
    • Customizing Labels
    • Labels: An Overview
    • Working With Envelopes
  • Mail Merge & Form Letters
    • Creating an E-mail Merge
    • Creating Merged Envelopes
    • Creating Merged Letters
    • Creating Merged Mailing Labels
    • Filter and Sort Options
    • Mail Merge: Working with the Recipient List
    • Mail Merge: An Overview
    • Mail Merge Terminology
    • Using an Excel Table For Mail Merge
    • Using Outlook Contacts For Mail Merge
  • Miscellaneous Topics
    • Adding and Removing Watermarks
    • Adding Line Numbers
    • Creating Headers and Footers
    • Working With Columns
    • Working With Images
  • Organizing Information With Word Tables
    • Calculations Within Tables
    • Creating a Table From Existing Text
    • Formatting Tables
    • Inserting Fields
    • Merging and Splitting Table Cells
    • Navigating and Selecting Within a Table
    • Resizing Table Elements
    • Table Basics
    • Table Options
    • Using the Sort Feature
  • Using Outlining
    • Outlining: Using the Outline View
    • Outlining: Bullet & Numbering Options
    • Using Outline Numbering
  • Using Word Styles
    • Advanced Style Options
    • Style Basics
    • Style Organizer
    • Styles: An Overview
  • Word Basics Series
    • Borders and Shading Options
    • Editing a Document
    • Hyphenation Options
    • Inserting Built-in Equations & Structures
    • Learning Document Basics
    • Page Formatting Options
    • Paragraph Formatting Options
    • Printing Options For Specific Pages
    • Saving In Alternate Formats
    • Setting Tabs
    • Using Grammar Check
    • Working With Spell Check
    • Working With Text Options
  • Working Collaberatively
    • Combining Word Files
    • Protecting a Document
    • Working With the Track Changes Feature
  • Working the Equation Editor
    • Creating Custom Mathematical Expressions
    • Creating Fractions
    • Equation Editor Functions
    • Inserting Symbols and Special Characters
    • The Equation Editor Environment