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

Excel 2016 Session 4: Tables, Charts & Formatting

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.

Learn how to use MS Excel’s IF function to aid you in the data formatting process.  We also examine defining data ranges as tables to streamline construction and more fully utilize MS Excel’s sorting and filtering tools.

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 4: Tables, Charts & Formatting 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: Analyzing Data
    • Topic A: Creating and Modifying Tables
    • Topic B: Applying Intermediate Conditional Formatting
    • Topic C: Applying Advanced Conditional Formatting
  • Lesson 2: Visualizing Data with Charts
    • Topic A: Creating Charts
    • Topic B: Modifying and Formatting Charts
    • Topic C: Using Advanced Chart Features
  • Lesson 3: What’s New In 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 Expert Exam 77-728
  • Appendix 2: Microsoft Excel 2016 Common Keyboard Shortcuts
  • Appendix 3: Financial Functions
  • Appendix 4: Working with Graphic Objects
  • Appendix 5: Microsoft Office Excel 2016 Exam 77-727

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 4: Tables, Charts & Formatting 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 4: Tables, Charts & Formatting 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: