Excel 2010/365 - Level 3

Duration: Instructor Led Learning – 1 Day
At Course Completion:


Upon successful completion of this course, delegates will be able to:

  • Enhance productivity and efficiency by streamlining the workflow
  • Collaborate with other workbook users
  • Audit worksheet data cells
  • Analyse data
  • Work with multiple workbooks
  • Import and export data
  • Integrate Excel data with websites and Sharepoint

 

Excel 2010/365 Advanced Outline:


Lesson 1: Streamlining Workflow

Updating Workbook Properties
Creating Macros
Editing Macros
Applying Conditional Formatting
Adding Data Validation Entry Criteria

 

Lesson 2: Collaborating with Other Users

Protecting Files
Sharing a Workbook
Setting Revision Tracking
Reviewing Tracked Revisions
Merging Workbooks
Restricting 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: Analysing Data

Creating Multiple Trendlines
Creating Cell Chart Sparklines
Creating Scenarios
Performing a What-If Analysis
Performing a Statistical Analysis with the Analysis ToolPak

 

Lesson 5: Working with Multiple Workbooks  

Creating a Workspace
Consolidating Data
Linking Cells on Different Sheets
Linking Cells in Different Workbooks
Editing all Links

 

Lesson 6: Importing and Exporting Data

Exporting Excel Data
Importing a Delimited Text File
Importing and Export XML Data

 

Lesson 7: Integrating Excel Data with the Web

Publishing a Worksheet to the Web or Sharepoint
Importing Data from the Web
Creating a Web or Sharepoint Query

Excel 2010 Level 3 Outline.pdf Excel 2010 Level 3 Outline.pdf
Size : 178.444 Kb
Type : pdf