or browse by Topic instead
Posts Tagged "Excel"
I love custom lists! They are a great way to organize non-document information. Whether it is a list of issues, a list of projects, or a list of vacation requests – lists allow for a great web-based alternative to Excel. By the way, I compared the two in the past. Over the years, lists evolved, and we now have several ways to… keep reading >
Importing Excel to SharePoint has always been somewhat of a matzo ball. We had a few options available, but each one came with a long list of quirks that made the whole process and result less than desirable. Recently, Microsoft has added a new capability to SharePoint Lists, where users can import Excel spreadsheets to a SharePoint Custom list, and the whole… keep reading >
I know what you are thinking. Greg, you will show me how to open a document in SharePoint? Isn’t it common knowledge? Kind of! I am sure you know how to open a document already, but I am hoping to show you a trick that you probably did not know about. Option 1: Open by clicking on File Name The most obvious… keep reading >
A great way to spice up your SharePoint site is by adding some visual charts and graphs to it. I am a very practical kind of guy, so shiny objects and charts don’t excite me much, but hey, we all know your boss will love them, so let me show you a few tricks on how to display charts in SharePoint so that… keep reading >
Quite often, I am asked by my clients and blog followers, whether or not it makes sense to transition information from Excel to SharePoint custom lists. As with many things in life, the answer is “It depends.” Let me list the advantages of both, which hopefully will help you make the right decision. I assume you have an idea of what Excel… keep reading >
A while back, I published a post where I explained how to export SharePoint lists from SharePoint to Excel. Today, I am going to cover the opposite of this – how to import Excel to SharePoint. Say, you have an Excel list/table and want to bring it to SharePoint (because SharePoint custom list kicks ass!). How do you achieve this? Well, let… keep reading >
We have lots of out of the box web parts at our disposal in SharePoint. We have Tasks for task management, issues for issues management, a calendar for events, and so on. But what if you want to create a custom list in SharePoint with your own custom columns and replicate, say an Excel spreadsheet? It is not that hard at all… keep reading >
Need SharePoint Help?
Hourly consulting, training and configuration services are availableLearn More