Blog

  • How To Develop a Simple Time Tracking Sheet in Microsoft Excel

    The process of tracking time is unique to every employee or position, so there’s no one-size fits-all sheet that will…

    Read More..
  • How to use the awesome FORECAST Function in Excel

    The FORECAST function is a rare function. In my few years of teaching Excel, none – even the most seasoned…

    Read More..
  • Introduction to Business Modeling using Goal Seek – Part I

    Wether you are calculating how much you will pay for that loan, resource optimization, modeling queues or soliving distribution and…

    Read More..
  • The Customer Experience (CX) Metrics & Perfomance Indicators

    The Customer Experience (CX) Value Equation defined by Oracle is a method to identify and measure the value of CX….

    Read More..
  • Power Pivot for Excel 2013 – Data Analysis Expressions (DAX) Overview

    The Data Analysis Expressions (DAX) language is a formula language that allows users to define custom calculations in calculated columns and measures. DAX includes some of the functions that are used in Excel formulas, and additional functions that are designed to work with relational data and perform dynamic aggregation.

    Read More..
  • How to populate a ComboBox in Excel without using VBA

    How to populate a ComboBox in Excel without using VBA Posted by David Kandie, Principal Data Scientist at OpenCastLabs Consulting…

    Read More..
  • Using Microsoft Excel to Build Smart Data Collection Tool (Questionnaire) – with NO VBA

    Collecting market data, internal employee data sometimes can be a daunting task to intermediate Microsoft Excel users. This post will help you to develop simple questionnaires inside Excel without using a Macro or VBA.

    Read More..
  • Microsoft Excel Charts – Different Scales and Dual Axes – ProTip

    Chart Like a Pro – How to represent 3 data sets in 1 Chart Posted by David Kandie, Principal Data…

    Read More..
  • Using defined names & named ranges in Microsoft Excel – Pro Tip

    By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.

    Read More..
  • How to create a User Defined Function (UDF) in Microsoft Excel

    Although Microsoft Excel includes a multitude of built-in worksheet functions, chances are it doesn’t have a function for every type of calculation you perform. Excel’s designers couldn’t possibly anticipate every calculation need of every user. But they did provide you with the ability to create your own custom functions. In the same way that a macro lets you encapsulate a sequence of actions execute that sequence with a single command, a custom function lets you encapsulate a sequence of calculations so that you can perform those calculations with a single formula.

    Read More..
  • Microsoft Excel – What is a Data Model

    If you’re importing foreign data or sharing a workbook, the data often ends up in several sheets. As a result, turning data into meaningful information can be difficult. That’s where Excel 2013’s new data modeling capabilities can help even casual users. By building a relationship between sheets, Excel 2013 makes summarizing data spread across multiple sheets easy.

    Read More..
  • Microsoft Online Proctoring now available in Kenya

    Imagine you have to take a certification exam. Traditionally, you would call or go online to schedule an appointment at a testing center, take time out of your day to travel to the testing facility, and then take the test.

    With online proctoring, you skip all of the excess travel – you can take exams from the comfort of your own office or even your home.

    Read More..
  • Training Needs – Microsoft Office 2013

    Fill out this form and a representative will contact you to discuss your Microsoft Office training needs

    Read More..
  • Time to dump the VLOOKUP Function for =INDEX(MATCH Functions?

    VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

    Read More..
  • Office 2016 is here – How to install Office 2016 Preview

    Want to help shape the next release of Office? Microsoft is looking for Office enthusiasts like you to share your feedback…

    Read More..
  • Risk Analysis using Solver Part 1 – Introduction

    Risk Analysis using Excel Solver – Part 1 | Introduction to Risk Welcome to our tutorial on risk analysis . …

    Read More..
  • 7 Free Online Monitoring and Evaluation Courses

    Developing a career in Monitoring & Evaluation on average takes between 3 – 10 years depending on nature of projects,…

    Read More..
  • Optimization – OpenSolver for Microsoft Excel

    OpenSolver for Microsoft Excel OpenSolver is an Excel VBA add-in that extends Excel’s built-in Solver with more powerful solvers. It…

    Read More..
  • Copying a sheet multiple times at once in Excel using VBA

    Copy a sheet Multiple times in Excel using VBA Copying multiple Excel sheets sometimes can be a daunting task when…

    Read More..
  • Excel Shortcuts – Function Keys

    Use Microsoft Excel Shortcuts to do achieve more efficiency! Download it here Excel Shortcuts – Function Keys    

    Read More..
  • Markov Chains

    A Markov chain (discrete-time Markov chain or DTMC) named after Andrey Markov, is a random process that undergoes transitions from…

    Read More..
  • CV writting basics

    CV Writing 101!

    Read More..
  • Timing Out Google Forms with a Script

        FORM_OPEN_DATE   =  “2016-08-22 08:00″;     FORM_CLOSE_DATE  =  “2014-08-22 23:30″;     RESPONSE_COUNT   =  ” “;         /* HowToGeek: http://www.opencastlabs.co.ke/blog…

    Read More..
  • Calculating Monthly Loan Repayments with Microsoft Excel PMT Function

    PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate. Download this Excel file (Compatible with Office 2010 – 2016) – OpenCastLabs Consulting (Advanced Excel Training)

    Read More..
  • Using IPMT Function to Calculate Interest on Loans – Reducing Balance

    The Excel IPMT function calculates the interest payment, during a specific period of a loan or investment that is paid…

    Read More..
  • David Kandie speaks on OpenCastLabs Consulting Course Offerings

    Read More..
VERIFIED & SECURED
BY: RapidSSL SHA256 CA
SSL Valid: Nov 07, 2016 - Nov 07, 2017