56,966 blogs · [ { "id": "01a08760-bda8-7089-bcb2-7ee02a9a3d7d", "title": "Select and Highlight across an Excel Dashboard", "url": "https://www.clearlyandsimply.com/2025/08/select-and-highlight-across-an-excel-dashboard/", "published_at": "2025-08-16T18:00:00+00:00" }, { "id": "01a08760-bda8-7089-bcb2-7ee02b2fce19", "title": "London Excel Meetup Workbooks", "url": "https://www.clearlyandsimply.com/2020/09/london-excel-meetup-workbooks/", "published_at": "2020-09-03T22:00:00+00:00" }, { "id": "01a08760-bda8-7089-bcb2-7ee02bffcfff", "title": "Visual Workbook Navigation with a Chart Carousel", "url": "https://www.clearlyandsimply.com/2020/08/visual-workbook-navigation-with-a-chart-carousel/", "published_at": "2020-08-23T21:00:00+00:00" }, { "id": "01a08760-bda8-7089-bcb2-7ee02cb721c4", "title": "A Neural Network to solve Travelling Salesman Problems in Excel", "url": "https://www.clearlyandsimply.com/2020/08/a-neural-network-to-solve-travelling-salesman-problems-in-excel/", "published_at": "2020-08-07T16:00:00+00:00" }, { "id": "01a08760-bda8-7089-bcb2-7ee02d46c732", "title": "Excel Oddity using Named Formulas in Charts", "url": "https://www.clearlyandsimply.com/2020/08/excel-oddity-using-named-formulas-in-charts/", "published_at": "2020-08-02T19:00:00+00:00" }, { "id": "01a08760-bda8-7089-bcb2-7ee02dcd8b19", "title": "Animated Races of the 4 Big Football Leagues", "url": "https://www.clearlyandsimply.com/2020/07/animated-races-of-the-4-big-football-leagues/", "published_at": "2020-07-11T19:00:00+00:00" }, { "id": "01a08760-bda8-7089-bcb2-7ee02e7adc72", "title": "An Alternative to the Bar Chart Race", "url": "https://www.clearlyandsimply.com/2020/07/an-alternative-to-the-bar-chart-race/", "published_at": "2020-07-07T21:00:00+00:00" }, { "id": "01a08760-bda8-7089-bcb2-7ee02ed85d0a", "title": "A practical Example for Dynamic Storyboards", "url": "https://www.clearlyandsimply.com/2020/06/a-practical-example-for-dynamic-storyboards/", "published_at": "2020-06-11T20:00:00+00:00" }, { "id": "01a08760-bda8-7089-bcb2-7ee02f46e484", "title": "Dynamic Storyboards in Excel", "url": "https://www.clearlyandsimply.com/2020/06/dynamic-storyboards-in-excel/", "published_at": "2020-06-10T21:00:00+00:00" }, { "id": "01a08760-bda8-7089-bcb2-7ee02fabf744", "title": "How to handle Line Charts with many Data Series", "url": "https://www.clearlyandsimply.com/2020/06/how-to-handle-line-charts-with-many-data-series/", "published_at": "2020-06-04T20:00:00+00:00" }, { "id": "01a0c502-9434-71ba-9866-a0fd44a98b20", "title": "Adjust Power Query Table Style and Properties", "url": "https://www.clearlyandsimply.com/2020/05/adjust-power-query-table-style-and-properties/", "published_at": "2020-05-26T20:00:00+00:00" }, { "id": "01a0c502-9434-71ba-9866-a0fd459826f8", "title": "Power BI lookalike Tooltips in Microsoft Excel", "url": "https://www.clearlyandsimply.com/2020/05/power-bi-lookalike-tooltips-in-microsoft-excel/", "published_at": "2020-05-25T20:00:00+00:00" }, { "id": "01a0c502-9434-71ba-9866-a0fd4628c17d", "title": "Animated Maps in Microsoft Excel", "url": "https://www.clearlyandsimply.com/2020/05/animated-maps-in-microsoft-excel/", "published_at": "2020-05-21T21:00:00+00:00" }, { "id": "01a0c502-9434-71ba-9866-a0fd46b54fe1", "title": "Create a Summary Table in Power Query", "url": "https://www.clearlyandsimply.com/2020/05/create-a-summary-table-in-power-query/", "published_at": "2020-05-18T20:00:00+00:00" }, { "id": "01a0c502-9434-71ba-9866-a0fd470a88a5", "title": "All Peaks of the Alps visualized in Excel", "url": "https://www.clearlyandsimply.com/2020/05/all-peaks-of-the-alps-visualized-in-excel/", "published_at": "2020-05-08T20:00:00+00:00" }, { "id": "01a0c502-9434-71ba-9866-a0fd47500108", "title": "All Peaks of the Alps visualized with Tableau", "url": "https://www.clearlyandsimply.com/2020/04/all-peaks-of-the-alps-visualized-with-tableau/", "published_at": "2020-04-29T19:00:00+00:00" }, { "id": "01a0c502-9434-71ba-9866-a0fd4843d1e6", "title": "Optimized Choropleth Maps in Microsoft Excel", "url": "https://www.clearlyandsimply.com/2020/04/optimized-choropleth-maps-in-microsoft-excel/", "published_at": "2020-04-22T21:00:00+00:00" }, { "id": "01a0c502-9434-71ba-9866-a0fd49062486", "title": "Filter Excel Dashboards with Slicers and Timelines", "url": "https://www.clearlyandsimply.com/2020/04/filter-excel-dashboards-with-slicers-and-timelines/", "published_at": "2020-04-20T18:00:00+00:00" }, { "id": "01a0c502-9434-71ba-9866-a0fd49573d37", "title": "Dynamic Icons in Microsoft Excel Cell Ranges", "url": "https://www.clearlyandsimply.com/2020/04/dynamic-icons-in-microsoft-excel-cell-ranges/", "published_at": "2020-04-16T20:00:00+00:00" }, { "id": "01a0c502-9434-71ba-9866-a0fd49f90e6e", "title": "My 2 Cents on the COVID-19 Dashboard by JHU", "url": "https://www.clearlyandsimply.com/2020/04/my-2-cents-on-the-covid-19-dashboard-by-jhu/", "published_at": "2020-04-13T22:00:00+00:00" }, { "id": "01a0c508-5e03-701a-bddb-ecc39cd85c28", "title": "Microsoft Excel Project Calendar Template", "url": "https://www.clearlyandsimply.com/2020/04/microsoft-excel-project-calendar-template/", "published_at": "2020-04-08T20:00:00+00:00" }, { "id": "01a0c508-5e03-701a-bddb-ecc39dbff203", "title": "Choropleth Maps of Italy in Excel", "url": "https://www.clearlyandsimply.com/2020/04/choropleth-maps-of-italy-in-excel/", "published_at": "2020-04-06T20:00:00+00:00" }, { "id": "01a0c508-5e03-701a-bddb-ecc39e66a2ef", "title": "Heat Maps with Individual Color Scales in Excel", "url": "https://www.clearlyandsimply.com/2020/04/heat-maps-with-individual-color-scales-in-excel/", "published_at": "2020-04-03T20:00:00+00:00" }, { "id": "01a0c508-5e03-701a-bddb-ecc39e7d1b0b", "title": "Analytical Color Scales for Heat Maps", "url": "https://www.clearlyandsimply.com/2020/04/analytical-color-scales-for-heat-maps/", "published_at": "2020-04-02T18:00:00+00:00" }, { "id": "01a0c508-5e03-701a-bddb-ecc39ec0fa91", "title": "Showcase for Table Slicers on Excel Dashboards", "url": "https://www.clearlyandsimply.com/2020/03/showcase-for-table-slicers-on-excel-dashboards/", "published_at": "2020-03-31T20:00:00+00:00" }, { "id": "01a0c508-5e03-701a-bddb-ecc39f8d9ae5", "title": "Weighted Route Maps in Excel", "url": "https://www.clearlyandsimply.com/2020/03/weighted-route-maps-in-excel/", "published_at": "2020-03-30T20:00:00+00:00" }, { "id": "01a0c508-5e03-701a-bddb-ecc39fbc3997", "title": "Geographical Flow Maps in Excel (Part 3 of 3)", "url": "https://www.clearlyandsimply.com/2020/03/geographical-flow-maps-in-excel-part-3-of-3/", "published_at": "2020-03-27T20:00:00+00:00" }, { "id": "01a0c508-5e03-701a-bddb-ecc39fe54ce9", "title": "Geographical Flow Maps in Excel (Part 2 of 3)", "url": "https://www.clearlyandsimply.com/2020/03/geographical-flow-maps-in-excel-part-2-of-3/", "published_at": "2020-03-26T20:00:00+00:00" }, { "id": "01a0c508-5e03-701a-bddb-ecc3a0433b32", "title": "Geographical Flow Maps in Excel (Part 1 of 3)", "url": "https://www.clearlyandsimply.com/2020/03/geographical-flow-maps-in-excel-part-1-of-3/", "published_at": "2020-03-25T20:00:00+00:00" }, { "id": "01a0c508-5e03-701a-bddb-ecc3a0cdf0d6", "title": "Filter Excel Dashboards with Table Slicers", "url": "https://www.clearlyandsimply.com/2020/03/filter-excel-dashboards-with-table-slicers/", "published_at": "2020-03-23T20:00:00+00:00" }, { "id": "01a0c518-d4cd-7104-9a8b-36b862b61fc6", "title": "Microsoft Excel Workbook Metrics", "url": "https://www.clearlyandsimply.com/2017/08/microsoft-excel-workbook-metrics/", "published_at": "2017-08-06T17:00:00+00:00" }, { "id": "01a0c518-d4cd-7104-9a8b-36b8632f31f2", "title": "Variations of Alternative Bullet Graphs in Excel", "url": "https://www.clearlyandsimply.com/2017/07/variations-of-alternative-bullet-graphs-in-excel/", "published_at": "2017-07-17T20:00:00+00:00" }, { "id": "01a0c518-d4cd-7104-9a8b-36b863e40c9b", "title": "US Choropleth Map by County per State – a 4th Option", "url": "https://www.clearlyandsimply.com/2017/06/us-choropleth-map-by-county-per-state-a-4th-option/", "published_at": "2017-06-21T17:00:00+00:00" }, { "id": "01a0c518-d4cd-7104-9a8b-36b863f7df98", "title": "US Choropleth Map by County per State", "url": "https://www.clearlyandsimply.com/2017/06/us-choropleth-map-by-county-per-state/", "published_at": "2017-06-19T22:00:00+00:00" }, { "id": "01a0c518-d4cd-7104-9a8b-36b864933039", "title": "Highlight Actions in Microsoft Excel with Multiselecting", "url": "https://www.clearlyandsimply.com/2017/06/highlight-actions-in-microsoft-excel-with-multiselecting/", "published_at": "2017-06-18T20:00:00+00:00" }, { "id": "01a0c518-d4cd-7104-9a8b-36b864dec4e0", "title": "Highlight Actions in Microsoft Excel", "url": "https://www.clearlyandsimply.com/2017/06/highlight-actions-in-microsoft-excel/", "published_at": "2017-06-13T20:00:00+00:00" }, { "id": "01a0c518-d4cd-7104-9a8b-36b8653e7d9d", "title": "Alternative Bullet Graph Design in Tableau", "url": "https://www.clearlyandsimply.com/2017/05/alternative-bullet-graph-design-in-tableau/", "published_at": "2017-05-23T20:00:00+00:00" }, { "id": "01a0c518-d4cd-7104-9a8b-36b865643e29", "title": "Interactive Bullet Graphs in Excel", "url": "https://www.clearlyandsimply.com/2017/05/interactive-bullet-graphs-in-excel/", "published_at": "2017-05-12T12:00:00+00:00" }, { "id": "01a0c518-d4cd-7104-9a8b-36b865a61237", "title": "An Alternative Design of Bullet Graphs", "url": "https://www.clearlyandsimply.com/2017/05/an-alternative-design-of-bullet-graphs/", "published_at": "2017-05-08T18:00:00+00:00" }, { "id": "01a0c518-d4cd-7104-9a8b-36b865bd07fe", "title": "Microsoft Excel VBA Progress Indicators", "url": "https://www.clearlyandsimply.com/2017/05/microsoft-excel-vba-progress-indicators/", "published_at": "2017-05-02T20:00:00+00:00" }, { "id": "01a0c523-d5e3-70fc-8477-8fe3cc58a60a", "title": "Excel VBA Read and Write Performance Test", "url": "https://www.clearlyandsimply.com/2017/04/excel-vba-read-and-write-performance-test/", "published_at": "2017-04-28T20:00:00+00:00" }, { "id": "01a0c523-d5e3-70fc-8477-8fe3cc9962a9", "title": "Mouse Driven Actions on Excel Dashboards", "url": "https://www.clearlyandsimply.com/2017/04/mouse-driven-actions-on-excel-dashboards/", "published_at": "2017-04-25T20:00:00+00:00" }, { "id": "01a0c523-d5e3-70fc-8477-8fe3ccae174c", "title": "S-Shaped Function in Microsoft Excel", "url": "https://www.clearlyandsimply.com/2017/04/s-shaped-function-in-microsoft-excel/", "published_at": "2017-04-24T20:00:00+00:00" }, { "id": "01a0c523-d5e3-70fc-8477-8fe3ccc2d67c", "title": "S-Shaped Function in Tableau", "url": "https://www.clearlyandsimply.com/2017/04/s-shaped-function-in-tableau/", "published_at": "2017-04-23T20:00:00+00:00" }, { "id": "01a0c523-d5e3-70fc-8477-8fe3cd37f960", "title": "Solar Calculations in Tableau", "url": "https://www.clearlyandsimply.com/2017/04/solar-calculations-in-tableau/", "published_at": "2017-04-09T21:00:00+00:00" }, { "id": "01a0c523-d5e3-70fc-8477-8fe3cd830cc6", "title": "User-defined Excel Chart Tooltips", "url": "https://www.clearlyandsimply.com/2016/09/user-defined-excel-chart-tooltips/", "published_at": "2016-09-14T16:00:00+00:00" }, { "id": "01a0c523-d5e3-70fc-8477-8fe3cd9637d7", "title": "List of all Files in a Folder and its Subfolders", "url": "https://www.clearlyandsimply.com/2016/08/list-of-all-files-in-a-folder-and-its-subfolders/", "published_at": "2016-08-29T19:00:00+00:00" }, { "id": "01a0c523-d5e3-70fc-8477-8fe3ce45c44d", "title": "Customizable Tooltips on Excel Charts", "url": "https://www.clearlyandsimply.com/2016/08/customizable-tooltips-on-excel-charts/", "published_at": "2016-08-27T18:00:00+00:00" }, { "id": "01a0c523-d5e3-70fc-8477-8fe3ce50848c", "title": "Writing and Reading Tableau Views to and from Databases and Text Files – Part 2", "url": "https://www.clearlyandsimply.com/2016/06/writing-and-reading-tableau-views-to-and-from-databases-and-text-files-part-2/", "published_at": "2016-06-09T20:00:00+00:00" }, { "id": "01a0c523-d5e3-70fc-8477-8fe3cf398008", "title": "Writing and Reading Tableau Views to and from Databases and Text Files – Part 1", "url": "https://www.clearlyandsimply.com/2016/06/writing-and-reading-tableau-views-to-and-from-databases-and-text-files-part-1/", "published_at": "2016-06-08T20:00:00+00:00" }, { "id": "01a0c52f-6914-73eb-bc9e-6799faa64be1", "title": "Zooming in and out of Excel Charts", "url": "https://www.clearlyandsimply.com/2015/07/zooming-in-and-out-of-excel-charts/", "published_at": "2015-07-16T19:00:00+00:00" }, { "id": "01a0c52f-6914-73eb-bc9e-6799fac95805", "title": "Select Areas on a USA Map in Microsoft Excel", "url": "https://www.clearlyandsimply.com/2015/07/select-areas-on-a-usa-map-in-microsoft-excel/", "published_at": "2015-07-07T21:00:00+00:00" }, { "id": "01a0c52f-6914-73eb-bc9e-6799fae4f145", "title": "Export Excel Dashboards (Improved Version)", "url": "https://www.clearlyandsimply.com/2015/07/export-excel-dashboards-improved-version/", "published_at": "2015-07-06T16:00:00+00:00" }, { "id": "01a0c52f-6914-73eb-bc9e-6799fb9f5085", "title": "Export Excel Dashboards to other Applications", "url": "https://www.clearlyandsimply.com/2015/07/export-excel-dashboards-to-other-applications/", "published_at": "2015-07-05T16:00:00+00:00" }, { "id": "01a0c52f-6914-73eb-bc9e-6799fc9af052", "title": "Cartograms in Microsoft Excel", "url": "https://www.clearlyandsimply.com/2015/06/cartograms-in-microsoft-excel/", "published_at": "2015-06-30T16:00:00+00:00" }, { "id": "01a0c52f-6914-73eb-bc9e-6799fcd7eac7", "title": "Create your own Cartograms in Tableau", "url": "https://www.clearlyandsimply.com/2015/06/create-your-own-cartograms-in-tableau/", "published_at": "2015-06-20T15:00:00+00:00" }, { "id": "01a0c52f-6914-73eb-bc9e-6799fd91ca7c", "title": "German Public Holidays in Tableau", "url": "https://www.clearlyandsimply.com/2015/05/german-public-holidays-in-tableau/", "published_at": "2015-05-31T23:00:00+00:00" }, { "id": "01a0c52f-6914-73eb-bc9e-6799fdf8c590", "title": "US Public Holidays in Tableau", "url": "https://www.clearlyandsimply.com/2015/05/us-public-holidays-in-tableau/", "published_at": "2015-05-30T12:00:00+00:00" }, { "id": "01a0c52f-6914-73eb-bc9e-6799feb765bb", "title": "Selecting and Highlighting Areas on Excel Charts", "url": "https://www.clearlyandsimply.com/2015/05/selecting-and-highlighting-areas-on-excel-charts/", "published_at": "2015-05-27T15:00:00+00:00" }, { "id": "01a0c52f-6914-73eb-bc9e-6799ff568b71", "title": "Another Technique for Interactive Excel Charts", "url": "https://www.clearlyandsimply.com/2015/05/another-technique-for-interactive-excel-charts/", "published_at": "2015-05-25T20:00:00+00:00" }, { "id": "01a0c539-b723-7365-a178-e9cc15caef48", "title": "Cartograms in Tableau", "url": "https://www.clearlyandsimply.com/2015/04/cartograms-in-tableau/", "published_at": "2015-04-29T11:00:00+00:00" }, { "id": "01a0c539-b723-7365-a178-e9cc165e2e0b", "title": "Create Excel Freeform Shapes from Polygons", "url": "https://www.clearlyandsimply.com/2015/04/create-excel-freeform-shapes-from-polygons/", "published_at": "2015-04-17T19:00:00+00:00" }, { "id": "01a0c539-b723-7365-a178-e9cc1680f49f", "title": "Excel Oddity: Camera Objects bloat File Size", "url": "https://www.clearlyandsimply.com/2015/03/excel-oddity-camera-objects-bloat-file-size/", "published_at": "2015-03-28T15:00:00+00:00" }, { "id": "01a0c539-b723-7365-a178-e9cc16cf87e7", "title": "Highlighting on Excel Dashboards", "url": "https://www.clearlyandsimply.com/2015/03/highlighting-across-excel-dashboards/", "published_at": "2015-03-26T20:00:00+00:00" }, { "id": "01a0c539-b723-7365-a178-e9cc17b869b9", "title": "Word Clouds with Tableau", "url": "https://www.clearlyandsimply.com/2015/03/word-clouds-with-tableau/", "published_at": "2015-03-24T15:00:00+00:00" }, { "id": "01a0c539-b723-7365-a178-e9cc186b957a", "title": "The Implementation of Word Clouds with Excel", "url": "https://www.clearlyandsimply.com/2015/03/the-implementation-of-word-clouds-with-excel/", "published_at": "2015-03-12T15:00:00+00:00" }, { "id": "01a0c539-b723-7365-a178-e9cc18708dcc", "title": "Word Clouds with Microsoft Excel", "url": "https://www.clearlyandsimply.com/2015/02/word-clouds-with-microsoft-excel/", "published_at": "2015-02-24T21:00:00+00:00" }, { "id": "01a0c539-b723-7365-a178-e9cc193969a9", "title": "Microsoft Excel Check List Compilation", "url": "https://www.clearlyandsimply.com/2015/01/microsoft-excel-check-list-compilation/", "published_at": "2015-01-20T19:00:00+00:00" }, { "id": "01a0c539-b723-7365-a178-e9cc19efbd1f", "title": "SQL Saturday BA Edition 2014 in London", "url": "https://www.clearlyandsimply.com/2014/11/sql-saturday-ba-edition-2014-in-london/", "published_at": "2014-11-24T07:00:00+00:00" }, { "id": "01a0c539-b723-7365-a178-e9cc1aab1d2d", "title": "Gapminder Replica in Microsoft Excel", "url": "https://www.clearlyandsimply.com/2014/09/gapminder-replica-in-microsoft-excel/", "published_at": "2014-09-06T21:00:00+00:00" }, { "id": "01a0c543-0e29-720b-96ed-d0144ca953fe", "title": "Financial Modeling World Championships 2014", "url": "https://www.clearlyandsimply.com/2014/08/financial-modeling-world-championships-2014/", "published_at": "2014-08-31T21:00:00+00:00" }, { "id": "01a0c543-0e29-720b-96ed-d0144d45947e", "title": "La Gazzetta dello Sport gives Tableau a try", "url": "https://www.clearlyandsimply.com/2014/08/la-gazzetta-dello-sport-gives-tableau-a-try/", "published_at": "2014-08-29T11:00:00+00:00" }, { "id": "01a0c543-0e29-720b-96ed-d0144de26493", "title": "Motion Chart Excel Template", "url": "https://www.clearlyandsimply.com/2014/08/motion-chart-excel-template/", "published_at": "2014-08-23T19:00:00+00:00" }, { "id": "01a0c543-0e29-720b-96ed-d0144e75e011", "title": "Tableau’s Viz as Art Contest – My Entries", "url": "https://www.clearlyandsimply.com/2014/08/tableaus-viz-as-art-contest-my-entries/", "published_at": "2014-08-13T23:00:00+00:00" }, { "id": "01a0c543-0e29-720b-96ed-d0144f3a364e", "title": "Drill Up and Down on Choropleth Maps in Excel", "url": "https://www.clearlyandsimply.com/2014/06/drill-up-and-down-on-choropleth-maps-in-excel/", "published_at": "2014-06-22T21:00:00+00:00" }, { "id": "01a0c543-0e29-720b-96ed-d0144fddd8dc", "title": "String Calculations in Tableau", "url": "https://www.clearlyandsimply.com/2014/06/string-calculations-in-tableau/", "published_at": "2014-06-13T22:00:00+00:00" }, { "id": "01a0c543-0e29-720b-96ed-d0145086fe8a", "title": "99 Blog Posts and 1000 Comments", "url": "https://www.clearlyandsimply.com/2014/05/99-blog-posts-and-1000-comments/", "published_at": "2014-05-24T20:00:00+00:00" }, { "id": "01a0c543-0e29-720b-96ed-d01451578fc7", "title": "Pivot-like Marimekko Charts in Excel", "url": "https://www.clearlyandsimply.com/2014/05/pivot-like-marimekko-charts-in-excel/", "published_at": "2014-05-20T21:00:00+00:00" }, { "id": "01a0c543-0e29-720b-96ed-d01451dfabc7", "title": "Marimekko Charts in Microsoft Excel", "url": "https://www.clearlyandsimply.com/2014/05/marimekko-charts-in-microsoft-excel/", "published_at": "2014-05-18T20:00:00+00:00" }, { "id": "01a0c543-0e29-720b-96ed-d01452b5a3e9", "title": "Extract Custom Shapes from a Tableau Workbook", "url": "https://www.clearlyandsimply.com/2014/05/extract-custom-shapes-from-a-tableau-workbook/", "published_at": "2014-05-15T18:00:00+00:00" }, { "id": "01a0c54b-f7f0-73c1-af95-381354830249", "title": "Bruce Springsteen Discography in Excel", "url": "https://www.clearlyandsimply.com/2013/07/bruce-springsteen-discography-in-excel/", "published_at": "2013-07-02T23:00:00+00:00" }, { "id": "01a0c54b-f7f0-73c1-af95-3813549b4236", "title": "Bruce Springsteen Discography – An Infographic", "url": "https://www.clearlyandsimply.com/2013/06/bruce-springsteen-discography-an-infographic/", "published_at": "2013-06-24T22:00:00+00:00" }, { "id": "01a0c54b-f7f0-73c1-af95-3813559b1eac", "title": "Build Network Graphs in Tableau", "url": "https://www.clearlyandsimply.com/2012/12/build-network-graphs-in-tableau/", "published_at": "2012-12-11T23:00:00+00:00" }, { "id": "01a0c54b-f7f0-73c1-af95-381355a7c5d5", "title": "Create Excel Choropleth Maps from Shape Files", "url": "https://www.clearlyandsimply.com/2012/12/create-excel-choropleth-maps-from-shape-files/", "published_at": "2012-12-09T22:00:00+00:00" }, { "id": "01a0c54b-f7f0-73c1-af95-3813565dae57", "title": "Interactive Tooltip Examples", "url": "https://www.clearlyandsimply.com/2012/11/interactive-tooltip-examples/", "published_at": "2012-11-11T19:00:00+00:00" }, { "id": "01a0c54b-f7f0-73c1-af95-381356c94917", "title": "Interactive Tooltips on Excel Worksheets", "url": "https://www.clearlyandsimply.com/2012/11/interactive-tooltips-on-excel-worksheets/", "published_at": "2012-11-10T13:00:00+00:00" }, { "id": "01a0c54b-f7f0-73c1-af95-38135718391e", "title": "Roll Over Tooltips and Web Actions on a Microsoft Excel Dashboard", "url": "https://www.clearlyandsimply.com/2012/11/roll-over-tooltips-and-web-actions-on-a-microsoft-excel-dashboard/", "published_at": "2012-11-04T18:00:00+00:00" }, { "id": "01a0c54b-f7f0-73c1-af95-381357741586", "title": "Filter Excel Tables by Double Clicking", "url": "https://www.clearlyandsimply.com/2012/11/filter-excel-tables-by-double-clicking/", "published_at": "2012-11-02T20:00:00+00:00" }, { "id": "01a0c54b-f7f0-73c1-af95-381358535316", "title": "Interactive Drop Lines on Microsoft Excel Charts", "url": "https://www.clearlyandsimply.com/2012/10/interactive-drop-lines-on-microsoft-excel-charts/", "published_at": "2012-10-28T22:00:00+00:00" }, { "id": "01a0c54b-f7f0-73c1-af95-3813593c953e", "title": "Tableau Quick Tip #4 – Drop Lines", "url": "https://www.clearlyandsimply.com/2012/10/tableau-quick-tip-4-drop-lines/", "published_at": "2012-10-20T23:00:00+00:00" }, { "id": "01a0c554-44bd-70c5-ac46-912db1c8da1c", "title": "O’zapft is!", "url": "https://www.clearlyandsimply.com/2012/09/ozapft-is/", "published_at": "2012-09-22T12:00:00+00:00" }, { "id": "01a0c554-44bd-70c5-ac46-912db280aae8", "title": "Web Page Objects on Tableau Dashboards", "url": "https://www.clearlyandsimply.com/2012/09/web-page-objects-on-tableau-dashboards/", "published_at": "2012-09-11T21:00:00+00:00" }, { "id": "01a0c554-44bd-70c5-ac46-912db313ac33", "title": "Fast Choropleth Map with Enhanced Features", "url": "https://www.clearlyandsimply.com/2012/09/fast-choropleth-map-with-enhanced-features/", "published_at": "2012-09-08T22:00:00+00:00" }, { "id": "01a0c554-44bd-70c5-ac46-912db3f6df32", "title": "Faster Choropleth Maps with Microsoft Excel", "url": "https://www.clearlyandsimply.com/2012/09/faster-choropleth-maps-with-microsoft-excel/", "published_at": "2012-09-04T23:00:00+00:00" }, { "id": "01a0c554-44bd-70c5-ac46-912db46a37f6", "title": "Microsoft Excel Check List Template", "url": "https://www.clearlyandsimply.com/2012/08/microsoft-excel-check-list-template/", "published_at": "2012-08-26T22:00:00+00:00" }, { "id": "01a0c554-44bd-70c5-ac46-912db4731d9c", "title": "Embed and Open Tableau Workbooks in PowerPoint", "url": "https://www.clearlyandsimply.com/2012/05/embed-and-open-tableau-workbooks-in-powerpoint/", "published_at": "2012-05-06T23:00:00+00:00" }, { "id": "01a0c554-44bd-70c5-ac46-912db50d4136", "title": "Embed Tableau Visualizations in PowerPoint", "url": "https://www.clearlyandsimply.com/2012/05/embed-tableau-visualizations-in-powerpoint/", "published_at": "2012-05-05T14:00:00+00:00" }, { "id": "01a0c554-44bd-70c5-ac46-912db5302007", "title": "Dice Portraits of the Tableau Management", "url": "https://www.clearlyandsimply.com/2012/04/dice-portraits-of-the-tableau-management/", "published_at": "2012-04-09T23:00:00+00:00" }, { "id": "01a0c554-44bd-70c5-ac46-912db5718c93", "title": "Taking up the SAP BO Dashboards Challenge", "url": "https://www.clearlyandsimply.com/2012/04/taking-up-the-sap-bo-dashboards-challenge/", "published_at": "2012-04-07T23:00:00+00:00" }, { "id": "01a0c554-44bd-70c5-ac46-912db64bc644", "title": "Dynamic Hierarchies with Tableau", "url": "https://www.clearlyandsimply.com/2012/03/dynamic-hierarchies-with-tableau/", "published_at": "2012-03-14T22:00:00+00:00" } ] posts Claim your blog

