Month: May 2019


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Microsoft Excel 2016 Tutorial For Beginners Part 2 Full Intro Learn How to Use Excel 2016

Posted on by Annie D

Microsoft Excel 2016 Tutorial For Beginners Part 2 Full Intro Learn How to Use Excel 2016

This is a Microsoft Excel 2016 Full Tutorial for beginners & intermediate users.In this crash course Excel video tutorial you will learn how to use Excel 2016 formulas and functions, Excel 2016 new features, Excel 2016 Charts along with many other necessary features that you must know how to use when using Excel 2016.
Excel Charts Tutorial
How to Excel charts
Formatting Excel Chart
Chart Styles in Excel 2016
Microsoft Excel 2016 Tables Tutorial
Excel tables tutorial
how to Excel Tables
Excel Tables for beginners
How to insert pictures in Excel
How to insert word art in Excel
Insert shapes in Excel

http://bit.ly/2f0EiJ7
hjttp://roofstampa.com
http:/www.subjectmoney.com
http://bit.ly/1jhTIZH


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

DAX Fridays! #4: COUNT, COUNTA, COUNTX, COUNTAX, DISTINCTCOUNT AND COUNTROWS in DAX

Posted on by Annie D

Let’s go through all the count expressions available in DAX!

Here you have the keynotes for the video so you can jump to the function you want to learn:

