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,...
How to create Charts in Sharepoint

How to create Charts in Sharepoint

by | Apr 30, 2017 | Tutorials

WebPart charts have been, for some reason, removed from SharePoint 2013 (including online) onwards. Probably because Microsoft thought that having Excel Web Parts Charts is a better idea. It may well be, but Excel Web Part Charts can’t use Sharepoint lists...