Post has attachment
YES ! We are now on #YOUTUBE
SUBSCRIBE TO OUR CHANNEL
Go to YOUTUBE.COM and Search “Excel Basement” OR https://www.youtube.com/channel/UCdVcnD4OFsfgcSB5Hrz3cgA
10 Videos uploaded (Feb-2017)
Photo

Post has attachment
Hi Guys, I have created a course for those who want to make a shift into their career by transitioning from MS Excel to QlikView.


Also it is recommended for those who want to begin learning QlikView.


Watch the promo video (first lecture) to understand the learning objective of this course.


Hope to see you there!


https://lnkd.in/fTJ7JPt

Post has attachment
Pasting in #Excel is an every day task right! But how much do you really know about the paste options in Excel?

In this weeks Video we will look at Excels Paste Special. Its a short video, only 4 minutes. Have a watch and then comment on how many of these options are new to you.

I am not normally a betting person but I have a bet on that the majority of people will learn something new from this video. So I hope you won't let me down and post a comment so I can win my bet.

Post has attachment

Post has attachment
Sometimes the simple things in Excel are overlooked. Like setting a workbook up for the correct print setting before you distribute it. This is something I have found to be overlooked a lot and it really gets under my skin.

In this weeks Video we will look at Excel Page Layout and print setup options. It's the perfect video to watch to refresh your knowledge and if you are more of an Excel newbie then you really need to know this stuff.

Post has attachment
Sometimes the simple things in Excel are overlooked. Like setting a workbook up for the correct print setting before you distribute it. This is something I have found to be overlooked a lot and it really gets under my skin.

In this weeks Video we will look at Excel Page Layout and print setup options. It's the perfect video to watch to refresh your knowledge and if you are more of an Excel newbie then you really need to know this stuff.

Post has attachment
There is a function in Excel know as SUMProduct. What this function will do is take a column and multiply it by another column and the add all the value to get a total.

In Power Pivot and Power BI there is a DAX function very similar, but more powerful. This function is know as SUMX. In this weeks DAX video, we will look at both the SUM function and the SUMX function.

You might already know these functions, but you just know that they work. If you really want to master DAX, I would suggest that you have a look at the video anyway as you may learn a little about how these functions actually work



Post has attachment
20% Discount ! Feb 14th till Feb 23rd 2017 #Excel
Next generations Dashboards with POWER BI (Business Intelligence)
<< Online Course Available Now >> #MyOnlineTrainingHub
Link: https://goo.gl/N0jkP8

This is a must learn skill ! Don't miss this course
In Demand Course #PowerBI #Excel #Dashboards

Post has attachment

Post has attachment
A tutorial on how to insert checkboxes in Excel. These checkboxes can be used to create to-do lists, interactive charts and dashboards.
Wait while more posts are being loaded