Tag: learn

MSPTDA 32: Slowly Changing Dimensions Team-Employee Report with Worksheet Formulas

Posted on by Annie D

Download files for videos: https://ift.tt/31gqHEm
Pdf files with notes: https://ift.tt/2IOoqtJ

In this video learn about how to deal with a “Slowly Changing Dimensions”, which is the Dimension = Employee and the changing Attribute = Team. Learn about the basics of “Slowly Changing Dimensions”. See a solution for reporting Teams and Employee Sales Over Time using the Worksheet Functions: SUMIFS and FILTER. Solution is shown for Office 365 Excel and older versions of Excel.
Topics:
1. (00:07) Introduction
2. (00:41) Basics of “Slowly Changing Dimensions” and what desired report looks like.
3. (02:12) Look at Worksheet, Power Query M Code and DAX Formulas for 3-way lookup.
4. (02:48) Excel Worksheet Solution
5. (03:40) FILTER Function for 3-way lookup (Office 365)
6. (05:54) INDEX and MATCH 3-way lookup formula (versions other than Office 365)
7. (06:10) SUMIFS Function
8. (08:00) Summary

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

View on YouTube

How to deal with errors in Power Query (2 ways)

Posted on by Annie D

In today’s video, I am going to show you how to manage errors in power query two ways: the “official one” and a faster way (that could be a lot faster 😉
#curbal #powerquery #powerbi

Here you can download all the pbix files: https://ift.tt/2yGx9Ih

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l

☟☟☟☟☟☟☟☟☟☟

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b

☟☟☟☟☟☟☟☟☟☟

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

https://ift.tt/2NrgChB

Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲

************

What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!

https://ift.tt/2I8nl09

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

#CURBAL #SUBSCRIBE

View on YouTube

Repeat ROW and COLUMN Headers on Each page in Excel

Posted on by Annie D

In this video, I will show you how to repeat row and column headers for each page in Excel.

This is especially useful when you’re printing a report that has a lot of data. You can use the method shown in this video to make sure the rows and column headers appear on each page of the printed report.

This can be done by changing a setting in the Page Setup dialog box.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.

It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube

Power BI & DAX Master Class – Data Model Design Deep Dive

Posted on by Annie D

TO VIEW REPLAY & DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/2oFQZlZ

When is it?
October 13th, 4pm New York (EDT), 1pm Los Angeles (PDT), 9pm London (BST)
October 14th, 7am Sydney (AEDT), 9am Auckland (NZDT)

Where is it? Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Sam McKay, Founder of Enterprise DNA – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

– Learn how to optimize data
– Setup data model structure
– Relationship best practices
– Unique data model designs
– Working w/ multiple tables

If you have questions regarding this training, please send it at https://ift.tt/2xDKj94

View on YouTube

Highlight Dates that are Past the Due Date in Excel (or about to be due)

Posted on by Annie D

In this video, learn how to highlight cells with dates that are past the due date.

This can easily be done using the TODAY function in conditional formatting.

In this video, I cover the following two examples:
⏵ How to highlight dates that are past the due date
⏵ How to highlight dates where the due date is in the next 5 days

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.

It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube

How to Split Each Excel Sheet Into a Separate File

Posted on by Annie D

In this video, I will show you how to split each worksheet in Excel into a separate Excel file/workbook.

Below is the VBA code used in the video:

‘Code Created by Sumit Bansal from TrumpExcel.com
Sub SplitEachWorksheet()
Dim FPath As String
FPath = Application.ActiveWorkbook.Path
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each ws In ThisWorkbook.Sheets
ws.Copy
Application.ActiveWorkbook.SaveAs Filename:=FPath & “\” & ws.Name & “.xlsx”
Application.ActiveWorkbook.Close False
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub

To use this code, you need to save the Excel workbook (from which you want to split the worksheets) in the same folder where you want the individual files.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube

XLOOKUP or VLOOKUP & Dynamic Arrays to Deliver Table of Lookup Values! –- Excel Magic Trick 1611

Posted on by Annie D

Download Excel File: https://ift.tt/2IFd37a
Learn about how to use XLOOKUP or VLOOKUP to lookup a rectangular range of lookup values and return a rectangular range of returns values.

View on YouTube

DAX Fridays! #145: SUMMARIZECOLUMS

Posted on by Annie D

In today’s #daxfridays we will cover the DAX function SUMMARIZECOLUMNS and compare it to SUMMARIZE.

Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU

Link to DAX Fridays survey: http://bit.ly/2MMM4KK

Here you can download all the pbix files: https://ift.tt/2yGx9Ih

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

☟☟☟☟☟☟☟☟☟☟

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b

☟☟☟☟☟☟☟☟☟☟

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

https://ift.tt/2NrgChB

Many thanks in advance!Here you can download all the pbix files: https://ift.tt/2yGx9Ih

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l

************

What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!

https://ift.tt/2I8nl09

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

#daxfridays #curbal #SUBSCRIBE

View on YouTube

Protect a Sheet in Excel But Leave Some Cells Unlocked

Posted on by Annie D

In this video, I will show you how to protect a sheet in Excel but have some cells that are unprotected and can be edited.

This can be useful when you’re sharing the workbook with other people and don’t want them to make any edits in some of the cells. In this case, you can only unprotect some cells and keep rest everything protected/locked.

You can also have a password for a specific range so that only the person with the password can edit that range.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website).

This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc.

Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube

Save Excel Charts as Images (2 Easy Methods)

Posted on by Annie D

In this video, I will show you how to save charts in Excel as images/pictures in JPG or PNG format.

You can choose to do this one by one in case you have only a couple of charts/graphs.

And in case you have many charts/graphs that you want to convert to images, you can also use the second method shown in this video – which is to save the Excel workbook as HTML.

When you save the Excel workbook as an HTML file, all the charts are automatically saved as images in the PNG format.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube

PowerApp approval app and adaptive card with Tomasz Poszytek

Posted on by Annie D

In today’s video and with the help of Tomasz Poszytek, we show you how to create a powerapp approval app that will allow your users to add tips to a power bi report. Tomasz will show you also how to create adaptive cards instead of send emails for the approval flow, so dont miss it!

Here is a link to Tomasz channel: https://www.youtube.com/channel/UCC_vmzvv1I8X_8OF7VTd_iw

I have released my first template app which is Free to download here: http://bit.ly/2othNWm and one trick I use is to change column names based on parameters given by the end user. Check this video if you want to do that too: https://www.youtube.com/watch?v=NHecJhFQ_Ys

Here you can download all the pbix files: https://ift.tt/2yGx9Ih

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l

☟☟☟☟☟☟☟☟☟☟

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b

☟☟☟☟☟☟☟☟☟☟

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

https://ift.tt/2NrgChB

Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲

************

What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!

https://ift.tt/2I8nl09

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

#SUBSCRIBE #CURBAL

View on YouTube

Calculate Working Days Between Two Dates in Excel (excluding Weekend & Holidays)

Posted on by Annie D

In today’s video, I will show you how to calculate working days between two dates in Excel.

The following five examples are covered in this video:
— Calculating the total number of days between two dates
— Calculating working days (excluding weekend days and holidays)
— Calculating working days (when weekend days are not Saturday and Sunday)
— Calculating working days in a part-time job
— Calculating the number of Mondays in between two dates.

For calculating working days, Excel has two functions – NETWORKDAYS and NETWORKDAYS.INTL.

These formulas allow you to specify the weekend days as well as the holidays.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #Excelin2Minutes

View on YouTube