Microsoft Excel
Level 1


Outcomes

Participants will learn basic worksheets skills and how to work with data in worksheets. Participants will learn how to use an electronic spreadsheet to create basic data reports

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session



          Getting Started with Microsoft Excel
          Working with an Existing Workbook

          Creating a New Workbook

          Modifying the Worksheet

          Working with Columns and Rows

          Working with Cell Contents

          Using Formulas
          Creating and Using Formulas
          Using Absolute Cell References

          Using Functions
          Creating and Using Functions

          Using the Paste Function Command
          Sorting and Filtering Data
          Sorting Data

          Filtering Data

          Formatting Worksheets
          Formatting Cells
          Formatting Worksheet Elements

          Working with Charts

          Creating Charts

          Modifying Charts

          Setting Print Options

          Changing Page Setup

          Previewing the Workbook




Performance-based objectives
  • Open and move around within and Excel Workbook and learn navigation skills necessary for creating and using Excel spreadsheets.
  • Organise columns and rows to accommodate information and edit the contents of cells to organise the information on your worksheet.
  • Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference.
  • Use functions to create complex formulas.
  • Sort information to arrange data in ascending or descending order use filters to display specific information from a list.
  • Format cells and worksheet elements to make the workbook consistent and readable.
  • Create charts to show data graphically.
  • Change the page setup and preview the workbook to define how the printed worksheet appears.



This course is not available on our public schedule, call us on 1800 456 002 or EMAIL to book this course


 
About our courses About Us Contact Us Education Outlines Schedule By Course© iTeam 2017