corpus.blog
41554 blogs · [ { "id": "01a0c566-feda-7358-86be-a9b3e185ec9e", "title": "Private vs Public Subs, Variables & Functions in VBA", "url": "https://exceloffthegrid.com/private-vs-public-in-vba/", "published_at": "2022-11-14T11:00:00+00:00" }, { "id": "01a0c566-feda-7358-86be-a9b3e1c0eb7c", "title": "VBA protect and unprotect Sheets (25+ examples)", "url": "https://exceloffthegrid.com/vba-code-worksheet-protection/", "published_at": "2022-11-11T10:00:00+00:00" }, { "id": "01a0c566-feda-7358-86be-a9b3e242dcfe", "title": "How to create a PivotTable from multiple Tables (easy way)", "url": "https://exceloffthegrid.com/combining-multiple-tables-in-a-pivottable/", "published_at": "2022-11-11T08:00:00+00:00" }, { "id": "01a0c566-feda-7358-86be-a9b3e33b254e", "title": "How to save Excel as PDF with VBA (10 examples)", "url": "https://exceloffthegrid.com/vba-code-save-excel-file-as-pdf/", "published_at": "2022-11-10T08:00:00+00:00" }, { "id": "01a0c566-feda-7358-86be-a9b3e38fb9e4", "title": "Excel formulas not calculating? 14 reasons & how to fix it", "url": "https://exceloffthegrid.com/why-are-excel-formulas-not-calculating/", "published_at": "2022-11-09T15:32:00+00:00" }, { "id": "01a0c566-feda-7358-86be-a9b3e3f0b0d6", "title": "How to calculate Top 10 with formulas in Excel", "url": "https://exceloffthegrid.com/creating-a-top-10-using-formulas/", "published_at": "2022-11-03T14:00:00+00:00" }, { "id": "01a0c566-feda-7358-86be-a9b3e4bc97d3", "title": "How to loop through each item in Data Validation list with VBA", "url": "https://exceloffthegrid.com/loop-through-each-item-in-a-data-validation-list-with-vba/", "published_at": "2022-11-01T14:03:00+00:00" }, { "id": "01a0c566-feda-7358-86be-a9b3e5496194", "title": "VLOOKUP: What does True/False do? (How to avoid errors!)", "url": "https://exceloffthegrid.com/vlookup-what-does-the-true-false-statement-do/", "published_at": "2022-10-31T07:00:00+00:00" }, { "id": "01a0c566-feda-7358-86be-a9b3e5b48813", "title": "How to reference another workbook without opening: 5 DANGERS!", "url": "https://exceloffthegrid.com/getting-values-from-a-closed-excel-workbook/", "published_at": "2022-10-26T13:00:00+00:00" }, { "id": "01a0c566-feda-7358-86be-a9b3e5c1a652", "title": "How to use Power Query Custom Functions", "url": "https://exceloffthegrid.com/power-query-custom-functions/", "published_at": "2022-10-25T13:00:00+00:00" }, { "id": "01a0c56e-050a-7303-9479-7ad5b9500f3c", "title": "How to use Power Query Group By to summarize data", "url": "https://exceloffthegrid.com/power-query-group-by/", "published_at": "2022-10-24T10:00:00+00:00" }, { "id": "01a0c56e-050a-7303-9479-7ad5b989193a", "title": "Power Query If statement: nested ifs & multiple conditions", "url": "https://exceloffthegrid.com/power-query-if-statements-for-conditional-logic/", "published_at": "2022-10-20T14:00:00+00:00" }, { "id": "01a0c56e-050a-7303-9479-7ad5b9cfa3d9", "title": "VBA code to copy, move, delete and manage files", "url": "https://exceloffthegrid.com/vba-code-to-copy-move-delete-and-manage-files/", "published_at": "2022-10-19T11:10:00+00:00" }, { "id": "01a0c56e-050a-7303-9479-7ad5ba113e6d", "title": "How to sum across multiple sheets in Excel – simple method", "url": "https://exceloffthegrid.com/how-to-sum-the-same-cell-across-multiple-worksheets/", "published_at": "2022-10-19T07:00:00+00:00" }, { "id": "01a0c56e-050a-7303-9479-7ad5ba8acdc3", "title": "Power Query formulas (how to use them and pitfalls to avoid)", "url": "https://exceloffthegrid.com/power-query-formulas/", "published_at": "2022-10-18T11:00:00+00:00" }, { "id": "01a0c56e-050a-7303-9479-7ad5bb520ed4", "title": "How to show hidden data in Excel chart", "url": "https://exceloffthegrid.com/using-hidden-cells-in-a-chart/", "published_at": "2022-10-17T17:00:00+00:00" }, { "id": "01a0c56e-050a-7303-9479-7ad5bb848187", "title": "How to Insert, Move & Delete Pictures with VBA", "url": "https://exceloffthegrid.com/vba-code-to-insert-move-delete-and-control-pictures/", "published_at": "2022-10-17T12:00:00+00:00" }, { "id": "01a0c56e-050a-7303-9479-7ad5bc1bf472", "title": "How to forecast seasonality in Excel (the easy way)", "url": "https://exceloffthegrid.com/how-to-forecast-seasonality-in-excel/", "published_at": "2022-10-17T11:55:00+00:00" }, { "id": "01a0c56e-050a-7303-9479-7ad5bcda1e87", "title": "How to change source data location in Power Query (7 ways)", "url": "https://exceloffthegrid.com/power-query-source-data-location/", "published_at": "2022-10-13T13:00:00+00:00" }, { "id": "01a0c56e-050a-7303-9479-7ad5bd87673c", "title": "VBA code to loop through files in a folder (and sub folders)", "url": "https://exceloffthegrid.com/vba-code-loop-files-folder-sub-folders/", "published_at": "2022-10-13T09:59:00+00:00" }, { "id": "01a0c579-9665-7201-80ba-dd629926d682", "title": "Power Query: Lookup value in another table with merge", "url": "https://exceloffthegrid.com/power-query-lookup-values-using-merge/", "published_at": "2022-10-12T15:00:00+00:00" }, { "id": "01a0c579-9665-7201-80ba-dd6299c4b181", "title": "Ultimate Guide: VBA for Charts & Graphs in Excel (100+ examples)", "url": "https://exceloffthegrid.com/vba-code-for-charts-and-graphs-in-excel/", "published_at": "2022-10-12T10:00:00+00:00" }, { "id": "01a0c579-9665-7201-80ba-dd629a5592b2", "title": "How to split cells in Excel: 4 simple ways", "url": "https://exceloffthegrid.com/how-to-split-cells-in-excel/", "published_at": "2022-10-11T18:00:00+00:00" }, { "id": "01a0c579-9665-7201-80ba-dd629ad902bf", "title": "How to fix “Microsoft has blocked macros” (2 simple ways)", "url": "https://exceloffthegrid.com/unblock-macros-downloaded-from-the-internet/", "published_at": "2022-10-10T07:17:00+00:00" }, { "id": "01a0c579-9665-7201-80ba-dd629bc48621", "title": "How to unpivot in Excel using Power Query (3 ways)", "url": "https://exceloffthegrid.com/power-query-unpivot-data/", "published_at": "2022-10-07T07:00:00+00:00" }, { "id": "01a0c579-9665-7201-80ba-dd629caf9629", "title": "Resetting the scroll bar in Excel (5 solutions)", "url": "https://exceloffthegrid.com/resetting-the-scroll-bar-in-excel/", "published_at": "2022-10-07T06:00:00+00:00" }, { "id": "01a0c579-9665-7201-80ba-dd629d9634ce", "title": "How to Interpolate in Excel: 4 simple ways", "url": "https://exceloffthegrid.com/interpolate-values-using-the-forecast-function/", "published_at": "2022-10-06T11:00:00+00:00" }, { "id": "01a0c579-9665-7201-80ba-dd629e031a12", "title": "How to get data from the Current Workbook with Power Query", "url": "https://exceloffthegrid.com/power-query-import-data-from-the-current-workbook/", "published_at": "2022-10-06T07:00:00+00:00" }, { "id": "01a0c579-9665-7201-80ba-dd629e9ccbca", "title": "How to subtract dates in Excel to get days", "url": "https://exceloffthegrid.com/subtract-dates-in-excel-to-get-days/", "published_at": "2022-10-04T15:43:01+00:00" }, { "id": "01a0c579-9665-7201-80ba-dd629f319273", "title": "Get data from folder in Power Query: combine files quickly", "url": "https://exceloffthegrid.com/power-query-import-all-files-in-a-folder/", "published_at": "2022-09-30T10:00:00+00:00" }, { "id": "01a0c587-a207-7012-a794-ace50503d57f", "title": "8 quick ways to open a new instance of Excel (+1 hard way)", "url": "https://exceloffthegrid.com/how-to-open-multiple-instances-of-excel/", "published_at": "2022-09-29T10:00:00+00:00" }, { "id": "01a0c587-a207-7012-a794-ace50531396e", "title": "List files in a folder & subfolders with Power Query", "url": "https://exceloffthegrid.com/power-query-file-attributes/", "published_at": "2022-09-27T16:00:00+00:00" }, { "id": "01a0c587-a207-7012-a794-ace506034348", "title": "Power Query Append: Quickly combine many queries into 1", "url": "https://exceloffthegrid.com/power-query-combine-append-queries/", "published_at": "2022-09-27T11:00:00+00:00" }, { "id": "01a0c587-a207-7012-a794-ace506ae9499", "title": "VBA Tables and ListObjects", "url": "https://exceloffthegrid.com/vba-excel-tables-code/", "published_at": "2022-09-27T07:00:00+00:00" }, { "id": "01a0c587-a207-7012-a794-ace506c66dc5", "title": "Power Query Parameters: 3 methods + 1 simple example", "url": "https://exceloffthegrid.com/power-query-using-parameters/", "published_at": "2022-09-26T17:00:00+00:00" }, { "id": "01a0c587-a207-7012-a794-ace507246d3a", "title": "Hide named ranges in Excel: 4 simple ways", "url": "https://exceloffthegrid.com/hide-named-ranges/", "published_at": "2022-09-26T12:42:54+00:00" }, { "id": "01a0c587-a207-7012-a794-ace507f1c8bc", "title": "Common Power Query transformations (50+ powerful transformations explained)", "url": "https://exceloffthegrid.com/power-query-basic-transformations/", "published_at": "2022-09-26T08:00:00+00:00" }, { "id": "01a0c587-a207-7012-a794-ace5081d3f3c", "title": "Excel rounding vs Power Query rounding: WARNING! They are different", "url": "https://exceloffthegrid.com/excel-power-query-rounding/", "published_at": "2022-09-22T09:00:00+00:00" }, { "id": "01a0c587-a207-7012-a794-ace508c96f66", "title": "Excel can calculate the wrong results: WARNING", "url": "https://exceloffthegrid.com/excel-calculate-wrong-results/", "published_at": "2022-09-15T13:52:26+00:00" }, { "id": "01a0c587-a207-7012-a794-ace50960ca2e", "title": "6 ways to make Excel sheets very hidden (invisible)", "url": "https://exceloffthegrid.com/make-excel-sheets-very-hidden/", "published_at": "2022-09-09T15:27:26+00:00" }, { "id": "01a0c595-6dfd-71ed-84b1-4b0e10d37415", "title": "5 quick ways to embed a Word document in Excel", "url": "https://exceloffthegrid.com/5-quick-ways-to-embed-a-word-document-in-excel/", "published_at": "2022-09-06T17:42:21+00:00" }, { "id": "01a0c595-6dfd-71ed-84b1-4b0e10d892ab", "title": "Get to know Power Query Close & Load options", "url": "https://exceloffthegrid.com/power-query-close-load-options/", "published_at": "2022-07-14T15:00:58+00:00" }, { "id": "01a0c595-6dfd-71ed-84b1-4b0e1115519c", "title": "Use the Power Query editor to update queries", "url": "https://exceloffthegrid.com/power-query-edit-queries/", "published_at": "2022-07-06T20:40:55+00:00" }, { "id": "01a0c595-6dfd-71ed-84b1-4b0e1165d230", "title": "Refresh Power Query in Excel: 4 ways + advanced options", "url": "https://exceloffthegrid.com/power-query-data-refresh/", "published_at": "2022-07-02T12:17:00+00:00" }, { "id": "01a0c595-6dfd-71ed-84b1-4b0e1226fcc8", "title": "Introduction to Power Query", "url": "https://exceloffthegrid.com/power-query-introduction/", "published_at": "2022-06-21T14:30:40+00:00" }, { "id": "01a0c595-6dfd-71ed-84b1-4b0e124e93aa", "title": "Power Automate CSV to Excel (via Office Script: Easy Method)", "url": "https://exceloffthegrid.com/csv-to-excel-online/", "published_at": "2022-05-31T07:12:14+00:00" }, { "id": "01a0c595-6dfd-71ed-84b1-4b0e126949a0", "title": "Using Slicers with dynamic array formulas in Excel", "url": "https://exceloffthegrid.com/using-slicers-with-formulas/", "published_at": "2022-05-19T10:03:31+00:00" }, { "id": "01a0c595-6dfd-71ed-84b1-4b0e12b02bfe", "title": "GETPIVOTDATA vs CUBE functions", "url": "https://exceloffthegrid.com/getpivotdata-vs-cube-functions/", "published_at": "2022-03-24T11:00:41+00:00" }, { "id": "01a0c595-6dfd-71ed-84b1-4b0e133b00b8", "title": "Running total in an Excel Table", "url": "https://exceloffthegrid.com/create-a-running-total-in-an-excel-table/", "published_at": "2022-03-17T09:30:20+00:00" }, { "id": "01a0c595-6dfd-71ed-84b1-4b0e13e86670", "title": "Create Slopegraphs in Excel", "url": "https://exceloffthegrid.com/the-ultimate-guide-to-slopegraphs-in-excel/", "published_at": "2022-03-10T08:00:34+00:00" } ] posts Claim your blog
Back to exceloffthegrid.com
Blog · corpus.blog/blogs/exceloffthegrid.com/posts