Back to clearlyandsimply.com

Blog · corpus.blog/blogs/clearlyandsimply.com/posts

clearlyandsimply.com

clearlyandsimply.com

2025

Select and Highlight across an Excel Dashboard original ↗

16 Aug 2025

2020

London Excel Meetup Workbooks original ↗

3 Sept 2020

Visual Workbook Navigation with a Chart Carousel original ↗

23 Aug 2020

A Neural Network to solve Travelling Salesman Problems in Excel original ↗

7 Aug 2020

Excel Oddity using Named Formulas in Charts original ↗

2 Aug 2020

Animated Races of the 4 Big Football Leagues original ↗

11 Jul 2020

An Alternative to the Bar Chart Race original ↗

7 Jul 2020

A practical Example for Dynamic Storyboards original ↗

11 Jun 2020

Dynamic Storyboards in Excel original ↗

10 Jun 2020

How to handle Line Charts with many Data Series original ↗

4 Jun 2020

Adjust Power Query Table Style and Properties original ↗

26 May 2020

Power BI lookalike Tooltips in Microsoft Excel original ↗

25 May 2020

Animated Maps in Microsoft Excel original ↗

21 May 2020

Create a Summary Table in Power Query original ↗

18 May 2020

All Peaks of the Alps visualized in Excel original ↗

