Friday, March 19, 2021

Get geography information's of countries in excel | Population | Leade...


Add Geography Data to Your Sheet

To check out the Geography data type in Microsoft Excel, simply select and add what you need. Then, if you want to expand it, you can create a table or use formulas

Select a cell in your spreadsheet and type a location. This can be a city, state, region, territory, or country. With the cell selected, click “Data,” and then click “Geography” in the “Data Types” section of the ribbon.

Click "Data," and then click "Geography."

Within a few seconds, you might see a question mark appear next to the location name in the cell and the “Data Selector” sidebar will open. This occurs if a location cannot be found, or if more than one location with the same name is available.

Click “Select” below the correct location on the right. If you don’t see the location you want, you can type it in the Search box at the top of the sidebar to look further.

Canada in Excel's Geography "Data Selector."

After you select a location in the Data Selector, you’ll see a map icon next to the location name and the sidebar will disappear. Now, it’s time to pull in the data you need.

The map icon next to "Canada" in a cell.

Click the cell that contains the location name, if necessary, and then click the Insert Data icon that appears next to the cell. This will display a scrollable list of data from which you can make selections. The data available here will depend on the kind of location you’ve selected. For example, if you type a country, you’ll see more options than you would for a city.

You can select an abbreviation, area, total tax or unemployment rate, urban population, and more.

The Insert Data menu for "Canada."

When you select something from the list, it will appear in the cell to the right of your location immediately. You can continue to add data from the list, and they’ll populate in subsequent cells on the right.

If you add several items for your location, though, and don’t label them with column headers, it’s easy to forget what each is for. Just click the cell containing the data to see what it is in the Formula Bar.

Click a cell to see what type of data it contains in the Formula Bar.

View the Data Type

Along with the data in the list, you can view what’s called a Data Type Card for your location. This gives you a snapshot of the data with the labels. To see it, just right-click the cell containing your location, and then select “Show Data Type Card.”

Select "Show Data Type Card."

You’ll then see an easy-to-read card containing all the details. You can drag the bottom-right corner to enlarge it.

A Data Type Card for Canada.

To add a piece of data from the Data Type Card to your spreadsheet, hover your cursor over it, and then click the Extract to Grid icon that appears.

Click the Extract to Grid icon.


Click "Data Type," and then click "Refresh."

Saturday, February 27, 2021

Monday, February 8, 2021

how to watch UAE's Hope probe Mars mission live

Emirates Mars Mission Overview

The Emirates Mars Mission (EMM) ​is the United Arab Emirates’ (UAE) ​first mission to Mars. EMM is designed to ​orbit Mars and study the dynamics in ​the Martian atmosphere on a global scale, and on both diurnal and seasonal timescales. Using three scientific instruments on board of the spacecraft, EMM will provide a set of measurements fundamental to an improved understanding of ​circulation and weather in the Martian lower and middle atmosphere. Combining such data with the monitoring of the upper layers of the atmosphere, EMM measurements will reveal the mechanisms behind the upward transport of energy and particles, and the subsequent escape of atmospheric particles from the gravity of Mars.

Wednesday, December 16, 2020

KERALA ELECTION RESULTS 2020 LIVE UPDATE

KERALA ELECTION RESULTS 2020 LIVE UPDATE തദ്ദേശ ഭരണത്തിൽ ജനങ്ങൾക്ക് താൽപ്പര്യം KERALA ELECTION RESULTS 2020 LOCAL BODY ELECTION 2020 Kerala local body election results LIVE Updates: Cong mayor candidate in Kochi corporation loses to BJP . 30 mins ago News18 . Kerala Local Body Election Results 2020 LIVE Updates: LDF Leads in 4 Corporations, UDF in 2; Tough Fight Between LDF & NDA in Thiruvanathapuram . 29 mins ago Firstpost . Kerala Local Body Election Results 2020: Counting of votes for 21,893 wards to begin at 8 am today . 9 hours ago View all Kerala local body election results LIVE Updates: KERALA ELECTIONS 2-0,ELECTIONS 2020,KERALA ELECTIONS,LOCAL BODY ELECTRIONS 2020,KERALA LIVE

Tuesday, December 8, 2020

Sunday, November 29, 2020

