MCSEClasses Certification Training Boot Camp MCSE MCSD MCDBA Cisco CIW Linux Oracle Java Security 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 2013 - Level 2

Course Length: 1 days
Class Schedule
Call for Class Schedule

Upon successful completion of this course, students will be able to:

  • use advanced formulas.
  • organize worksheet and table data using various techniques.
  • create and modify charts.
  • analyze data using PivotTables, Slicers, and PivotCharts.
  • insert and modify graphic objects in a worksheet.
  • customize and enhance workbooks

Course Content

Lesson 1: Calculating Data with Advanced Formulas
  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data
Lesson 3: Presenting Data Using Charts
  • Create a Chart
  • Modify Charts
  • Format Charts
Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing the Excel Environment
  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates

MCSEClasses.com is your best choice for Excel 2013 Intermediate Level 2, Excel 2013 Intermediate Level 2 training, Excel 2013 Intermediate Level 2 certification, Excel 2013 Intermediate Level 2 certification boot camp, Excel 2013 Intermediate Level 2 boot camp, Excel 2013 Intermediate Level 2 certification training, Excel 2013 Intermediate Level 2 boot camp training, Excel 2013 Intermediate Level 2 boot camp certification, Excel 2013 Intermediate Level 2 certification course, Excel 2013 Intermediate Level 2 course, training Excel 2013 Intermediate Level 2, certification Excel 2013 Intermediate Level 2, boot camp Excel 2013 Intermediate Level 2, certification Excel 2013 Intermediate Level 2 boot camp, certification Excel 2013 Intermediate Level 2 training, boot camp Excel 2013 Intermediate Level 2 training, certification Excel 2013 Intermediate Level 2 course.



mcseclasses home | technical schedule | application schedule | class outlines | mcse, mcdba, mcsd training | microsoft .net | cisco certification | security training | ced solutions oracle® certification training | linux, unix, aix | comptia certification | webmaster training | pricing | locations | financing | instructors needed | e-mail us





Search classes by keyword:


Search classes by category:

Copyright © 2018 CED Solutions. CED Solutions Refund Policy. All Rights Reserved.