Tag: How to

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

Extract Top 5 Values with Names with Dynamic Array Formulas & Conditional Formatting – EMT 1610

Posted on by Annie D

Download Excel File: https://ift.tt/33dB3Gd
Learn how to extract top five scores and names of people with the score, including when there are ties or duplicates. Learn about Office 365 Excel Dynamic Array Functions like FILTER and SORT, lean about how the new Excel Calculation Engine Spills the results so we do not have to copy formulas, and learn about how to add Conditional Formatting to Spilled Results.

View on YouTube

Quickly Hyperlink to Another Sheet in Excel (or a Defined Named Range)

Posted on by Annie D

In this video, I will show you how to quickly and easily insert hyperlinks from one sheet to another sheet in Excel.

This can be useful when you want to create a summary sheet and want to give a link to all the sheets in the Workbook.

To do this, you can use the Insert Hyperlink dialog box that allows you to simply select a sheet and it will instantly create a hyperlink to that sheet. You can also specify if you want this link to take you to any specific cell.

Once this hyperlink is created and you click on the cell with this link, it will instantly take you to the sheet to which it’s linked. You can also create a hyperlink to a named range (covered later in this video).

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 Remove Line Breaks in Excel (takes less than 10 Seconds)

Posted on by Annie D

In this video, I will show you how to remove line breaks in Excel (using Find and Replace).

Line Break is what makes it possible to have a new line in the same cell in Excel. In some cases, you may want to remove these line breaks and get all the data in one line only.

For example, if you have names data with the first name is one line and the last name in one line, you may want to remove the line break and get it all together in one line.

In this video, I will show you how to use Find and Replace to find all the line breaks and replace these with a blank or a comma. The trick here to tell Find and Replace to find line breaks, which you can do by using the keyboard shortcut Control + J.

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

Change column names dynamically with parameters in Power BI

Posted on by Annie D

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 to. 🙂

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

How to Add 0 Before a Number in Excel (No formula or VBA needed)

Posted on by Annie D

In this video, I will show you how to add a 0 (or multiple zeros) before a number in Excel.

When you add a 0 before a number in Excel, it would automatically be removed. For example, if you enter 010, Excel would remove the 0 and make it 10.

This may be needed if you have data such as zip codes or employee ids and you want to make all these of consistent length.

You can use Custom Number formatting to specify how long you want a number to be. For example, if you want all the numbers to ve five-digit long, you can make the custom format as 00000

This will make sure that your numbers are at least five-digit long.

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

excelisfun Flashback Friday 05: Extract Top 5 Values & Names with Array Formula

Posted on by Annie D

excelisfun Flashback Friday 05: Extract Top 5 Values & Names with Array Formula
Download Excel File: https://ift.tt/2ANYRoe
Learn how to create the classic Array Formula to extract the top five values with names including when there are ties. See the Functions: INDEX, MATCH, COUNTIFS, AGGREGATE, SMALL, ROW, ROWS, IF Function and more. This is an excelisfun YouTube Channel Flashback Friday back to a video that I made in 2012.

View on YouTube

How to Insert a Row After Every Row in Excel (a really simple trick)

Posted on by Annie D

In this video, I will show you how to insert a row after every row in your dataset in Excel.

While you can do this easily in a small dataset, doing this manually with a huge dataset is not an option.

You can use a simple sorting technique to reshuffle the rows to make sure you get an empty row after every row in your existing dataset.

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