Skip to main content
SharePoint Knowledge Base

Posts Tagged "Excel"

3 ways to open a document in SharePoint and OneDrive

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 >

4 ways to display charts in SharePoint

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 >

SharePoint Custom list vs. Excel

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 >

3 ways to import Excel to SharePoint

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 >

How to create a custom list in SharePoint

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 >

Advantages and Limitations of using Office Online in SharePoint and OneDrive

One of the biggest draws of SharePoint Online and Office 365 is the ability to access the files anytime, anywhere. An added benefit, that in my opinion is somewhat of a revolution in collaboration world, is the ability to open and edit documents in Word, Excel and PowerPoint right in the browser. That means that you can work with those file types without… keep reading >

Need SharePoint Help?

Hourly consulting, training and configuration services are available

Learn More