ITS Online»Email, Calendar & MS Office»Excel 2010

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.

Latest Tips

  • With so many digital tools that require passwords, it’s difficult to create memorable passwords that are both unique and hard to guess. Use LastPass to get control of your passwords for National Cyber Security Awareness Month!

  • Smartphones and tablets offer convenience but pose unique security risks. Protect yourself with these mobile security tips as part of National Cyber Security Awareness Month!