8 May 2020

All Peaks of the Alps visualized with Tableau original ↗

29 Apr 2020

Optimized Choropleth Maps in Microsoft Excel original ↗

22 Apr 2020

Filter Excel Dashboards with Slicers and Timelines original ↗

20 Apr 2020

Dynamic Icons in Microsoft Excel Cell Ranges original ↗

16 Apr 2020

My 2 Cents on the COVID-19 Dashboard by JHU original ↗

13 Apr 2020

Microsoft Excel Project Calendar Template original ↗

8 Apr 2020

Choropleth Maps of Italy in Excel original ↗

6 Apr 2020

Heat Maps with Individual Color Scales in Excel original ↗

3 Apr 2020

Analytical Color Scales for Heat Maps original ↗

2 Apr 2020

Showcase for Table Slicers on Excel Dashboards original ↗

31 Mar 2020

Weighted Route Maps in Excel original ↗

30 Mar 2020

Geographical Flow Maps in Excel (Part 3 of 3)original ↗

27 Mar 2020

Geographical Flow Maps in Excel (Part 2 of 3)original ↗

26 Mar 2020

Geographical Flow Maps in Excel (Part 1 of 3)original ↗

25 Mar 2020

Filter Excel Dashboards with Table Slicers original ↗

23 Mar 2020

