Excel Essentials

Prerequisites:Students Looking to take this course should have taken an introduction to computers class or the equivelant knowledge.

Getting Started with Excel
 · Defining Workbooks
 · Defining Worksheets
 · Moving Around Worksheets

Creating Worksheets
 · AutoComplete
 · Auto Fill

Modifying Worksheets
 · Copying Worksheet Data
 · Using Drag–and–Drop
 · Moving Worksheet Data
 · Reversing Actions

Printing Worksheets
 · Defining Page Setup Options
 · Changing Print Size
 · Changing Margins
 · Creating Headers and Footers

Formatting Worksheets
 · Rows and Columns
 · Using AutoFit
 · Using Numeric Formats
 · Using the Number Format
 · Using the Date Format

Enhancing Worksheets
 · Enhancing Text
 · Borders
 · Shading Ranges
 · Removing Gridlines
 · 3–Dimensional Shapes


Formulas and Functions
 · Using Formulas
 · Editing Formulas
 · Using Cell References
 · Using Relative Cell References
 · Using Absolute Cell References
 · Using Functions
 · Using Auto Calculate
 · IF Function
 · VLOOKUP Function
 · PMT Function
 · Nesting Functions

Using Multiple Worksheets
 · Working with Multiple Worksheets
 · Moving Between Worksheets
 · Inserting and Deleting Worksheets
 · Renaming Worksheets

Styles and AutoFormats
 · Using Styles
 · Using AutoFormats

Working with Charts
 · Creating Charts
 · Formatting Charts
 · Modifying Charts
 · Modifying Objects to Charts
 · Printing Charts

Automating Excel
 · Record a Macro
 · Macro Names
 · Custom Toolbars
 · Custom Buttons
 · Keyboard Shortcuts



Close this Window

SiliconBay Training
4847 Hopyard Rd Suite #4165
Pleasanton, CA 94588
Phone: (925) 462-3277