Excel school training courses in Columbus, OH (public, in-house or online)

Introduction to Excel focuses on basis concepts. You will create and edit spreadsheets by entering data, formatting the data, and using formulas to do automatic calculations. You will also learn to enhance your spreadsheets with charting tools to present the data in line graphs, pie charts, bar charts, and more. The workshop assumes participants understand how to use a mouse and drop-down menus, save files to some type of storage media, and perform other basic skills required to run Windows prog...

Full archival course description>>

Program Fundamentals

Starting Excel 2010

What’s New in Excel 2010

Understanding the Excel Program Screen

Giving Commands

Using Command Shortcuts

Creating a New Workbook

Opening a Workbook

Previewing and Printing a Worksheet

Saving a Workbook

Closing a Workbook

Using Help

Exiting Excel



Getting Started with Worksheets

Navigating a Worksheet

Entering Labels and Values
Full archival course description>>

Each student will receive:

A printed courseware manual for use during and after class.
Access to a searchable, electronic version of the courseware manual for reference after class (available for 12 months after class.)
Access to a Microsoft Excel 2010 eLearning course for reviewing course topics after class (available for 12 months after class.)
A PC headset for communicating with your instructor and fellow students during your Microsoft Excel 2007 Training Class
A cours...

Full archival course description>>

This course will cover getting started with Excel 2007. In this course, students will focus on manipulating and formatting data and reviewing and printing spreadsheets. The training also teaches Excel 2007 formulas, functions, charts, pictures, themes, styles, advanced formatting, advanced data management, advanced customization and how to analyzing data and to protect and share Excel 2007 workbooks.

1.Visual Basic Editor A.Visual Basic for Applications
B.Object programming
C.The Object Browser

2.Programming basics A.Data basics
B.Scope of variables
C.Scope of procedures

3.Control structures A.Decision structures
B.Loop structures

4.Custom dialog boxes A.User forms
B.Events

5.Debugging and error handling A.Errors
B.Debugging
C.Error handling