Excel

Allan Rocha

How to Create an Excel Gantt Chart with Project Online Data + Power BI

You are not dreaming! You can easily create a Gantt Chart directly in Excel using a FREE app and also publish it to Power BI! We will...

Allan Rocha

How to Create a Resource Demand Dashboard using Project Online, Excel and Power BI

Let’s create and access a simple but effective Resource Demand Dashboard using: Project Online Engagements data; Power Query Office Apps...

Allan Rocha

Office 365 Roadmap using Excel, Power Query and Power BI

Hi All! This post is just to show how cool are Excel, Power Query and Power BI! J If you need to know what is going on in the Office 365...

Allan Rocha

Edit SAP data directly in Excel

Hi All, Look at this new amazing capability coming to Excel Client, Online and iPad… Excel add-ins and extensibility solutions for Office...

Allan Rocha

Comparing 2 Excel Files

Believe it or not, this is a standard feature in Excel 2013. It allow you to compare 2 excel files showing EVERY difference between then…...