Courtney Owen | Author at Microsoft 365 Blog

Tricks for creating dropdown lists that let you select multiple items

Courtney Owen — Tue, 21 Aug 2012 06:47:00 +0000

Our guest blogger and Excel MVP award winner, Debra Dagleish, makes it easy to create an Excel dropdown list that lets you select multiple names in one cell. The magic to her method is adding a few lines of VBA code--a trick just about anyone can learn, even if you don't know programming.

The post Tricks for creating dropdown lists that let you select multiple items appeared first on Microsoft 365 Blog.

Tips for turning your Excel data into PowerPoint charts

Courtney Owen — Tue, 21 Aug 2012 06:14:00 +0000

Incorporating a well-constructed chart within your PowerPoint presentation can be a powerful tool to help deliver your message.

The post Tips for turning your Excel data into PowerPoint charts appeared first on Microsoft 365 Blog.

Plug into your data: Connecting Excel to an Access database

Courtney Owen — Tue, 14 Aug 2012 15:59:00 +0000

Northwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of data. Luckily, the same features that Excel provides for viewing and organizing information in a spreadsheet, can be used to view and organize information in an Access database. But first you need to create the connection.

The post Plug into your data: Connecting Excel to an Access database appeared first on Microsoft 365 Blog.

Automatically relink Microsoft Access tables

Courtney Owen — Fri, 03 Aug 2012 08:23:00 +0000

Automating the relinking of tables just makes good sense. This is especially true if you are distributing your database to others. It can save you a lot of headaches, trouble, travel, and time. You do not have to be physically present, nor do you need to remotely access another computer. Additionally, you do not have to enter the names of your back end database(s) or your linked tables.
In this post, guest blogger Patrick Wood shows you how you can call a single procedure using just a little code to automatically relink your back-end tables, even when the database files have been moved to a different folder. The procedure will also relink the tables in multiple back-ends. And best of all, you don't have to know much about writing code to make this work.

The post Automatically relink Microsoft Access tables appeared first on Microsoft 365 Blog.

OneNote on SharePoint: A quick guide for site admins

Courtney Owen — Thu, 26 Jul 2012 06:10:00 +0000

Hosting your organization's OneNote notebooks in a SharePoint document library offers the advantages of organizing them in one location, and the flexibility to decide who can access them through setting permissions. The job of creating a library and configuring permissions usually falls on the shoulders of the SharePoint site administrator. This post shows you how to perform both tasks.

The post OneNote on SharePoint: A quick guide for site admins appeared first on Microsoft 365 Blog.

The good kind of circular reference

Courtney Owen — Tue, 17 Jul 2012 06:58:00 +0000

There have been ample articles about troubleshooting unintentional circular references in Excel workbooks. This post focuses on the opposite: choosing to deliberately work with circular references. Circular references aren't a bad thing in itself: you can use them to achieve complex calculations that are otherwise impossible to do, but first you must set them up properly.

The post The good kind of circular reference appeared first on Microsoft 365 Blog.

Score! Merge data from multiple worksheets

Courtney Owen — Thu, 05 Jul 2012 11:43:00 +0000

The Excel Consolidate feature provides an easy way for a coach to merge data from different expense worksheets into one main budget. By using the Consolidate feature, the beleaguered coach can get a handle on his team's expenses so he can focus on teaching the Decatur Golden Gators to score goals.

The post Score! Merge data from multiple worksheets appeared first on Microsoft 365 Blog.