Excel 2010

Getting Help in Microsoft Excel

Help IconAll the help you need is built right into Excel!

Click the blue question mark icon in Microsoft Excel to search for
solutions to your problems, training, and more.

Excel 2010 eBooks Microsoft Excel 2010 Plain & Simple

LawKey Required

ITS provides full eBooks for all Faculty, Staff, and Students. Get started by taking a look at Microsoft Excel 2010 Plain & Simple Password Required for visual, step-by-step guides on all of Excel’s major features.

Online Resources

All of Microsoft’s help resources are also available online. Visit Microsoft’s Help and How-to Site to get started.

Microsoft Online Training Courses

Microsoft offers a series of 15-60 minute online training courses that can be completed from your desk at your own pace. Most trainings have an audio component, so be sure to wear headphones or turn up your speakers.

Reference Cards: All trainings also include a convenient reference card that covers all of the topics from the training. Direct links are available in the table below.

Already know the topics below? Click the Test Yourself links to make sure you’re not missing anything!

Don’t have headphones? Email ITS Help.

Course What You’ll Learn Additional Resources
Getting started with Excel 2010
  • Initial steps if you have never used Excel
  • Initial steps if upgrading from Excel 2003 or earlier
  • New Features
  • New Menu’s
Reference Card Test Yourself
Office 2010 Security: Protecting your files
  • Message bars can alert you to useful information and potential problems with your files
  • Security messages bars can provide the opportunity to consider the ptotential security risks that may be in your files
  • Open or read a file while reducing the inherent risks
Reference Card Test Yourself
Get to know Excel 2010: Create your first spreadsheet
  • Create a spreadsheet
  • Do basic math
  • Add and delete columns and rows
  • Keep column titles in sight as you scroll
  • Prepare a spreadsheet for printing
Reference Card Test Yourself
Get to know Excel 2010: Create formulas
  • Make formulas update automatically
  • Use predefined formulas called functions that do things like calculate the amount of monthly payments
Reference Card Test Yourself
VLOOKUP: What it is, and when to use it
  • Use VLOOKUP to look up a value you want to find in an Excel list or table
Reference Card Test Yourself
Understand data at a glance with conditional formatting
  • Make certain data stand out
  • Help analyze data
  • Identify patterns and trends
Reference Card Test Yourself
Sparklines: Use tiny charts to show data trends
  • Add tiny charts next to data to give readers a picture of what the data means
  • Make it easy to spot patterns and trends
Reference Card Test Yourself

Additional Links

Below are some additional product and information links on Excel 2010 for you to explore.

Contact

Systems Availability

  • Our online services may not be available during these maintenance periods.

    Regularly
    Fridays: 5pm-midnight
    2nd & 4th Tuesdays: 5pm-7pm

    Occasionally
    Tuesdays: 5am-7am
    Thursdays: 5pm-7pm

    Notices
    https://twitter.com/pennlawitsalert

image
Bug 00