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 2013 - Level 3

Course Length: 1 days

Class Schedule
Call for Class Schedule

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

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

  • enhance productivity and efficiency by streamlining the workflow.
  • collaborate with other workbook users.
  • audit worksheets and analyze data.
  • work with multiple workbooks.
  • import and export data.
  • integrate Excel data with the web.

Course Content

Lesson 1: Streamlining Workflow
  • Update Workbook Properties
  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
Lesson 2: Collaborating with Other Users
  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access
Lesson 3: Auditing Worksheets
  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline
Lesson 4: Analyzing Data
  • Create a Trendline, Sparklines, and Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links
Lesson 6: Importing and Exporting Data
  • Export Excel Data
  • Import a Delimited Text File
  • Import and Export XML Data
Lesson 7: Integrating Excel Data with the Web
  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query

IPLearning.net is your best choice for Excel 2013 - Level 3, Excel 2013 - Level 3 training, Excel 2013 - Level 3 certification, Excel 2013 - Level 3 certification boot camp, Excel 2013 - Level 3 boot camp, Excel 2013 - Level 3 certification training, Excel 2013 - Level 3 boot camp training, Excel 2013 - Level 3 boot camp certification, Excel 2013 - Level 3 certification course, Excel 2013 - Level 3 course, training Excel 2013 - Level 3, certification Excel 2013 - Level 3, boot camp Excel 2013 - Level 3, certification Excel 2013 - Level 3 boot camp, certification Excel 2013 - Level 3 training, boot camp Excel 2013 - Level 3 training, certification Excel 2013 - Level 3 course.




Search classes by keyword:


Search classes by category:

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