| |
We offer both beginner and
intermediate skill levels. Here are some examples of the
topics offered in our Excel Training Workshops..
Beginner Excel Skills:
Recommended Time: 4 hour block
Identify the components of Excel
Working with Workbooks and Worksheets
Entering Data and Editing
Creating Simple Formulas
Formatting Cells
Using Simple Functions: Max, Min, Average, Dates and Times
Intermediate Excel Skills:
Recommended Time: 4-6 hour block
Rotating text- using fill handles
Increase column widths
Copying a range of cells to a none adjacent area
Using drag & drop to move on copy cells
Inserting rows/columns
Entering numbers with a format symbol
Freezing worksheet titles
Absolute versus relative addressing
Using the Functions: Max, Min, If, Lookup, Loan Amortization
Conditional formatting
Copying formulas using drag/fill handle
Formatting: numbers, fonts
Use background colors
3-d pie chart
Changing colors in chart
Goal seeking
Analyzing
Validation: Adding Drop Down boxes to spreadsheets
Macros
Intermediate Excel Skills: Using Excel as a Database:
Recommended Time: 2 hour block
Creating a simple database using an excel spreadsheet
Learning to Use Filters and Sorting
Text to Columns
Data Tracking using the template Wizard
|