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
Re
-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
Cell
Data
Activate Worksheet Elements
for Linking Cells


Lesson 4: Modifying the Appearance of a Worksheet

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


Lesson 5: Managing an Excel Workbook

Manage Worksheets and Workbooks
View Worksheets and Workbooks
as HTML


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