651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

Excel 2016 Session 3: Functions, Formulas & More

1/2 Day

Description

NOTE: This course is only available by customer request. If you are interested in taking this course, please call 651-905-3729 or submit a request for a date.

An informative exploration of the many functions and formulas available to MS Excel users.  We’ll also learn about time effective methods for extracting summary data, such as database functions, outlining and subtotaling.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Excel 2016 Session 3: Functions, Formulas & More class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

  • Lesson 1: Working with Functions
    • Topic A: Working with Ranges
    • Topic B: Using Specialized Functions
    • Topic C:  Working with Logical Functions
    • Topic D: Working with Date/Time Functions
    • Topic E: Working with Text Functions
  • Lesson 2: Working with Lists
    • Topic A: Sorting Data
    • Topic B: Filtering Data
    • Topic C: Querying Data with Database Functions
    • Topic D: Outlining and Subtotaling Data.
  • Lesson 3: What's New in Microsoft Excel 2016
    • Topic A: Streamline Workflow in Excel Using Templates
    • Topic B: Accelerate  Data Entry with Flash Fill
    • Topic C: Incorporate Charts
    • Topic D: Analyze Data
  • Appendix 1: Microsoft Office Excel 2016 Exam 77-727
  • Appendix 2: Microsoft Office Excel 2016 Expert Exam 77-728
  • Appendix 3: Microsoft Excel 2016 Common Keyboard Shortcuts

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Excel 2016 Session 3: Functions, Formulas & More class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

Must have a good working understanding of MS Excel, either through experience, or completion of Excel 2016 Session 1: Getting Started with the Basics.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Excel 2016 Session 3: Functions, Formulas & More class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date


About us

Knowledge Transfer Consulting Services Inc. is a single-source solution provider offering a full range of Training Delivery and Training Management solutions from concept to delivery. Learn more

Find a Course

Corporate Services

Contact us

follow us on social media: