Computer Training Course Outline for PC Training Experts
Home
About
Contact
Courses
Tutorials
Hot Articles
Blog
Forums
Excel 2016 Level 3
(
1.0 day
)
In this information-packed course, you will automate common Excel tasks using macros and Visual Basic. You will apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications. After this course you will have advanced tools for manipulating spreadsheets, finding and fixing errors, handling multiple files, linking information between spreadsheets and workbooks, and importing/exporting data. This is the course that will take your skills from competence to mastery and begin to earn you the respect and rewards of an accomplished professional. Sign-up right now using the link on this page!
Performance-Based Objectives
Enhance productivity and efficiency by streamlining the workflow
Collaborate with other workbook users
Audit worksheets
Analyze data
Work with multiple workbooks
Import and export data
Integrate Excel data with the web
Course Outline*
Module 1: Streamlining Workflow
Update Workbook Properties
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Module 5: Working with Multiple Workbooks
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links
Module 2: Collaborating with Other Users
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Administer Digital Signatures
Restrict Document Access
Module 6: Importing and Exporting Data
Export Excel Data
Import a Delimited Text File
Module 3: Auditing Worksheets
Trace Cells
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline
Module 7: Integrating Excel Data with the Web
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query
Module 4: Analyzing Data
Create a Trendline
Create Sparklines
Create Scenarios
Perform a What-If Analysis
Perform a Statistical Analysis with the Analysis ToolPak
Module 8: Structuring Workbooks with XML
Develop XML Maps
Import and Export XML Data
Register
Dates Offered
Email
Print Friendly
Show All
*Note: webinar courses cover only essential topics due to time constraints. Please discuss topics with your instructor prior to webinars to ensure your necessary topics are covered.
Dates Offered
Email
Print
Friendly
Tuition
Live, In-Person:
$277.00
Live, Webinar:
$0.00
Home
|
About
|
Contact
|
Schedule Training
|
Course Catalog
|
Blog
|
Terms of Use
|
Privacy Statement
Copyright © 2011 Mike Phillips