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

Month: June 2020

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

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

Import Data into Excel, and Create a Data Model

Excel for Microsoft 365 Excel 2019 Excel 2016 Excel 2013 Abstract:    This is the first tutorial in a series designed to get you acquainted and comfortable using Excel and its built-in data mash-up and analysis features. These tutorials build and refine an Excel workbook from scratch, build a data model, then create amazing interactive reports using Power View.…
Read more