Excel school training courses in Detroit, MI (public, in-house or online)

Students use the advanced features and tools of Microsoft Excel to solve problems and support decisions by effectively analyzing alternatives (e.g., using What-If analyses, comparing financial options, constructing effective charts) based on quantitative data. Students produce documents within a portfolio reflecting their ability to analyze and present documentation in a professional, business-like manner. Students also learn how to manage large amounts of data using a variety of techniques incl...

Full archival course description>>

Learn Excel 2007 basic skills. Review the new Office Ribbon interface. Enter and edit data, select cells
and ranges, print worksheets, create formulas and functions, create and modify charts, and format cell
contents. Bring USB Drive.

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

At Course Completion:
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.

Outline :
Lesson 1: Creating a Basic Worksheet
Explore ...

Full archival course description>>

Develop worksheets and embedded charts using mathematical formulae, formatting, charts, and web queries. Apply what- if- analysis to large worksheets, multiple worksheet and workbooks. Use financial functions, data table, amortization schedules, and hyperlinks.

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