Madonna House, Westlands Road - Nairobi

Category: Uncategorized

Microsoft Certified: Azure Data Scientist Associate

The Azure Data Scientist applies their knowledge of data science and machine learning to implement and run machine learning workloads on Azure; in particular, using Azure Machine Learning Service. Skills measured Set up an Azure Machine Learning workspace Run experiments and train models Optimize and manage models Deploy and consume models Download Microsoft Certified Azure…
Read more

Get Latest Purchase Date using MAX and IF Functions

Download Excel File Here: Watch Video Here:

Power Query with Excel Training

The Excel Power Query gets data from almost anywhere (web sites, databases, Excel files, SharePoint, Salesforce etc.) and enables you to manipulate it in many ways (clean, transform, merge and append) using a straightforward interface add-in to Microsoft Excel. Non-technical Excel users can access large corporate databases to conduct analysis and produce reports. At the…
Read more

Download Waterfall Chart Template

Step 1 – Create a data table with 7 columns In order to build your own waterfall chart, you first have to organize your data as follows: Period: includes a start, end and all the years/periods to show in the waterfall Cash Flow: the amount of cash flow for each period (only enter data in the…
Read more

Microsoft Excel Shortcuts for PC and Mac

Get the cheatsheet to popular Excel for PC and M

Microsoft Excel Project Gantt Chart Template

A Gantt chart is a project management tool assisting in the planning and scheduling of projects of all sizes, although they are particularly useful for simplifying complex projects. Project management timelines and tasks are converted into a horizontal bar chart, showing start and end dates, as well as dependencies, scheduling and deadlines, including how much…
Read more

3 Most Powerful Free AddIns for PowerPoint

Power-User is a comprehensive add-in that brings various tools to boost your presentations. Get ready-made templates, icons, diagrams, and maps directly in PowerPoint, as well as powerful charts such as Waterfall, Marimekko, Sankey, or Gantt. You can also automate formatting tasks such as changing colors, fonts, charts, or alignment automatically for your entire presentation.Basic options are…
Read more

How to create relationships I. Excel

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

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