corpus.blog
41554 blogs · [ { "id": "01a08776-1e13-7362-b56f-aa8e0576d084", "title": "Combine multiple sheets in Power Query with a Transform Sample Sheet", "url": "https://exceloffthegrid.com/transform-sample-sheet/", "published_at": "2025-05-09T11:04:02+00:00" }, { "id": "01a08776-1e13-7362-b56f-aa8e061fbf2e", "title": "How to remove Excel passwords (all 6 types)", "url": "https://exceloffthegrid.com/removing-cracking-excel-passwords-with-vba/", "published_at": "2024-07-31T16:00:00+00:00" }, { "id": "01a08776-1e13-7362-b56f-aa8e06a6147b", "title": "Common Power Query errors & how to fix them", "url": "https://exceloffthegrid.com/power-query-common-errors/", "published_at": "2024-06-12T15:00:00+00:00" }, { "id": "01a08776-1e13-7362-b56f-aa8e0768369f", "title": "Power Query date format (How to + 5 tricky scenarios)", "url": "https://exceloffthegrid.com/power-query-date-formats/", "published_at": "2024-06-11T14:00:00+00:00" }, { "id": "01a08776-1e13-7362-b56f-aa8e07bd5d7d", "title": "Formatted dynamic chart titles in Excel", "url": "https://exceloffthegrid.com/create-dynamic-chart-titles/", "published_at": "2024-05-28T14:00:00+00:00" }, { "id": "01a08776-1e13-7362-b56f-aa8e081c82c5", "title": "How to convert text to a formula in Excel (3 ways)", "url": "https://exceloffthegrid.com/convert-string-to-formula/", "published_at": "2024-05-23T09:00:00+00:00" }, { "id": "01a08776-1e13-7362-b56f-aa8e084878bf", "title": "How to create a relative named range in Excel", "url": "https://exceloffthegrid.com/creating-relative-named-ranges/", "published_at": "2024-05-16T12:00:00+00:00" }, { "id": "01a08776-1e13-7362-b56f-aa8e08ad0ae5", "title": "How to change source connector in Power Query", "url": "https://exceloffthegrid.com/change-source-connector-power-query/", "published_at": "2024-05-09T09:22:45+00:00" }, { "id": "01a08776-1e13-7362-b56f-aa8e096ce153", "title": "How to use Excel Table within a data validation list (4 easy ways)", "url": "https://exceloffthegrid.com/using-an-excel-table-within-a-data-validation-list/", "published_at": "2024-05-08T15:00:00+00:00" }, { "id": "01a08776-1e13-7362-b56f-aa8e0a5d44c8", "title": "Create your own keyboard shortcuts in Excel (5 ways)", "url": "https://exceloffthegrid.com/create-keyboard-shortcuts/", "published_at": "2024-05-02T08:21:52+00:00" }, { "id": "01a0c50c-1a51-7003-acab-2495de426ca3", "title": "How to auto refresh Power Query in Excel (6 ways)", "url": "https://exceloffthegrid.com/auto-refresh-power-query/", "published_at": "2024-04-26T10:00:00+00:00" }, { "id": "01a0c50c-1a51-7003-acab-2495defb0340", "title": "How to copy file with VBA in Excel (10 examples)", "url": "https://exceloffthegrid.com/vba-copy-file/", "published_at": "2024-04-19T08:00:00+00:00" }, { "id": "01a0c50c-1a51-7003-acab-2495df031af8", "title": "How to calculate Weighted Average in Excel (4 easy examples)", "url": "https://exceloffthegrid.com/weighted-average-in-excel/", "published_at": "2024-04-17T15:00:00+00:00" }, { "id": "01a0c50c-1a51-7003-acab-2495dfbaa318", "title": "How to create multiple folders at once with Excel", "url": "https://exceloffthegrid.com/create-multiple-folders/", "published_at": "2024-04-11T09:00:00+00:00" }, { "id": "01a0c50c-1a51-7003-acab-2495dfc0320c", "title": "How to automate Excel with reusable Office Scripts", "url": "https://exceloffthegrid.com/reusable-office-scripts/", "published_at": "2024-04-04T08:10:58+00:00" }, { "id": "01a0c50c-1a51-7003-acab-2495e0344cf1", "title": "Don’t trust data validation in Excel!", "url": "https://exceloffthegrid.com/dont-trust-data-validation/", "published_at": "2024-03-28T10:48:16+00:00" }, { "id": "01a0c50c-1a51-7003-acab-2495e07f89f2", "title": "Change number format based on a cell value in Excel", "url": "https://exceloffthegrid.com/change-number-format-based-on-its-value/", "published_at": "2024-03-21T09:49:04+00:00" }, { "id": "01a0c50c-1a51-7003-acab-2495e0bcabcb", "title": "How to create a Jitter Plot in Excel (100% dynamic)", "url": "https://exceloffthegrid.com/jitter-plot-in-excel/", "published_at": "2024-03-14T11:50:56+00:00" }, { "id": "01a0c50c-1a51-7003-acab-2495e0fae7a5", "title": "How to use Table slicers for advanced interactivity in Excel", "url": "https://exceloffthegrid.com/table-slicers/", "published_at": "2024-03-07T10:25:47+00:00" }, { "id": "01a0c50c-1a51-7003-acab-2495e1d31436", "title": "How to use slicers with PIVOTBY, GROUPBY & FILTER in Excel", "url": "https://exceloffthegrid.com/slicers-with-pivotby/", "published_at": "2024-02-29T10:38:25+00:00" }, { "id": "01a0c51b-90f5-72a5-83e5-f86ea788440a", "title": "EOMONTH function in Excel (How to + 8 examples)", "url": "https://exceloffthegrid.com/eomonth-function-in-excel/", "published_at": "2024-02-22T09:55:16+00:00" }, { "id": "01a0c51b-90f5-72a5-83e5-f86ea8199be0", "title": "How to make a Dumbbell Dot Plot in Excel (100% dynamic)", "url": "https://exceloffthegrid.com/dumbbell-dot-plot-in-excel/", "published_at": "2024-02-15T11:40:24+00:00" }, { "id": "01a0c51b-90f5-72a5-83e5-f86ea8d3deb3", "title": "How to use SUMIFS with arrays (Excel problem solved!)", "url": "https://exceloffthegrid.com/sumifs-with-arrays/", "published_at": "2024-02-08T13:04:27+00:00" }, { "id": "01a0c51b-90f5-72a5-83e5-f86ea926b355", "title": "Calculate quarter from dates in Excel (inc non-standard calendars)", "url": "https://exceloffthegrid.com/quarter-from-dates/", "published_at": "2024-02-01T08:56:30+00:00" }, { "id": "01a0c51b-90f5-72a5-83e5-f86ea9a92e0c", "title": "Promote headers in nested tables before expanding columns (2 ways)", "url": "https://exceloffthegrid.com/promote-headers-before-expanding/", "published_at": "2024-01-25T09:39:50+00:00" }, { "id": "01a0c51b-90f5-72a5-83e5-f86ea9c34e69", "title": "How to spill multiple FILTER functions in Excel", "url": "https://exceloffthegrid.com/spill-multiple-filter-functions/", "published_at": "2024-01-18T10:01:11+00:00" }, { "id": "01a0c51b-90f5-72a5-83e5-f86eaa2c7e64", "title": "How to add manual information to a query (commentary & references)", "url": "https://exceloffthegrid.com/add-manual-information-to-a-query/", "published_at": "2024-01-11T08:28:05+00:00" }, { "id": "01a0c51b-90f5-72a5-83e5-f86eab16762e", "title": "Automate Reconciliations with Power Query (amazing time saver)", "url": "https://exceloffthegrid.com/automate-reconciliations-with-power-query/", "published_at": "2024-01-04T10:16:23+00:00" }, { "id": "01a0c51b-90f5-72a5-83e5-f86eab6bb8c1", "title": "Text functions – Excel & Power Query comparison", "url": "https://exceloffthegrid.com/text-functions-excel-vs-powerquery/", "published_at": "2023-12-05T17:50:28+00:00" }, { "id": "01a0c51b-90f5-72a5-83e5-f86eac29ed13", "title": "Get data from latest file with Power Query", "url": "https://exceloffthegrid.com/data-latest-file-power-query/", "published_at": "2023-11-28T12:12:47+00:00" }, { "id": "01a0c526-b4d2-7378-b44e-96da4e3b0978", "title": "How to create chart data with Power Query", "url": "https://exceloffthegrid.com/power-query-chart-data/", "published_at": "2023-11-16T11:30:36+00:00" }, { "id": "01a0c526-b4d2-7378-b44e-96da4f084ca0", "title": "How to easily swap ranges in Excel (1 click)", "url": "https://exceloffthegrid.com/swap-ranges/", "published_at": "2023-10-27T12:00:00+00:00" }, { "id": "01a0c526-b4d2-7378-b44e-96da4fab7fed", "title": "Cell ranges: 99% of users don’t know this", "url": "https://exceloffthegrid.com/cell-ranges-basic-things-99-users-dont-know/", "published_at": "2023-10-17T13:49:54+00:00" }, { "id": "01a0c526-b4d2-7378-b44e-96da4fea68f6", "title": "When you should merge cells in Excel – 3 scenarios", "url": "https://exceloffthegrid.com/when-to-merge-cells-in-excel/", "published_at": "2023-09-14T09:00:00+00:00" }, { "id": "01a0c526-b4d2-7378-b44e-96da502ae11c", "title": "How to make cross filter visuals in Excel (amazing interactive visuals)", "url": "https://exceloffthegrid.com/cross-filter-visuals/", "published_at": "2023-08-31T09:00:00+00:00" }, { "id": "01a0c526-b4d2-7378-b44e-96da51118780", "title": "Power Query: Rename columns in nested tables from list (without errors)", "url": "https://exceloffthegrid.com/power-query-rename-columns-nested-tables/", "published_at": "2023-08-24T09:00:00+00:00" }, { "id": "01a0c526-b4d2-7378-b44e-96da51831d85", "title": "How to create Multiple PDFs from Excel (Office Scripts + Power Automate)", "url": "https://exceloffthegrid.com/multiple-pdfs-office-scripts/", "published_at": "2023-08-17T09:00:00+00:00" }, { "id": "01a0c526-b4d2-7378-b44e-96da51dcb241", "title": "How to add fiscal Month, Quarter or Year Column in Power Query", "url": "https://exceloffthegrid.com/power-query-fiscal-month-quarter-year/", "published_at": "2023-08-10T09:00:00+00:00" }, { "id": "01a0c526-b4d2-7378-b44e-96da52b18dd6", "title": "Power Query: How to multiple replace values based on a list", "url": "https://exceloffthegrid.com/power-query-replace-values-from-list/", "published_at": "2023-08-03T09:00:00+00:00" }, { "id": "01a0c526-b4d2-7378-b44e-96da52e54b32", "title": "How to transform nested tables in Power Query (without coding)", "url": "https://exceloffthegrid.com/transform-nested-table/", "published_at": "2023-07-27T09:00:00+00:00" }, { "id": "01a0c532-09a6-734e-91a0-77ca82412f4d", "title": "How to Find & Replace multiple words in Excel: REDUCE & SUBSTITUTE", "url": "https://exceloffthegrid.com/find-replace-multiple-words/", "published_at": "2023-07-20T09:00:00+00:00" }, { "id": "01a0c532-09a6-734e-91a0-77ca827fd280", "title": "How to make an interactive view-only dashboard from Excel", "url": "https://exceloffthegrid.com/view-only-dashboard-excel/", "published_at": "2023-07-13T09:00:00+00:00" }, { "id": "01a0c532-09a6-734e-91a0-77ca836e7fc8", "title": "Power Query: How to Combine files based on a list", "url": "https://exceloffthegrid.com/power-query-files-from-list/", "published_at": "2023-07-06T09:00:00+00:00" }, { "id": "01a0c532-09a6-734e-91a0-77ca83c708d5", "title": "How to create dynamic text in Excel (TEXT + Number Formats)", "url": "https://exceloffthegrid.com/dynamic-text-number-formats/", "published_at": "2023-06-22T09:00:00+00:00" }, { "id": "01a0c532-09a6-734e-91a0-77ca83f379c6", "title": "How to make Waffle Charts in Excel that work EVERYWHERE!", "url": "https://exceloffthegrid.com/waffle-charts-in-excel-best-method/", "published_at": "2023-06-15T09:00:00+00:00" }, { "id": "01a0c532-09a6-734e-91a0-77ca84411484", "title": "How to make Waffle Charts in Excel: The EASIEST way", "url": "https://exceloffthegrid.com/waffle-charts-in-excel/", "published_at": "2023-06-08T09:00:00+00:00" }, { "id": "01a0c532-09a6-734e-91a0-77ca845fd688", "title": "How to FILTER by a list in Excel (including multiple lists)", "url": "https://exceloffthegrid.com/filter-by-a-list/", "published_at": "2023-06-01T09:00:00+00:00" }, { "id": "01a0c532-09a6-734e-91a0-77ca84c296b1", "title": "Excel number formats for accounting & finance you NEED to know", "url": "https://exceloffthegrid.com/number-formats-for-accounting-and-finance/", "published_at": "2023-05-25T09:00:00+00:00" }, { "id": "01a0c532-09a6-734e-91a0-77ca859101c0", "title": "How to expand columns dynamically in Power Query", "url": "https://exceloffthegrid.com/expand-columns-dynamically-power-query/", "published_at": "2023-05-18T09:00:00+00:00" }, { "id": "01a0c532-09a6-734e-91a0-77ca85e7b4e5", "title": "How to run Excel macros from Power Automate Desktop", "url": "https://exceloffthegrid.com/excel-macros-from-power-automate-desktop/", "published_at": "2023-05-11T09:00:00+00:00" }, { "id": "01a0c53c-0421-7180-a21f-d796f7b034b6", "title": "How To Create Sheets For Each Item In PivotTable Field", "url": "https://exceloffthegrid.com/show-report-filter-pages/", "published_at": "2023-05-04T09:00:00+00:00" }, { "id": "01a0c53c-0421-7180-a21f-d796f841cb90", "title": "Power Query: Get data when sheet/Table names change (2 ways)", "url": "https://exceloffthegrid.com/data-from-workbook-by-position/", "published_at": "2023-04-27T15:06:00+00:00" }, { "id": "01a0c53c-0421-7180-a21f-d796f93bb2a5", "title": "How to create QR codes in Excel for FREE (3 easy ways)", "url": "https://exceloffthegrid.com/qr-codes-in-excel/", "published_at": "2023-04-20T09:00:00+00:00" }, { "id": "01a0c53c-0421-7180-a21f-d796f97f2b77", "title": "Move data between workbooks (Power Automate+Office Scripts)", "url": "https://exceloffthegrid.com/move-data-between-workbooks-power-automate/", "published_at": "2023-04-13T09:00:00+00:00" }, { "id": "01a0c53c-0421-7180-a21f-d796f98c4dfb", "title": "How to filter by a list in Power Query (4 methods)", "url": "https://exceloffthegrid.com/power-query-filter-list/", "published_at": "2023-04-06T09:00:00+00:00" }, { "id": "01a0c53c-0421-7180-a21f-d796f9c51631", "title": "How to run any macro from one button (magic macro)", "url": "https://exceloffthegrid.com/any-macro-one-button/", "published_at": "2023-03-30T09:00:00+00:00" }, { "id": "01a0c53c-0421-7180-a21f-d796f9f915af", "title": "How to get data from SharePoint List with Power Query", "url": "https://exceloffthegrid.com/get-data-from-sharepoint-list/", "published_at": "2023-03-21T10:00:00+00:00" }, { "id": "01a0c53c-0421-7180-a21f-d796fa35ad87", "title": "Automatic commentary writing formula in Excel – Amazing LAMBDA", "url": "https://exceloffthegrid.com/commentary-writing-formula/", "published_at": "2023-03-16T10:00:00+00:00" }, { "id": "01a0c53c-0421-7180-a21f-d796fad5069b", "title": "Browse for file path with VBA: insert value into cell", "url": "https://exceloffthegrid.com/insert-file-path-into-cell-with-browse-button/", "published_at": "2023-03-14T10:00:00+00:00" }, { "id": "01a0c53c-0421-7180-a21f-d796fb9da370", "title": "VBA Rename File (How to + 5 code examples)", "url": "https://exceloffthegrid.com/vba-rename-file/", "published_at": "2023-03-13T22:00:00+00:00" }, { "id": "01a0c545-0b0c-7320-83c4-350c33dc0ea6", "title": "How to remove spaces in Power Query", "url": "https://exceloffthegrid.com/remove-spaces-in-power-query/", "published_at": "2023-03-12T10:00:00+00:00" }, { "id": "01a0c545-0b0c-7320-83c4-350c34c0f28e", "title": "How to create user forms in Office Scripts (4 ways)", "url": "https://exceloffthegrid.com/user-forms-office-scripts/", "published_at": "2023-03-09T10:00:00+00:00" }, { "id": "01a0c545-0b0c-7320-83c4-350c3584a52e", "title": "How to create nice looking Office Scripts button (3 ways)", "url": "https://exceloffthegrid.com/office-scripts-button/", "published_at": "2023-03-02T10:00:00+00:00" }, { "id": "01a0c545-0b0c-7320-83c4-350c3636cba5", "title": "How to email or save Excel images with Power Automate", "url": "https://exceloffthegrid.com/excel-images-with-power-automate/", "published_at": "2023-02-23T10:00:00+00:00" }, { "id": "01a0c545-0b0c-7320-83c4-350c372cb38a", "title": "How to create dynamic chart legends in Excel", "url": "https://exceloffthegrid.com/dynamic-chart-legends/", "published_at": "2023-02-16T10:00:00+00:00" }, { "id": "01a0c545-0b0c-7320-83c4-350c3810f0af", "title": "How to run Power Automate from Excel with Office Scripts or VBA", "url": "https://exceloffthegrid.com/power-automate-from-excel/", "published_at": "2023-02-09T10:00:00+00:00" }, { "id": "01a0c545-0b0c-7320-83c4-350c3826e1a3", "title": "How to fix the Formula.Firewall error in Power Query (2 ways)", "url": "https://exceloffthegrid.com/formula-firewall-in-power-query/", "published_at": "2023-02-06T10:00:00+00:00" }, { "id": "01a0c545-0b0c-7320-83c4-350c3894094c", "title": "Application.CutCopyMode = False (How to use it)", "url": "https://exceloffthegrid.com/what-is-cutcopymode-false-should-i-use-it/", "published_at": "2023-02-05T07:00:00+00:00" }, { "id": "01a0c545-0b0c-7320-83c4-350c39658411", "title": "How to install or uninstall Excel Add-ins (Windows & Mac)", "url": "https://exceloffthegrid.com/install-uninstall-excel-add/", "published_at": "2023-02-04T10:00:00+00:00" }, { "id": "01a0c545-0b0c-7320-83c4-350c39cd4ab6", "title": "INDEX MATCH MATCH in Excel (How to do 2-dimension lookup)", "url": "https://exceloffthegrid.com/index-match-match-in-excel-2-dimension-lookup/", "published_at": "2023-02-02T08:00:00+00:00" }, { "id": "01a0c54d-e7e0-71d9-b34b-5c0e7a318486", "title": "Advanced dynamic array formula techniques (3 methods)", "url": "https://exceloffthegrid.com/advanced-dynamic-array-formula-techniques/", "published_at": "2023-01-31T10:23:00+00:00" }, { "id": "01a0c54d-e7e0-71d9-b34b-5c0e7a406cb5", "title": "How to use dynamic arrays with other features (7 scenarios)", "url": "https://exceloffthegrid.com/using-dynamic-arrays-with-other-excel-features/", "published_at": "2023-01-30T10:00:00+00:00" }, { "id": "01a0c54d-e7e0-71d9-b34b-5c0e7ad60ca6", "title": "RANDARRAY function in Excel (How to + 4 Examples)", "url": "https://exceloffthegrid.com/randarray-function-in-excel/", "published_at": "2023-01-28T10:00:00+00:00" }, { "id": "01a0c54d-e7e0-71d9-b34b-5c0e7afb4c08", "title": "SEQUENCE function in Excel (How to + 5 Examples)", "url": "https://exceloffthegrid.com/sequence-function-in-excel/", "published_at": "2023-01-28T08:35:00+00:00" }, { "id": "01a0c54d-e7e0-71d9-b34b-5c0e7bdbf48a", "title": "FILTER function in Excel (How to + 8 Examples)", "url": "https://exceloffthegrid.com/filter-function-in-excel/", "published_at": "2023-01-27T08:34:00+00:00" }, { "id": "01a0c54d-e7e0-71d9-b34b-5c0e7c26dea0", "title": "SORTBY function in Excel (How to + 6 Examples)", "url": "https://exceloffthegrid.com/sortby-function-in-excel/", "published_at": "2023-01-26T08:33:00+00:00" }, { "id": "01a0c54d-e7e0-71d9-b34b-5c0e7c9763fa", "title": "SORT function in Excel (How to + 6 Examples)", "url": "https://exceloffthegrid.com/sort-function-in-excel/", "published_at": "2023-01-25T08:32:00+00:00" }, { "id": "01a0c54d-e7e0-71d9-b34b-5c0e7d4fb9b1", "title": "UNIQUE function in Excel (How to + 6 Examples)", "url": "https://exceloffthegrid.com/unique-function-in-excel/", "published_at": "2023-01-24T08:31:00+00:00" }, { "id": "01a0c54d-e7e0-71d9-b34b-5c0e7d62d76e", "title": "Dynamic arrays in Excel – Everything you NEED to know", "url": "https://exceloffthegrid.com/dynamic-arrays-in-excel/", "published_at": "2023-01-22T08:30:00+00:00" }, { "id": "01a0c54d-e7e0-71d9-b34b-5c0e7dac11fb", "title": "Get data from OneDrive Personal files with Power Query", "url": "https://exceloffthegrid.com/power-query-connect-to-onedrive-personal-files/", "published_at": "2023-01-17T08:28:00+00:00" }, { "id": "01a0c556-6afe-73a9-a064-c5b2b89bc3ac", "title": "How to run a macro from a macro (from another workbook)", "url": "https://exceloffthegrid.com/how-to-run-a-macro-from-another-workbook/", "published_at": "2023-01-17T08:18:00+00:00" }, { "id": "01a0c556-6afe-73a9-a064-c5b2b92380eb", "title": "Get data from OneDrive or SharePoint with Power Query", "url": "https://exceloffthegrid.com/power-query-connect-onedrive-sharepoint/", "published_at": "2023-01-16T08:12:00+00:00" }, { "id": "01a0c556-6afe-73a9-a064-c5b2b9ec99cb", "title": "How to resize Excel sheet – 4 ways: manual & automatic", "url": "https://exceloffthegrid.com/auto-resize-excel-spreadsheet/", "published_at": "2023-01-12T08:45:00+00:00" }, { "id": "01a0c556-6afe-73a9-a064-c5b2ba6ccd2e", "title": "How to create a Sankey diagram in Excel", "url": "https://exceloffthegrid.com/sankey-diagram-in-excel/", "published_at": "2023-01-12T08:00:00+00:00" }, { "id": "01a0c556-6afe-73a9-a064-c5b2ba949120", "title": "How to list all possible combinations from multiple lists (2 ways)", "url": "https://exceloffthegrid.com/list-of-all-possible-combinations-using-power-query/", "published_at": "2023-01-12T07:30:00+00:00" }, { "id": "01a0c556-6afe-73a9-a064-c5b2ba968bf2", "title": "Excel calculation mode keeps changing: How to fix it!", "url": "https://exceloffthegrid.com/why-does-the-calculation-mode-keep-changing/", "published_at": "2023-01-11T09:30:00+00:00" }, { "id": "01a0c556-6afe-73a9-a064-c5b2bb767d1a", "title": "How to close VBA UserForm: Hide vs Unload", "url": "https://exceloffthegrid.com/closing-vba-userforms-hide-vs-unload/", "published_at": "2023-01-10T09:30:00+00:00" }, { "id": "01a0c556-6afe-73a9-a064-c5b2bbc2f841", "title": "How to automate Goal Seek in Excel with VBA Macro (2 ways)", "url": "https://exceloffthegrid.com/automated-goal-seek/", "published_at": "2022-12-07T08:00:00+00:00" }, { "id": "01a0c556-6afe-73a9-a064-c5b2bc611bbc", "title": "How to calculate Power Query Percent of total or category", "url": "https://exceloffthegrid.com/power-query-percent-of-total/", "published_at": "2022-12-05T09:03:00+00:00" }, { "id": "01a0c556-6afe-73a9-a064-c5b2bd5b2fa7", "title": "How to change images based on cell values (3 ways)", "url": "https://exceloffthegrid.com/automatically-change-picture/", "published_at": "2022-12-03T11:39:00+00:00" }, { "id": "01a0c55e-9708-71d9-b8fb-f99b1e69a157", "title": "How to calculate CAGR in Excel (5 easy ways)", "url": "https://exceloffthegrid.com/calculate-cagr-in-excel-compound-annual-growth-rate/", "published_at": "2022-12-02T08:00:00+00:00" }, { "id": "01a0c55e-9708-71d9-b8fb-f99b1f32bc59", "title": "How to remove spaces in Excel (7 simple ways)", "url": "https://exceloffthegrid.com/remove-additional-spaces-in-excel/", "published_at": "2022-11-29T09:00:00+00:00" }, { "id": "01a0c55e-9708-71d9-b8fb-f99b1f4198ca", "title": "How to add a drop-down list in Excel (3 easy ways)", "url": "https://exceloffthegrid.com/drop-down-list/", "published_at": "2022-11-28T12:00:00+00:00" }, { "id": "01a0c55e-9708-71d9-b8fb-f99b1ff7e43e", "title": "How to get data into Power Query – 5 common data sources", "url": "https://exceloffthegrid.com/power-query-import-data/", "published_at": "2022-11-25T15:00:00+00:00" }, { "id": "01a0c55e-9708-71d9-b8fb-f99b20144cb7", "title": "How to display fractions in Excel (the easy way)", "url": "https://exceloffthegrid.com/how-to-display-fractions-in-excel/", "published_at": "2022-11-24T11:16:00+00:00" }, { "id": "01a0c55e-9708-71d9-b8fb-f99b20eb7310", "title": "How to combine rows in Power Query", "url": "https://exceloffthegrid.com/power-query-combine-rows-into-a-single-cell/", "published_at": "2022-11-22T12:00:00+00:00" }, { "id": "01a0c55e-9708-71d9-b8fb-f99b214218c1", "title": "Excel Table absolute reference for cells, columns, and rows", "url": "https://exceloffthegrid.com/excel-tables-absolute-references/", "published_at": "2022-11-21T11:00:00+00:00" }, { "id": "01a0c55e-9708-71d9-b8fb-f99b21ae4bb4", "title": "Useful VBA codes for Excel (30 example macros + Free ebook)", "url": "https://exceloffthegrid.com/excel-vba-macros/", "published_at": "2022-11-21T10:00:00+00:00" }, { "id": "01a0c55e-9708-71d9-b8fb-f99b2292a7df", "title": "How to convert color codes (RGB, HSL, HSV, Hex, Long, CMYK)", "url": "https://exceloffthegrid.com/convert-color-codes/", "published_at": "2022-11-17T13:00:00+00:00" }, { "id": "01a0c55e-9708-71d9-b8fb-f99b235441ec", "title": "How to add double quotes in Excel formula", "url": "https://exceloffthegrid.com/insert-double-quotes-in-an-excel-formula/", "published_at": "2022-11-15T11:32:00+00:00" } ] posts Claim your blog
Back to exceloffthegrid.com
Blog · corpus.blog/blogs/exceloffthegrid.com/posts

