| What or Who: | Where: |  SEARCH |
 | Microsoft Excel 2010 Level 3 (Training Course) - Oldham, Greater ManchesterUK Events > Business Events > Training Courses |
Event DetailsStreamlining Workflow.-Update Workbook Properties -Create a Macro -Edit a Macro -Apply Conditional Formatting -Add Data Validation Criteria -Collaborating with Other Users Protect Files - Share a Workbook - Set Revision Tracking - Review Tracked Revisions - Merge Workbooks - Administer Digital Signatures - Restrict Document Access - Auditing Worksheets Trace Cells - Troubleshoot Invalid Data and Formula Errors - Watch and Evaluate Formulas - Create a Data List Outline - Analysing Data - Create a Trendline - Create Sparklines - Create Scenarios - Perform a What-If Analysis - Perform a Statistical Analysis with the Analysis ToolPak - Working with Multiple Workbooks Create a Workspace - Consolidate Data - Link Cells in Different Workbooks - Edit Links Importing and Exporting Data - Export Excel Data - Import a Delimited Text File - Integrating Excel Data with the Web Publish a Worksheet to the Web - Import Data from the Web - Create a Web Query - Structuring Workbooks with XML Develop XML Maps - Import and Export XML Data Course Benefits. 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 -Analyse data -Work with multiple workbooks -Import and export data -Integrate Excel data with the web -Structure workbooks with XML Target Audience. This course is designed for students wishing to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources and import and export data. Pre Requisites. To ensure your success we recommend that you first take the following courses or have equivalent knowledge: -Excel 2010 Level 1 -Excel 2010 Level 2. Dates and Times
| Nearby
Related CategoriesBusiness EventsTraining Courses Added byFOSVA TrainingReport Inaccurate Content |
