Insight Analytics

Training

We can provide onsite training for all of your Excel users. Course material is geared to three levels; basic for new users, intermediate for users with some experience and advanced for experienced users who need to perform tasks in Excel that are complex and may require programming.

SpreadSheet Boot Camp I (Basic)

This training is geared to the new user. Covered topics:

  • Create a Simple Worksheet
  • Copy and Paste
  • Navigating the Worksheet
  • Searching
  • Entering Data
  • Page Layout
  • Create Formulas
  • Graphs
  • AutoSum
  • Feeze Panes
  • Formatting Cells
  • Insert Pictures
  • Format Painter
  • Worksheet Tabs
  • Naming Cells
  • Protecting Worksheets

SpreadSheet Boot Camp II (Intermediate)

This training is geared to the experienced user who needs to construct more complex workbooks. Covered topics:

  • Conditional Formatting
  • Create Pivot Tables
  • Data Validation
  • Excel Workbook Options
  • VLOOKUP / Lookup Functions
  • Form Controls
  • Complex Formulas
  • Cell Merging
  • Create Tables and Data Bases
  • Form Construction Basics
  • Create Basic Charts
  • Hyperlinking
  • Using Templates
  • 2 Axis Graphs
  • Sort and Filter Data
  • Macro Basics

SpreadSheet Boot Camp III (Advanced)

This training is geared to the advanced user who needs to construct complicated workbooks and workbook applications (for highly repetitive work). Covered topics:

  • Analyzing Data
  • Solver
  • Create Excel Applications
  • ActiveX Controls
  • Advanced Charting
  • Visual Basic Editor
  • Types of Data Files
  • Recording Macros
  • Tracing Precedents and Dependents
  • Writing and Editing Macros
  • Hiding Spreadsheet Elements
  • Looping
  • Scenarios
  • User Defined Functions
  • What-If Analysis
  • Personal.XLS

Customized Training

This training is geared toward the specific needs of a group or individual. The trainees are surveyed and then a specific syllabus is constructed based on their wishes and needs. Topics can range from formatting to formulas to VBA coding; virtually anything Excel.