Главная
Study mode:
on
You
History
Saved
In progress 0 courses
compleat 0 courses
#Art & Design #Adobe #ChatGPT #GitHub

#VLOOKUP

Showing: 51 courses

MS-Excel

4 rewiews
Comprehensive Excel training covering basics to advanced features, including formulas, functions, charts, pivot tables, and keyboard shortcuts for enhanced productivity.
Add to list
103 Lesons
10 hours
On-Demand
Free-Video
Learnit Training

Google Sheets Advanced Tutorial

4 rewiews
Master advanced Google Sheets techniques: data sorting, filtering, charts, pivot tables, functions (IF, VLOOKUP, SUMIF), macros, and more. Enhance your spreadsheet skills for efficient data analysis and visualization.
Add to list
25 Lesons
1 hour 35 minutes
On-Demand
Free-Video
Simon Sez IT

The Ultimate MS Excel Crash Course - Microsoft Excel 2016 Tutorial for Beginners

2 rewiews
Comprehensive 6-hour tutorial covering Excel basics to advanced functions. Learn data entry, formatting, formulas, VLOOKUP, charts, and more. Includes hands-on exercises for practical skill development.
Add to list
39 Lesons
6 hours 2 minutes
On-Demand
Free-Video
Mr Tompkins EdTech

Microsoft Excel - A Teachers Guide to Creating Dynamic Gradebooks-E-Markbooks

1 rewiews
Learn to create dynamic gradebooks in Excel with features like named ranges, VLOOKUP, XLOOKUP, and student summary pages. Perfect for teachers seeking efficient grading solutions.
Add to list
4 Lesons
30 minutes
On-Demand
Free-Video
Simon Sez IT

The Ultimate Excel Tutorial - Beginner to Advanced

1 rewiews
Comprehensive Excel mastery: from basic formulas to advanced techniques like VBA macros, covering data cleaning, pivot tables, and dynamic arrays for enhanced productivity.
Add to list
6 Lesons
5 hours 43 minutes
On-Demand
Free-Video
Learnit Training

Google Docs Advanced Tutorial

1 rewiews
Master advanced Google Docs features: tables, styles, images, charts, collaboration tools, and more. Enhance your document creation skills with practical tutorials on formatting, organizing, and sharing content effectively.
Add to list
39 Lesons
1 hour 34 minutes
On-Demand
Free-Video

Excel Skills

0 rewiews
Enhance data analysis skills with time-series plots, matrix-to-vector conversion, vlookup, histograms, text data import, and correlation techniques in Excel.
Add to list
6 Lesons
30 minutes
On-Demand
Free-Video
The Organic Chemistry Tutor

Excel 2016 Tips, Tricks, Shortcuts, Functions & Formulas

0 rewiews
Master Excel 2016 with 30 essential tips, tricks, shortcuts, functions, and formulas. Boost productivity and efficiency in data management, analysis, and visualization.
Add to list
30 Lesons
1 hour 2 minutes
On-Demand
Free-Video
Teacher's Tech

How to Use Formulas and Functions in Microsoft Excel

0 rewiews
Learn essential Excel formulas and functions, from basic math to advanced techniques like VLOOKUP and conditional functions, enhancing your data analysis and productivity skills.
Add to list
13 Lesons
26 minutes
On-Demand
Free-Video
ExcelIsFun

Excel for Accountants - VLOOKUP & PivotTables - Complete Lessons from Basic to Advanced

0 rewiews
Comprehensive tutorial on VLOOKUP and PivotTables for accountants, covering basic to advanced techniques. Includes practical examples, efficiency tricks, and number formatting tips for Excel mastery.
Add to list
19 Lesons
1 hour 33 minutes
On-Demand
Free-Video
ExcelIsFun

MIN & MAX Functions for Alphanumeric - Text Values Report

0 rewiews
Learn 8 methods to find MIN and MAX alphanumeric values in Excel, including VLOOKUP, array formulas, AGGREGATE, MINIFS/MAXIFS, Power Query, and SQL, with practical examples and explanations.
Add to list
10 Lesons
32 minutes
On-Demand
Free-Video
ExcelIsFun

Lookup Functions and Formulas in Excel 2016 - Comprehensive Lessons with 20 Examples

0 rewiews
Comprehensive tutorial on Excel lookup functions with 20 practical examples, covering VLOOKUP, HLOOKUP, INDEX, MATCH, and LOOKUP for data retrieval and analysis.
Add to list
23 Lesons
1 hour 19 minutes
On-Demand
Free-Video
ExcelIsFun

