- 38
- 16 209
Learning With MO
เข้าร่วมเมื่อ 28 พ.ย. 2011
Having uncertainty with desktop applications? Make the most of step-by-step lessons to become more comfortable with MS Office products. Lessons, tips, tricks, and at your own pace.
Calculate Columns in SharePoint List
In this tutorial, we learn how to calculate columns in an existing SharePoint List.
มุมมอง: 30
วีดีโอ
Add OneDrive to Microsoft Teams
มุมมอง 3421 ชั่วโมงที่ผ่านมา
Add OneDrive to MS Teams for greater efficiency. Communicate and manage files in one place.
Merge Tables with Power Pivot
มุมมอง 13214 วันที่ผ่านมา
In this tutorial, we will merge 3 tables into one by using Power Pivot. Using simple DAX expressions, we will create calculated columns.
Merge Worksheets with Xlookup
มุมมอง 27021 วันที่ผ่านมา
In this tutorial, we will learn how to merge data from different worksheets by using Xlookup.
Track Projects in Teams
มุมมอง 10328 วันที่ผ่านมา
Learn how to Add and manage the Planner App in Teams. Integrate this simple project tracking tool today.
Track Projects with Google Sheets
มุมมอง 74หลายเดือนก่อน
In this tutorial, we explore simple project tracking in Google Sheets.
Free Demo of Power BI
มุมมอง 46หลายเดือนก่อน
Enjoy this snippet from our Full-length Power BI Essentials course.
What can I do in OneNote?
มุมมอง 79หลายเดือนก่อน
Why OneNote? Let's see if it is a good productivity tool. Enjoy this snippet from our full-length course.
Next Level Productivity in Outlook
มุมมอง 114หลายเดือนก่อน
In this tutorial, we go beyond the basics and explore awesome tools available for prductivity
Try these Outlook productivity tools
มุมมอง 75หลายเดือนก่อน
Be more productive in Outlook with these 3 simple concepts.
Brand Your PowerPoint Slides
มุมมอง 112 หลายเดือนก่อน
In this tutorial, we will learn how to brand our slides by establishing the colors, fonts, and logo. We then incorporate them into our slides for a streamlined experience.
Make Your Own Theme in PowerPoint
มุมมอง 292 หลายเดือนก่อน
In this tutorial, we will learn how to make our own theme in PowerPoint and save it for future use.
Return Multiple Values with Single Xlookup Statement
มุมมอง 12K4 หลายเดือนก่อน
Return Multiple Values with Single Xlookup Statement
Calculate Excel Data Efficiently by Naming Ranges
มุมมอง 1724 หลายเดือนก่อน
Calculate Excel Data Efficiently by Naming Ranges
Format All Slides at once in PowerPoint
มุมมอง 4974 หลายเดือนก่อน
Format All Slides at once in PowerPoint
Customize Slides with PowerPoint Designer Tool
มุมมอง 95 หลายเดือนก่อน
Customize Slides with PowerPoint Designer Tool
Getting Started with Themes in PowerPoint
มุมมอง 85 หลายเดือนก่อน
Getting Started with Themes in PowerPoint
PowerPoint Slide Layout and Components
มุมมอง 145 หลายเดือนก่อน
PowerPoint Slide Layout and Components
Dynamically Filter Pivot Table Data with Slicers
มุมมอง 165 หลายเดือนก่อน
Dynamically Filter Pivot Table Data with Slicers
Building a Pivot Table to show different values
มุมมอง 955 หลายเดือนก่อน
Building a Pivot Table to show different values
Preparing Data For Pivot Table Analysis
มุมมอง 425 หลายเดือนก่อน
Preparing Data For Pivot Table Analysis
Nice, thanks!
Sr, please also share data file for practice
Waste of time. This is yet another (I stopped counting at about 300) example of bad data structuring and a solution looking for a problem that should not exist in the first place. If you want to use Excel as a database I suggest you first learn how databases and normalization work...
Please clarify and or provide an efficient solution. The very nature of data is to be queried.
Most company don’t use databases as they should and strictly use spreadsheets. You’re either a kid or an adult that’s never had a job in data.
@@mojonesprokeep up the good work
I like this video ❤❤❤
Nice video....I was using an older version of Excel and did the same thing using vlookup function.
Nice work!
I’m curious as to why you went through the trouble of going to the FORMULA RIBBON, clicking on the INSERT FORMULA icon then typing in the XLOOKUP FORMULA when you could have just put the cursor into the cell where you want the formula and type =XLOO… which brings up your function choices with XLOOKUP coming up as the first choice. Then hit the tab key and your formula appears. This is not a put down but rather a sincere inquiry. Thanks
Good question. As an educator, I find it useful to utilize the function arguments dialog when teaching functions with multiple arguments. I don't want to assume that all of my students are accustomed to writing out the function in a cell. The function argument box provides more detail and guidance.
Here's a trick to fetch all the values (even from non-adjacent columns) in one XLOOKUP statement. No need to bring the Date column in a separate statement: =XLOOKUP(H6,A6:A23,CHOOSECOLS(B6:F23,{1,2,3,5})) This formula will return data from the following columns: Name, Level, Price, Date
What Excel tool or feature would you like to see?