UpcomingExcel 2010 Level 1

admin

Price Qty*
January 12, 2018 show details + $267.75 (CAD)  
January 23, 2018 show details + $267.75 (CAD)  
February 12, 2018 show details + $267.75 (CAD)  
March 14, 2018 show details + $267.75 (CAD)  
April 25, 2018 show details + $267.75 (CAD)  
May 1, 2018 show details + $267.75 (CAD)  
May 15, 2018 show details + $267.75 (CAD)  
June 5, 2018 show details + $267.75 (CAD)  
June 20, 2018 show details + $267.75 (CAD)  

  • January 12, 2018
    8:30 am - 4:00 pm
  • January 23, 2018
    8:30 am - 4:00 pm
  • February 12, 2018
    8:30 am - 4:00 pm
  • March 14, 2018
    8:30 am - 4:00 pm
  • April 25, 2018
    8:30 am - 4:00 pm
  • May 1, 2018
    8:30 am - 4:00 pm
  • May 15, 2018
    8:30 am - 4:00 pm
  • June 5, 2018
    8:30 am - 4:00 pm
  • June 20, 2018
    8:30 am - 4:00 pm

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

Course Objective: You will create and edit basic Excel 2010 worksheets and workbooks. You will do simple formulas using AutoSum, insert column and rows, cut, copy & paste single and multiple cells, use AutoCorrect, Spellcheck and Find/Replace. You will learn to adjust cell height & width, merge cells, add patterns, colors and borders. In addition you will learn to create & modify charts, hide & freeze windows, and arrange and compare multiple workbooks.

Prerequisites: This course assumes the user understands the basics of using a Windows-based computer. Students must be comfortable using the keyboard, mouse, and Start menu. Understanding and experience with printing and using a Web browser is an asses, but not required. No previous experience with other versions of Excel is necessary.

Course Content

Section 1: Getting Started
Lesson 1.1: Starting Out
Lesson 1.2: About Worksheets
Lesson 1.3: Exploring your Workbook
Lesson 1.4: Getting Help with Excel
Section 2: The Excel Interface
Lesson 2.1: The Quick Access Toolbar and File Menu
Lesson 2.2: The Home Tab
Lesson 2.3: The Insert Tab
Lesson 2.4: The Page Layout Tab
Lesson 2.5: The Formulas Tab
Lesson 2.6: The Data Tab
Lesson 2.7: The Review Tab
Section 3: Excel Basics
Lesson 3.1: Working with Excel; columns, rows, cells
Lesson 3.2: Basic Excel Features; AutoFill, AutoSum
Lesson 3.3: Moving your Data; cut, copy, paste
Lesson 3.4: Custom Actions and Options Buttons
Section 4: Editing your Workbook
Lesson 4.1: Modifying Cells and Data; cell alignment
Lesson 4.2: Cell Formatting; merge and AutoFit
Lesson 4.3: Enhancing a Worksheet’s Appearance
Lesson 4.4: Working with Charts, Part 1
Lesson 4.4: Working with Charts, Part 2
Section 5: Printing and Viewing your Workbook
Lesson 5.1: Using the View Tab
Lesson 5.2: Managing a Single Window
Lesson 5.3: Managing Multiple Windows
Lesson 5.4: Printing your Workbook
adminUpcomingExcel 2010 Level 1