My very own list of news on Excel, gathered from various sources!
|Update: Excel File Remediation Utility|
Our Excel File Remediation Utility has just been updated. I have added an option to remove all styles from the workbooks. This is very useful if you have Excel files with corrupt styles.
Thu, 23 Mar 2017 15:40:00 GMT
RefTreeAnalyser 2.0 has just been updated. Added jump to pivotsource when you trace precedents when in a pivottable.
Fri, 03 Mar 2017 13:00:00 GMT
An error has occured while trying to process http://excelexperts.nl/?feed=rss2
Please contact web-master.
I use a product called SQL Prompt from Redgate in SSMS. Honestly I can’t image life without it. They added a new feature to the grid right-click menu called Open in Excel. It’s very handy and definitely worth the trip over to my mouse. My only complaint about it is that it adds the resulting […]
Tue, 21 Mar 2017 13:28:33 +0000
|Calculate Start and End Dates|
I got an email from a reader this morning who asked how to calculate start and end dates for a given employee when they have had multiple terms of employment.Â Since it's been a while since we've had a technical … Continue reading
Tue, 14 Mar 2017 18:00:00 +0000
|Peltier Tech Charts for Excel â€“ Demo Version|
I’ve finally finished a demo version of Peltier Tech Charts for Excel 3.0. This trial version will allow potential users to try the software before they buy a license. In 2008 I launched my first commercial Excel add-in, Peltier Tech Waterfall Chart Utility. All it did was make waterfall charts. Over the years I made […]
Wed, 22 Mar 2017 13:00:29 +0000
|Excel Freeze All Worksheets Macro|
If you’re working with a large worksheet in Excel, it usually helps if you freeze the cells at the top and/or the left side of the sheet. That way, your headings are always visible,...
Thu, 23 Mar 2017 04:01:00 +0000
|Episode 123 on the Excel Bot with Jakob Nielsenâ€”Office 365 Developer Podcast|
In episode 123 of the Office 365 Developer Podcast, Richard diZerega and Andrew Coates talk to Jakob Nielsen about the Excel Bot.
The post Episode 123 on the Excel Bot with Jakob Nielsenâ€”Office 365 Developer Podcast appeared first on Office Blogs.
Thu, 23 Mar 2017 17:15:10 +0000