Microsoft Excel 2016 Advanced

Most organizations rely heavily on Excel to consolidate, analyze, and report data and want their employees to be proficient in this important program. This Excel training class gives you the skills you need to impress your current or future employer-and its online format means you can take this class from anywhere, at any time.

Master PivotTables & PivotCharts to summerize large amounts of data.

Record macros to automate repetitive tasks.

Build advanced formulas using IF, SUMIF, VLOOKUP, HLOOKUP, and more.

Analyze complex data using What-If Analysis and Goal Seek.

[Training Pkg #CPTRAINPKG0155a] Get The Advanced Microsoft Excel 2016 Package
(18 purchase(s) during the period from 6/31/2025 to 09/25/2026)

Training Packages Available Quarterly: 40

  • Get The Updated Study Guide (or Tutorial)
  • Earn Your Needed CEUs
  • RESELLERS: Find Out About Submitting A Custom Learning Package - info@certificationpoint.org
  • Take The Certification Exam (CertificationPoint Version)
  • Complete A Work Experience Builder (WXB) For Your Resume

   $20.00

[See All Reviews]




[Training Pkg #CPTRAINPKG0155b] Get The Advanced Microsoft Excel 2016 Package (Level II)

(5 purchase(s) during the period from 6/31/2025 to 09/25/2026)

Training Packages Available Quarterly: 40

  • Get The Updated Study Guide (or Tutorial)
  • Earn Your Needed CEUs
  • RESELLERS: Find Out About Submitting A Custom Learning Package - info@certificationpoint.org
  • Take The Certification Exam (CertificationPoint Version)
  • Complete A Work Experience Builder (WXB) For Your Resume

   $50.00

[See All Reviews]




FOR EDUCATORS: Get The Advanced Microsoft Excel 2016 Package
(2 purchase(s) during the period from 6/31/2025 to 09/25/2026)

Training Packages Available Quarterly: 40

  • Get The Updated Study Guide (or Tutorial)
  • Earn Your Needed CEUs
  • Certification Exam For Up To 10 Students (CertificationPoint Version)
  • Collaborative Work Experience Builder (WXB) For Students
  • RESELLERS: Find Out About Submitting A Custom Learning Package - info@certificationpoint.org

   $89.00

[See All Reviews]




Tutorials w/FREE Study Guide Samples:
CompTIA A+  |  Writing The Perfect Resume  |  30 Days Of React  |  Adobe InDesign  |   Advanced Microsoft Excel  |  Learning German  |  Client Server Computing  |  Coldfusion Express  |  Cascading Style Sheets (CSS)  |  Dashboards Tutorial  |  Microsoft Excel 2016 Advanced  |  Google Chrome  |  Twitter For Business  |  Microsoft Project 2019  |  CompTIA Security+


OTHER POPULAR PACKAGES YOU WILL FIND HELPFUL:
(Note: New Training. Learning. & Experience. Builder Packages Added Frequently)


PROJECT MANAGEMENT

Certified Scrum Master  |   PMI Project Management Professional  |   PMI Professional in Business Analysis (PBA)


SEARCH

Google Certified Professional Cloud Architect


SECURITY

EC-Council Certified Ethical Hacker   |   CompTIA Security+  |   ISACA Cybersecurity Fundamentals  |   GIAC Information Security Fundamentals (GISF)  |   (ISC)2 Systems Security Certified Practitioner (SSCP)  |   CompTIA Pentest+  |   CISSP (Certified Information Systems Security Professional)   |   CISA (Certified Information Systems Auditor)   |   CISM (Certified Information Security Manager)


NETWORKING

CompTIA Network+  |   CCNP Routing and Switching


DATABASES

Oracle Certified Professional Database Administrator (OCP - DBA)


INFORMATION TECHNOLOGY (Dev, Web, AI, & Other)

Information Technology Infrastructure Library (ITIL)  |   TOGAF 9 Certification – Foundation  |   Certification of Professional Achievement in Data Sciences  |   Certified Analytics Professional (CAP)  |   Dell EMC Data Science Associate (EMCDS)  |   SAS Certified Data Scientist  |   Microsoft Certified: Azure Data Scientist Associate  |   Microsoft Certified Azure Fundamentals  |   IIBA Certification in Business Data Analysis (CBDA)  |   IIBA-CBDA Competencies  |   IQBBA Certified Foundation Level Business Analyst (CFLBA)  |   Certified Professional for Requirements Engineering (CPRE)  |   HBS Online Business Analytics Programme  |   Puppet Certified Professional  |   Microsoft Certified: DevOps Engineer Expert  |   Linux Foundation Certified System Administrator (LFCS)  |   Red Hat Certified Specialist in OpenShift Administration (EX280)  |   FinOps Certified Practitioner (FOCP)  |   Prometheus Certified Associate (PCA)  |   CCC Internet Of Things Foundation Certification  |   CertNexus Certified Internet Of Things Practitioner  |   CertNexus Certified Internet Of Things Security Practitioner  |   Microsoft Certified Azure IoT Developer  |   Arcitura Certified IoT Architect  |   AWS Internet Of Things Foundation Series  |   IBM AI Engineering Professional Certificate  |   IBM Data Science Professional Certificate  |   IBM Data Analyst Professional Certificate  |   Microsoft Certified: Azure AI Engineer Associate  |   Microsoft Certified: Azure AI Fundamentals  |   Full Stack Java Developer  |   IBM Full Stack Cloud Developer  |   IBM DevOps and Software Engineering Professional Certificate  |   Full-Stack Web Development With React Specialisation


CLOUD/VIRTUALIZATION RELATED

Dell EMC Cloud Architect  |   Cloudera Certified Spark and Hadoop Developer (CCHD)  |   Cloudera Certified Associate (CCA) Data Analyst  |   Cloudera Certified Professional (CCP) Data Administrator  |   Amazon Web Services Solutions Architect - Associate  |   Google Associate Cloud Engineer  |   IBM Certified Technical Advocate - Cloud v3  |   Cloud Security Alliance: Certificate of Cloud Security Knowledge (CCSK)  |   Cloudera Certified Spark and Hadoop Developer (CCHD)  |   AWS Certified DevOps Engineer - Professional  |   Certified Kubernetes Administrator (CKA)  |   Docker Certified Associate (DCA)  |   Certified Kubernetes Application Developer (CKAD)  |   Certified Kubernetes Security Specialist (CKS)  |   HashiCorp Certified Terraform Associate  |   HashiCorp Certified: Vault Associate  |   Red Hat Certified Engineer (RHCE) exam (Ansible Certification)  |   VMware VCP6-DCV  |   Citrix Certified Professional - Virtualization (CCP-V)


BLOCKCHAIN & CRYPTOCURRENCY

Certified Blockchain Architect (Blockchain Council)  |   Certified DAO Expert (Blockchain Council)  |   Certified Blockchain Developer (Blockchain Council)  |   Certified Smart Contract Developer (Blockchain Council)


TUTORIAL SET #2


CertificationPoint WXB Carousel






Feedback Request:
Full Name:
Email:
Which of the following sections would you like to receive additional information about?




  Career Readiness, Growth, & Development Insights

  BLOG ARTICLES 

Subject: The biggest issue with internships isn't whether or not they're paid
Date: Monday, September 26, 2016
Article Content: I don't know where I developed this stereotypical notion, but to me the word 'internship' meant photocopying documents, taking lunch orders, and making hazelnut coffee for my boss.  [Read More...]

View All Content

 REGION1 
Experience Builders (Posted):
  [CAPSTONE OPPORTUNITY] Applying Project Management Techniques in the Real World
Budget: $0-$0 ->  4 STUDENT Proposals   JOIN In?   
  VIEW All Region 1 Opportunities    CREATE An Opportunity 

  September 2026 Stats  ->  73 NEW Opportunities Available Today 
  ->  44 Work Experience Builders In Progress 
  MONTHLY TOP SCHOOL: University of the Pacific (CA)
 MONTHLY TOP Business: T-Mobile USA
 MONTHLY TOP Experience: Website Management

 REGION2 
Experience Builders (Posted):
  Looking for Our Future Hire(s) Via Several Taskings Part 1- Contact Form
Budget: $0-$50 ->  1 STUDENT Proposals   JOIN In?   
  VIEW All Region 2 Opportunities    CREATE An Opportunity 

  September 2026 Stats  ->  63 NEW Opportunities Available Today 
  ->  46 Work Experience Builders In Progress 
  MONTHLY TOP SCHOOL: University of Central Oklahoma (OK)
 MONTHLY TOP Business: Hewlett Packard Corp.
 MONTHLY TOP Experience: Graphic Design

 REGION3 
Experience Builders (Posted):
  Website Development Needed
Budget: $350-$650 ->  2 STUDENT Proposals   JOIN In?   
  VIEW All Region 3 Opportunities    CREATE An Opportunity 

  September 2026 Stats  ->  53 NEW Opportunities Available Today 
  ->  37 Work Experience Builders In Progress 
  MONTHLY TOP SCHOOL: DePaul University (IL)
 MONTHLY TOP Business: Workiva
 MONTHLY TOP Experience: Website Management

 REGION4 
Experience Builders (Posted):
  Marketing Support Needed
Budget: $500-$500 ->  2 STUDENT Proposals   JOIN In?   
  VIEW All Region 4 Opportunities    CREATE An Opportunity 

  September 2026 Stats  ->  39 NEW Opportunities Available Today 
  ->  23 Work Experience Builders In Progress 
  MONTHLY TOP SCHOOL: Old Dominion University (VA)
 MONTHLY TOP Business: VantagePoint AI
 MONTHLY TOP Experience: Data Analyst

 REGION5 
Experience Builders (Posted):
  Website Development Needed
Budget: $700-$1500 ->  0 STUDENT Proposals  UPLOAD Proposal?   
  VIEW All Region 5 Opportunities    CREATE An Opportunity 

  September 2026 Stats  ->  47 NEW Opportunities Available Today 
  ->  33 Work Experience Builders In Progress 
  MONTHLY TOP SCHOOL: Northeastern University (MA)
 MONTHLY TOP Business: Guardicore
 MONTHLY TOP Experience: Graphic Design

 REGION6 
Experience Builders (Posted):
  Website Development Needed
Budget: $120-$400 ->  2 STUDENT Proposals   JOIN In?   
  VIEW All Region 6 Opportunities   -   CREATE An Opportunity 

  September 2026 Stats  ->  39 NEW Opportunities Available Today 
  ->  22 Work Experience Builders In Progress 
  MONTHLY TOP SCHOOL: Heidelberg University (Germany)
 MONTHLY TOP Business: Volkswagen
 MONTHLY TOP Experience Gained: Website Management

    COMPANY SPOTLIGHT 

  Name:
Kimpton Hotels & Restaurants

  Headquarters: California
  View Company Profile


  Popular Tutorials For Learning: 
  - How To Write A Resume
  - CompTIA A+ Complete Study Guide   -> [Advanced]
  - Building Dashboards Tutorials
  - Advanced Microsoft Excel   -> [Hands-On]
  - Windows Powershell Cookbook 3rd Edition
  - Python Tutorial   -> [Hands-On]
  - How To Use Twitter For Business
  - View All Tutorials

    80 'CertPointeers' Actively Completing Tutorials 
 

  Available Cert Exams:
  Exam Sample  Take An Online Exam


    19 'CertPointeers' Actively Taking Certifications 
 

  Virtual Courses:
  On Demand: Miscellaneous (Optional)
  All Courses (Region 3)


    46 'CertPointeers' Actively Taking Courses 
 

Recent Members' CollabTalk:
Term Of The Day: Multimedia

Multimedia is the use of computers to present text, graphics, video, animation, and audio in an integrated format. It is contrasted with traditional mass media, which typically consists of separate print, video, or audio materials like newspapers, television, or radio.
Learn More
#terms #news #edtech #learning


Sign-Up & Begin Connecting w/Other Students In Your Region


    1016 'CertPointeers' Actively Chatting & Collaborating 
 
cannot select DB