Summary

This training course is divided into two parts: Microsoft Excel Essential provides Participants with the fundamental understanding of the Microsoft Excel environment and the ability to complete tasks independently. Microsoft Excel Expert provides Participants advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program’s full features – critical skills for those in roles such as accountants, financial analysts, and commercial bankers.

Learning Goals

Image

This course will enable participants to demonstrate the correct application of the principal features of Microsoft Excel by creating and editing a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Participants will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Microsoft Excel environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

Topics Covered

Image

For Microsoft Excel Essentials

  1. Create and Manage Worksheets and Workbooks
  2. Manage Data Cells and Ranges
  3. Create Tables
  4. Perform operations with formulas and functions.
  5. Create chart and objects.

For Microsoft Excel Expert

  1. Manage Workbook Options and Settings
  2. Apply Custom Data Formats and Layouts
  3. Create Advanced Formulas
  4. Create Advanced Charts and Tables

What Attendees Get

Image
  1. Class notes handout
  2. Course certification of completion
  3. Pre-Assignment, Pre/Post-Assessment
  4. Familiarity with features of Microsoft Excel Office.
Image

Who will benefit?

Anyone seeking working and advanced knowledge of Microsoft Excel.

  1. Accountants
  2. Financial Analysts
  3. Commercial Bankers
  4. Data Analysts
  5. Business Analysts
Image

Prerequisites

Computer literate with access to personal computer.

Professional Development Units (PDUs) and Scrum Education Units (SEUs)

Not available for this course.

Image

Exam & Certification Details

Not available for this course.

What you get

Not available for this course.

Image
X