Manuel

Over the last 20 years, I have been employed to work with big and small companies. My main focus has been on IT project management and improving the productivity of teams of all sizes thanks to optimizing the usage of Software. My drive is that, thanks to my help, people can focus on their job, save time and avoid frustration. I am specialized in Power Automate, and through my personal website – ManuelTGomes.com – I’ve been able to help hundreds of thousands of people over the last few years. This has made me decide to turn my passion into my job. I started my own company – Skillful Sardine – helping people and companies fix problems by teaching about and optimizing the usage of Power Automate and dozens of other Office 365 tools.

base64ToBinary function

base64ToBinary function

Converts a base64-encoded string into binary file content. The content type changes; the base64 does not.

Excel: Countif Function

Excel: Countif Function

Counts the cells in a range that meet one condition. Text matching ignores case.

SharePoint: YEAR function

SharePoint: YEAR function

Returns the year of a date as a number between 1900 and 9999. Empty dates return 1899.

The site is 7 years today

The site is 7 years today

Seven years of the site. The newsletter is live, new reference areas launched, and old articles updated.

Excel: Averageif Function

Excel: Averageif Function

Averages the values that meet one condition. Returns #DIV/0! when nothing qualifies.