Name: Create an X-Lookup Dropdown with Images!
Uploaded: 2024-04-17T14:28:02.097Z
Duration: 8 min 43 s

Welcome to our YouTube channel! In this video, we will guide you through the process of creating a dynamic dependent drop-down list with images in Excel. 

If you've ever wanted to manage a list of offices and their corresponding managers, and have the choices automatically update as you navigate through the data, then this tutorial is for you. 

Join us as we demonstrate how to utilize the powerful features of Office 365, including the exciting new capability to insert images directly into cells. 

By the end of this step-by-step tutorial, you'll have the skills to create your own dynamic dependent drop-down lists, enhancing your Excel spreadsheets with visually appealing images. 

Don't miss out on this opportunity to expand your Excel knowledge and optimize your data management. Hit that play button now and let's get started on this exciting journey!


Microsoft Excel

Excel,  Microsoft Office and Web Design are one of the most powerful apps and we can work together on a lesson plan that fits your needs and timeframe. I will make sure that you learn exactly what you need and give you the tools so you can keep improving even after our lessons. My approach is to make the lessons fun, and break down complex ideas into small and logical concepts that you will understand fully.

Create an X-Lookup Dropdown with Images!

eceedcf3-ac5a:37756;isclassifiedstrendingsuggestionsenableddt:42136;316f64c0-2415:46048;b2454379-d6cf:44572;335d7519-3303:46159;6d3f11ff-ee6c:47314;1a645375-144d:47316;69eea575:61685;i9de8100:55497;ei83g319:53872;47h3f766:58362;fg008402:58376;i6jj6667:86739;istutorredesignv2_1:73124;2b6i0532:68197;a5gbd220:61179;blogpwt:71359;5db3b892:67466;2a2j8400:70238;b534g232:70741;j91hb444:69773;18h21436:69961;85h98405:81245;0eie7335:76839;cia78296:75037;9b4gd804:78753;4d465237:81260;deisn977:110326;1d789912:110325;slcardst:87990;searchranking_newpqs:91321;b1ff5649:88417;d9c7i206:87231;ajgj0920:88926;a1d06430:92612;15gbg809:92228;3cf2h499:95552;90ahj157:94513;3d835968:100010;gg41j822:94817;3i5dg498:97157;437bb176:97771;06ieg414:100430;9ab7j510:99496;a0ge6769:101092;bfb37872:105751;7f8gg909:114000;e36bg556:114647;

Web Design

Microsoft PowerPoint

Beginner

Intermediate

Advanced

Awarded Diamond Presenter of 2022

Awarded Diamond Presenter of 2021

MCTS VB. NET

Microsoft Partner

MCTS SQL Server

Trainer and consultant for Microsoft Office, Instagram, Facebook, Trello, JavaScript, Joomla!, WordPress, and Google’s Search Engine Optimization (SEO). Provides digital marketing solutions including QuickBooks management and website creation using WordPress and MySQL.
•	Designed a compelling website for Garcia Awnings and delivered a 180º pivot from zero calls, leads, and little to no business to an astounding 16k impressions in 3 months
•	Provided consulting for client PwC related to technical writing and copywriting services
•	Created a website for client BeyondBrook.com, a social media influencer with over 11k followers
•	Re-designed websites for Bird Road Auto Body Shop and Carolina Pediatrics Emergency Fellowship
•	Research, Design and Implementation of online courses currently published on the company’s website
•	Ongoing support and training for local businesses that require a customized structured learning method.
•	Former trainer for Sandata’s CalEVV System and participated in the latest rollout for the training of providers from the State of California.

IT Trainer / Business Consultant

Designed, implemented, and updated technical support documentation, technical training materials, and overall technical presentations for end users on 4 managed applications: Trust Central, WebGrants, Contract Analyst, and Microsoft Office 365.
•	Delivered level I and II technical training and support for 60 internal and 800 external staff daily
•	Enhanced accountability and productivity by 40% after integrating Zendesk with the ticketing system
•	Improved customer satisfaction scores by 10% for a client by implementing tutorials with voiceovers
•	Increased productivity for an IT department after implementing web tutorials for customized apps
•	Developed Zendesk macros including standard responses and data gathering questionnaires

IT Trainer / Helpdesk Specialist

Excel has been a passion of mine for 20 years. My goal is for my students to feel motivated and ready for their tasks at work or business. Patience, positive reinforcement and creative teaching strategies are incentives to make a lesson as good as it can be. Let me show you the magic and tips that you need to master Excel.

Karina is excellent, very experienced, knowledgeable and a bonus track that she is bilingual and can wear 2 hats as she teaches (ideal for bilingual audiences that use instinctively English and Spanish in Excel)
Thank you Karina!

Karina was wonderful! She listened to what I needed to focus on in Excel and we put together a plan of action. Will definitely be working with her again!

She’s excellent teaching , very easy to understand!

Karina was organized and prepared! We jumped right into it. She had several sample spreadsheets prepped and had a lesson plan ready to go. I learned a lot in short lesson and will continue on with her!

Karina was super helpful and has even offered classes catered more towards what I need and for that I am GRATEFUL!

Hola, y en este video te mostraremos cómo configurar tu cuenta de correo electrónico de Hostinger usando Outlook.


Como Configurar Hostinger en Microsoft Outlook 

Hola a todos en este ejemplo tenemos 2 listas separadas de polizas de seguro que se han vendido en el 2022 y 2023

Vamos a usar el formato condicional, resaltando los resultados en la lista del 2023


Excel: Como Resaltar Diferencias en 2 Listas 

Welcome to our tutorial on how to use ChatGPT, the large language model trained by OpenAI! ChatGPT is a powerful tool that can assist you in generating human-like responses to a wide range of prompts and questions.

