Back to Home
Computer Skills

Computer Skills Courses

REQUEST MORE INFORMATION

Most employees want to perform great work. If you are constantly looking for ways to be more efficient and productive, Excel training is your answer. Microsoft Excel is a spreadsheet program that enables users to organize large amounts of data, and even perform functions like calculations, graphing, and creating pivot tables, among many other features.

With Microsoft Excel training, you gain access to a wide-range of invaluable tools. Whether you are formatting cells, protecting pertinent information, or integrating with other software tools, you will be surprised at how productive you can be.

Explore our current course offerings

Questions? Contact us at 616-233-2589 or ipex@davenport.edu for more information.

At your organization: IPEx professional development programs can be customized and delivered at your workplace, or a location of your choice. To learn more about these programs or to inquire about pricing, please contact ipex@davenport.edu.


Excel Introduction

COST: $395

LENGTH: 1 day, 8 a.m. – 5 p.m.

GRAND RAPIDS - DOWNTOWN
February 15, 2018
REGISTER

LANSING
March 29, 2018
REGISTER

DETROIT AREA
March 1, 2018
REGISTER

Learn the fundamentals of Microsoft Excel to improve your job performance.  

In this one-day workshop, you will learn to use spreadsheets, formatting tools, shortcuts, and data entry techniques to streamline and simplify everyday tasks. 

After completing this course, you will be able to:

  • Swiftly navigate Excel menus
  • Manage numerous files for quick access
  • Create workbooks and perform calculations
  • Create basic charts and graphs
  • Protect your data
  • Use key formulas and functions
  • Find and correct errors

 

 

RETURN TO TOP


Excel Formatting, Charts, and Reporting

COST: $395

LENGTH: 1 day, 8 a.m. – 5 p.m.

GRAND RAPIDS - DOWNTOWN
April 9, 2018
REGISTER

LANSING
April 26, 2018
REGISTER

DETROIT AREA
April 5, 2018
REGISTER

Create charts, use styles and templates, and manage advanced worksheet formatting. 

In this one-day workshop, you will learn how to use Excel to manage data sets, develop worksheets, and automate tasks to improve business intelligence. 

After completing this course, you will be able to:

  • Use excel to analyze numbers and track data
  • Graphically represent your information
  • Use formulas and solve formula errors
  • Apply What If Analysis tools
  • Trace precedent and dependent cells for auditing
  • Apply chart styles, filters, and data labels

 

 

RETURN TO TOP


Excel Workbooks, Functions and Formulas

COST: $395

LENGTH: 1 day, 8 a.m. – 5 p.m.

GRAND RAPIDS - DOWNTOWN
March 22, 2018
REGISTER

LANSING
May 31, 2018
REGISTER

DETROIT AREA
May 3, 2018
REGISTER

Learn to store and analyze data using Excel.

In this one-day workshop, learn to perform calculations and manage data using Excel worksheets. Reorder, summarize, combine, and analyze alternative data sets to make your worksheets perform.  

After completing this course, you will be able to:

  • Apply permissions, versions and Excel options
  • Track changes and share workbooks
  • Perform advanced formula auditing and calculations
  • Use trend lines, secondary axes, and chart templates
  • Create and manipulate a PowerView sheet

 

 

 

RETURN TO TOP


Excel Macros

COST: $395

LENGTH: 1 day, 8 a.m. – 5 p.m.

GRAND RAPIDS - DOWNTOWN
May 24, 2018
REGISTER

LANSING
June 21, 2018
REGISTER

DETROIT AREA
June 7, 2018
REGISTER

Although Excel provides hundreds of functions, you can also create your own functions by writing Excel macros to perform specific tasks.

In this one-day workshop, you will learn to record, edit, debug, and manage macros and the syntax used to create macros. We highly recommend participants have previous knowledge of Excel formulas, functions, and PivotTables. No previous macro experience is required. 

After completing this course, you will be able to:

  • Create, record, edit and debug a macro
  • Format worksheets using macros
  • Create and interactive worksheet
  • Perform custom calculations using Visual Basic Applications

RETURN TO TOP