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 3

Course Length: 1 days
Class Schedule
21/03/18 - 21/03/18

Info/Enroll

23/05/18 - 23/05/18

Info/Enroll


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

MCSEClasses.com 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.



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.