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

#XLOOKUP

Showing: 31 courses
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
ExcelIsFun

Text Formulas & Functions in Excel Worksheet and Power Query

0 rewiews
Comprehensive tutorial on Excel text functions and Power Query, covering formulas, data extraction, error handling, and data cleaning techniques for efficient spreadsheet management.
Add to list
37 Lesons
34 minutes
On-Demand
Free-Video
ExcelIsFun

Excel Statistical Analysis - Learn Central Limit Theorem by Building Sampling Distribution of Xbar

0 rewiews
Explore the Central Limit Theorem through practical Excel exercises, learning to build sampling distributions and apply statistical concepts for informed business decision-making.
Add to list
21 Lesons
50 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
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

Microsoft Excel Advanced Excel Training Course

0 rewiews
Comprehensive advanced Excel training covering dynamic arrays, advanced functions, data manipulation, and statistical analysis. Includes hands-on exercises for practical skill development.
Add to list
35 Lesons
3 hours 44 minutes
On-Demand
Free-Video
Learnit Training

Excel 2021 Pivot Tables Tutorial

0 rewiews
Master Excel Pivot Tables to efficiently analyze large datasets, create insightful reports, and design powerful charts. Learn data organization, custom sorting, and advanced functions like XLOOKUP and Power Pivot.
Add to list
16 Lesons
1 hour 36 minutes
On-Demand
Free-Video
Learnit Training

Office 2021 New Features Tutorial

0 rewiews
Explore new features in Office 2021: XLOOKUP, SORT, UNIQUE functions in Excel; Ink Replay and Draw tab in PowerPoint; translation in Outlook. Learn to leverage these tools for enhanced productivity.
Add to list
11 Lesons
29 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
ExcelIsFun

All Important Excel Lookup Formulas - Excel Worksheet, Power Query & DAX – 28 Examples

0 rewiews
Comprehensive guide to Excel lookup formulas, covering XLOOKUP, FILTER, XMATCH, INDEX, and more. Includes examples in Excel, Power Query, and DAX for exact and approximate matches.
Add to list
36 Lesons
1 hour 19 minutes
On-Demand
Free-Video
Learnit Training

Excel 2021 Pivot Tables Tutorial

0 rewiews
Master Excel Pivot Tables to efficiently analyze large datasets, create insightful reports, and design powerful charts. Learn data organization, custom sorting, and advanced Power Pivot features.
Add to list
15 Lesons
1 hour 34 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 2021 Advanced Tutorial - Part 3 of 3

0 rewiews
Master advanced Excel 2021 features: nested functions, database operations, XLOOKUP, UNIQUE, SORT, FILTER, LET, data consolidation, and an introduction to macros for enhanced productivity.
Add to list
12 Lesons
1 hour 5 minutes
On-Demand
Free-Video
Learnit Training

XLOOKUP Excel Tutorial

0 rewiews
Master Excel's powerful XLOOKUP function for faster, more efficient data lookup. Learn its advantages over VLOOKUP and Index/Match, and explore advanced features like approximate matching and two-way searches.
Add to list
10 Lesons
39 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 - Visualize Your Data

0 rewiews
Unlock Excel's data analysis power: learn XLOOKUP, Pivot Tables, Slicers, and Timelines to visualize and extract insights from large datasets.
Add to list
13 Lesons
56 minutes
On-Demand
Free-Video
Learnit Training

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

0 rewiews
Master Excel skills for leadership: data retrieval, validation, XLOOKUP, tables, and advanced functions. Enhance decision-making and efficiency in your professional role.
Add to list
21 Lesons
1 hour 6 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
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

Excel Pivot Tables Tutorial - From Basics to Advanced Techniques

0 rewiews
Master Excel Pivot Tables: Analyze complex data, create insightful charts, and leverage advanced features like Power Pivot and DAX expressions for powerful data manipulation and visualization.
Add to list
27 Lesons
2 hours 23 minutes
On-Demand
Free-Video
ExcelIsFun

Microsoft Data Analysis Tools: Excel, Power Query, Power BI, Dataflow, DAX and M Code

0 rewiews
Comprehensive tutorial on Microsoft data analysis tools, covering Excel, Power Query, Power BI, and more. Learn formulas, data modeling, and visualization techniques for effective data analysis.
Add to list
14 Lesons
1 hour 46 minutes
On-Demand
Free-Video
Learnit Training

Excel Advanced Tutorial - From Named Ranges to VBA

0 rewiews
Master advanced Excel techniques: named ranges, XLOOKUP, database functions, macros, and VBA coding. Enhance data analysis, automate tasks, and create efficient spreadsheets for improved productivity.
Add to list
15 Lesons
1 hour 18 minutes
On-Demand
Free-Video
Learnit Training

Excel Data Analysis Full Course Tutorial

0 rewiews
Comprehensive tutorial covering advanced Excel features for data analysis, including Pivot Tables, XLOOKUP, Copilot integration, VBA, and macros. Master powerful tools to enhance your data manipulation skills.
Add to list
83 Lesons
7 hours 12 minutes
On-Demand
Free-Video
ExcelIsFun

Excel 365 for Teaching: Dynamic Arrays, XLOOKUP, Power Query and PivotTables

0 rewiews
Streamline teaching tasks with Excel 365: master dynamic arrays, XLOOKUP, Power Query, and PivotTables for efficient gradebooks, budgets, and data analysis.
Add to list
10 Lesons
52 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
Simon Sez IT

Advanced Excel 365 Training: Dynamic Arrays, Complex Lookups, and Power Tools

0 rewiews
Boost data analysis skills with advanced Excel 365 features. Master dynamic arrays, complex lookups, custom functions, Power Pivot, and Power Query for efficient data manipulation and management.
Add to list
38 Lesons
3 hours 8 minutes
On-Demand
Free-Video
ExcelIsFun

Microsoft 365 Excel Fundamentals: Formulas, Functions, Formatting and Page Setup - Part 1

0 rewiews
Master essential Excel skills from formulas and functions to formatting and cell references. Includes hands-on projects, time-saving shortcuts, and practical techniques for efficient spreadsheet creation and data analysis.
Add to list
36 Lesons
1 hour 5 minutes
On-Demand
Free-Video
Learnit Training

Excel for HR Professionals - Data Management and Analysis Fundamentals

0 rewiews
Master essential Excel functions and tools specifically designed for HR tasks, from data organization and calculations to creating dynamic visualizations for workforce analytics and reporting.
Add to list
18 Lesons
1 hour 20 minutes
On-Demand
Free-Video