exceloffthegrid.com

exceloffthegrid.com

2025

Combine multiple sheets in Power Query with a Transform Sample Sheetoriginal ↗
9 May 2025

2024

How to remove Excel passwords (all 6 types)original ↗
31 Jul 2024
Common Power Query errors & how to fix themoriginal ↗
12 Jun 2024
Power Query date format (How to + 5 tricky scenarios)original ↗
11 Jun 2024
Formatted dynamic chart titles in Exceloriginal ↗
28 May 2024
How to convert text to a formula in Excel (3 ways)original ↗
23 May 2024
How to create a relative named range in Exceloriginal ↗
16 May 2024
How to change source connector in Power Queryoriginal ↗
9 May 2024
How to use Excel Table within a data validation list (4 easy ways)original ↗
8 May 2024
Create your own keyboard shortcuts in Excel (5 ways)original ↗
2 May 2024
How to auto refresh Power Query in Excel (6 ways)original ↗
26 Apr 2024
How to copy file with VBA in Excel (10 examples)original ↗
19 Apr 2024
How to calculate Weighted Average in Excel (4 easy examples)original ↗
17 Apr 2024
How to create multiple folders at once with Exceloriginal ↗
11 Apr 2024
How to automate Excel with reusable Office Scriptsoriginal ↗
4 Apr 2024
Don’t trust data validation in Excel!original ↗
28 Mar 2024
Change number format based on a cell value in Exceloriginal ↗
21 Mar 2024
How to create a Jitter Plot in Excel (100% dynamic)original ↗
14 Mar 2024
How to use Table slicers for advanced interactivity in Exceloriginal ↗
7 Mar 2024
How to use slicers with PIVOTBY, GROUPBY & FILTER in Exceloriginal ↗
29 Feb 2024
EOMONTH function in Excel (How to + 8 examples)original ↗
22 Feb 2024
How to make a Dumbbell Dot Plot in Excel (100% dynamic)original ↗
15 Feb 2024
How to use SUMIFS with arrays (Excel problem solved!)original ↗
8 Feb 2024
Calculate quarter from dates in Excel (inc non-standard calendars)original ↗
1 Feb 2024
Promote headers in nested tables before expanding columns (2 ways)original ↗
25 Jan 2024
How to spill multiple FILTER functions in Exceloriginal ↗
18 Jan 2024
How to add manual information to a query (commentary & references)original ↗
11 Jan 2024
Automate Reconciliations with Power Query (amazing time saver)original ↗
4 Jan 2024