Create Login Form Windows Application (C#.NET) Using Entity Framework

Video Showing How to create login form in windows form Application using entity framework with mssql(microsoft sql server )database . visual studio 2019 and microsoft sql server has been used to demonstrate this video Entity framework login form 1.CREATE MSSQL DATABASE 2.CREATE MSSQL USER TABLE 3.CREATE WINDOWS FORMS APPLICATION 4.PREPARE FORMS WITH TEXTBOX AND BUTTON,LABELS, 5.CREATE ADO.NET ENTITY MODAL 6.VALIDATE USERNAME AND PASSWORD IN SQL TABLE 7.SHOW MESSAGE BOX (VALID,INVALID USERNAME) 8.Change Textbox Input Type to Password Character IDE USED: Microsoft Visual Studio 2019 Language Used: C#.NET Technology: Microsoft .Net Windows Forms , Entity Framework Database: MSSQL Server if statement messagebox mbox try catch Entity Framework (Visual C#) - Creating A Simple User Login Application

Thursday, November 26, 2020

Mina Plaza Building Demolition

Mina Plaza 11/Nov/2020 8 AM Abu Dhabi ensures safety as Mina Plaza demolished 144 floors gone in 10 seconds: demolition day Construction of the complex began in 2007, but more than a decade later the still-unfinished towers at Mina Port disappeared in a flash of explosive charge.

Monday, November 2, 2020

HOW TO CHECK SQL SERVER VERSION THROUGH QUERY | MSSQL SERVER

HOW TO CHECK SQL SERVER VERSION THROUGH QUERY | MSSQL SERVER

 

HOW TO CHECK SQL SERVER VERSION THROUGH QUERY | MSSQL SERVER MICROSOFT SQL SERVER VERSION THROUGH QUERY #MSSQL #MSSQL_SERVER #PROGRAMMING

 

Sunday, November 1, 2020

Burj Khalifa Electrified For Porche Taycan | Burj Khalifa Light Up

Porsche Middle East and Africa FZE has officially kicked off its launch for the all-new Taycan with a special animation on the facade of the Burj Khalifa, the largest single display surface in the world. A visually exciting light show, covering the total area of 33,000 square meters, portrayed the brand’s most important milestones from the Lohner-Porsche revealed in 1900 to the cutting-edge Taycan. With its 828 metres, the iconic tower is the largest building in the world and provided a unique setting to announce the long-awaited arrival of Porsche’s first fully electric vehicle.

Dr Manfred Braeunl, Chief Executive Officer at Porsche Middle East and Africa FZE, stated: “Electricity has been running through Porsche’s veins from day one and the brand is a pioneer in shaping the mobility of tomorrow with innovative products setting the benchmark for the industry. The all-new Taycan is a culmination of over 70 years of experience building sports cars, merged with incredible new driving technologies. But first and foremost, it is a true Porsche offering pure emotion and extraordinary driving pleasure. The upcoming months will be hugely exciting for us and our business partners, as we launch the car across the region.”

Markus Peter, Marketing Director at Porsche Middle East and Africa FZE, added: “It was a very special moment watching the more than 1 million LED lights turning the facade into one big screen to celebrate the start of the Taycan introduction in our region. We are convinced that the new Porsche Taycan will inspire everyone in the same way as the first electric sports car with the Porsche soul.”

Whilst the Taycan is the brand’s first fully electric model, Porsche has been at the forefront of electromobility for a long time. Today, plug-in hybrids present some of the most powerful flagship models in the brand’s range, such as the Cayenne Turbo S E-Hybrid or the new Panamera Turbo S E-Hybrid. With the launch of the new Taycan, Porsche presents its first ever fully electric model, setting another important milestone for the successful future of the company.

In the coming weeks and months, Porsche’s regional office with base in Dubai will support its importers with the rollout of the first three Taycan models comprising the 4S, Turbo and Turbo S. Officially declared as the most innovative car in the world, thanks to 27 new developments of which 13 are global firsts, the Taycan generates up to 761 PS. The fastest model in the range, the Turbo S, accelerates from 0-100 km/h in just 2.8 sec – the same as the Porsche 911 GT2 RS, a purebred, two-seater sports car.

According to WLTP tests, all three derivatives feature a generous driving range. When equipped with the Performance battery Plus, the Taycan 4S leads with a capacity of up to 463 km.

The Taycan is the first production vehicle with a system voltage of 800 volts. This is a significant advantage when high-power charging access is available, allowing exceptionally short charging times. All owners can comfortably charge their vehicles with an 11kW AC charger at home, at work on a fast industrial charger, or at any public charging point while running errands.

The start of the launch phase follows a successful period of business for Porsche’s regional office in Dubai. With a healthy five per cent growth year-on-year, the organization recently announced its best third quarter results since 2015.