MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SharePoint Server 2010 Integrate w/ Office 2010: Excel

Course Summary

Part 2 of 3 in the SharePoint Server 2010 Integrating With Office 2010 series. It says it all in the title! If you are a SharePoint admin who wants to integrate with office 2010 this course is for you.


  • +

    Course Syllabus

    ● Synchronize a Document Library with Outlook
        ◦ Introduction
        ◦ Connect a Document Library to Outlook
        ◦ Download the Library Contents
        ◦ Edit the Document Offline and Sync to SharePoint
        ◦ What We Covered
    ● Co-authoring Using the Excel Web App
        ◦ Simultaneously Edit an Excel Workbook
        ◦ What We Covered
    ● Export a List from SharePoint to Excel
        ◦ Introduction
        ◦ Export a List to Excel
        ◦ Refresh the Excel Workbook
        ◦ What We Covered
    ● Export Excel Data to a Custom List
        ◦ Introduction
        ◦ Export Data from Excel to SharePoint
        ◦ Import Data from Excel to SharePoint
        ◦ What We Covered
    ● Publish an Excel Workbook to SharePoint
        ◦ Introduction
        ◦ Excel Services
        ◦ Publish a Workbook
        ◦ Make a Workbook Interactive
        ◦ What We Covered
    ● Add and Use the Excel Web Part
        ◦ Introduction
        ◦ Add the Excel Web Access Web Part
        ◦ Define the Web Part Properties
        ◦ What We Covered
    ● Status Indicators in SharePoint
        ◦ Introduction
        ◦ Status Indicators (KPIs)
        ◦ Status Types
        ◦ Creating Status Indicators
        ◦ Fixed Value Based Status Indicator
        ◦ SharePoint List Based Indicator
        ◦ Excel Based Status Indicator
        ◦ What We Covered
    ● Add and Use the Chart Web Part
        ◦ Add the Chart Web Part
        ◦ Connect to Your Data
        ◦ Customize the Chart
        ◦ What We Covered
    ● Creating Dashboards with Excel Web Services and Status Indicators
        ◦ Introduction
        ◦ Create a Report Library
        ◦ Add Status Indicators
        ◦ Add the Web Chart Part
        ◦ Add the Excel Web Access Web Part
        ◦ What We Covered

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top