Tricks for creating dropdown lists that let you select multiple items
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.
-
-
Tips for turning your Excel data into PowerPoint charts
Incorporating a well-constructed chart within your PowerPoint presentation can be a powerful tool to help deliver your message.
-
Plug into your data: Connecting Excel to an Access database
Northwind Trading Company is a growing online wholesale food business. -
Automatically relink Microsoft Access tables
Automating the relinking of tables just makes good sense.
-
OneNote on SharePoint: A quick guide for site admins
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 good kind of circular reference
There have been ample articles about troubleshooting unintentional circular references in Excel workbooks.
-
Score! Merge data from multiple worksheets
The Excel Consolidate feature provides an easy way for a coach to merge data from different expense worksheets into one main budget.