The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she will understand and be able to accomplish basic operations associated with developing, formatting, and using a spreadsheet.

What will you learn in this Microsoft Excel Basic Level Training?

• The course empowers the trainee to understand the basic concepts of spreadsheets and to
demonstrate the ability to use a spreadsheet application on a personal computer.
• He or she will understand and be able to accomplish basic operations associated with developing,
formatting, and using a spreadsheet.
• Additionally, trainees will be able to accomplish standard mathematical operations using
basic formulas and functions.
• The trainee will be able to demonstrate competence in using some of the features of Excel such
as filtering, managing data and creating charts.

Course Outline

OFFICE WORKSPACE BASICS

• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with Key Tips
• Using the Status Bar

INTRODUCTION TO EXCEL

• What is Excel?
• Getting to Know the Excel Window
• Moving the Cell Selector
• Opening a Workbook
• Navigating a Workbook
• Selecting Cells
• Creating Workbooks
• Saving a Workbook
• Closing a Workbook

ENTERING AND EDITING DATA

• Entering Text, Numbers, and Dates
• Editing Data
• Using AutoComplete and AutoFill
• Copying Data
• Moving and Clearing Data
• Using Undo and Redo
• Finding and Replacing Data

FORMATTING DATA
• Introduction to Formatting
• Applying Number Formats
• Applying Font Formats
• Changing Cell Alignment
• Applying Cell Styles
• Copying Formats
• Clearing Formats
• Finding and Replacing Formats

FORMATTING WORKSHEETS
• Inserting and Deleting Rows and Columns
• Inserting and Deleting Cells
• Adjusting Column and Row Sizes
• Hiding Worksheet Components
• Inserting and Deleting Worksheets
• Copying and Moving Worksheets
• Customizing Sheet Tabs
• Adding a Worksheet Background

KICK START WITH BASIC FORMULAS AND FUNCTIONS

• What are Formulas and Functions?
• Entering Formulas
• Entering Functions
• Using the Insert Function Tools
• Using AutoSum
• Copying and Moving Formulas

ADDING CHARTS AND GRAPHICS
• Creating a Chart
• Enhancing a Chart
• Modifying Chart
• Data Changing Chart
• Types Drawing
• Shapes Inserting
• Pictures Creating
• SmartArt

VIEWING AND PRINTING WORKBOOKS

• Changing View Options
• Splitting and Freezing a Worksheet
• Sorting and Filtering Data
• Customizing the Page Layout
• Adding Headers and Footers
• Modifying Page Breaks
• Previewing and Printing the Worksheet