Excel 2016 IFS Functions - Compare and Contrast IF and IFS Functions

0 rewiews
Learn to use Excel 2016's IFS function for complex conditional logic, comparing it with IF and VLOOKUP. Explore practical examples and advanced techniques for efficient data analysis and formula creation.
Add to list
9 Lesons
28 minutes
On-Demand
Free-Video
ExcelIsFun

Build Database with Excel Table Feature and VLOOKUP to Get Invoice Detail

0 rewiews
Learn to create dynamic databases in Excel using Tables, master VLOOKUP for invoice details, and explore advanced features like structured references and data validation.
Add to list
16 Lesons
26 minutes
On-Demand
Free-Video
ExcelIsFun

Basic Excel Business Analytics - Clean & Transform Data - Formulas, Flash Fill, Power Query, Text To Columns

0 rewiews
Aprenda técnicas avançadas para limpar e transformar dados no Excel, incluindo fórmulas, Flash Fill, Power Query e Text to Columns, preparando-os eficientemente para análise.
Add to list
14 Lesons
30 minutes
On-Demand
Free-Video
ExcelIsFun

Data Modeling - VLOOKUP, Power Query or Power Pivot?

0 rewiews
Learn data modeling techniques using VLOOKUP, Power Query, and Power Pivot for efficient data analysis in Excel. Explore methods for handling multiple tables and creating effective PivotTable reports.
Add to list
17 Lesons
45 minutes
On-Demand
Free-Video
ExcelIsFun

Ctrl - Shift - Enter - Excel Array Formulas - Dynamic Ranges - INDEX & OFFSET Functions

0 rewiews
Master Excel's dynamic ranges using INDEX and OFFSET functions. Learn to create flexible formulas, charts, and data validation lists that automatically adjust as data changes, enhancing efficiency and accuracy in data analysis.
Add to list
21 Lesons
1 hour
On-Demand
Free-Video
ExcelIsFun

Excel for Accounting - Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards

0 rewiews
Master Excel for accounting with advanced formulas, PivotTables, macros, and charts. Learn efficient techniques for data analysis, reporting, and visualization to enhance your financial workflow.
Add to list
98 Lesons
2 hours 44 minutes
On-Demand
Free-Video
ExcelIsFun

Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions

0 rewiews
Learn to create reusable Excel invoices using advanced functions like VLOOKUP, IF, and data validation. Master invoice formatting, calculations, and automated invoice numbering for efficient business operations.
Add to list
13 Lesons
31 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Basics - PivotTable Power - Amazing PivotTable Reporting Tricks - Slicers to Show Values As

0 rewiews
Master advanced PivotTable techniques in Excel, including slicers, custom calculations, and data analysis. Learn to create powerful reports and gain insights from complex datasets.
Add to list
24 Lesons
40 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More

0 rewiews
Learn to leverage Excel's Table feature for dynamic ranges in VLOOKUP, PivotTables, charts, and more. Master efficient data management and analysis techniques for improved productivity.
Add to list
12 Lesons
37 minutes
On-Demand
Free-Video

Excel Lookup Formulas

0 rewiews
Master Excel lookup formulas like VLOOKUP, INDEX MATCH, and XLOOKUP. Learn advanced techniques for complex data retrieval, multi-criteria searches, and cross-sheet lookups to enhance your spreadsheet skills.
Add to list
19 Lesons
3 hours 30 minutes
On-Demand
Free-Video

Excel Intermediate Functions & Features

0 rewiews
Master advanced Excel functions like IF, VLOOKUP, IFS, and custom formatting. Learn time-saving techniques, data manipulation, and presentation skills to enhance productivity and analysis capabilities.
Add to list
14 Lesons
2 hours 30 minutes
On-Demand
Free-Video
Learnit Training

Excel 2021 XLOOKUP Tutorial

0 rewiews
Discover XLOOKUP, Excel's powerful lookup function. Learn its advantages over VLOOKUP and INDEX/MATCH, and master techniques for faster, more efficient data retrieval and analysis in spreadsheets.
Add to list
9 Lesons
31 minutes
On-Demand
Free-Video
Learnit Training

Excel 2021 Power User Tutorial

0 rewiews
Advanced Excel techniques for power users, covering complex functions, data analysis, pivot tables, conditional formatting, charts, and macros to solve challenging problems and streamline workflows.
Add to list
12 Lesons
1 hour 16 minutes
On-Demand
Free-Video
Simon Sez IT

Excel for Business Analysts Crash Course - XLOOKUP, IF, Forecast Sheets & More

