MCSEClasses Certification Training Boot Camp Cisco Certification Training Military Discounts Testimonials About Us Linux/Unix Certification MCSD Certification Home MCSE Certification MCDBA Certification Cisco Certification Security Certification Java Certification Oracle® Certification CIW Certification Jobs Boot Camp Financing Boot Camp Pricing Boot Camp Technical Schedule Contact Us


Excel 2016 - Level 2

Course Length: 1 days

Class Schedule
Call for Class Schedule

  • Hands-on instruction by a certified instructor
  • Includes all course materials

In this course, you will become familiar with intermediate features and functionality of Microsoft Excel 2016.

Course Content

Lesson 1: Managing workbooks
  • Managing worksheets
  • Customizing Excel
Lesson 2: Named ranges
  • Using names in formulas
Lesson 3: Tables
  • Sorting
  • Filtering tables
  • Structured references
  • Validation
  • Transposing data
Lesson 4: Summarizing data
  • Consolidation
  • Subtotals
Lesson 5: PivotTables
  • Creating and formatting PivotTables
  • Manipulating PivotTables
  • PivotCharts
Lesson 6: Presentation features
  • Conditional formats
  • Custom Formats
  • Graphics
Lesson 7: Advanced charts
  • Special chart types
  • Sparklines
  • Quick Analysis
Lesson 8: Collaboration
  • Permissions
  • Shared workbooks

IPLearning.net is your best choice for Excel 2016 Level 2, Excel 2016 Level 2 training, Excel 2016 Level 2 certification, Excel 2016 Level 2 certification boot camp, Excel 2016 Level 2 boot camp, Excel 2016 Level 2 certification training, Excel 2016 Level 2 boot camp training, Excel 2016 Level 2 boot camp certification, Excel 2016 Level 2 certification course, Excel 2016 Level 2 course, training Excel 2016 Level 2, certification Excel 2016 Level 2, boot camp Excel 2016 Level 2, certification Excel 2016 Level 2 boot camp, certification Excel 2016 Level 2 training, boot camp Excel 2016 Level 2 training, certification Excel 2016 Level 2 course.




Search classes by keyword:


Search classes by category:

Copyright © 2018 Institute of Professional Learning. IPL Refund Policy. All Rights Reserved.