02:44 COUNT text (#ERROR)
03:24 COUNT numbers
04:20 COUNT blanks
04:56 COUNT dates
05:36 COUNTA text
06:44 COUNTA numbers
07:27 COUNTX
09:16 COUNTAX
09:58 DISTINCTCOUNT
10:59 COUNTROWS(DISTINCT)
12:06 COUNTBLANK
12:34 COUNTROWS
13:32 COUNTROWS with columns (#ERROR)
14:33 COUNTROWS with an expression

Link to Curbal Glossary: http://bit.ly/2JbxKt8

PREVIOUS VIDEO: https://www.youtube.com/watch?v=vcYz0XPklXg
NEXT VIDEO: https://www.youtube.com/watch?v=-oDpOfhgmzA

Dowload the sample file here:
http://bit.ly/2Jv3RDN

Looking for a download file? Go to our Download Center: http://bit.ly/2PUURaz

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

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://bit.ly/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:

http://bit.ly/2V3o0Ux

Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲

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

#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP

View on YouTube


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Cross Selling Matrix Deep Dive – Power BI & DAX Tutorial

Posted on by Annie D

In this tutorial we cover how to create a cross selling matrix.

This requires a full understanding of the concept of ‘context’ and much more.

Some advanced DAX formulas are covered in detail, especially table functions.

Plenty of great techniques to learn about during this one.

Enjoy!

Sam

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

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Microsoft Excel 2016 Tutorial For Beginners Part 2 Full Intro Learn How to Use Excel 2016

Posted on by Annie D

This is a Microsoft Excel 2016 Full Tutorial for beginners & intermediate users.In this crash course Excel video tutorial you will learn how to use Excel 2016 formulas and functions, Excel 2016 new features, Excel 2016 Charts along with many other necessary features that you must know how to use when using Excel 2016.
Excel Charts Tutorial
How to Excel charts
Formatting Excel Chart
Chart Styles in Excel 2016
Microsoft Excel 2016 Tables Tutorial
Excel tables tutorial
how to Excel Tables
Excel Tables for beginners
How to insert pictures in Excel
How to insert word art in Excel
Insert shapes in Excel

http://bit.ly/2f0EiJ7
hjttp://roofstampa.com
http:/www.subjectmoney.com
http://bit.ly/1jhTIZH

View on YouTube


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Understanding The CALCULATE Function – Ultimate Beginners Guide to DAX

Posted on by Annie D

Understanding The CALCULATE Function – (1.12) Ultimate Beginners Guide to DAX

DOWNLOAD RESOURCES HERE – http://bit.ly/2vOtYxm
START FROM THE BEGINNING – https://www.youtube.com/playlist?list=PL1myWUzvmmDGmLfty3BDluz8nzme1dZxg

Follow along to the beginners guide DAX tutorials by using the demo data available for download. Enjoy!

Details of what you will learn during this course
Learn – what DAX is and why you need to learn it when using Power BI
Learn – the basics of DAX calculations
Understand – formula syntax, writing comments & variables
Review – how the data model and DAX calculations work together
Learn – what the most important concept of DAX is – CONTEXT
Understand – what the CALCULATE statement does
Learn – what table functions are and when to use them
Review – time intelligence functions
Understand – how important learning DAX well is when using Power BI

Here are the specifics for the course
Learn how to;
Use DAX formula with Power BI
When and where to use DAX functions
Utilise some of the great features built into the DAX formula bar
Use the data model in combination with DAX formula
Understand the concept of CONTEXT
Use the CALCULATE statement
Create filters using table functions
Incorporate time intelligence functions in your analysis
Become a DAX master by combining patterns of DAX formula

DESCRIPTION
Here I work through how important the CALCULATE function is to any advanced analysis in Power BI.

If you want to complete great work in Power BI then using CALCULATE and understand what is does is essential

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

All Enterprise DNA TV Resources – http://bit.ly/2vUxOVv

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Power BI Tutorial | Intro to Power BI & DAX | Development Power BI Training 2019 from Enterprise DNA

Posted on by Annie D

Power BI Tutorial | Intro to Power BI & DAX | Development Power BI Training 2019 from Enterprise DNA

FOLLOW ALONG WITH RESOURCE DOWNLOAD – http://bit.ly/2PUaZdW

This end to end demo of how to develop compelling Power BI reports has been taken from part of a comprehensive course module from Enterprise DNA Online – Dashboarding & Data Visualization Intensive

You may be a beginner Power BI user or intermediate Power BI & DAX users. If so, you will learn a significant amount from this training and tutorial made available from Enterprise DNA.

You will learn end to end development techniques for Power BI. To download the resources click on the link above and follow through with the example.

This training is perfect if you need;
Power BI beginner training
Beginner DAX training
Learning Power BI visualization techniques
Learning advanced DAX techniques

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

All Enterprise DNA TV Resources – http://bit.ly/2vUxOVv

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

[FREE EXCEL COURSE] Lesson 16 – 10 Advanced Examples Formula Examples

Posted on by Annie D

There a lot of awesome stuff you can do with a combination of formulas in Excel.

In this video, I will show you some advanced formula examples that involve using one or more than functions.

I cover the following topics this video:

— Compare Lists, Get Unique List
— Get the Closest Match
— Get Last Value in the List
— Find the Last Occurrence of an Item in a List
— 2 Way and 3 Way Lookup using Index/Match
— Count the Number of Words
— Extract Username from Email Id
— Find the First Monday of the Month
— Extract Data using Drop Down List

This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

TrumpExcel.com | Online Excel Tips & Tutorials (with videos)


-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

[FREE EXCEL COURSE] Lesson 15 – Date & Time Formulas in Excel

Posted on by Annie D

In this video of this online Excel Training, you will learn about the following DATE and TIME formulas:

— DAY function
— HOUR function
— MINUTE function
— DATE function
— DATEVALUE function
— TODAY function
— NOW function
— WEEKDAY function
— NETWROKDAYS function
— NETWORKDAYS.INTL function
— WORKDAY function
— WORKDAY.INTL function

This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

TrumpExcel.com | Online Excel Tips & Tutorials (with videos)


-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

[FREE Excel Course] Lesson 14 – Text Formulas in Excel

Posted on by Annie D

In this video of this Free Excel Training, you will learn about the following TEXT formulas:

— LEFT function
— RIGHT function
— MID function
— LEN function
— LOWER function
— PROPER function
— UPPER function
— FIND function
— -REPLACE function
— SUBSTITUTE function
— TEXT function

This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

TrumpExcel.com | Online Excel Tips & Tutorials (with videos)


-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

[FREE Excel Course] Lesson 13 – Stats Formulas in Excel

Posted on by Annie D

In this video of this Free Excel Training, you will learn about the following STAT formulas:

— AVERAGE function
— AVERAGEIF function
— AVERAGEIFS function
— COUNT function
— COUNTA function
— COUNTBLANK function
— COUNTIF function
— COUNTIFS function
— LARGE function
— SMALL function
— RANK function
— MAX function
— MIN function

This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

TrumpExcel.com | Online Excel Tips & Tutorials (with videos)


-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

[FREE Excel Course] Lesson 12 – Lookup and Reference Formulas in Excel

Posted on by Annie D

If you want to get good with Excel, Lookup and Reference formulas are something you must learn about. You don’t need to know each and every formula, but a basic understanding of these will help you a lot.

In this video, you will learn about the following LOOKUP and REFERENCE formulas:

— VLOOKUP function
— HLOOKUP function
— INDEX function
— MATCH function
— OFFSET function
— INDIRECT function
— ROW function
— ROWS function
— COLUMN function
— COLUMNS function

This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

TrumpExcel.com | Online Excel Tips & Tutorials (with videos)


-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

[FREE Excel Course] Lesson 11 – Math Formulas in Excel

Posted on by Annie D

In this video of this Free Excel Training, you will learn about the MATH formulas

— INT function
— MOD function
— RAND function
— RANDBETWEEN function
– ROUND function
— SUM function
— SUMIF function
— SUMIFS function
— SUMPRODUCT function

This video is a part of my Free Excel course where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

TrumpExcel.com | Online Excel Tips & Tutorials (with videos)


-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube