Microsoft Excel 2016 Expert

Customizable Training Materials


Microsoft Excel 2016 Expert

Microsoft Excel 2016 Expert

Easily edit and re-brand as your own!

$597.00

Each course kit now includes:

Training manuals and instructor's guide
Powerpoint slides and flip chart notes
Workshop activities and exercises
Plus e-learning with source files

 

 Download A FREE Course

Participants will gain an 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.

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

 

 


Course Outline

Module One: Manage Workbook Options and Settings
  • Manage Workbooks
  • Manage Workbook Review
Module Two: Apply Custom Data Formats and Layouts
  • Apply Custom Data Formats and Validation
  • Apply Advanced Conditional Formatting and Filtering
  • Create and Modify Custom Workbook Elements
  • Prepare a Workbook for Internationalization
Module Three: Create Advanced Formulas
  • Apply Functions in Formulas
  • Look up data using Functions
  • Apply Advanced Date and Time Functions
  • Perform Data Analysis and Business Intelligence
  • Troubleshoot Formulas
  • Define Named Ranges and Objects
Module Four: Create Advanced Charts and Tables
  • Create Advanced Charts
  • Create and Manage Pivot Tables
  • Create and Manage PivotCharts

Each courseware kit contains everything
you need to teach workshops:
Trainer's Guide
Workbooks
Powerpoint Slides
Activities
Exercises
And More!
Lifetime License – Unlimited Audience
Lifetime License – Unlimited Audience
Fully Customizable - Print on Demand
No per user fees or monthly subscription
No Costly Certification process

Courseware.com is relied upon by hundreds of companies worldwide!

  • Since purchasing the course material I have already made my money back by conducting training in both customer service and workplace harassment. Both courses went very well. I am very happy with the material!

    Ashley Willis,
    Houston Training Solutions

    The training products I received from your company are fantastic! I am thoroughly impressed and they have far exceeded my expectations in quality and professionalism. The customer service and attention to detail provided is outstanding! You designed a training package that more than meets my needs. Thank you!

    Pamela Wiggins
    Wiggins Management & Consulting, LLC
  • Thank you so much for your note, and for the professionalism of all the Corporate Training Materials team, that made my dealing such a very pleasant experience.

    Mohamed Abdelrazek,
    Independent Trainer

    Thanks for the excellent experience we had with your organization.
    I know, it's been a year already and all what we have experienced is EXCELLENCE. We are very, very pleased and it was one of the best investments that we had during last year. I thank you again for the great assistance your material were to us, and for the great investment we had with your organization.

    Maisa Karkotli
    OUSOS HR & Institutional Development
  • When I came upon your training library I was intrigued. I not only purchased the soft skills package, my VP of HR suggested we get the Microsoft package as well.

    Peggy Ann Anderholm
    Manager, Education and Workforce Development
    Marvin Windows and Doors

    Thank you so very much for the entire set. I am very happy to see how professionally you have made each training module. I am sure this will help me a lot to start my training business. It has really saved my time.

    Charuhas