MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Geography Data Type


August 7, 2018 - by Bill Jelen

Geography Data Type

Office 365 subscribers will soon start seeing a new feature on the Data tab: Linked Data Types for geography or stocks.

Start by typing some city names or country names in Excel. Select those cells and choose Data, Geography.

Select the city names and choose Data, Geography.
Select the city names and choose Data, Geography.

For each city that is recognized, a map icon will appear in the cell. Click that icon or press Ctrl + Shift + F2 to get more information about the city.

Click this symbol to see a Data Card.
Click this symbol to see a Data Card.

The data card contains fields about the city. At the bottom of the data card are links to the source web pages where the data came from.

continue reading »

More Reading


Sentence Case in Excel

Sentence Case in Excel »

August 6, 2018 - by Suat M. Ozgur


Although Excel is not a word processing application, sometimes you might need to change the given text to Sentence Case. There is a way to do this by combining some text functions for a single sentence, but multiple sentences. Today we will discuss about a VBA solution to achieve this in Excel.

MrExcel Offers Data Analytics Video Course in Conjunction with IMA

MrExcel Offers Data Analytics Video Course in Conjunction with IMA »

July 30, 2018 - by Bill Jelen


In partnership with the Institute of Manageral Accountants, Bill Jelen and MrExcel have developed an online course: Data Analytics: Leveraging Excel. People can earn 3.5 hours of NASBA CPE credit by taking the course.

read more news »

Featured Products


Power Pivot and Power BI

Power Pivot and Power BI »


Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

Learn to Write DAX

Learn to Write DAX »


Data analysis expressions (DAX) is the formula language of PowerPivot and Power BI. Simply reading a book is normally not enough to help Excel users learn DAX skills – you need to complete exercises and get plenty of practice to make the transition.

Power Excel With MrExcel - 2017 Edition

Power Excel With MrExcel - 2017 Edition »


This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

Excel JavaScript UDFs Straight to the Point

Excel JavaScript UDFs Straight to the Point »


JavaScript custom functions - UDFs can be used like any other native functions or UDFs in Excel. This book shows the process of creating JavaScript UDFs in Excel Developer Preview for Office Insider program subscribers.

MrExcel LIVe

MrExcel LIVe »


A book for people who use Excel 40+ hours per week. Illustrated in full color.

M is for (DATA) MONKEY

M is for (DATA) MONKEY »


Despite the moniker "data monkey", we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.

see more products »