Windows 10 1803 new OEM (or ESP) Partition

Windows 10 1803 new OEM (or ESP) Partition

by | May 4, 2018 | Tutorials

So Windows 10 1803 update creates another OEM partition. In my case, the new partition decided to take over one of my existing drive letters, G: that was mapped to a shared network location. This was confusing, because my G drive (4TB) suddenly became empty. Disk...
Unprotect Excel Worksheets without Password

Unprotect Excel Worksheets without Password

by | Mar 18, 2018 | Tutorials

So, you forgot your Worksheet password, but you can still access the Spreadsheet file? The difference between a Spreadsheet and a Worksheet is that an Excel Spreadsheet file contains Worksheets that some people call “tabs”. See screenshot below. To...
Calculate Ratio Between Two Numbers

Calculate Ratio Between Two Numbers

by | Sep 17, 2017 | Tutorials

Calculate Ratio with GCD In this example, there is a list of screen dimensions, with the first width — 400 — in cell B4 and the first height — 300 –in cell C4. To calculate the ratio for each screen, the formula will use the GCD function, which...
Workflow loop through SharePoint list

Workflow loop through SharePoint list

by | May 17, 2017 | Tutorials

SharePoint 2013 Designer workflows now has two new interesting options: the ability to call HTTP web services and the option to loop over some code a number of times. This, together with the new REST API, which supports querying lists and returning data in JSON,...