YoVDO

Excel for Emerging Leaders - Use Excel to Look Like a Boss

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Retrieval Courses Data Validation Courses Data Formatting Courses XLOOKUP Courses

Course Description

Overview

Discover how to leverage Excel's powerful features to enhance your leadership skills and impress in the workplace. Learn to retrieve data efficiently using X Lookup, master Autofill for quick data entry, utilize the Help Box for instant assistance, and understand Function Arguments for complex calculations. Explore Data Validation techniques to ensure data integrity, implement the Lookup Function for dynamic data retrieval, and harness XLOOKUP for advanced searching. Gain proficiency in working with Tables, using Data Tools for analysis, and applying Data Formatting for clear presentation. Delve into advanced techniques like Index and Match for flexible data lookups. This comprehensive tutorial, designed for emerging leaders, covers beginner to advanced topics with easy-to-follow instructions and the opportunity to ask questions, ensuring you'll be equipped to use Excel like a boss.

Syllabus

Intro
How these events work
Introduction
Retrieve Data
X Lookup
Autofill
Help Box
Function Arguments
Data Validation
Using Data Validation
Using the Lookup Function
XLOOKUP
Tables
First Name
Using the Data Tools
Questions
Data Formatting
Example
Index and Match
Creating an Index of Match
Index of Match


Taught by

Learnit Training

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard