Subscribe
in a readerExcel Headlines
My very own list of news on Excel, gathered from various sources!
This site
| A new tool: Compare Two Tables I've added a new tool (in beta!!) to my download section called Compare2Tables. Mon, 25 Feb 2019 17:00:00 GMT |
| Update: Name Manager Name Manager has just been updated to build 666. Name Manager will now recognize names starting with _xlfn as Excel system names. Tue, 22 Jan 2019 13:50:00 GMT |
Excel Experts Nederland
Excel Expert Nederland Blog| Nieuw: ons Excel Forum Wij kregen tamelijk veel Excel gerelateerde vragen in onze commentaren. Om deze vragen beter te kunnen kanaliseren zijn we daarom een Excel forum gestart. Heb je een vraag? Word lid van ons forum en stel hem hier: Excel Experts Nederland Forum Mon, 30 Jan 2017 16:38:13 +0000 |
Daily Dose Of Excel
By Dick Kusleika (et al)| Keyboard Metrics III In the grand tradition of Keyboard Shortcut Metrics and More Keyboard Metrics, here’s this: Procedure 2016 2017 2018 Grand Total MakeComma 20.54% 18.67% 19.01% 19.19% WrapSheetsDown 13.80% 17.15% 9.93% 14.93% WrapSheetsUp 8.60% 15.36% 7.33% 12.16% FillVirtualScreen 10.50% 11.04% 8.42% 10.40% CopyPasteValues 14.00% 4.84% 2.20% 6.54% ShowFormatting 5.85% 5.13% 7.04% 5.68% IncrementDate 4.25% 4.08% 9.77% 5.23% […] Mon, 12 Nov 2018 13:00:34 +0000 |
The Ken Puls Blog
By Ken Puls| Using Rich Data Types in Power Query If you’re on Office 365 and don’t have Excel’s new Rich Data Types, you should know that they’ll be coming to you soon. Giving us the ability to create both Stocks and Geographies, these are going to add some exciting … Continue reading The post Using Rich Data Types in Power Query appeared first on The Excelguru Blog. Wed, 20 Mar 2019 17:05:34 +0000 |
PTS Blog
By Jon Peltier| Surplus-Deficit Area Chart This Surplus-Deficit chart shows the history of surpluses and deficits (positive and negative values) over the past few years. The two colors help show when the deviation was positive and when it was negative. It takes a little bit of Excel magic to get that effect to work properly in an Excel area chart. I […] The post Surplus-Deficit Area Chart appeared first on Peltier Tech Blog. Mon, 18 Mar 2019 15:00:43 +0000 |
Contextures Blog
By Debrah Dalgleish| Get Data from Excel Button Clicks Here's a simple example that shows how you can get data from Excel button clicks. There are 3 buttons on one sheet, and if you click one, the date and time are recorded on another sheet, along with your name and the button number. Sheet with Buttons This example could be used during a short … Continue reading "Get Data from Excel Button Clicks" Thu, 21 Mar 2019 04:01:00 +0000 |
Microsoft Excel on MSDN
By various Authors An error has occured while trying to process http://blogs.office.com/b/microsoft-excel/rss.aspx
Please contact web-master.