2017

Microsoft Excel Workbook Metrics original ↗

6 Aug 2017

Variations of Alternative Bullet Graphs in Excel original ↗

17 Jul 2017

US Choropleth Map by County per State – a 4th Option original ↗

21 Jun 2017

US Choropleth Map by County per State original ↗

19 Jun 2017

Highlight Actions in Microsoft Excel with Multiselecting original ↗

18 Jun 2017

Highlight Actions in Microsoft Excel original ↗

13 Jun 2017

Alternative Bullet Graph Design in Tableau original ↗

23 May 2017

Interactive Bullet Graphs in Excel original ↗

12 May 2017

An Alternative Design of Bullet Graphs original ↗

8 May 2017

Microsoft Excel VBA Progress Indicators original ↗

2 May 2017

Excel VBA Read and Write Performance Test original ↗

28 Apr 2017

Mouse Driven Actions on Excel Dashboards original ↗

25 Apr 2017

S-Shaped Function in Microsoft Excel original ↗

24 Apr 2017

S-Shaped Function in Tableau original ↗

23 Apr 2017

Solar Calculations in Tableau original ↗

9 Apr 2017

2016

User-defined Excel Chart Tooltips original ↗

14 Sept 2016

List of all Files in a Folder and its Subfolders original ↗

29 Aug 2016

