Information

Price: $29.00

Views: 55

Rating:
  • Resold modules appear on your website. You earn syndication share from each purchase.

    Contact Coggno to learn more on how to embed your own Portable Webshop in your website.

  • What is syndication?
  • Syndication FAQs

Excel Advanced 2016

Preview    

Become a Microsoft Excel expert with this easy to follow course featuring 9-hours of professionally produced videos. Exercise and demo files included.

  • Practice what you learned with included exercise files
  • Detailed easy instruction to master Microsoft Excel 2016
  • A full 9 hours of professional video instruction
  • 60+ easy to follow how-to videos
  • Everything explained step-by-step for quick comprehension
  • The next step after completing Microsoft Excel 2016 for Beginners
  • Learn how to import and export data to and from Excel
  • Learn how to create various charts and graphs
  • Effectively create and use functions and formulas
  • Import and export data 
  • Create and effectively use Pivot Tables
  • How to use Excel for data analysis
  • Discover practical methods for financial & statistical functions 

This course is designed for students that are already familiar with Excel, but wish to improve their skills and open the possibilities with this versatile spreadsheet program. Bring your basic knowledge of Excel 2016 and learn how to reach the next level of database tracking and reporting.

Contents and Overview

Through 57 lectures and over 9-hours of content, this course will take you through learning how to use functions in everyday work environments. Professional financial functions are covered including payments, future value and depreciation. Students will learn statistical functions like averages, percentiles, and regression.

In order to improve efficiency, students will also cover concepts for connecting to external data like other workbooks or web data; tables including style, selection and sizing. Pivot tables and data analysis will be key concepts helpful to the work environment.

For help with reporting, students will learn surface charts, stock charts, radar charts and bubble charts and graphs.

Upon completion of this course, students will be able to create colorful charts and databases that communicate data and financial records efficiently and effectively. Students will be able to apply data to various reporting forms like tables, graphs and pivot tables in order to show important analysis like depreciation, percentiles and regression for use with planning. Students who finish this course will have an advanced knowledge of the versatility of Excel that is immediately applicable to their work with the database.

 

 

$29.00
:

Included Modules

Chapter 1: Prerequisites of the Course and Version of Excel


Chapter 1: Course Structure


Chapter 2: Functions - Part 1


Chapter 2: Functions - Part 2**


Chapter 2: Autosum**


Chapter 3: How Date and Time Works


Chapter 3: Basic Date and Time Functions


Chapter 3: Complex Date and Time Functions


Chapter 4: Using Text Functions - Part 1


Chapter 4: Using Text Functions - Part 2


Chapter 5: Using Logical Functions


Chapter 5: Exercise 01


Chapter 6: HLOOKUP Function


Chapter 6: VLOOKUP Function**


Chapter 6: Exercise 02**


Chapter 7: Financial Functions and Terminology


Chapter 7: Personal Financial Functions


Chapter 7: Professional Financial Functions


Chapter 7: Depreciation


Chapter 7: Exercise 03


Chapter 8: Statistical Functions for Description - Part 1


Chapter 8: Statistical Functions for Description - Part 2


Chapter 8: Statistical Functions for Forecasting - Part 1


Chapter 8: Statistical Functions for Forecasting - Part 2


Chapter 8: Exercise 04


Chapter 8: One Click Forecasting


Chapter 8: Statistical Functions for Inference


Chapter 9: Connecting to Other Workbooks**


Chapter 9: Connecting to Access Databases


Chapter 9: Connecting to Web Data Sources


Chapter 9: Get and Transform


Chapter 10: Introduction to Tables


Chapter 10: Working with Tables


Chapter 10: Table References


Chapter 10: Table Styles


Chapter 11: Introduction to Pivot Tables


Chapter 11: Filters and Slicers


Chapter 11: Pivot Charts


Chapter 11: Exercise 07**


Chapter 12: What If Analysis


Chapter 12: Scenario Manager**


Chapter 12: Goal Seek


Chapter 12: Solver**


Chapter 12: Exercise 08**


Chapter 13: Area Charts**


Chapter 13: Surface Charts**


Chapter 13: Radar Charts**


Chapter 13: Bubble Charts**


Chapter 13: Stock Charts


Chapter 13: Exercise 09**


Chapter 14: Introduction to Excel Web App


Chapter 14: Using the Excel Web App


Chapter 15: Closing Message