This is a hands-on training that provides students with the knowledge and skills required to work with cell, row, column, table, text, formula, Absolute Addresses, Relative addresses and built-in functions, manage large data set and present the data using charts and graphs, using spell checker, sorting and filtering data, creating and modifing a chart, customizing printout and adding header and footer.
Prerequite: Familiar with Microsot product such as Word and basic computer skills.
Topics:
Getting Started with Programs
Sharing Common Elements
Starting Excel
Exiting Excel
Using the Quick Access Toolbar
Using the Ribbon
Getting Help
Working with Files
Printing Files
Understanding Basic Excel Terminology
Creating a New Blank Workbook
Opening Workbooks
Closing a Workbook
Saving Workbooks
Managing Your Files
Entering Data in the Worksheet
Moving Around the Worksheet
Manipulating the Information
Selecting Cells
Making Changes to the Contents
Using Undo, Redo, or Repeat
Copying and Moving Data
Using AutoFill
Changing the Column Widths
Adjusting the Row Height
Inserting or Deleting Rows, Columns, or Cells
Managing Worksheets
Working with Formulas
Creating Simple Formulas
Using Common Built-In Functions
Using Absolute & Relative Addresses
Being Careful with Formulas
Formatting a Worksheet
Formatting Numbers and Decimal Digits
Changing Cell Alignment
Changing Fonts and Sizes
Applying Cell Borders
Applying Colors and Patterns
Using Styles
Using the Format Painter
Using Miscellaneous Tools
Using the Spell Checker
Sorting Data
Working with Charts
Understanding Charts
Getting Ready to Print
Previewing the Worksheet
Adding Page Breaks
Customizing the Printout
Printing the Worksheet
Venue:
Location: NR Computer Learning Center,
2100 W. Orangewood, #110, Orange, CA
Date: 6/26, 7/3, 7/10 (3 Sat) Time: 8:30 AM to 12:30 PM Phone: (714) 505-3475
Cost $149 pre-register online before 5/31 $169 after 5/31
Home
