Excel school training courses in Columbia, SC (public, in-house or online)

In this class, you will learn how to create, edit, format, and print basic worksheets in Microsoft Excel 2007 that include absolute and relative formulas. You’ll also learn how to format cells and cell ranges, control pages, work with multiple sheets, and even create charts with professional flair. Topics include:
â—?Explore the User Interface and the Ribbon
â—?Create Basic Formulas
â—?Manipulate Data
â—?Apply Cell Styles
â—?Set Print Options
â—?Manage the View of Large Wo...

Full archival course description>>

In this course, students create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks. (Second Edition)

Objective :
Upon successful completion of this course, students will be able to: - Explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet. - Perform calculations. - Modify a worksheet. - Format a worksheet. - Print workbook contents. - Manage large workbooks.

At Course Completion:
Upon successful completion of this course, stu...

Full archival course description>>

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual ...

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>>