Madonna House, Westlands Road - Nairobi
+254790706395
info@opencastlabs.co.ke

Category: Blog

Using Conditional Formatting to compare budgets and actuals

Use Microsoft Excel Conditional formatting and IF to compare monthly actuals and budgets. Use colors to flag months or periods that budgets are over actuals

Advanced Microsoft Excel Live Online

Live Online Training WhatsApp: +254722831259

Tutorial: Import Data into Excel, and Create a Data Model – Part I

Where is Power Pivot? Excel 2016 & Excel for Microsoft 365 – Power Pivot is included in the Ribbon. Excel 2013 – Power Pivot is part of the Office Professional Plus edition of Excel 2013, but is not enabled by default. Learn more about starting the Power Pivot add-in for Excel 2013. Excel 2010 – Download the Power Pivot add-in,…
Read more

The SUMIF Function

The Excel SUMIF Function

Optimization with Goal Seek

Optimization with Goal Seek