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

Author: admin

How to create relationships I. Excel

Use the power of the Excel Data Model and Pivot tables to analyze data from multiple data sources

Microsoft PowerApps and Flow Training

Power Apps is a suite of apps, services, connectors and data platform that provides a rapid application development environment to build custom apps for your business needs. Using Power Apps, you can quickly build custom business apps that connect to your business data stored either in the underlying data platform (Common Data Service) or in various online and on-premises data sources (SharePoint, Excel, Office 365, Dynamics 365, SQL Server, and so on).

Optimizing Product Mix with Excel Solver

Essential Steps To define an optimization model in Excel you’ll follow these essential steps: Organize the data for your problem in the spreadsheet in a logical manner. Choose a spreadsheet cell to hold the value of each decision variable in your model. Create a spreadsheet formula in a cell that calculates the objective function for your model. Create a formulas…
Read more

How to Create a Waterfall chart

How to chart Income Statement Data with Excel Waterfall. A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. These intermediate values can either be time based or category based. Full video:

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