My very own list of news on Excel, gathered from various sources!
RefTreeAnalyser 2.0 has just been updated. I have added an option to display your formula as a mathematical equation.
Tue, 21 Jun 2016 14:55:00 GMT
|Updated: An MSForms (all VBA) treeview.|
Our All VBA treeview control now has a professional version which is ready for beta testing.
Thu, 16 Jun 2016 15:50:00 GMT
|Tref ons op de 10e Excel Experience Day!|
Vrijwel al onze Excel Experts zullen op de 10e Excel Experience DayÂ als spreker fungeren. Dus als u ons wilt ontmoeten (en -wellicht- spreken over toekomstige projecten), dan is dat een uitgelezen gelegenheid! Dus schrijf u nu in en tref ons 10 december in Burgers Zoo! Jan Karel Pieterse
Wed, 04 Nov 2015 16:47:27 +0000
An error has occured while trying to process http://www.dailydoseofexcel.com/feed/
Please contact web-master.
|June 2016 Power Query Update|
Yesterday, Microsoft released the June 2016 Power Query update.Â Even though there are only four items on the list of new features, some of them are quite impactful. Whatâ€™s new in the June 2016 Power Query Update The four new … Continue reading
Wed, 22 Jun 2016 16:57:47 +0000
An error has occured while trying to process http://xldennis.wordpress.com/feed
Please contact web-master.
|Copy Chart to New Sheet and Link to Data on New Sheet|
This is a quick post to answer thisÂ rather common question from the forums: I have a worksheet that has data in a particular arrangement and a chart that plots this data. I have another worksheet with the identical data arrangement. How can I copy the chart to the new worksheet and have the chart link […]
The post Copy Chart to New Sheet and Link to Data on New Sheet appeared first on Peltier Tech Blog.
Wed, 06 Jul 2016 13:00:28 +0000
|How to Show Excel Table Name on the Sheet|
If you have an Excel workbook with lots of tables and pivot tables, it can be hard to remember what theyâ€™re named, or what source data they're using. To help you keep track of them, AlexJ is sharing the User Defined Function (UDF) that he uses to help manage his files. With AlexJ's code in your file, just add a formula, click on a cell, and show Excel table name, or pivot table name, on the sheet.
The code is shown below, and there is also a link for downloading a sample file with the code installed in it. You
Continue reading How to Show Excel Table Name on the Sheet
Thu, 21 Jul 2016 04:01:00 +0000
|Office 365 news roundup|
Find out how you can learn more about Office 365, share best practices with others and keep up-to-date on everything you need to know about the service. We also catch you up on the recent news about Office 365.
Fri, 22 Jul 2016 20:25:42 +0000