Computer Training Course Outline for PC Training Experts, Serving Irvine, Newport Beach, and Mission Viejo

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.