Excel 2010 Level 3
Request a Class
9:00am - 4:30pm
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
AUDIENCE AND PREREQUISITES
Certification: MOS: Microsoft Office Excel 2010 Exam 77-882, MOS: Microsoft Office Excel 2010 Expert Exam 77-888
Upon successful completion of this course, students will be able to:
*Enhance productivity and efficiency by streamlining the workflow.
*Collaborate with other workbook users.
*Work with multiple workbooks.
*Import and export data.
*Integrate Excel data with the web.
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
PREREQUISITE COURSESFOLLOW UP COURSES
*Course cost listed does not include the cost of courseware. Course to run is subject to a minimum enrollment. For questions, please contact: firstname.lastname@example.org or call: 207-775-0244.
Lesson 1: Streamlining Workflow Update Workbook Properties Create a Macro Edit a Macro Apply Conditional Formatting Add Data Validation CriteriaLesson 2: Collaborating with Other Users Protect Files Share a Workbook Set Revision Tracking Review Tracked Revisions Merge Workbooks Administer Digital Signatures Restrict Document AccessLesson 3: Auditing Worksheets Trace Cells Troubleshoot Invalid Data and Formula Errors Watch and Evaluate Formulas Create a Data List OutlineLesson 4 Analyzing Data Create a Trendline Create Sparklines Create Scenarios Perform a What-If Analysis Perform a Statistical Analysis with the Analysis ToolPakLesson 5: Working with Multiple Workbooks Create a Workspace Consolidate Data Link Cells in Different Workbooks Edit LinksLesson 6: Importing and Exporting Data Export Excel Data Import a Delimited Text File Import and Export XML DataLesson 7: Integrating Excel Data with the Web Publish a Worksheet to the Web Import Data from the Web Create a Web Query