Debido al formato tabular de Excel, mucha gente cree que ya está familiarizada con las tablas, pero solo se introdujeron en Excel 2010; antes de esto, existía una versión rudimentaria llamada Lista. Las tablas de Excel utilizan un nuevo tipo de referencia de celdas, denominado referencia estructurada, y tienen muchas funciones nuevas e increíbles. Una de las principales ventajas es que su comportamiento dinámico permite que los datos crezcan con el tiempo. En esta sesión de una hora analizamos en detalle las tablas y las referencias estructuradas. Nivel de introducción, no se necesita experiencia.
You must be logged in to access these events
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...
