Office 2016 is on the verge of being released, and although Power BI is the cool new thing Excel 2016 has added several new BI-related features too. What is also interesting – and less well publicised ...

In Excel 2016, Power Query is no longer an Excel add-in but a native feature of Excel, and what’s more, you can now use VBA to create and manage Power Query queries. I’ve found two sources of ...

For more than three decades, Microsoft Office Excel has been one of the inevitable tools for offices! For a big variety of purposes — if it is about creating a basic list of payment you have to ...

Have you found this content useful? Use the button above to save it to your profile. By some strange coincidence, at about the same time I was writing an overview of the Excel 2016 changes, a question ...

Many of us spend a vast portion of our time banging our heads against Excel. Unfortunately we can't help you make those specific figures line up in Office 2016's spreadsheet app – that one's on you – ...

This repository holds the Excel files proposed as examples in the book Manual avanzado Excel 2016 by Francisco Charte, published by Anaya Multimedia Este repositorio contiene los archivos Excel ...

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more. Everyone knows Microsoft Excel as a ...

Following on from our time saving Excel shortcuts, we continue offering updated advice for the time-sensitive spreadsheet enthusiast. Back in 2013 John Gagnon wrote a very popular post about VLOOKUP ...