Excel 2010/365 - Level 1

Duration:  Instructor Led Learning - 1 Days

At Course Completion:

  • Upon successful completion of this course, students will be able to:
  • Create a set of basic worksheets
  • Perform basic calculations on an Excel worksheet
  • Modify the Excel cells and worksheets for formatting
  • Change the appearance of data within a worksheet
  • Manage Excel workbooks  for filing and printing
  • Print the contents of an Excel worksheet or specific areas within the worksheet

Excel 2010 Beginning Outline:


Lesson 1: Getting Started with Excel

Work with the Elements of the Excel Interface
Navigate, Select and Move Cells in Worksheets
Format the Excel Interface for Cleaner Entry
Create a Basic Worksheet from Scratch

Lesson 2: Performing Calculations in an Excel Worksheet

Create Basic Formulas in a Cells
Insert and Replicate Functions in a Worksheet
-use Formulas for Additional Sheets and Workbooks

Introduce basic ‘If’ Functions for Data Analysis

Lesson 3: Modifying an Excel Worksheet

Edit Worksheet Cell Data
Find and Replace
Activate Worksheet Elements
for Linking Cells

Lesson 4: Modifying the Appearance of a Worksheet

Apply Font Properties
Add Borders and Colours to Cells
the Contents
in a Cell
Text, Number and Date
Apply Cell Styles
and Conditional Formats

Lesson 5: Managing an Excel Workbook

Manage Worksheets and Workbooks
View Worksheets and Workbooks

Lesson 6: Printing Excel Workbooks

Design the Page Layout and Themes
Print a Workbook
or Regions of Cells


 View Excel Intermediate 2010 Outline

Excel 2010 Level 1 Outline.pdf Excel 2010 Level 1 Outline.pdf
Size : 177.281 Kb
Type : pdf