- 35
- 14 728
Learning With MO
Registrace 28. 11. 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.
Merge Tables with Power Pivot
In this tutorial, we will merge 3 tables into one by using Power Pivot. Using simple DAX expressions, we will create calculated columns.
zhlédnutí: 78
Video
Merge Worksheets with Xlookup
zhlédnutí 165Před 21 hodinou
In this tutorial, we will learn how to merge data from different worksheets by using Xlookup.
Track Projects in Teams
zhlédnutí 97Před 14 dny
Learn how to Add and manage the Planner App in Teams. Integrate this simple project tracking tool today.
Track Projects with Google Sheets
zhlédnutí 71Před 21 dnem
In this tutorial, we explore simple project tracking in Google Sheets.
Free Demo of Power BI
zhlédnutí 44Před měsícem
Enjoy this snippet from our Full-length Power BI Essentials course.
What can I do in OneNote?
zhlédnutí 75Před měsícem
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
zhlédnutí 114Před měsícem
In this tutorial, we go beyond the basics and explore awesome tools available for prductivity
Try these Outlook productivity tools
zhlédnutí 75Před měsícem
Be more productive in Outlook with these 3 simple concepts.
Brand Your PowerPoint Slides
zhlédnutí 10Před 2 měsíci
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
zhlédnutí 29Před 2 měsíci
In this tutorial, we will learn how to make our own theme in PowerPoint and save it for future use.
Custom Charts in PowerPoint
zhlédnutí 58Před 3 měsíci
In this tutorial, we learn how to customize charts to give it a desired look and feel. Dynamically display your chart and wow your audience while presenting.
Return Multiple Values with Single Xlookup Statement
zhlédnutí 11KPřed 3 měsíci
Return Multiple Values with Single Xlookup Statement
Calculate Excel Data Efficiently by Naming Ranges
zhlédnutí 172Před 3 měsíci
Calculate Excel Data Efficiently by Naming Ranges
Format All Slides at once in PowerPoint
zhlédnutí 489Před 4 měsíci
Format All Slides at once in PowerPoint
Customize Slides with PowerPoint Designer Tool
zhlédnutí 9Před 4 měsíci
Customize Slides with PowerPoint Designer Tool
Getting Started with Themes in PowerPoint
zhlédnutí 8Před 4 měsíci
Getting Started with Themes in PowerPoint
PowerPoint Slide Layout and Components
zhlédnutí 14Před 4 měsíci
PowerPoint Slide Layout and Components
Dynamically Filter Pivot Table Data with Slicers
zhlédnutí 16Před 4 měsíci
Dynamically Filter Pivot Table Data with Slicers
Building a Pivot Table to show different values
zhlédnutí 88Před 5 měsíci
Building a Pivot Table to show different values
Preparing Data For Pivot Table Analysis
zhlédnutí 41Před 5 měsíci
Preparing Data For Pivot Table Analysis
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?