Category: Excel Tips

Tricks for creating dropdown lists that let you select multiple items

Here is a post from the official Excel Blog over at Microsoft on creating dropdown lists that let you select multiple items in Microsoft Excel: “Our guest blogger Debra Dalgleish is a consultant specializing in Microsoft Office programming and development. She offers her Excel wisdom every week on the Contextures blog and has received the …

Continue reading

Intro to Power View for Excel 2013

Here is a Blog post from Microsoft introducing used to the new Power Viewer for Excel 2013: “byDiego M. Oppenheimer – on October 04 Have you ever looked at a dashboard someone made and went, “man, I like that, but there’s too many steps for me to remember”? Or maybe wanted to have a way …

Continue reading

Better Excel workbook navigation

Are you an Excel power user? Here is a great tip to make navigation workbooks that have many worksheets much easier: Add a new worksheet to your Excel workbook.

Continue reading