Excel agregó una nueva función hace unos años que hace que sea muy fácil rellenar listas de cosas de una manera diferente una vez que reconoce un patrón. Esta función se denomina «Rellenar con flash» y, en el primer ejercicio de hoy, la utilizaremos para descifrar una lista de nombres, añadir direcciones de correo electrónico, extraer números de vuelo de los códigos de destino y años de las fechas. El segundo consejo explora la nueva función «IFS» y el tercero utiliza una solución ingeniosa para rellenar una columna hacia abajo. Nota: IFS requiere Excel 2019 o Microsoft 365
.Nivel de introducción, no se requiere 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...
