Excel – YB.Digital

ybierling July 5, 2026 Excel, Productivity, Shortcuts

Master Excel Format Painter – 10 Time-Saving Tricks Most Users Don't Know

With Excel’s underused Format Painter, you can instantly copy formatting across cells in seconds. Most users don’t know it supports

Office productivity

ybierling July 4, 2026 Excel, Mastery, Validation

Excel Data Validation Mastery – Eliminate Input Errors Forever

Validation in Excel 365 gives you complete control over data entry, ensuring accuracy and consistency across your spreadsheets. You can

Office productivity

ybierling May 25, 2026 ArrowKeys, Excel, Fix

Excel Arrow Keys Move Screen Instead of Cells? Here’s the Real Fix

You will resolve Excel navigation errors like arrow keys moving the screen by checking Scroll Lock and Excel’s settings; this

Office productivity

ybierling May 24, 2026 AutoFilter, criteria, Excel

How to Use Excel AutoFilter With More Than Two Criteria

Excel: Based on continued interest in Excel filtering, this article provides a practical walkthrough for users seeking advanced techniques so

How to insert / include an Excel spreadsheet in a Powerpoint presentation : Excel spreadsheet embed in Powerpoint presentation

Various

ybierling August 20, 2017July 20, 2017 browse, computer, document, easy, embed, en, Excel, file, include, insert, local, Microsoft, name, Office, Powerpoint, spreadsheet, useful, various, Word

How to insert / include an Excel spreadsheet in a Powerpoint presentation

Inserting a Microsoft Excel spreadsheet in a Powerpoint presentation is pretty simple. In short, use the INSERT > Text >

How to insert / include an Excel spreadsheet in a Word document : Resulting document with Excel file embed

Various

ybierling August 13, 2017July 20, 2017 browse, computer, document, easy, embed, en, Excel, file, include, insert, local, Microsoft, name, Office, Powerpoint, spreadsheet, useful, various, Word

How to insert / include an Excel spreadsheet in a Word document

Inserting a Microsoft Excel spreadsheet in a Word document is pretty simple. In short, use the INSERT > Text >

Excel filter wildcards and with wildcards - star and interrogation mark : Researching succession of wildcards preceded with tilde ~

Various

ybierling July 9, 2017July 3, 2017 en, Excel, filter, interrogation, mark, Microsoft, replace, result, search, star, tip, wildcard, wildcards

Excel filter wildcards and with wildcards – star and interrogation mark

In Microsoft Excel, two wildcards are available for filtering – and they can be used directly in the quick filter,

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

Web-en

ybierling April 23, 2017May 31, 2018 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

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

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

Various

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

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

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

Various

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

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

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

Various

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

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

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

Various

ybierling December 22, 2016July 4, 2017 activated, arrow, en, Excel, key, keyboard, lock, Microsoft, press, scroll, various, vlookup

Excel keyboard arrows moving page instead of cell

If you have happen to be moving the page viewed instead of the cell selected in Microsoft Excel, do not

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

Various

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

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

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

Microsoft Excel 2013 filter on multiple (1, 2 or more than 2) criterias : Selection of the list to filter with multiple criteria

Various

ybierling October 29, 2016July 4, 2017 advanced, criteria, data, en, Excel, filter, list, Microsoft, multiple, one, two, various, vlookup

Microsoft Excel 2013 filter on multiple (1, 2 or more than 2) criterias

If you have an Excel sheet on which you would like to filter on several criteria, you have three different

Microsoft Excel paste CSV into cells : Select CSV data column

Various

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

Microsoft Excel 2013 paste CSV in spreadsheet

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

Various

ybierling July 17, 2016May 31, 2018 cells, compare, en, Excel, format, how to do vlookup excel, list, master, simple, text, values, vlookup, vlookup excel, vlookup from another workbook, vlookup not working in excel, vlookup partial match, what is vlookup used for, why is my vlookup not working, why is vlookup not working

Master Excel values vlookup – How to do vlookup

When applying vlookup on lists from different sources, you might easily end up not being able to match values. Typical

Various

ybierling July 3, 2016May 31, 2018 data, duplicates, en, Excel, Excel 2013 order a list and remove duplicates, excel order a list, excel order list remove duplicates, excel remove duplicates, how to remove duplicates in excel, remove duplicates in excel, sort, useful, various

Excel 2013 order a list and remove duplicates

Ordering a list and removing duplicates is a common and useful operation, when working with data lists : email addresses,

SAP-en

ybierling August 7, 2011November 18, 2016 en, Excel, log, LSMW, SAP, spreadsheet

SAP export LSMW batch input session results

Sometimes, when running an LSMW batch input session (Fig 1), we want to get the results in a useful format