"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com
  • Microsoft/Microsoft Excel Level 1 Intro Duration: 1 Day

Microsoft Excel Level 1 Intro Duration: 1 Day

Course Overview

Course Objectives · Identify basic worksheet and workbook concepts and terms · Enter and edit data · Modify the worksheet · Use functions to calculate and return values · Change the page set-up to define how the printed worksheet appears · Format cells to enhance the appearance of your worksheet

 

 

 

Target student

Microsoft Excel combines a powerful spreadsheet application with the user-friendly atmosphere of

Windows. Delegates will learn the basics of creating, editing, and saving worksheets in our Essentials level class. They will work with formulas and functions to calculate and return values. Delegates will learn to change the appearance of a page, including adding headers and footers and format data.

Prerequisites

Delegates should have an understanding of the Windows operating systems.

Excel Essentials

Starting Excel

What is a Worksheet?

What is a Workbook?

Identifying Parts of the Screen

Identifying the ribbon Components

Getting Help

Opening a Workbook

Creating a New Workbook

Opening a Recently Used Workbook

Moving Around/Selecting Areas of a Worksheet

Navigating in a Worksheet

Using the Scroll Bars and Boxes

Changing Worksheets

Using Go To

Using Selection Techniques

Selecting a Range of Cells

Selecting Nonadjacent Cells and Ranges

Selecting an Entire Worksheet

Entering Data and Editing Data

Entering Text Data into a Cell

Entering Values

Entering Data into a Range

Quickly Adjusting a Column Width

Editing Data on the Worksheet

Editing the Data in a Cell

Clearing the Contents from a Cell or Range

Using Undo and Redo

Moving and Copying Data

Copying Data

Copying Data with AutoFill

Creating a Series with AutoFill

Saving/Closing a Workbook

Saving a Named Workbook

Printing a Worksheet

Closing a Workbook and Exiting from Excel

Formulae and Functions

Creating Simple Formulas

Creating a Formula by Pointing

Using Functions

Using the AutoSum Button

Using the Formula Palette

Defining Relative, Mixed, and Absolute References

Copying Formulas

Managing the Worksheet

Changing the Worksheet Structure

Deleting Cells, Rows, and Columns

Formatting the Worksheet

Changing the Appearance of Data

Changing Row Height

Applying Fonts

Adding Enhancements

Aligning Data in Cells

Merging and Centering Cells

Rotating and Indenting Text

Adding Borders and Shading

Printing the Worksheet/book

Printing a Single Worksheet

Using Print Preview

Creating Headers and Footers

Removing the Grid

Printing a Selection

Printing a Selection

Using Print Areas

Using Advanced Printing Techniques

Aligning the Printout

Fitting a Document onto a Desired Number of Pages

Working with Page Breaks

Working with Page Breaks in Normal View

Setting Print Titles

Removing Print Titles