Excel school training courses in Charlotte, NC (public, in-house or online)

Upon successful completion of this course, students will be able to:
enhance productivity and efficiency by streamlining your workflow.
collaborate with others using workbooks.
audit worksheets.
analyze data.
work with multiple workbooks.
import and export data.
use Excel with the web.
structure workbooks with XML.

Course Content

Lesson 1: Streamlining Workflow
Topic 1A: Create a Macro
Macros
The Record Macro Dialog Box
How to Create a Macro
T...

Full archival course description>>

Getting Started
Introducing Visual Basic for Applications
Recording a Macro
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor

Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Funct...

Full archival course description>>

When you have completed this Business Analytics course, you will be able to:

•Create PivotTables and PivotCharts and apply conditional formatting
•Convert spreadsheets into tables, adding conditional formats and charts
•Connect to external data using Office data connections and SharePoint
•Create SharePoint dashboards that display data from multiple sources
•Add key performance indicators and reports to your dashboards
Effective business analysis skills are essential, and w...

Full archival course description>>

When you have completed this Excel course, you will be able to:

•Design your own charts
•Utilize Excel’s "What-if" analysis tools
•Analyze data using pivot tables
•Exchange data with other programs
•Share Excel files and incorporate web information
•Program Excel macros
•Customize Excel and utilize advanced worksheet management features
Excel computing skills are essential, and with lecture and demonstration this hands-on training course is designed to ...

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