Tag Archives: tutorial
Nested JSON to flat data tables
Have you ever had to convert a file of JSON text to Excel tables? Not simple JSON, but one with a collection of dictionaries inside a dictionary inside a collection of dictionary records inside another collection of records inside a … Continue reading
Excel Options for updating external links
There are many options in Excel that control this depending on the kind of link it is. I’ll cover the usual external links in formulas first, then finish up with the other kinds. An external link formula shows the full … Continue reading
Patrick O'Beirne @ sysmod 