sheet – YB Digital

How to create interactive map in Google Sheets

How to create interactive map in Google Sheets

February 20, 2019February 18, 2020 ybierling 0 Comments chart, create interactive map, Drive, Europe, geo, google, google maps spreadsheet, interactive, map, network, share, sheet, social, spreadsheet, various, web, world

Create interactive map in Google Sheets Want to create a map chart to share, either by putting it online on

Create a shareable map chart with Google Sheets : Europe region of a map chart

Create a shareable map chart with Google Sheets

July 16, 2017July 11, 2017 ybierling 0 Comments chart, Drive, en, Europe, geo, google, interactive, map, network, share, sheet, social, spreadsheet, various, web, world

Want to create a map chart to share, either by putting it online on your website like below, or sharing

How to import an Excel file in a MySQL database in PHPMyAdmin : Import results with links to database and table

How to import an Excel file in a MySQL database in PHPMyAdmin

April 23, 2017May 31, 2018 ybierling 0 Comments content, data, database, en, Excel, How to import an Excel file in a MySQL database in PHPMyAdmin, import, import Excel file in MySQL, import Excel in MySQL, import Excel in PHPMyAdmin, mysql, option, phpmyadmin, sheet, structure, table, web, worksheet

It is sometimes easier to work on some data in Excel, before importing in a MySQL database. In order to

Microsoft Excel Spreadsheet

How to count the number of occurrences in a list with functions in Excel

January 29, 2017January 18, 2017 ybierling 0 Comments builtin, column, count, countif, easy, en, Excel, function, list, MSOffice, option, row, sheet, simple, table, unique, value, values

Having a list of values, for example city names, and want to know how many times each unique entry is

Microsoft Excel Spreadsheet

How to count the number of occurrences in a list with a pivot table in Excel

January 28, 2017September 10, 2018 ybierling 0 Comments column, count, en, Excel, list, MSOffice, option, pivot, row, sheet, table, unique, values, various

Having a list of values, for example city names, and want to know how many times each unique entry is

How to combine two data sets and create all possible combinations with Excel : Result of combination of two data sets by creating some ID columns, and applying some vlookups

How to combine two data sets and create all possible combinations with Excel

January 15, 2017July 4, 2017 ybierling 0 Comments automatic, cell, column, combine, customer, data, en, Excel, expand, file, function, line, list, merge, Microsoft, MSOffice, product, roundup, sheet, spreadsheet, various, vlookup

Having two different data sets, for example a customers list and a products list, and want to combine them to

MS Excel 2013 how to make a table look good ? Table looking good in Excel

Excel how to make a table look good ? MS Excel 2013

November 5, 2016November 18, 2016 ybierling 0 Comments 2013, data, design, en, Excel, format, good, information, look, Microsoft, sheet, spreadsheet, style, table

Wondering how to make a table look good in MS Excel 2013 ? Here are a few steps to help

Microsoft Excel paste CSV into cells : Select CSV data column

Microsoft Excel 2013 paste CSV in spreadsheet

October 1, 2016November 18, 2016 ybierling 0 Comments column, comma, csv, data, delimited, en, Excel, Microsoft, paste, selection, sheet, spreadsheet, transform, values

Copy pasting CSV (Comma Separated Values) is pretty easy in Excel 2013 ! In short : use the Data >