exceloffthegrid.com

exceloffthegrid.com

2022

Private vs Public Subs, Variables & Functions in VBAoriginal ↗
14 Nov 2022
VBA protect and unprotect Sheets (25+ examples)original ↗
11 Nov 2022
How to create a PivotTable from multiple Tables (easy way)original ↗
11 Nov 2022
How to save Excel as PDF with VBA (10 examples)original ↗
10 Nov 2022
Excel formulas not calculating? 14 reasons & how to fix itoriginal ↗
9 Nov 2022
How to calculate Top 10 with formulas in Exceloriginal ↗
3 Nov 2022
How to loop through each item in Data Validation list with VBAoriginal ↗
1 Nov 2022
VLOOKUP: What does True/False do? (How to avoid errors!)original ↗
31 Oct 2022
How to reference another workbook without opening: 5 DANGERS!original ↗
26 Oct 2022
How to use Power Query Custom Functionsoriginal ↗
25 Oct 2022
How to use Power Query Group By to summarize dataoriginal ↗
24 Oct 2022
Power Query If statement: nested ifs & multiple conditionsoriginal ↗
20 Oct 2022
VBA code to copy, move, delete and manage filesoriginal ↗
19 Oct 2022
How to sum across multiple sheets in Excel – simple methodoriginal ↗
19 Oct 2022
Power Query formulas (how to use them and pitfalls to avoid)original ↗
18 Oct 2022
How to show hidden data in Excel chartoriginal ↗
17 Oct 2022
How to Insert, Move & Delete Pictures with VBAoriginal ↗
17 Oct 2022
How to forecast seasonality in Excel (the easy way)original ↗
17 Oct 2022
How to change source data location in Power Query (7 ways)original ↗
13 Oct 2022
VBA code to loop through files in a folder (and sub folders)original ↗
13 Oct 2022
Power Query: Lookup value in another table with mergeoriginal ↗
12 Oct 2022
Ultimate Guide: VBA for Charts & Graphs in Excel (100+ examples)original ↗
12 Oct 2022
How to split cells in Excel: 4 simple waysoriginal ↗
11 Oct 2022
How to fix “Microsoft has blocked macros” (2 simple ways)original ↗
10 Oct 2022
How to unpivot in Excel using Power Query (3 ways)original ↗
7 Oct 2022
Resetting the scroll bar in Excel (5 solutions)original ↗
7 Oct 2022
How to Interpolate in Excel: 4 simple waysoriginal ↗
6 Oct 2022
How to get data from the Current Workbook with Power Queryoriginal ↗
6 Oct 2022
How to subtract dates in Excel to get daysoriginal ↗
4 Oct 2022
Get data from folder in Power Query: combine files quicklyoriginal ↗
30 Sept 2022
8 quick ways to open a new instance of Excel (+1 hard way)original ↗
29 Sept 2022
List files in a folder & subfolders with Power Queryoriginal ↗
27 Sept 2022
Power Query Append: Quickly combine many queries into 1original ↗
27 Sept 2022
VBA Tables and ListObjectsoriginal ↗
27 Sept 2022
Power Query Parameters: 3 methods + 1 simple exampleoriginal ↗
26 Sept 2022
Hide named ranges in Excel: 4 simple waysoriginal ↗
26 Sept 2022
Common Power Query transformations (50+ powerful transformations explained)original ↗
26 Sept 2022
Excel rounding vs Power Query rounding: WARNING! They are differentoriginal ↗
22 Sept 2022
Excel can calculate the wrong results: WARNINGoriginal ↗
15 Sept 2022
6 ways to make Excel sheets very hidden (invisible)original ↗
9 Sept 2022
5 quick ways to embed a Word document in Exceloriginal ↗
6 Sept 2022
Get to know Power Query Close & Load optionsoriginal ↗
14 Jul 2022
Use the Power Query editor to update queriesoriginal ↗
6 Jul 2022
Refresh Power Query in Excel: 4 ways + advanced optionsoriginal ↗
2 Jul 2022
Introduction to Power Queryoriginal ↗
21 Jun 2022
Power Automate CSV to Excel (via Office Script: Easy Method)original ↗
31 May 2022
Using Slicers with dynamic array formulas in Exceloriginal ↗
19 May 2022
GETPIVOTDATA vs CUBE functionsoriginal ↗
24 Mar 2022
Running total in an Excel Tableoriginal ↗
17 Mar 2022
Create Slopegraphs in Exceloriginal ↗
10 Mar 2022
Previous