Si su función implica combinar conjuntos de datos que abarcan varios períodos de tiempo, puede resultar complicado si se presentan y formatean de forma diferente. Aquí es donde resultan útiles las herramientas de consolidación de datos de Excel y, en esta sesión, analizaremos varias opciones para consolidar los datos por posición, categoría y fórmula y, para los usuarios de Microsoft 365, mediante Power
Query.You must be logged in to access these events
There are no upcoming events at this time.
This one-hour session explores fundamental Excel skills that every user should benefit from including Sorting on multiple fields, Changing...
One of the most used features of Excel is the ability to visualise data with charts, and this session focusses on the Types of chart,...
This one-hour session is an essential for any Excel user that has never had formal training or is a bit rusty! In it we cover some...
Tips and tricks for Microsoft Excel including how to insert a chart, format shortcuts and incrementing values. This is a 5-part...
Pivot Tables are one of the most revered – and feared – elements Of Excel. In this one-hour session we explode some of...
Learn how to get the most out of Microsoft Excel. In this course, you will learn how to automatically total rows and columns, use conditional...
This is a 5-part series though sessions don't need to be completed in succession. This one-hour session covers some more hints...
In this one-hour session we continue our exploration of Pivot Tables, and cover Expanding Pivot Table functionality, Adding a Calculated...
