Free online mapping services open up a world of possibilities for your creative, practical and professional projects. Nik Rawlinson grabs his passport.
![Do More With Maps](https://magarticles.magzter.com/articles/499/232374/596ca31014b55/Google-Mapping-Apple-Microsoft.jpg)
You might not think of mapping as an everyday computing task, but the technology is becoming ubiquitous. Google, Apple and Microsoft each have their own mobile platforms, which draw in geographical data to help us navigate from A to B, geotag our photos and pull in weather reports from the web.
Those basic functions, however, represent only a fraction of the potential on hand. We literally have the world in our pockets – and there are a lot of things we can do with it. The possibilities include creating your own customised maps; navigating and exploring more effectively; and even promoting your business through Street View.
Embed a map in Excel
If you’re putting together a report or presentation that relies on geographical data – such as country populations or vote share in different cities – you can make that data more accessible and visually interesting by plotting it on a map, rather than a boring old graph.
You can do this directly within Excel, but to make it work you have to format your data in precisely the right way. The top row of your data table must contain column headers, to define the data. Below this, the first column must contain only location names, with all other columns being entirely numeric. You can see a sample table above right, showing cities in column A and a statistic of your choice in column B. (We’ve chosen cars, but don’t hold us to the accuracy of the data.)
Esta historia es de la edición September 2017 de PC Pro.
Comience su prueba gratuita de Magzter GOLD de 7 días para acceder a miles de historias premium seleccionadas y a más de 9,000 revistas y periódicos.
Ya eres suscriptor ? Conectar
Esta historia es de la edición September 2017 de PC Pro.
Comience su prueba gratuita de Magzter GOLD de 7 días para acceder a miles de historias premium seleccionadas y a más de 9,000 revistas y periódicos.
Ya eres suscriptor? Conectar
![How to earn Cyber Essentials certification](https://reseuro.magzter.com/100x125/articles/499/1693520/3vzMhKwqA1715943236784/HOW-TO-EARN-CYBER-ESSENTIALS-CERTIFICATION.jpg)
How to earn Cyber Essentials certification
The UK's government-backed security standard provides reassurance for you and your customers. Nik Rawlinson explores what's involved - and how to get it
![HP Omen Transcend 14](https://reseuro.magzter.com/100x125/articles/499/1693520/_J2metwie1715942359246/HP-OMEN-TRANSCEND-14.jpg)
HP Omen Transcend 14
If you're sticking with Asus or Razer gaming laptops out of habit, the HP Omen Transcend 14 may just change your mind
![AI TRİSM](https://reseuro.magzter.com/100x125/articles/499/1693520/PBW43WzV_1715941897626/AI-TRSM.jpg)
AI TRİSM
New computing paradigms come with new challenges. Steve Cassidy explores how to use AI safely and securely
![13 warnings about using AI at work](https://reseuro.magzter.com/100x125/articles/499/1693520/Om7wJ5jd51715941293590/13-WARNINGS-ABOUT-USING-AI-AT-WORK.jpg)
13 warnings about using AI at work
AI experts from industry and academia were gathered by the Turing Institute to consider the future of the technology. Nicole Kobie reveals the lessons they offered
![Brilliant business comms at zero cost](https://reseuro.magzter.com/100x125/articles/499/1693520/FUrJqZnjl1715940993185/BRILLIANT-BUSINESS-COMMS-AT-ZERO-COST.jpg)
Brilliant business comms at zero cost
Whether you choose 3CX Free or 3CX SMB V20, it's time to say goodbye to per-user pricing and bundle rip-offs
![TURN YOUR DUMB TV INTO A SMART ONE WITH A RASPBERRY PI](https://reseuro.magzter.com/100x125/articles/499/1693520/cwNbzBW2I1715940488533/TURN-YOUR-DUMB-TV-INTO-A-SMART-ONE-WITH-A-RASPBERRY-PI.jpg)
TURN YOUR DUMB TV INTO A SMART ONE WITH A RASPBERRY PI
Enjoy video on demand and more Nik Rawlinson finds out how the humble Pi can transform your TV
![GIGABIT INTERNET Get the speeds you're paying for](https://reseuro.magzter.com/100x125/articles/499/1693520/byn7WEnrw1715939990641/GIGABIT-INTERNET-GET-THE-SPEEDS-YOURE-PAYING-FOR.jpg)
GIGABIT INTERNET Get the speeds you're paying for
Is your premium internet service not racing along like it should? Darien Graham-Smith goes in search of faster downloads on every device
![7 HABITS OF HIGHLY EFFECTIVE IT PROS](https://reseuro.magzter.com/100x125/articles/499/1693520/QIEkuXPtM1715939529947/7-HABITS-OF-HIGHLY-EFFECTIVE-IT-PROS.jpg)
7 HABITS OF HIGHLY EFFECTIVE IT PROS
The PC Pro team combine their collective wisdom to create seven tips for keeping on top of your IT game
![BRILLIANT MONITORS from £149](https://reseuro.magzter.com/100x125/articles/499/1693520/S9Nd6qoaz1715939044767/BRILLIANT-MONITORS-FROM-149.jpg)
BRILLIANT MONITORS from £149
Whether you’re looking for screens to roll out ina business, an entertainment centrepiece ora pro-quality monitor, one of our 15 displays holds the answer
![PORTABLESSDs FROM £69](https://reseuro.magzter.com/100x125/articles/499/1693520/hKyAOR7n91715938275324/PORTABLESSDS-FROM-69.jpg)
PORTABLESSDs FROM £69
We review 12 portable SSDs that cover a wide range of standards, form factors and target users