— iIT-Services

Archive
2021 Yearly archive

Capture, edit, and share audio and video. Descript is an all-in-one audio and video editor that makes editing as easy as a doc. Upload media or record directly in Descript to instantly transcribe your file into text, then tweak the text to directly edit your media clips. Edit out filler words and silent gaps with a single click. Record your screen and webcam for presentations and video messages and edit out mistakes before publishing. Export your project to other pro apps: descript.com.

Read More

Extract key data from your emails, automatically. Integrates directly with any major email provider, tell Mailparser what data to extract and where to send it: mailparser.io/integrations.

Read More

This webservice converts images in HEIC format online into JPG files, just that: https://heictojpg.com.

Read More

I recently tried to have the custom date format in MS Excel

DDD DD.M., as of Mon 24.5. formatted on two lines in a single cell. That is, as:

Mon
24.5.

Aesthetisc of MS Office required me to implement this through formatting, instead of, e.g., using two cells with different formulas.

The solution was to use special characters, i.e., the line break character. Here, we’re talking about “ALT Keyboard Sequences”. Meaning: press and hold the ALT key while typing a sequence of numbers. For a line break, the sequence is “0010” or just “10”.

For the challenge above, in Excel, that meant typing DDD, then the ALT-sequence, and finally the DD.M. into the custom cell format. Interestingly enough, Excel makes a line break without showing the second (and further) line(s), but perfectly working as format.

The key sequences for any speical character can be found for example on https://tools.oratory.com/altcodes.html (EN) or also http://www.sonderzeichen.de/sonderzeichen_mit_alt.html (DE).

Read More

I was wondering, how can I add vertical line metrics to a horizontal bar chart or box-plot in Excel, as for example shown below in a box plot.

This is explained, step-by-step, in the tutorial that can be found here: https://www.exceldashboardtemplates.com/step-by-step-horizontal-bar-chart-with-vertical-lines-tutorial/.

Read More

Slido is a simple Q&A and polling platform for virtual trainings and teaching. Slido helps prioritizing the discussion topics for conference Q&As, panel discussions or all-hands meetings. It supports audience engagement, quizzes, brainstorming etc. and can be integrated with tools like Powerpoint, Google Slides, Teams, Zoom, YouTube, Facebook live etc.: www.sli.do.

Read More

“Everything” is search engine that locates files and folders by filename instantly for Windows. Unlike Windows search “Everything” initially displays every file and folder on your computer (hence the name “Everything”). You type in a search filter to limit what files and folders are displayed: https://www.voidtools.com.

Thanks, T., for the hint.

Read More