Excel

 1 -Tracking Customer Data

Create and modify a simple worksheet. Learn the basic tools used in Excel.

L E A R N I N G  O B J E C T I V E S

•     Enter data into a worksheet
•    Navigate a workbook
•    Format a worksheet
•    Apply number and date formats
•    Enter a series of related data
•    Print a worksheet
•    Adjust the view with Zoom tools

2 -Recording Student Grades

Work with multiple worksheets created to record student grades. Manage and organize worksheets to insert, delete,  hide data and make your data easier to find. Learn about using functions in your formulas and the difference between a relative and an absolute reference.

L E A R N I N G  O B J E C T I V E S

 ·         Rearrange data on a worksheet

•      Manage multiple worksheets
•      Use functions to perform calculations
•     Use relative and absolute cell references in formulas
•      Define names for cells and ranges

3 -Data Visualization & Images

Create visually interesting worksheets. Understand when to create charts, which chart types to use, and how they are useful in understanding relationships between numbers in a worksheet. You will also learn about formatting data based on desired conditions and inserting pictures and shapes.

LEARNING OBJECTIVES

·         Insert charts

·         Use chart tools to modify charts

·         Move and size charts

·         Edit chart data

·         Add images to a worksheet

·         Apply conditional formatting