Madonna House, Westlands Road - Nairobi

Month: August 2020

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

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. The waterfall chart is also known as a flying bricks chart or Mario chart due to the apparent suspension of columns (bricks) in mid-air. Often in finance, it will be referred to as a bridge.

Microsoft Excel Shortcuts for PC and Mac

Get all Excel shorts for PC and Mac when you download this file. Subscribe to blog for more posts as this. Get the training you need for yourself and your team mates

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

3 Statement Financial Model Template

This free template includes assumptions, an income statement, a balance sheet, a cash flow statement, and a supporting schedules section to calculate depreciation, amortization, and interest on the debt.