We are happy to announce the first in a series of training programs offered at your company and customized to fit your needs!
Our half day sessions are designed to increase the confidence, skills and productivity of your staff. We’ll bring a Microsoft Certified Trainer with expertise in the version of Microsoft Excel that your company uses or is implementing.
Laptops are available for use during this hands-on workshop.
To get started, contact Pete Bednar, Director of CBI at pbednar@lakelandcc.edu / (440) 525.7541.
Excel: Basics:
Length: 4 hours | Prerequisites: None | Cost: $1195
What you can expect to learn:
o Starting Excel
o Screen Orientation
o Workbook Orientation/Navigation
o Basic Text Entry
o Saving
o Mouse Pointer Shapes
o Simple Formulas
o Text Formatting
o Number/Date Formatting
o Cell Formatting (borders & fills)
o Printing (Print Ranges, Print Titles)
o Print Preview
» top
Excel: Formulas & Functions:
Length: 4 hours | Prerequisites: Basic Excel Skills | Cost: $1195
What you can expect to learn:
o Formula Basics
o Order of Calculation
o Creating a Formula
o Relative & Absolute References
o Basic Functions
o AutoSum
o Paste Function
o If Function
o Nesting Functions
o V lookup Function
o Linking Basics
o Naming Cells
o Text Functions
o Error Values
» top
Excel: List Management Tools
Length: 4 hours | Prerequisites: Basic Excel Skills | Cost: $1195
What you can expect to learn:
o What Constitutes a List?
o Excel or Access?
o Sorting
o SubTotals
o AutoFilter
o Advanced Filtering
o Pivot Tables
o Data Validation
o Using Forms to Enter Data
» top
Excel: Charting & Drawing
Length: 4 hours | Prerequisites: Basic Excel Skills | Cost: $1195
What you can expect to learn:
o Creating a Chart
o Setting up Your Worksheet
o Embedded Charts or Chart Sheets
o Chart Wizard
o Modifying Chart Data
o Text
o Legends
o Printing a Chart
o Picture Charts
o Changing the Chart Type
o Charting on Multiple Axis
o Adding a Data Table
o Drawing Tools
o Formatting the Chart
o Fills & Lines –
o Changing the Default Chart
o Data Markers
» top
Excel: Macros
Length: 4 hours | Prerequisites: Intermediate Excel Skills | Cost: $1195
What you can expect to learn:
o Recording a Macro
o Absolute vs. Relative Recording
o Playing Back a Macro
o Saving a Macro
o Editing a Macro Using VBA
o If … Then … Else Statements
o Looping a Macro
o Prompting in a Macro
o Custom Functions
|
