How to create an Excel pivot table to analyse data? Tutorial to create an Excel pivot table When analysing a lot of data, it can be difficult to analyse all the information in your spreadsheet. Especially large tables […]
Tips on Excel, the flagship software of the Microsoft Office suite. It is the most widely used spreadsheet program in the world for managing tables and numbers in general. It is certainly one of the office tools on which financiers spend most of their time.
Excel tips to master the Excel software
It is in a way the number one business intelligence tool by far. Because Excel allows you to analyse, create and format data. What are the time-saving tips for Excel?
Here is a selection of the best keyboard shortcuts to manage Excel pivot tables. Excel Pivot Tables, Excel Pivot table in English, allow you to cross reference data in a file very efficiently. Whether the source is a
How to remove #VALUE! #NA! #DIV0 Excel errors with any version of Excel like 2003, 2007, 2010 or Excel 2016? Common messages are for example: #VALUE!, #N/A, #DIV/0!, #REF!, #NAME?, #NULL!, #NUM! Indeed, there is a trick to
How to create and open a new Excel workbook? What is the Excel spreadsheet? Excel is a software from the Microsoft Office suite. An Excel file is also called an Excel workbook. Like a traditional physical workbook, it
What are the best Excel selection shortcuts? Excel is a very powerful software tool and the most used spreadsheet program in the world by far. Nowadays everyone uses Excel in their daily work. However, many of the most
How to select an entire Excel column with data all the way down from the top the end? Use a keyboard shortcut to select an entire Excel column with data. This Excel shortcut works with a table and
How to open two Excel files in separate windows at the same time? Open two Excel files in separate windows seems easy, yet by default, Windows 10 opens both files in the same software, i.e. Excel 2016. So