In this course, you will use Microsoft Office Excel to manage, edit, and print data.

Nothing.

Lesson 1: Getting Started with Excel

                   An Overview of Excel

                   Navigate in Excel

                   Enter Data

                   Select Data

                   Save a Workbook (Compatibility Mode, Macro-enabled

                   Workbook – 2007)

                   Obtain Help

 
Lesson 2: Modifying a Worksheet

                   Move and Copy Data Between Cells

                   Fill Cells with Series of Data

                   Edit Cell Data

                   Insert and Delete Cells, Columns, and Rows

                   Find, Replace, and Go To Cell Data

                   Spell Check a Worksheet
 

Lesson 3: Performing Calculations

                   Create Basic Formulas

                   Calculate with Functions (Function

                   AutoComplete - 2007)

                   Copy Formulas and Functions

                   Create an Absolute Reference

 

Lesson 4: Formatting a Worksheet

                   Change Font Size and Type

                   Add Borders and Color to Cells

                   Change Column Width and Row Height

                   Merge Cells

                   Apply Number Formats

                   Create a Custom Number Format

                   Align Cell Contents

                   Find and Replace Formats

                   Apply an AutoFormat

                   Apply Styles (save formatting as new

                   Quick Style – 2007)

 

Lesson 5: Developing a Workbook

                   Format Worksheet Tabs

                   Reposition Worksheets in a Workbook

                   Insert, Delete and Rename Worksheets

                   Copy and Paste Worksheets

                   Copy a Workbook

 

Lesson 6: Printing Workbook Contents

                   Set a Print Title

                   Create a Header and a Footer

                   Set Page Margins

                   Change Page Orientation

                   Insert and Remove Page Breaks

                   Print a Range

 

Lesson 7: Customizing Layout

                   Split a Worksheet

                   Arrange Worksheets

                   Freeze and Unfreeze, Hide and Unhide Rows

                   and Columns

                   Hide & Unhide Worksheets

With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT training company. Through an integrated learning approach that ensures that new knowledge can be applied to real-life situations, New Horizons Ireland - Dublin and Galway - delivers a full range of computer training courses; from basic application and desktop productivity tools to complex and integrated business systems.