UpcomingExcel 2010 Level 2


Price Qty*
November 17, 2017 show details + $267.75 (CAD)  
December 8, 2017 show details + $267.75 (CAD)  

  • November 17, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • December 8, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)

Course Length: 1 day (8:30 a.m. – 4:00 p.m.)    Instructor Led Training

Course Overview:  Microsoft Office Excel 2010 is the latest offering of Microsoft’s spreadsheet program. Excel is a popular tool for creating spreadsheets, analyzing data, and charting information. This new version of Excel incorporates robust error checking, numerous file validation/verification tools, image editing, and Sparklines (charts within individual cells).

This Intermediate level is intended to help everyday users of Excel become more proficient by expanding their knowledge of functions, formulas, and new Excel features. This manual will also help more experienced users who have little to no experience with Excel 2010 and the ribbon interface.

Course Content

Section 1: Advanced File Tasks
Lesson 1.1: Using Windows Explorer within Excel
Lesson 1.2: Saving your Files
Lesson 1.3: Using File Management Tools, Part One
Lesson 1.4: Using File Management Tools, Part Two
Section 2: Working with Functions and Formulas
Lesson 2.1: Using Formulas in Excel, Part 1
Lesson 2.2: Using Formulas in Excel, Part 2
Lesson 2.3: Exploring Excel Functions
Lesson 2.4: Using Functions in Excel
Lesson 2.5: Working with Names and Ranges
Lesson 2.6: Working with Array Formulas
Section 3: Managing Tables
Lesson 3.1: Working with Tables
Lesson 3.2: Working with Records and Fields
Lesson 3.3: Working with Tables and Filters
Lesson 3.4: Using Excel as a Database
Section 4: Adding the Finishing Touches
Lesson 4.1: Research Tools
Lesson 4.2: Using Themes
Lesson 4.3: Adding Text Boxes
Lesson 4.4: Inserting Pictures and ClipArt
Lesson 4.5: Editing Pictures
Section 5: Showing Data as a Graphic
Lesson 5.1: Inserting SmartArt
Lesson 5.2: Formatting SmartArt
Lesson 5.3: Adding Symbols, Equations, and Shapes
Lesson 5.4: Adding Sparklines
Lesson 5.5: Editing Sparklines
adminUpcomingExcel 2010 Level 2