Go to Course Home
Vlookup and Data Validation
Vlookup and Data Validation
In this lesson you will learn: what is vlookup? Why and how...
In this lesson you will learn:
what is vlookup?
Why and how we use data validation ?
Attachments
vlookup.xlsx
Size: 25.41 KB
Join the conversation
Submit
Prev
Next
Table of Contents
Day 1 – Excel (Basics, Personalizing & Presenting Your Work)
1. Basic Background of excel, version, format 2. Cell Referencing 3. Data Type
Knowing excel and its prowess
10m
Walkthrough important excel elements
5m
Essential Keyboard Shortcuts
20m
Quiz-Basics of Excel
Cell Basics and referencing: Your Building Blocks
20m
Quiz – Cell Referencing
Data types in excel
0s
Vlookup and Data Validation
0s
Quiz-vlookup and data validation
Data aggregations, granularity and pivot tables
0s
Conditional Formatting: Highlighting What Matters
55m
Quiz-Pivot Table and Conditional Formatting
Day 2 – Excel (Data Mastery) & Introduction to Power BI & Data Visualization
Mastering Text Functions: Transform Your Data with Ease
5m
Unlocking the Power of Date/Time Functions
5m
Sort and Filter Data Like a Wizard: Tips and Tricks
30m
Visual Storytelling: Mastering Graphs, Charts and Data Visualization
0s
Excel- Text Functions
Installing Power BI
5m 27s
Introduction to Power BI
10m
PowerBI Components
15m
Basic concepts for data visualization
30m
Connect with Data & Key concepts
60m
Introduction to Visuals In Power BI -1
75m
Day 3 – Essential Concepts, Calculations and Interactive Dashboards
Formatting in PowerBI
15m
Hierarchies and Drill down
15m
Filters and Filter Card
20m
Calculated Field, Measure and Parameter
15m
Power BI Workflow: From Planning to Interactive Dashboards
15m
Case Study
0s
Custom Visuals, Page Layout & Formatting, Bookmarks & Selection Pane
30m
Day 4 – Power BI Service & Advanced Concepts
Join using LINK below
0s
Insights & Anlysis in Power BI
30m
Power Query
0s
Data Analysis Expressions (DAX)
30m
Adding further Analysis (constant line etc)
20m
Power BI Services account creation guide
0s
Introduction to Power BI Service
30m
Power BI Embedded & Bookmarks and Buttons
30m
Sharing and publishing
15m
Roles
15m
In this lesson you will learn: