600 Maryland Avenue, S.W.,
Washington, DC 20024-2520



Or find a course by:

Microsoft Excel 2010: Introduction

Home / Course Details

  • ORegistration open
  • FClass full
  • GGuaranteed to Go
  • RRemote Classroom
Multiple Registrations?
Session Schedule Location Tuition Status
Contract to bring this course to your location

Click here for more information

Course overview

This course focuses on basic spreadsheet skills, incorporating the new features and functionality of Microsoft Office 2010. Students learn how to navigate the Ribbon, and key features in Excel. Students will learn to create simple worksheets which include formulas, formatting, absolute and relative cell references. They will also learn how to use Excel to analyze data more efficiently and effectively, work with data queries, and create professional looking charts.

Who should attend?

Anyone who uses Microsoft Excel and needs to acquire the knowledge, skills and techniques to design formulas, create and edit worksheets, and present data results. No previous experience with Excel is assumed. Participants should have some prior knowledge of Microsoft Windows.

Learning outcomes

  • Demonstrate proficiency in MS Office Excel 2010 new interface to include the Ribbon, Command and Contextual Tabs, Galleries, the Quick Access Toolbar, and the Navigation Pane
  • Utilize the full range of new editing and formatting features available to include themes and styles
  • Create and modify a 3-D Clustered Column Chart and gain an understanding of Excel’s charting program
  • Print standard and customized documents to include orientation, page setup, margins, page breaks, and sizing
  • Examine the use of analytical tools such as the IF function and Goal Seek in order to perform what-if simulations
  • Use external data such as Web Queries and understand how to refresh a query definition
  • Explore database functions by formatting a range as a table, adding total rows, sort and filter using both single and multiple criteria

Chat Now