SharePoint Server 2010 Integrate w/ Office 2010: Excel

Part 2 of 3 in the SharePoint Server 2010 Integrating With Office 2010 series. It says it all in the title!
Course info
Level
Intermediate
Updated
Sep 12, 2012
Duration
2h 40m
Table of contents
Description
Course info
Level
Intermediate
Updated
Sep 12, 2012
Duration
2h 40m
Description

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.

About the author
About the author

Bill Kulterman is an educator, author, and a Microsoft Certified Trainer (MCT). Bill has been a trainer for more than a dozen years, educating students in Excel, Visio and a bevy of additional solutions. In recent years he has focused solely on SharePoint and SharePoint Online through Office 365. When he's not creating courses, he can usually be found riding his bike or relaxing near his Koi pond.

More from the author
Introduction to Microsoft Planner
Beginner
52m
11 Oct 2017
More courses by Bill Kulterman
Section Introduction Transcripts
Section Introduction Transcripts

Synchronize a Document Library with Outlook
Hi, welcome to TrainSignal. My name's Bill and this lesson is synchronize a document library with Outlook. In this lesson, I'm going to show you how to connect a document library to Outlook, how you can go ahead, then, and download the library contents into your Outlook so that you can, then, edit the documents offline and, if you want, if you have the permissions, or it is appropriate, then be able to go ahead and upload or sync those changes that you made back to SharePoint. Lots of great stuff, so let's just get started.

Export a List from SharePoint to Excel
Hi, welcome to TrainSignal. My name's Bill and this lesson is export a list from SharePoint to Excel. In this lesson I'm going to do just what the title says. I'm going to show you how to go ahead and export a list from SharePoint right into my Excel on my local machine. Sounds like a lot of fun, doesn't it? Then the next thing we're going to do is there's something special that happens when we do that. We create a link between that SharePoint list and the list on our local machine, and we're going to show you how to refresh that Excel workbook so that you can see any changes that have been made in the SharePoint list. Pretty cool stuff, so why don't we go ahead and get started.

Export Excel Data to a Custom List
Hi, welcome to TrainSignal. My name is Bill, and this lesson is Export Excel Data to a Custom List. In this lesson I'm going to show you how to export data from Excel to SharePoint, and how to import data from Excel to SharePoint. And I know it seems kind of confusing, like wait a minute, Bill, isn't that almost, huh? Ultimately what we're going to do is we're going to get data from a local Excel workbook on our local computer, and we're going to get it into SharePoint as a custom list, and there's two ways to do it. One is right from Excel, and the other one is we're going to go ahead and from SharePoint grab that data from our Excel off our local machine. So let's go ahead, and let's get started.

Publish an Excel Workbook to SharePoint
Hi, welcome to TrainSignal. My name's Bill and this lesson is Publish an Excel Workbook to SharePoint. In this lesson, we're going to start by telling you a little bit about Excel Services. In previous lessons, we've kind of actually been using them, but now we're going to go in a little bit more explanation about what they are and what they allow you to do. Next, we're going to take a look at publishing a workbook, an Excel workbook up into our SharePoint using the Excel Services, make a workbook interactive, also possible because of Excel Services. Sounds like a lot of fun. Why don't we go ahead and just get started?

Add and Use the Excel Web Part
Hi, welcome to TrainSignal. My name's Bill, and this lesson is Add and Use the Excel Web Part. In this lesson, I'm going to do exactly that. I'm going to show you how to add the Excel Web Access Web Part to a page in our SharePoint. That includes then, selecting a workbook to link to that Web Part. And then, we're going to show you how to go ahead and define the Web Part Properties so that you can make that Web Part act and look and work the way you want it to. A lot of really cool stuff in this lesson, so why don't we just get started?

Status Indicators in SharePoint
Hi, welcome to TrainSignal. My name is Bill and this lesson is Status Indicators in SharePoint. In this lesson, we're going to start by having a little bit of a discussion of what are status indicators, and we'll take a look at the status types that we have available to us in SharePoint. Then, we're going to go ahead and show you how to create status indicators 'cause that's the best part of this whole lesson. We have three different types that we're going to look at, a fixed value based status indicator, a SharePoint list based status indicator, and an Excel based status indicator. Lots of great stuff coming up, so stay with me, and let's get started.

Creating Dashboards with Excel Web Services and Status Indicators
Welcome to TrainSignal. My name's Bill, and this lesson is Creating Dashboards with Excel and Status Indicators. In this lesson we're going to start by showing you how to create a Report Library. This is going to allow us to very easily create those Dashboards. Next we'll take a look at adding those Status Indicators. Then we're going to add the Web Chart Part, and add an Excel Web Access Web Part. Lots of really cool stuff here. And if you've been watching my lessons in order, the last couple of lessons that we've done have all led us up to this point. We've worked with Status Indicators, we've worked with the Web Chart Part, we've worked with Excel Web Access, now we're going to put them all together onto one really cool Dashboard, where with just a very quick click you can look and see, "Oh, there you go, "this is what's going on. " So, great stuff coming up, let's go ahead and let's get started.