To use ChatGPT, simply type your prompt or question into the input box, and ChatGPT will generate a response for you. You can use ChatGPT for a variety of purposes, including answering questions, generating text for creative writing, or even just for fun!

ChatGPT is powered by artificial intelligence and has been trained on vast amounts of text from the internet, so it has a broad knowledge base to draw from. You can ask ChatGPT about almost anything, and it will do its best to provide a helpful and informative response.

To get the most out of ChatGPT, try to be as clear and specific as possible in your prompts. This will help the model understand exactly what you are looking for and provide a more accurate and relevant response.

Overall, ChatGPT is an excellent tool for anyone looking to generate human-like text quickly and easily. Give it a try and see what kind of responses it can generate for you!


What is ChatGPT and How You Can Use It?

Esta herramienta es super poderosa y te permite hacer cambios de texto, llenar en serie, unir y separar texto en solo segundos no te lo puedes perder

Excel Super Poderoso Flash-Fill - Ahorra Horas de Trabajo!

Aqui te explicamos como borrar duplicados en solo segundos con Excel

Como Eliminar Duplicados Rapidisimo en Excel

This is the best way to practice - and master - important Excel shortcuts. Follow along this tutorial to be a Pro in Excel shortcuts

Create a Full Schedule in Excel with NO MOUSE: Best Way to master Shortcuts!

En este video te explicamos de manera clara y sencilla como seleccionar elementos en Excel, esto es indispensable para que puedas aprender a tu ritmo esta maravillosa aplicacion.

Excel de Estados Unidos: Cómo Navegar y Seleccionar Correctamente

En este video le daremos tips de como imprimir en Excel, no mas "guess work" tratando de cuadrar e imprimir documentos con las paginas que necesitas.

Excel: Como Imprimir Correctamente Paso a Paso 

Hola, en este video te mostraremos cómo configurar tu dirección de correo electrónico de Hostinger Titan usando tu cuenta de Gmail 

Esta configuración te permitirá enviar y recibir correos electrónicos en un lugar central y aún se verá profesional. También puede vincular varios correos electrónicos de Hostinger en una sola cuenta de Gmail. Otro beneficio es que puede ver estos correos electrónicos desde su teléfono móvil a través de Gmail como lo haces normalmente.



Como Vincular tu Hostinger Email con tu Cuenta de Gmail - Al Grano!

Hola y en este video te vamos a ensenar como hacer graficos explicado facil y al grano 


Tambien veremos como Excel usa Inteligencia Artificial con los graficos



Como Hacer Graficos en Excel Paso a Paso y con Inteligencia Artificial

¡Bienvenidos a nuestro canal de videos! En este emocionante video, exploramos el fascinante mundo de Canva y sus herramientas de inteligencia artificial que están revolucionando el diseño gráfico. Prepárate para descubrir cómo la IA puede llevar tus habilidades creativas al siguiente nivel y ayudarte a crear contenido visual impactante en cuestión de minutos.

En los últimos años, Canva se ha convertido en una herramienta indispensable para diseñadores, profesionales del marketing y entusiastas creativos. Con su plataforma intuitiva y fácil de usar, cualquier persona puede crear diseños sorprendentes sin necesidad de conocimientos técnicos avanzados. Pero lo que realmente distingue a Canva es su integración de herramientas de inteligencia artificial, que potencian las posibilidades creativas y aceleran el proceso de diseño.

En este video, te llevaremos de la mano a través de las poderosas funciones de IA que Canva ofrece. Descubrirás cómo la tecnología de reconocimiento de imágenes puede sugerir estilos de diseño y combinaciones de colores basados en tus imágenes de referencia. Además, exploraremos la herramienta de detección automática de objetos, que identifica elementos clave en tus diseños y te brinda recomendaciones inteligentes para mejorarlos.


Super Tips de Canva con Ai que no Te Puedes Perder!

Aprende como calcular entre dos hojas de Excel. 

Siempre se demuestra en una misma hoja pero que pasaria si tienes que sumar, restar multiplicar y dividir 2 hojas al mismo tiempo? aquí te lo explicamos todo.

Karina A.

Create an X-Lookup Dropdown with Images!

Karina's Microsoft Excel videos

Como Configurar Hostinger en Microsoft Outlook

Excel: Como Resaltar Diferencias en 2 Listas

What is ChatGPT and How You Can Use It?

Excel Super Poderoso Flash-Fill - Ahorra Horas de Trabajo!

Como Eliminar Duplicados Rapidisimo en Excel

Create a Full Schedule in Excel with NO MOUSE: Best Way to master Shortcuts!

Excel de Estados Unidos: Cómo Navegar y Seleccionar Correctamente

Excel: Como Imprimir Correctamente Paso a Paso

Como Vincular tu Hostinger Email con tu Cuenta de Gmail - Al Grano!

Como Hacer Graficos en Excel Paso a Paso y con Inteligencia Artificial

Super Tips de Canva con Ai que no Te Puedes Perder!

Excel: Sumar, Restar, Multiplicar y Dividir ENTRE 2 Hojas!

Teacher Reviews (5)

Book online lesson

How to Use the Filter Function in Microsoft Excel

How to Clean Data in Microsoft Excel Quickly

How to Mask Mobile Numbers in Microsoft Excel

How to Copy Data from One Sheet to Another Without Losing Format in Microsoft Excel

How to Insert Image in any Chart in Microsoft Excel

How to Highlight Active Row in Microsoft Excel

Removing Empty Rows in a Table in Microsoft Excel

How to Automate Serial Numbers in Microsoft Excel

Inserting a Slicer to Filter Data in Microsoft Excel

How to Get Data from Web to Microsoft Excel

Related Subjects