Excel Stuff

by Debra Dalgleish

[ddalgleish]

Create amazing interactive dashboards with Power BI and Excel data

http://blog.contextures.com/archives/2017/07/06/learn-more-about-power-bi-and-excel/

[ddalgleish]

How to add commands to Quick Access Toolbar in Excel, and use keyboard shortcuts to run them. Export your Excel Ribbon customizations to save them

[ddalgleish]

Go to http://www.contextures.com/excelworksheetsshowtab.html to get the sample file and code.

[ddalgleish]

Hide Excel sheets based on their tab colour

http://blog.contextures.com/archives/2016/07/07/hide-sheets-based-on-tab-color/

[ddalgleish]

Moving to a new laptop is hard work!

[ddalgleish]

How to do a lookup in Excel, based on two criteria http://blog.contextures.com/archives/2016/05/26/excel-lookup-with-two-criteria/

[ddalgleish]

Choose from a drop down list to change Excel data http://blog.contextures.com/archives/2016/04/21/choose-from-a-list-to-change-excel-data/

[ddalgleish]

How to avoid this VLOOKUP sorting problem http://blog.contextures.com/archives/2016/03/03/excel-vlookup-sorting-problem/

[ddalgleish]

How to split dates and times in Excel http://blog.contextures.com/archives/2016/02/18/how-to-split-date-and-time-in-excel/

[ddalgleish]

Weekly collection of Excel tweets http://exceltheatre.com/blog/archives/2016/02/19/excel-twitter-20160219/

[ddalgleish]

Get a distinct count in an Excel pivot table http://blog.contextures.com/archives/2016/02/25/count-unique-in-excel-pivot-table/

[ddalgleish]

In Excel 2013, you can quickly create a pivot chart from the source data, without building a pivot table first. Read the details here.

[ddalgleish]

Group numbers by tens in Excel pivot table. More info at http://www.contextures.com/xlPivot07.html

[ddalgleish]

There penny is dropped from circulation in Canada, and sales totals will be rounded to the closest nickel. Use the MROUND function to calculate the cash payments due.

[ddalgleish]

Get Started With Excel Custom Ribbon Tabs

You can create custom ribbon tabs in Excel, and have them appear when a specific workbook opens.

In this intro video, you'll see a free tool that lets you view and edit ribbon code.

http://www.youtube.com/v/NEWyGAPkP3Q

[ddalgleish]

Clean Up Pivot Table Headings and Labels

This article has a couple of quick tips for cleaning up a pivot table.  See how to quickly remove "Sum Of" in the headings, and clear (blank) labels

Change Pivot Table Data Headings and Blanks

[ddalgleish]

Show Missing Items in Excel Pivot Table