ExpiredExcel 2010 Level 1

admin

  • Excel 2010: Level 1
    February 2, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • Excel 2010: Level 1
    March 2, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • Excel 2010: Level 1
    April 6, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • Excel 2010: Level 1
    May 2, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • Excel 2010: Level 1
    June 5, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • Excel 2010: Level 1
    August 2, 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 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
adminExpiredExcel 2010 Level 1