0 rewiews
Master essential Excel functions for data analysis: VLOOKUP, XLOOKUP, IF statements, forecasting tools, and conditional formatting. Enhance your business analysis skills with practical examples and downloadable files.
Add to list
14 Lesons
2 hours 16 minutes
On-Demand
Free-Video
Simon Sez IT

Lookup Functions in Excel - VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP Tutorial

0 rewiews
Master essential Excel lookup functions: VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP. Learn exact and approximate matches, expanding data, and combining functions for efficient data retrieval and analysis.
Add to list
6 Lesons
1 hour 10 minutes
On-Demand
Free-Video
Simon Sez IT

Advanced Excel Tutorial - Advanced Functions - VLOOKUP, IF, Forecasting, Statistical

0 rewiews
Master advanced Excel functions like VLOOKUP, IF, and forecasting. Learn to manipulate dates, use financial formulas, and apply statistical analysis for data-driven decision making.
Add to list
28 Lesons
4 hours 33 minutes
On-Demand
Free-Video
Learnit Training

Excel 2019 Power User Tutorial

0 rewiews
Advanced Excel techniques for data analysis, including VLOOKUP troubleshooting, INDEX MATCH, PivotTables, array formulas, conditional formatting, charts, and macros. Ideal for power users seeking efficient problem-solving methods.
Add to list
19 Lesons
1 hour 16 minutes
On-Demand
Free-Video
Learnit Training

Google Sheets Beginner Tutorial

0 rewiews
Master Google Sheets essentials: navigation, data entry, formulas, formatting, and advanced features. Gain practical skills for efficient spreadsheet creation, analysis, and sharing in this comprehensive tutorial.
Add to list
32 Lesons
1 hour 19 minutes
On-Demand
Free-Video
Learnit Training

Excel 2021 XLOOKUP Tutorial

0 rewiews
Discover XLOOKUP, Excel's powerful new lookup function. Learn its advantages over VLOOKUP and INDEX/MATCH, and master techniques for faster, more efficient data retrieval and analysis.
Add to list
8 Lesons
29 minutes
On-Demand
Free-Video
Learnit Training

Excel 2021 Power User Tutorial

0 rewiews
Master advanced Excel techniques for efficient data analysis, including XLOOKUP, pivot tables, array functions, and macros. Enhance problem-solving skills and streamline complex tasks for power users.
Add to list
11 Lesons
1 hour 14 minutes
On-Demand
Free-Video
Learnit Training

Excel Power User Advanced Tutorial

0 rewiews
Advanced Excel techniques for power users: dynamic ranges, pivot table enhancements, web data import, and VBA macros. Develop skills to solve complex problems efficiently and push Excel's capabilities to new limits.
Add to list
21 Lesons
1 hour 31 minutes
On-Demand
Free-Video
Learnit Training

Excel Power User Beginner Tutorial

0 rewiews
Master advanced Excel functions like VLOOKUP, INDEX-MATCH, and OFFSET. Learn data mining, dynamic ranges, and conditional formatting to solve complex problems efficiently and become a true Excel power user.
Add to list
22 Lesons
1 hour 44 minutes
On-Demand
Free-Video
Learnit Training

Excel 2016 Advanced Tutorial

0 rewiews
Master advanced Excel techniques including named ranges, complex functions, data consolidation, solver tools, and macros to enhance your data analysis and productivity skills.
Add to list
30 Lesons
2 hours 39 minutes
On-Demand
Free-Video
Learnit Training

Excel 2019 Pivot Tables Tutorial

0 rewiews
Master Excel's Pivot Tables to analyze large datasets efficiently. Learn creation, modification, and advanced features like Power Pivot for data modeling and DAX expressions.
Add to list
22 Lesons
1 hour 49 minutes
On-Demand
Free-Video
Learnit Training

Excel 2019 XLOOKUP Tutorial

0 rewiews
Master Excel's powerful XLOOKUP function to streamline data lookup and analysis. Learn its advantages over VLOOKUP and Index/Match, and explore advanced features for efficient spreadsheet management.
Add to list
9 Lesons
39 minutes
On-Demand
Free-Video
Learnit Training

Excel 2019 Power User Tutorial

0 rewiews
Advanced Excel techniques for data analysis, including VLOOKUP troubleshooting, INDEX MATCH, PivotTables, array formulas, conditional formatting, and macros. Ideal for users seeking to enhance efficiency and problem-solving skills.
Add to list
18 Lesons
1 hour 15 minutes
On-Demand
Free-Video
Learnit Training

Excel 2019 Advanced Tutorial

