Tag: How to

Quickly Find and Select Cells with BOLD Text in Excel

Posted on by Annie D

In this video, I will show you how to find and select all the cells that have a bold text formatting applied to it.

You can do this easily using the Find and Replace dialog box. There is an option in the Find and Replace dialog box which allows you to select the formatting from a cell and then finds all the cells that have the same formatting.

You can use this to select the cell with bold font formatting and then find all the cells that have bold text.

Once you have selected these, you can easily highlight these, change the formatting, or delete the cells/rows.

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

One tip to work easier with JSON theme file in Power BI

Posted on by Annie D

Working with JSON files is not easy, at least not for me. In today’s video, I will show you one trick that will make it easier to work and discover JSON properties when creating Power BI theme files.

Get visual studio code:
https://ift.tt/2pHDJNP

Get the extension:
https://ift.tt/2MyGl9V
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

Automatically Open Specific Excel Files When you Start Excel

Posted on by Annie D

In this video, I will show you how to open specific Excel files when you start Excel.

You can specify a folder so that whenever you start Excel, it will automatically open all the files in that folder.

You can read more about this here: https://ift.tt/2MxbQkI

You can also modify the files in this folder, and Excel would automatically consider these files when you open Excel the next time. You can also add new files to this folder, and Excel would open these files when you start Excel the next time.

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

Excel Formula for Text Number Label with Lead Zeroes: 010-030, 030-050, 050-070 – EMT 1612

Posted on by Annie D

Download Excel File: https://ift.tt/31sTV30
Learn about how to create the labels: 010-030, 030-050, 050-070… Learn the Excel Traditional Formula and a Dynamic Array Formula.
Topics:
1. (00:01) Intro
2. (00:36) Traditional Formula to create labels across columns with the functions COLUMNS and TEXT.
3. (03:03) Dynamic Array Formula to spill labels using SEQUENCE and TEXT
4. (04:22) Summary
5. (04:42) Bonus Formula #1 to copy Traditional Formula down the rows, using ROWS and TEXT
6. (04:57) Bonus Formula #2 to spill label down the rows

View on YouTube

Compare Two Columns in Excel (for Matches & Differences)

Posted on by Annie D

In this video, I will show you six examples to compare two columns in Excel for matches and differences.

You can read more about this here: https://ift.tt/2BJshHp

The following examples are covered in this video:
— Compare two columns based on row values
— Compare and highlight values that are in both the columns (using conditional formatting)
— Compare and highlight values that are in one column and not in the other column
— Find names that are in column 1 and not in column 2 (using VLOOKUP)
— Pull matching data point
— Pull matching data point when there is a partial match

Based on your dataset, you may need to change or adjust the method. However, the basic principles would remain the same.

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 #ExcelTutorial

View on YouTube

How to Select Only the Visible Cells in Excel (SHORTCUT)

Posted on by Annie D

In this video, I will show you how to select only the visible cells in Excel.

This may be required when you have some hidden rows/columns in Excel. When you have some hidden rows/column and you copy a range with these hidden rows/columns, Excel automatically copies them as well.

And if you only want to copy the visible cells, you first need to select these visible cells and then copy it.

There is a really simple keyboard shortcut that I show in the video that you can use to select visible cells only.

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

DAX Fridays! #146: IGNORE, ROLLUPGROUP, ROLLUPADDISSUBTOTALS

Posted on by Annie D

Link to resources mentioned in the video:
Summarize : https://www.youtube.com/watch?v=-Ola264bKXk
Addcolumns+summarize : https://www.youtube.com/watch?v=hoIsIsa6b4M
Summarize + rollupgroup: https://www.youtube.com/watch?v=V0lLgLVL1xg
Summarizecolumns: https://www.youtube.com/watch?v=IdMsKbHfyn4

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

MSPTDA 33: Data Modeling for Slowly Changing Dimensions with Power Query & PivotTable

Posted on by Annie D

Download Start Excel file: https://ift.tt/2qg0tF1
Download Finished Excel file: https://ift.tt/2W0DmKJ
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 how to use Power Query to transform the Dimension Table and Fact Table so that we can show Total Sales by Team and Employee using a Standard PivotTable. Learn how to create automatic steps in Power Query and Custom M Code.
Topics:
1. (00:08) Introduction to Data Setup and Goal of Power Query Data Modeling
2. (01:44) Power Query Transformation for Dimension Table, including UnPivot Other Columns.
3. (03:30) Power Query M Code Formula to pull Team Key into Fact Table based on three conditions / criteria. See the functions Table.AddColumn and Table.SelectRows, and how to Define a Variable for a Custom Function. The Formula does a Three Way Lookup in Power Query.
4. (11:09) Build Standard PivotTable Report, including Loading Power Query Output directly to a Standard PivotTable.
5. (11:57) Summary

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

View on YouTube

3 Simple Ways to TRANSPOSE Data in Excel [with & without Formula]

Posted on by Annie D

In this video, I will show you a couple of ways to transpose data in Excel.

The following methods of transposing data are covered in this video:
— Transpose using Paste Special
— Using the TRANSPOSE function
— Transpose using Find and Replace and Paste Special

When you use Paste Special to transpose the data, it will give you the static result. This means that when you change the original dataset, it will not update the resulting transposed data.

If you want to have the transposed data linked, you need to use the Transpose function or the Find and Replace technique I cover in the video.

One issue that I don’t like about the TRANSPOSE function is that you need to select the range which is of the same size as the expected result.

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 – Advanced Analytics w/Power BI

Posted on by Annie D

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

When is it?
October 16th, 4pm New York (EDT), 1pm Los Angeles (PDT), 9pm London (BST)
October 17th, 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:

– Use DAX to create valuables insights
– Learn how to think creatively about what you can analyze
– Bring your analysis and visualization techniques together
– Create compelling reports and dashboard that add value

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

View on YouTube

AI services in Power BI and Excel: one click insights!

Posted on by Annie D

Yes, with a click from a button, you can get your data analyzed both in Excel and Power BI. This is the beginning of how this industry will look in a near future. Prepare for it!
#powerbi #AI #excel #curbal

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

View on YouTube

📷 Excel CAMERA Tool – Create Linked Images that update automatically

Posted on by Annie D

In this video, I will show you the camera tool in Excel, which you can use to create dynamically linked images that update when you change the original data.

You can read more about it here: https://ift.tt/2s4spII

Camera tool is not available by default in Excel, so you need to add it first in the Quick Access Toolbar. Once you have added it, you can create a linked image with a single click.

All you need to do is select the range of cells for which you want to create the image and then click on the camera tool icon in the QAT.

You can place the image on the same sheet or in any other sheet of the workbook.

In case you need to take a snapshot of a chart and create a linked picture, you need to select all the cells around it (in such a way that the chart is within the range of cells.

Once done, simply click on the camera tool icon and it will create a linked picture of the chart.

This tool can be really useful when you want to create a dashboard. You can use these images to quickly take a snapshot and create the dashboard.

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