Excel school training courses in Fairbanks, AK (public, in-house or online)

This beginning level course is designed to teach you the fundamentals of Excel. We will learn the different parts of the Excel window, how to open a workbook and enter and edit data in columns and rows. Insert and delete cells and modify column width and row height. We will work with the Office Clipboard to cut, copy, and paste text. Move cells and learn to use fills instead of typing in data. Discover how formulas work. Use functions and different methods of entering functions, including paste ...

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