Customizable Tooltips on Excel Charts original ↗

27 Aug 2016

Writing and Reading Tableau Views to and from Databases and Text Files – Part 2 original ↗

9 Jun 2016

Writing and Reading Tableau Views to and from Databases and Text Files – Part 1 original ↗

8 Jun 2016

2015

Zooming in and out of Excel Charts original ↗

16 Jul 2015

Select Areas on a USA Map in Microsoft Excel original ↗

7 Jul 2015

Export Excel Dashboards (Improved Version)original ↗

6 Jul 2015

Export Excel Dashboards to other Applications original ↗

5 Jul 2015

Cartograms in Microsoft Excel original ↗

30 Jun 2015

Create your own Cartograms in Tableau original ↗

20 Jun 2015

German Public Holidays in Tableau original ↗

31 May 2015

US Public Holidays in Tableau original ↗

30 May 2015

Selecting and Highlighting Areas on Excel Charts original ↗

27 May 2015

Another Technique for Interactive Excel Charts original ↗

25 May 2015

Cartograms in Tableau original ↗

29 Apr 2015

Create Excel Freeform Shapes from Polygons original ↗

17 Apr 2015

Excel Oddity: Camera Objects bloat File Size original ↗

28 Mar 2015

Highlighting on Excel Dashboards original ↗

