Computer Technology

   >

Computer Technology 

   >

Microsoft Excel Basic

Microsoft Excel Basic

Duration (Days)

1

Overview

This course is designed to help participants to create and edit basic worksheets and workbooks. Participants will gain the necessary skills to create, edit, format and print basic excel worksheets.

Objectives
  • Create basic worksheets using excel

  • Perform calculations in an excel worksheet

  • Modify an excel worksheet

  • Modify the appearance of data within a worksheet

  • Manage excel workbooks

  • Print the content of an excel worksheet

Course Outline
  • Excel basics

  • Columns, row, cells and ranges

  • Ribbon

  • Backstage view

  • Save and save as

  • Entering data

  • Creating and editing formulas and functions

  • Formatting and proofing

  • Excel formula

  • Formula bar

  • Mathematical operators

  • Functions

  • Functions library

  • Undo and redo commands

  • Autofill

  • Cut, copy and paste

  • Transpose option

  • Preview

  • Clear button Insert, manipulate and delete cells, columns and rows

  • Search for and replace data

  • Find command

  • Replace command

  • Modify fonts

  • Borders and colour

  • Number formats

  • Align cells

  • Printing and page setup

  • Multiple file and large workbook tools