Create Four Column Layout in SharePoint

The available section layouts in modern SharePoint is a three column layout. But what if you what to have more columns, like a 4 column layout? There's actually an option to do this by using the the vertical section option when adding a section to a page. There's some limitations to the view or design of the whole page, but if you want a four column layout on your Share Point page, this is a nice workaround for your design.

Create Custom Sort Order Pivot Table

Did you know you could have a custom sort order for pivot tables? You can customize a sort order when using the drop down sort features to enable a sort like bronze, silver and gold. Or in this example green, blue or diamond; which corresponds with ski slope difficulty in some resorts. You'll have to customize a sort order but it's easy.

Quickly Calculate Investment Return

If you're given an scenario where you have the present value of an investment and a future value of that investment with not periodic investments for five years, could you figure out a rate of return per year for that investment? There's a common business concept of Compounded Annual Growth Rate (CAGR) and and there's an Excel function called RRI that will help you calculate it