MS Excel

Blog Posts on MS Excel

Export Places From Google Maps to Excel

by

Google My Maps lets you mark places and export them as a KML file, which Excel opens as a table of names and coordinates. Here’s how, using the six municipal corporations of Kerala as the example. ToolGoogle My Maps (free) ExportKML (not KMZ) Opens inExcel as an XML table, or Power Query Step 1: Create … Read more

Matrix Digital Rain in Excel

by

Falling green code, like the film The Matrix, made with RANDBETWEEN, three conditional formatting rules and a tiny macro. A fun way to learn how MOD, ROW and conditional formatting work together. FunctionsRANDBETWEEN, MOD, ROW Formatting3 conditional formatting rules Macro8 lines, no Windows API The idea comes from Nitin Mehta of XLnControl (Engineers-Excel.com); I’ve added … Read more

4 Actual vs Target Charts in Excel

by

Comparing actuals with targets is one of the most common charts in reports. Here are four ways to draw it in Excel, from overlapping columns to a chart that colours every month green or red automatically. Chart typesColumn, combo, markers Works inExcel 2013 and later DataMonth, Target, Actual The data Type 1: Thin actual inside … Read more