Using Microsoft Excel

Level 2

Course Description


 

Length: 6 hours

Prerequisites: Working knowledge of Microsoft Excel or Level 1 Course

 

           
 

Keyboard Shortcuts  

Customizing Toolbars  

Text Alignment

•  Cell Sizing
•  Aligning Cell Contents
•  Vertical Text
•  Text Control
•  Merge & Center

Clip Art

•  Inserting Clip Art
•  Word Art
•  Auto Shapes
•  Drawing Toolbar
•  Files
•  Organizational Chart
•  Forms Toolbar
•  Inserting Buttons
•  Scrollbars/Spinners
•  Assigning Macros

Using Excel as a Database

•  Common List Operations
•  Designing the Worksheet
•  Database Entry
•  Auto Filters
•  Advanced Sorting


Entering Data

•  Grouping Worksheets
•  Multiple Data Entry
•  Find Command


Protection

•  Protecting the Worksheet
•  Protecting the Workbook
•  Passwords
•  Locking & Unlocking Cells


Charting Data

•  Creating Charts Using the
   Chart Wizard
•  Creating Charts as Chart Sheets
•  Modifying Charts
•  Drawing Toolbar

Using Fill

•  Auto Fill
•  Fill Menu
•  Text
•  Dates
•  Step Value & Stop Value

  Register For This Class