Location

Community Services & Continuing Education - Alexandria

Objectives

• This course aims to provide new users with the essential skills needed to perform common tasks in Excel, Create a basic worksheet by using Microsoft Excel ,Perform calculations in an Excel worksheet ,Modify an Excel worksheet ,Modify the appearance of data within a worksheet ,Manage Excel workbooks.

Outcomes

Upon successful completion of this course, students will be able to: Identify the Elements of the Excel Interface Navigate and Select Cells in Worksheets Customize the Excel Interface Create a Basic Worksheet Create Formulas in a Worksheet Insert Functions in a Worksheet Reuse Formulas Edit Worksheet Data Find and Replace Data Manipulate Worksheet Elements

Course Contents

• The Basics:- Creating a New Workbook- Navigating in Excel- Moving the Cell Pointer - Using Excel Menus - Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars - Entering Values in a Worksheet and Selecting a Cell Range Previewing and Printing a - Worksheet Getting Help from the Office Assistant - Saving a Workbook & Re-opening a saved workbook• Formatting a Worksheet- Creating Headers, Footers, and Page Numbers- Adjusting Page Margins and Orientation - Adding Print Titles and Gridlines, rows to repeat at top of each page - Formatting Fonts & Values- Adjusting Row Height and Column Width- Changing Cell Alignment- Adding Borders- Applying Colors and Patterns - Using the Format Painter - Using AutoFormat- Merging Cells, Rotating Text, and using AutoFit - Using AutoFill• Managing your workbooks- Switching Between Sheets in a Workbook - Inserting and Deleting Worksheets- Renaming and Moving Worksheets- Protecting a Workbook - Hiding Columns, Rows and