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

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

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.