Workplace Productivity Using Excel

“Getting Started with a Spreadsheet Application

Learn to use the application.
Work with workbooks.
Understand basic spreadsheet concepts.
Utilize the functionalities of the application.

Manage Data in a Spreadsheet

Follow good practices in managing data.
Enter and edit data.
Navigate within a worksheet.
Master cell selection techniques.
Utilize copy, cut, and paste functions.
Use find and replace.
Apply sort and filter techniques.

Manage Worksheets

Insert, delete, and format rows and columns.
Insert, delete, rename, move, and copy worksheets.

Perform Calculations

Use arithmetic formulas.
Apply Excel functions.
Understand cell referencing.

Perform Formatting of Data

Format data.
Format cells.

Create Charts

Create standard charts.
Format charts.

Set Up Worksheets and Select Print Options

Adjust page options.
Configure headers and footers.
Adjust sheet display options.
Preview worksheet.
Select printing options.”