0 rewiews
Master advanced Excel skills: named ranges, complex functions, data analysis tools, and macros. Boost efficiency and tackle sophisticated spreadsheet tasks with confidence.
Add to list
25 Lesons
1 hour 33 minutes
On-Demand
Free-Video
LiquidBrain Bioinformatics

Batch Create Reports with App Scripts

0 rewiews
Learn to automate report generation in Google Sheets using Apps Script. Create tables, graphs, and text replacements without add-ons, streamlining data processing from raw CDC EU information.
Add to list
11 Lesons
39 minutes
On-Demand
Free-Video
Learnit Training

Excel 2021 Power User Full Course

0 rewiews
Comprehensive tutorial for advanced Excel users covering powerful functions, pivot tables, data analysis techniques, and XLOOKUP. Develop skills to solve complex problems and streamline data processing efficiently.
Add to list
44 Lesons
4 hours 16 minutes
On-Demand
Free-Video
Learnit Training

Google Sheets Advanced Tutorial

0 rewiews
Master advanced Google Sheets techniques including data manipulation, complex functions, pivot tables, charts, and collaborative features to enhance your spreadsheet skills and boost productivity.
Add to list
28 Lesons
1 hour 11 minutes
On-Demand
Free-Video
Learnit Training

Google Sheets Full Course Tutorial

0 rewiews
Comprehensive tutorial covering Google Sheets essentials: navigation, formulas, data manipulation, charts, pivot tables, functions, collaboration, and more. Perfect for beginners and intermediate users seeking to enhance spreadsheet skills.
Add to list
53 Lesons
2 hours 17 minutes
On-Demand
Free-Video
Simon Sez IT

11 Excel Functions to Supercharge Your Skills in 2024

0 rewiews
Elevate your Excel proficiency with 11 advanced functions, from SUMIFS to VBA, enhancing data analysis, visualization, and automation for improved productivity and decision-making.
Add to list
12 Lesons
1 hour 43 minutes
On-Demand
Free-Video
Learnit Training

Google Sheets Beginner Tutorial - 2023 Update

0 rewiews
Master Google Sheets essentials: navigation, formulas, formatting, data management, and collaboration. Gain practical skills for efficient spreadsheet creation and analysis in this comprehensive beginner-friendly tutorial.
Add to list
26 Lesons
1 hour 7 minutes
On-Demand
Free-Video
Simon Sez IT

Top 10 Excel Formulas for Beginners - Essential Functions Tutorial

0 rewiews
Master essential Excel formulas with step-by-step guidance. Learn VLOOKUP, IF statements, COUNTIF, and more. Practical examples and timestamps for easy navigation make this tutorial perfect for beginners.
Add to list
13 Lesons
1 hour 32 minutes
On-Demand
Free-Video
Prodramp

No-Code and Full-Code Data Analytics with GigaSheet and Pandas - Side-by-Side

0 rewiews
Hands-on workshop comparing no-code (GigaSheet) and full-code (Pandas) data analytics solutions, covering data upload, filtering, aggregation, updating, grouping, and exporting.
Add to list
14 Lesons
56 minutes
On-Demand
Free-Video
PASS Data Community Summit

Modern Excel - The Supercomputer Hiding on Everyone’s Desktop

0 rewiews
Discover game-changing Excel tools for data-driven decisions. Learn multi-source import, rapid data shaping, portable formulas, and insightful reporting techniques to supercharge your spreadsheet skills.
Add to list
26 Lesons
1 hour 19 minutes
On-Demand
Free-Video
Teacher's Tech

How to Use VLOOKUP in Google Sheets - Beginner's Tutorial

0 rewiews
Master VLOOKUP in Google Sheets: Find and match data efficiently. Step-by-step examples cover basics to advanced techniques, including multiple criteria and error handling.
Add to list
6 Lesons
13 minutes
On-Demand
Free-Video
Kevin Stratvert

Google Sheets - From Basics to Advanced Features Tutorial

0 rewiews
Master spreadsheet essentials with hands-on practice in data entry, formulas, charts, pivot tables, and collaboration features. Transform raw data into meaningful insights using practical functions and visualization tools.
Add to list
38 Lesons
49 minutes
On-Demand
Free-Video
Great Learning

Google Sheets Tutorial - How to Use Google Sheets

0 rewiews
Master Google Sheets essentials: data manipulation, formulas, formatting, pivot tables, and VLOOKUP. Learn to create insightful charts and leverage ChatGPT for enhanced productivity and data analysis.
Add to list
8 Lesons
1 hour 10 minutes
On-Demand
Free-Video