26 Mar 2015

Word Clouds with Tableau original ↗

24 Mar 2015

The Implementation of Word Clouds with Excel original ↗

12 Mar 2015

Word Clouds with Microsoft Excel original ↗

24 Feb 2015

Microsoft Excel Check List Compilation original ↗

20 Jan 2015

2014

SQL Saturday BA Edition 2014 in London original ↗

24 Nov 2014

Gapminder Replica in Microsoft Excel original ↗

6 Sept 2014

Financial Modeling World Championships 2014 original ↗

31 Aug 2014

La Gazzetta dello Sport gives Tableau a try original ↗

29 Aug 2014

Motion Chart Excel Template original ↗

23 Aug 2014

Tableau’s Viz as Art Contest – My Entries original ↗

13 Aug 2014

Drill Up and Down on Choropleth Maps in Excel original ↗

22 Jun 2014

String Calculations in Tableau original ↗

13 Jun 2014

99 Blog Posts and 1000 Comments original ↗

24 May 2014

Pivot-like Marimekko Charts in Excel original ↗

20 May 2014

Marimekko Charts in Microsoft Excel original ↗

18 May 2014

Extract Custom Shapes from a Tableau Workbook original ↗

15 May 2014

2013

Bruce Springsteen Discography in Excel original ↗

