Rufen Sie uns an! +49 61 51 – 6 27 41 48 info@carinko.com
Excel nugget: Flash Fill

Excel nugget: Flash Fill

Excel nugget: Flash Fill

Flash Fill automatically fills your data when it senses a pattern. You are able to separate e. g. first name and surname or split other cell content.

Also it is possible to merge existing cell content of a record from different columns.

As well, you can combine text, which isn´t part of your table or data source, and your existing cell content.

In this tutorial you’ve got 4 options to use the Flash Fill in Microsoft Excel and fill your table with data in no time.

The Flash Fill is part of the Excel versions 2013, 2016, 2019 and Office 365.

Have fun with our nugget.

Regards,

your CARINKO-Team

Weitere Beiträge der Kategorien:

PowerPoint nugget: Default Shape

PowerPoint nugget: Default Shape

PowerPoint nugget: Default Shape

Do you agree, it is so annoying that, if you insert a shape on your slide in PowerPoint, the default microsoft or corporate design layout applies automatically?

Again and again you have to change the shape layout, because you want to have anotherone?

Sure, it’s possible to insert one shape, design it in your desired format and paste this format to the outher shapes. It’s the faster way instead of formatting one by one but unfortunately it is also time-consuming.

In this tutorial we will show you an option to set your default shape layout.  You will be able to insert shape without formatting actions. Any shape will be designed automatically like you prefer 🙂

Have fun with our nugget.

Regards,

your CARINKO-Team

Weitere Beiträge der Kategorien:

Pin It on Pinterest