Professional Training

Prerequisites

To effectively understand this course, we recommend that you take the Microsoft Office Windows XP or Vista Introduction course or have equivalent knowledge.

Excel Essentials

Starting Excel
What is a Worksheet?
What is a Workbook?
Identifying Parts of the Screen
The Ribbon
Using Selection Techniques
Selecting a Range of Cells
Selecting Nonadjacent Cells and Ranges
Selecting an Entire Worksheet
Entering Data
Entering Text Data into a Cell
Entering Values
Entering Data into a Range
Quickly Adjusting a Column Width
Finishing a Workbook
Printing a Worksheet
Closing a Workbook and Exiting from Excel
Assignment

Formatting Text & Printing a Document

Opening a Workbook
Creating a New Workbook
Opening a Recently Used Workbook
Creating Simple Formulas
Creating a Formula by Pointing
Using Functions
Using the AutoSum Button
Using the Formula Palette
Editing Data on the Worksheet
Editing the Data in a Cell
Editing a Formula
Clearing the Contents from a Cell or Range
Using Undo and Redo
Assignment

Managing the Worksheet

Navigating in a Worksheet
Using the Scroll Bars and Boxes
Changing Worksheets
Using Go To
Changing the Worksheet Structure
Deleting Cells, Rows, and Columns
Performing a Simple Sort
Creating and Using Named Ranges
Automatically Naming Ranges
Navigating with Named Ranges
Using Range Names in Formulas
Pasting a List of Named Ranges
Deleting and Editing Range Names
Creating Named Constants
Assignment

Formatting the Worksheet

Moving and Copying Data
Copying Data
Copying Data with AutoFill
Creating a Series with AutoFill
Defining Relative, Mixed, and Absolute References
Copying Formulas
Changing the Appearance of Data
Changing Row Height
Formatting Numbers
Fonts
Adding Enhancements
Aligning Data in Cells
Merging and Centre Cells
Rotating and Indenting Text
Adding Borders and Shading
Assignment

Printing the Worksheet/book

Printing a Single Worksheet
Using Print Preview
Creating Headers and Footers
Removing the Grid
Printing a Selection
Printing a Selection
Using Print Areas
Using Advanced Printing Techniques
Aligning the Printout
Fitting a Document onto a Desired Number of Pages
Working with Page Breaks
Working with Page Breaks in Normal View
Setting Print Titles
Removing Print Titles
Assignment

New Features in Excel 2013

What’s New in Excel 2013
Compatibility
Benefits in the new version
File Types
The Ribbon
The Quick Access Toolbar
Keyboard shortcuts in Excel 2013 (KEY TIPS)
The Excel 2013 Page Layout View
Different Screen Resolutions - Solutions

Additional Features in Office 2013

Office 2013 – A New Platform
At a Glance Highlights Across the Suite
New Visual and navigational Features
File formats
User Assistance System (HELP)
Collaboration features
Themes and Quick Styles
Application-specific changes
General Keyboard Navigational Tips in Office 2013
Beyond Office 2013