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


Pivot Table Data Crunching: Microsoft Excel 2016

Pivot Table Data Crunching: Microsoft Excel 2016 »


Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.

Excel 2016 in Depth

Excel 2016 in Depth »


Experienced with Excel? Don’t let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016.

Your Excel Survival Kit

Your Excel Survival Kit »


This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

100 Excel Simulations

100 Excel Simulations »


Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.

VBA & Macros for Microsoft Excel 2016

VBA & Macros for Microsoft Excel 2016 »


Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful.

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.

see more products »