UpcomingExcel 2010 Level 2

admin

Price Qty*
January 16, 2018 show details + $267.75 (CAD)  
January 29, 2018 show details + $267.75 (CAD)  
February 13, 2018 show details + $267.75 (CAD)  
February 26, 2018 show details + $267.75 (CAD)  
March 7, 2018 show details + $267.75 (CAD)  
March 15, 2018 show details + $267.75 (CAD)  
April 4, 2018 show details + $267.75 (CAD)  
April 26, 2018 show details + $267.75 (CAD)  
May 2, 2018 show details + $267.75 (CAD)  
May 30, 2018 show details + $267.75 (CAD)  
June 7, 2018 show details + $267.75 (CAD)  
June 22, 2018 show details + $267.75 (CAD)  

  • January 16, 2018
    8:30 am - 4:00 pm
  • January 29, 2018
    8:30 am - 4:00 pm
  • February 13, 2018
    8:30 am - 4:00 pm
  • February 26, 2018
    8:30 am - 4:00 pm
  • March 7, 2018
    8:30 am - 4:00 pm
  • March 15, 2018
    8:30 am - 4:00 pm
  • April 4, 2018
    8:30 am - 4:00 pm
  • April 26, 2018
    8:30 am - 4:00 pm
  • May 2, 2018
    8:30 am - 4:00 pm
  • May 30, 2018
    8:30 am - 4:00 pm
  • June 7, 2018
    8:30 am - 4:00 pm
  • June 22, 2018
    8:30 am - 4:00 pm

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