Tag: Productivity

Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula)

Posted on by Annie D

When you filter data, getting the SUM of only the visible part of the data can be a challenge. If you use SUM function for it, it will show you the SUM of the entire range (visible as well as hidden).

In such cases, when you want to get the sum of filtered data only (i.e., the cells that are visible), you can use the SUBTOTAL function. SUBTOTAL function can ignore hidden rows (either through filters or done manually) and can give you the following values:
— SUM
— AVERAGE
— COUNT
— COUNTA
— MAX
— MIN
— PRODUCT
— STDEV.P
— STDEV.S
— VAR.S
— VAR.P

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

Guide to the Acquisition Page in the Google Analytics Template App

Posted on by Annie D

I have released my first template app and is Free to download here: http://bit.ly/2othNWm

In this video, I will guide through the main functionality of the Acquisition’s Page. How to interact with the visuals and what insights you can gain from it.

Here is a blog post detailing everything you need to know about it: http://bit.ly/2omjzZ8

and here you have some video guides:
1. Here is how you install the app: https://www.youtube.com/watch?v=I2KAnMG3-r4
2. Guide to the User’s Page: https://www.youtube.com/watch?v=NCBqOZwOctI
3. Guide to the Acquisition Page: https://www.youtube.com/watch?v=fnhfR2IzZbA
4. Guide to the Content Page: https://www.youtube.com/watch?v=WsZvfzu4PPI
5. Guide to Site Speed Page: https://www.youtube.com/watch?v=9ztblbeqBZs
6. Guide to Site search page: https://www.youtube.com/watch?v=8okR8tEAxLk

Enjoy and dont forget to give me feedback here: http://bit.ly/2mWFZ2U

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

Guide to the User’s Page on Google Analytics Template App by Curbal

Posted on by Annie D

I have released my first template app and is Free to download here: http://bit.ly/2othNWm

In this video, I will guide through the main functionality of the User’s Page. How to interact with the visuals and what insights you can gain from it.

Here is a blog post detailing everything you need to know about it: http://bit.ly/2omjzZ8

and here you have some video guides:
1. Here is how you install the app: https://www.youtube.com/watch?v=I2KAnMG3-r4
2. Guide to the User’s Page: https://www.youtube.com/watch?v=NCBqOZwOctI
3. Guide to the Acquisition Page: https://www.youtube.com/watch?v=fnhfR2IzZbA
4. Guide to the Content Page: https://www.youtube.com/watch?v=WsZvfzu4PPI
5. Guide to Site Speed Page: https://www.youtube.com/watch?v=9ztblbeqBZs
6. Guide to Site search page: https://www.youtube.com/watch?v=8okR8tEAxLk

Enjoy and dont forget to give me feedback here: http://bit.ly/2mWFZ2U

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

Guide to the Site Search Page in the Google Analytics Template App

Posted on by Annie D

I have released my first template app and is Free to download here: http://bit.ly/2othNWm

In this video, I will guide through the main functionality of the Site Search Page. How to interact with the visuals and what insights you can gain from it.

Here is a blog post detailing everything you need to know about it: http://bit.ly/2omjzZ8

and here you have some video guides:
1. Here is how you install the app: https://www.youtube.com/watch?v=I2KAnMG3-r4
2. Guide to the User’s Page: https://www.youtube.com/watch?v=NCBqOZwOctI
3. Guide to the Acquisition Page: https://www.youtube.com/watch?v=fnhfR2IzZbA
4. Guide to the Content Page: https://www.youtube.com/watch?v=WsZvfzu4PPI
5. Guide to Site Speed Page: https://www.youtube.com/watch?v=9ztblbeqBZs
6. Guide to Site search page: https://www.youtube.com/watch?v=8okR8tEAxLk

Enjoy and dont forget to give me feedback here: http://bit.ly/2mWFZ2U

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

Actuals vs Budgets – Comparison Insights w/Power BI

Posted on by Annie D

In this tutorial, I run through how you can compare actuals to budgets in Power BI.

This is an extension of a prior tutorial that covers how to create the ultimate budget calculation with DAX.

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Excel Formula to Sum All Digits: Old School Dynamic Array Formula? Excel Magic Trick 1609

Posted on by Annie D

Download Excel File: https://ift.tt/2omI7l3
Learn how to sum the digits of a number. See 4 examples. See Method 1 that will work in all versions of Excel. See a method that works in Office 365. And See two methods that will work if you have decimals.

View on YouTube

DAX Fridays! #143: ADDCOLUMNS and SUMMARIZE | Create virtual tables

Posted on by Annie D

In todays video I will show you how to create virtual tables to make more advanced calculations using ADDCOLUMNS and 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 #dax #powerbi #mvp

View on YouTube

Dynamic Array & Old Array Formulas to Create Student Classes Report – Excel Magic Trick 1608

Posted on by Annie D

Download Excel File: https://ift.tt/2lWBWDr
Learn how to create a report that shows each student by quarter with a list of classes in a single cell. See many of the new Excel 365 Functions like: SORTBY, UNIQUE, FILTER, TEXTJOIN and the ROWS Function. See how we can combine Spilled Arrays formulas and Old School Arrays Formulas together to make a report that automatically updates when new data arrives.

View on YouTube

Calculate Total CRM Forecasts From Today Until End Of Month

Posted on by Annie D

In this video tutorial, I showcase how you can work out a dynamic monthly calculation.

This is perfect for a CRM scenario where you may want to dynamically calculate a monthly sales forecast for the remainder of the month.

In this example, we use the DATESBETWEEN function, which enables us to open up a dynamic date window.

Enjoy working through this one.

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

SPLIT NAMES in Excel | Separate First, Middle and Last Name

Posted on by Annie D

In this video, learn how to use different methods to Split names in Excel (i.e., separate first, middle and last name in Excel).

There are different ways you can manipulate text data in Excel. And one of the common things people do in Excel is to manage the names datasets.

Here are the methods covered in this video to split names into first and last names:
— Text to Columns
— Find and Replace
— Flash Fill
— Formulas

All these methods work great and are quick and easy.

With the first three methods, the result you get is static. This means that if your names data changes, then the resulting data wouldn’t change.

The last method in this video shows how to split names using formulas. With formulas, you get a result that is dynamic. This means that if you change the original dataset, the resulting data automatically updates.

Text to Columns method uses a delimiter to separate the first and last name. The delimited could be a space character or any other delimiter – such as a comma.

Find and Replace method uses wildcard characters to find and replace part of the name. For example, if you want to remove the last name and only keep the first name, you can do that with Find and Replace.

Flash Fill is one of the easiest methods to split names in Excel. All you have to do si type in a few cells and it automatically identifies a pattern and gives you the same result for all the cells. Note that Flash Fill is available only in Excel 2013 and later versions.

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

Time tracking solution ⏱ in Teams with PowerApps and Power BI

Posted on by Annie D

In this video I am going to show you how you can create a time track app in 20 minutes using MS Teams, Sharepoint, PowerApps and Power BI.
That is why the call it the power platform 😉
#curbal #powerapps #msteams #sharepoint

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

Calculating Dynamic % Of Total Changes – Power BI Analysis w/DAX

Posted on by Annie D

Recently on the EDNA support forum, a member was stuck on how to work out the differences around percent of total calculations year to year.

There’s a much simpler and dynamic way this can be done.

In this tutorial, I run through the techniques required to make this all work in Power BI.

It’s much simpler than you think.

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube