Course Code: 738

Excel 2010 Level 1

Class Dates:
1/2/2019
12/4/2018
2/5/2019
3/5/2019
Length:
1 Days
Cost:
$295
Class Time:
Technology:
Office
Delivery:

Overview

  • Course Overview
  • Recommended for individuals who are new to Microsoft Excel or need a brush up on the basics, this hands on instructor-led course will provide an introduction to spreadsheets and the practical uses and versatility of Excel. Students will learn time saving features and tips for using Excel effectively. This is a good foundational course that will provide you a solid knowledge base before attending other Excel courses.

  • Audience
  • This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2010 that is necessary to create and work with electronic spreadsheets.

Prerequisites

  • This course requires you to be familiar with using personal computers and have used a mouse and keyboard.

    • You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.
    • The ability to launch and close programs.
    • Navigate to information stored on the computer.
    • Manage files and folders, is highly recommended.
    • A familiarity with other Microsoft Office applications (e.g., Word) will be helpful.
  • Recommended Courses:

Course Details

  • Lesson 1: Getting Started with Excel
  • Identify the Elements on the Excel Interface
  • The Ribbon & Backstage View
  • The Quick Access & Formula Toolbar
  • Lab: Identifying Elements of the User Interface
  • Navigate and Select Cells in Worksheets
  • Lab: Working with Cells
  • Customize the Excel Interface
  • Lab: Customizing the Excel User Interface
  • Create a Basic Worksheet
  • Data Types
  • Commands
  • Lab: Entering Data in an Excel Worksheet
  • Lesson 2: Performing Calculations in an Excel Worksheet
  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas
  • Create Basic Calculations
  • Lab: Creating Formulas
  • Insert Functions in a Worksheet
  • Function Categories
  • Commonly Used Functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
  • Lab: Calculating Values Using Functions
  • Reuse Formulas
  • Relative and Absolute References
  • Lab: Copying Formulas and Functions
  • Lesson 3: Modifying an Excel Worksheet
  • Edit Worksheet Data
  • Undo and Redo Commands
  • Auto Fill Feature and Options
  • The Transpose Option
  • Lab: Manipulating Data
  • Find and Replace Data and Advanced Search Option
  • The Replace Command and Spelling Dialog Box
  • Lab: Searching for Data in a Worksheet
  • Lab: Checking a Worksheet for Spelling Errors
  • Manipulate Worksheet Elements
  • Insert and Delete, Column Width and Row Height Alternation Methods
  • Lab: Adjusting Columns
  • Lesson 4: Modifying the Appearance of a Worksheet
  • Apply Font Properties
  • The Font Group and Format Cells Dialog Box
  • Lab: Modifying Fonts
  • Add Borders and Colors to Cells
  • Lab: Adding Borders and Colors to Cells
  • Align Content in a Cell
  • Alignment Options and Indent Command
  • The Wrap Text, Orientation and Merge Options
  • Lab: Positioning the Content in a Cell
  • Apply Number Formatting
  • Lab: Applying a Number Format
  • Apply Cell Styles and Lab: Applying Cell Styles
  • Lesson 5: Managing an Excel Workbook
  • Manage Worksheets
  • Insertion and Deletion Options
  • Worksheet Repositioning Methods
  • Tab Formatting Option
  • Hide and Unhide Option
  • Lab: Formatting Worksheet Tabs
  • Lab: Organizing a Workbook
  • View Worksheets and Workbooks
  • Freeze Panes Options
  • The Split, Arrange All and View Side by Side Commands
  • The Switch Windows and New Window Commands
  • Lab: Viewing a Large Worksheet
  • Lesson 6: Printing Excel Workbooks
  • Define the Page Layout
  • Headers and Footers
  • Page Margins and Page Orientation
  • The Print Titles Commands
  • Page Breaks and Options
  • Lab: Adding Headers and Footers
  • Lab: Setting the Page Layout and Previewing a Worksheet
  • Print a Workbook
  • The Print Area and Scaling Options
  • Lab: Setting the Print Area
  • Appendix A: Microsoft Office Excel 2010 Exam 77-882
  • Appendix B: Microsoft Office Excel 2010 Expert Exam 77-888