— iIT-Services

Archive
Office

Just a simple online text extractor. The text extractor allows to extract text from any image. One may upload an image or document (.pdf), from the device, a cloud storage, or an URL, and the tool will pull text from the image. Once extracted, the text can be copied to the clipboard: https://brandfolder.com/workbench/extract-text-from-image.

Read More

A (German) list of the top 100 open source software applications including some nifty little tools, by Computer Bild: https://www.computerbild.de/fotos/Software-besten-kostenlosen-Open-Source-Programme-herunterladen-3266766.html.

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

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

HFSExplorer is an application that can read Mac-formatted hard disks and disk images.
It can read the file systems HFS (Mac OS Standard), HFS+ (Mac OS Extended) and HFSX (Mac OS Extended with case sensitive file names).

HFSExplorer allows you to browse your Mac volumes with a graphical file system browser, extract files (copy to hard disk), view detailed information about the volume and create disk images from the volume.
HFSExplorer can also read most .dmg / .sparsebundle disk images created on a Mac, including zlib / bzip2 compressed images and AES-128 / AES-256 encrypted images. It supports the partition schemes Master Boot RecordGUID Partition Table and Apple Partition Map natively: http://www.catacombae.org/hfsexplorer/.

Read More

As a teacher, MikeMcKinley1 regularly marks up his PowerPoint presentations and saves the markup to send to his students at the end of the class. Then before the beginning of the next class with a different group of students, he erases/deletes all of his ink markings in a powerpoint file using the “Delete All Comments and Ink in This Presentation” function.

Unfortunately, the “Delete All Comments and Ink in This Presentation” option is gone in Powerpoint 2016 Version 1805. It seems to be replaced by the “Hide Ink” function. But when the “Hide Ink” function is used, the old ink reappears when trying to write on the slide. Going through each slide and laboriously select the ink and delete it is obnoxious.

Therefore, the following Macro has to do the job:

Sub zapInk()
    Dim osld As Slide
    Dim L As Long
    For Each osld In ActivePresentation.Slides
        For L = osld.Shapes.Count To 1 Step -1
            If osld.Shapes(L).Type = 23 Then osld.Shapes(L).Delete
        Next L
    Next osld
End Sub

Copied from: answers.microsoft.com…

Read More