My very own list of news on Excel, gathered from various sources!
|The Amsterdam Excel Summit 2015: Great content!|
Extended early bird discount on our Amsterdam Excel Summit! Last week our mail server experienced some problems, which meant that the registration form did not work. To compensate for anny inconvenience caused by this problem we have decided to extend the early bird discount period with an additional week. So register before March 1st 2015 and receive the 50 Euro discount!
Mon, 23 Feb 2015 14:40:00 GMT
|Updated article: Working with Circular references in Excel|
In my Circular Reference article I promised to include an example of a VBA driven circular reference calculation. I have done that today so head over to my site to check it out!
Wed, 11 Feb 2015 09:30:00 GMT
|The Amsterdam Excel Summit 2015|
Hallo! Na het enorme succes van vorig jaar, hebben we besloten opnieuw dit unieke evenement te organiseren: The Amsterdam Excel Summit Excel Experts Van Wereldklasse Een absoluut unieke groep Excel MVPâ€™s zal in april 2015 in Amsterdam zijn om hun geweldige Excel kennis met u te delen.Â Deze MVPâ€™s zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd om deze mensen voor ons evenement te boeken! Hoor het direct van de makers van Excel Iemand van het BI team van Microsoft zal tijdens dit evenement presentaties verzorgen, dus als je wilt weten welke kant het op gaat bij Microsoft Excel, zorg dan dat je erbij bent! Programma We hebben … Continue reading
Mon, 26 Jan 2015 16:28:42 +0000
An error has occured while trying to process http://www.dailydoseofexcel.com/feed/
Please contact web-master.
|Combine Multiple Excel Workbooks in Power Query|
I got a comment on a previous post today, which made me realize Iâ€™d promised this but never posted it.Â So letâ€™s look at how to combine multiple workbooks together in Power Query, providing they have the same format.Â Yes, … Continue reading
Wed, 25 Feb 2015 14:00:00 +0000
An error has occured while trying to process http://xldennis.wordpress.com/feed
Please contact web-master.
|Select Data to Display in an Excel Chart With Option Buttons|
The Problem A member of the MrExcel forum wanted to know aboutÂ using form controls to select columns from a data table to populate a graph. Essentially he wanted his users to be able to choose between two charts, one comparing their scoresÂ to district and regional scores, the other comparing their scores to the top 20%. […]
The post Select Data to Display in an Excel Chart With Option Buttons appeared first on Peltier Tech Blog.
Tue, 17 Feb 2015 08:00:28 +0000
|Resize Excel Comments With Macro|
Occasionally, for reasons unknown to anyone other than the centuries-old trolls who live in underground tunnels at Microsoft, Excel comments resize themselves. They get really wide, or narrow, and become almost impossible to read.
To fix this problem, there is a macro on my website, written 13 years ago by Dave Peterson, which resizes comments in a selected range. It changes each comment to AutoSize, and calculates the area of the AutoSized comment. Then, it sets a specific width, and calculates the height, from the area and the width.
Recently, someone asked if there was a better way
Continue reading Resize Excel Comments With Macro
Thu, 26 Feb 2015 05:02:00 +0000
|Catching a comet with Excel Power Map|
The recent news that the Rosetta spacecraft made the closest approach ever to the Comet 67P inspired the Power Map team to plot the trajectory of Earth, Mars, Comet 67P and Rosettaâ€”by visualizing their paths through time.
Thu, 26 Feb 2015 17:00:25 +0000