2023

Text functions – Excel & Power Query comparisonoriginal ↗
5 Dec 2023
Get data from latest file with Power Queryoriginal ↗
28 Nov 2023
How to create chart data with Power Queryoriginal ↗
16 Nov 2023
How to easily swap ranges in Excel (1 click)original ↗
27 Oct 2023
Cell ranges: 99% of users don’t know thisoriginal ↗
17 Oct 2023
When you should merge cells in Excel – 3 scenariosoriginal ↗
14 Sept 2023
How to make cross filter visuals in Excel (amazing interactive visuals)original ↗
31 Aug 2023
Power Query: Rename columns in nested tables from list (without errors)original ↗
24 Aug 2023
How to create Multiple PDFs from Excel (Office Scripts + Power Automate)original ↗
17 Aug 2023
How to add fiscal Month, Quarter or Year Column in Power Queryoriginal ↗
10 Aug 2023
Power Query: How to multiple replace values based on a listoriginal ↗
3 Aug 2023
How to transform nested tables in Power Query (without coding)original ↗
27 Jul 2023
How to Find & Replace multiple words in Excel: REDUCE & SUBSTITUTEoriginal ↗
20 Jul 2023
How to make an interactive view-only dashboard from Exceloriginal ↗
13 Jul 2023
Power Query: How to Combine files based on a listoriginal ↗
6 Jul 2023
How to create dynamic text in Excel (TEXT + Number Formats)original ↗
22 Jun 2023
How to make Waffle Charts in Excel that work EVERYWHERE!original ↗
15 Jun 2023
How to make Waffle Charts in Excel: The EASIEST wayoriginal ↗
8 Jun 2023
How to FILTER by a list in Excel (including multiple lists)original ↗
1 Jun 2023
Excel number formats for accounting & finance you NEED to knoworiginal ↗
25 May 2023
How to expand columns dynamically in Power Queryoriginal ↗
18 May 2023
How to run Excel macros from Power Automate Desktoporiginal ↗
11 May 2023
How To Create Sheets For Each Item In PivotTable Fieldoriginal ↗
4 May 2023
Power Query: Get data when sheet/Table names change (2 ways)original ↗
27 Apr 2023
How to create QR codes in Excel for FREE (3 easy ways)original ↗
20 Apr 2023
Move data between workbooks (Power Automate+Office Scripts)original ↗
13 Apr 2023
How to filter by a list in Power Query (4 methods)original ↗
6 Apr 2023
How to run any macro from one button (magic macro)original ↗
30 Mar 2023
How to get data from SharePoint List with Power Queryoriginal ↗
21 Mar 2023
Automatic commentary writing formula in Excel – Amazing LAMBDAoriginal ↗
16 Mar 2023
Browse for file path with VBA: insert value into celloriginal ↗
14 Mar 2023
VBA Rename File (How to + 5 code examples)original ↗
13 Mar 2023
How to remove spaces in Power Queryoriginal ↗
12 Mar 2023
How to create user forms in Office Scripts (4 ways)original ↗
9 Mar 2023
How to create nice looking Office Scripts button (3 ways)original ↗
2 Mar 2023
How to email or save Excel images with Power Automateoriginal ↗
23 Feb 2023
How to create dynamic chart legends in Exceloriginal ↗
16 Feb 2023
How to run Power Automate from Excel with Office Scripts or VBAoriginal ↗
9 Feb 2023
How to fix the Formula.Firewall error in Power Query (2 ways)original ↗
6 Feb 2023
Application.CutCopyMode = False (How to use it)original ↗
5 Feb 2023
How to install or uninstall Excel Add-ins (Windows & Mac)original ↗
4 Feb 2023
INDEX MATCH MATCH in Excel (How to do 2-dimension lookup)original ↗
2 Feb 2023
Advanced dynamic array formula techniques (3 methods)original ↗
31 Jan 2023
How to use dynamic arrays with other features (7 scenarios)original ↗
30 Jan 2023
RANDARRAY function in Excel (How to + 4 Examples)original ↗
28 Jan 2023
SEQUENCE function in Excel (How to + 5 Examples)original ↗
28 Jan 2023
FILTER function in Excel (How to + 8 Examples)original ↗
27 Jan 2023
SORTBY function in Excel (How to + 6 Examples)original ↗
26 Jan 2023
SORT function in Excel (How to + 6 Examples)original ↗
25 Jan 2023
UNIQUE function in Excel (How to + 6 Examples)original ↗
24 Jan 2023
Dynamic arrays in Excel – Everything you NEED to knoworiginal ↗
22 Jan 2023
Get data from OneDrive Personal files with Power Queryoriginal ↗
17 Jan 2023
How to run a macro from a macro (from another workbook)original ↗
17 Jan 2023
Get data from OneDrive or SharePoint with Power Queryoriginal ↗
16 Jan 2023
How to resize Excel sheet – 4 ways: manual & automaticoriginal ↗
12 Jan 2023
How to create a Sankey diagram in Exceloriginal ↗
12 Jan 2023
How to list all possible combinations from multiple lists (2 ways)original ↗
12 Jan 2023
Excel calculation mode keeps changing: How to fix it!original ↗
11 Jan 2023
How to close VBA UserForm: Hide vs Unloadoriginal ↗
10 Jan 2023

2022

How to automate Goal Seek in Excel with VBA Macro (2 ways)original ↗
7 Dec 2022
How to calculate Power Query Percent of total or categoryoriginal ↗
5 Dec 2022
How to change images based on cell values (3 ways)original ↗
3 Dec 2022
How to calculate CAGR in Excel (5 easy ways)original ↗
2 Dec 2022
How to remove spaces in Excel (7 simple ways)original ↗
29 Nov 2022
How to add a drop-down list in Excel (3 easy ways)original ↗
28 Nov 2022
How to get data into Power Query – 5 common data sourcesoriginal ↗
25 Nov 2022
How to display fractions in Excel (the easy way)original ↗
24 Nov 2022
How to combine rows in Power Queryoriginal ↗
22 Nov 2022
Excel Table absolute reference for cells, columns, and rowsoriginal ↗
21 Nov 2022
Useful VBA codes for Excel (30 example macros + Free ebook)original ↗
21 Nov 2022
How to convert color codes (RGB, HSL, HSV, Hex, Long, CMYK)original ↗
17 Nov 2022
How to add double quotes in Excel formulaoriginal ↗
15 Nov 2022
Next