2 Jul 2013

Bruce Springsteen Discography – An Infographic original ↗

24 Jun 2013

2012

Build Network Graphs in Tableau original ↗

11 Dec 2012

Create Excel Choropleth Maps from Shape Files original ↗

9 Dec 2012

Interactive Tooltip Examples original ↗

11 Nov 2012

Interactive Tooltips on Excel Worksheets original ↗

10 Nov 2012

Roll Over Tooltips and Web Actions on a Microsoft Excel Dashboard original ↗

4 Nov 2012

Filter Excel Tables by Double Clicking original ↗

2 Nov 2012

Interactive Drop Lines on Microsoft Excel Charts original ↗

28 Oct 2012

Tableau Quick Tip #4 – Drop Lines original ↗

20 Oct 2012

O’zapft is!original ↗

22 Sept 2012

Web Page Objects on Tableau Dashboards original ↗

11 Sept 2012

Fast Choropleth Map with Enhanced Features original ↗

8 Sept 2012

Faster Choropleth Maps with Microsoft Excel original ↗

4 Sept 2012

Microsoft Excel Check List Template original ↗

26 Aug 2012

Embed and Open Tableau Workbooks in PowerPoint original ↗

6 May 2012

Embed Tableau Visualizations in PowerPoint original ↗

5 May 2012

Dice Portraits of the Tableau Management original ↗

9 Apr 2012

Taking up the SAP BO Dashboards Challenge original ↗

7 Apr 2012

Dynamic Hierarchies with Tableau original ↗

14 Mar 2012