- 3D Map
**1** - Array Functions
**6** - Calendar
**1** - Cell Format
**3** - Charts
**5** - Conditional Formatting
**3** - Conferences
**4** - CSV
**1** - Data Types in Excel
**2** - Data Validation
**4** - Dynamic Arrays
**1** - Dynamic Ranges
**4** - Excel
**1** - Excel 365
**4** - Excel Facts
**21** - Excel Functions
**35** - Excel Shortcuts
**5** - Excel Tools
**19** - Lists in Power Query
**3** - M
**10** - Pivot Table
**9** - Power BI
**20** - Power BI Designer
**2** - Power BI Desktop
**6** - Power Map
**1** - Power Query
**20** - PowerPivot
**6** - Uncategorized
**1** - VBA
**8** - Xcessories
**1**

Amsterdam Excel Summit
Array functions
BI
Cell Format
Charts
CHOOSE function
Conditional Formatting
Custom Cell Format
Data Validation
Dates
Dynamic Ranges
Excel
excel facts
Excel Functions
Excel Shortcuts
Excel Unplugged
F5
Fill and Series in Excel
Get Data From Folder
Go To
Go To Special
INDIRECT function
LARGE function
Lists
M
Microsoft Excel
MID function
M Language
MOD function
Month Function
MS Excel
MVP
New Data Types in Excel
Office 2016
Pivot Table
Pivot vs PowerPivot
Power BI
Power BI Desktop
PowerPivot
Power Query
ROW function
Shortcut
TODAY function
VBA
Vlookup

%d bloggers like this:

Reblogged this on SutoCom Solutions.

Your article is really good to read. Amazing!!

Thanks for sharing, could I post it on my Facebook to share with my friends?

Thanks for the compliments. You can, the link is at the bottom of the article… Just click the Facebook button.

Howdy! I just wish to give you a huge thumbs up for the excellent info you have here on this post.

I’ll be coming back to your blog for more soon.

Hello, I enjoy reading through your article.

I wanted to write a little comment to support you.

This article is in fact a good one it helps new net visitors, who are wishing in favor of blogging.

Very good information. Lucky me I ran across your site by chance (stumbleupon).

I’ve book marked it for later!

This paragraph will assist the internet viewers for creating new blog or even a

weblog from start to end.

Spot on with this write-up, I actually think this website needs

a great deal more attention. I’ll probably be back again to see more, thanks for the advice!

Please let me know if you’re looking for a article writer for your

blog. You have some really great articles and I believe I would be a

good asset. If you ever want to take some of the load off,

I’d love to write some articles for your blog in exchange for a link back to mine.

Please send me an email if interested. Cheers!

Hi,

as a matter of fact, I would give great praise if you were to contribute to Excel Unplugged and if approved you can link to your blog as much as you like but overall there would be some conditions.

– As I don’t know you and your writing style, in the beginning your contributions would have to be approved by me (just until the trust is established).

– since the blog is

ExcelUnplugged all contributions would have to beExcelrelated and at least intermediate by level.– If this sounds good to you and to anyone else, you can reach me through the contact portion on my blog. You can also give your blog in the website field, so I can check it out…

I do not know whether it’s just me or if everyone else experiencing problems with your site.

It appears like some of the written text in your posts are running off

the screen. Can someone else please comment and let me

know if this is happening to them as well? This might be a issue with my web browser because I’ve had this happen before.

Thank you

Since this is the first mention of overflow on this site, the conclusion has to be that it’s a problem with your browser. Try a different browser and let me know if it still doesn’t work.

Thanks in favor of sharing such a pleasant opinion, post is pleasant, thats

why i have read it completely

I must thank you for the efforts you have put in writing this

website. I’m hoping to see the same high-grade content by you in the future as well.

In truth, your creative writing abilities has inspired me to get my own site now 😉

hello there and thank you for your info – I’ve certainly picked up anything new from right

here. I did however expertise some technical points using this web

site, as I experienced to reload the web site lots of times previous to I could get it to load properly.

I had been wondering if your hosting is OK? Not that I am complaining,

but sluggish loading instances times will very frequently affect your placement in google and could damage your

quality score if ads and marketing with Adwords.

Anyway I am adding this RSS to my e-mail and can look out

for a lot more of your respective interesting content.

Ensure that you update this again very soon.

We stumbled over here coming from a different web address and thought I should check things out.

I like what I see so now i’m following you. Look forward to going over your web page for a second time.

Hello there, You have done an excellent job.

I will certainly digg it and personally recommend to my friends.

I’m confident they will be benefited from this website.

After going over a handful of the articles on your blog, I really like your technique of writing a blog.

I book marked it to my bookmark site list and will be checking back in the near future.

Please check out my web site too and let me know what you think.

Pretty! This was a really wonderful article. Many thanks

for providing this info.

Thanks in support of sharing such a good idea, article is nice, thats why

i have read it fully

Very good written post. It will be beneficial to anyone who

usess it, as well as me. Keep up the good work – looking

forward to more posts.

Thanks Gasper. You have saved my day.

Hi Gasper,

Thanks for the tips and tricks!

With respect to this article I have one additional question. What if I want to work with multiple years. How can I make sure that the value for January 2016 come after December 2015 and is not added to January 2015. I want to look 12 months back but with a dataset which contains multiple years I end up with a chart where January from one year is added up to the January of a previous year.

I hope you have a solution for this.

Thanks in advance

Hi Manfred,

your best option would be to create a calculated field YYYYMM so 201609 that would relate to September 2016… Or any other format you like, but it has to include month and year information.

There are some days I need that answer. Thanks so much!