Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Headlines

Excel Headlines

My very own list of news on Excel, gathered from various sources!

This site

Update: Name Manager
Name Manager has just been updated to build 669. When a name is renamed, PowerQuery M code will be checked for existence of the name and updated accordingly
Fri, 21 Feb 2020 13:40:00 GMT
Webinar recording: Working with tables in Microsoft Excel
Ever used Format as Table in Microsoft Excel? Did you know Format as Table can be a whole lot more than just fancy formating? Join Jan Karel Pieterse as he discusses working with tables and how they can help you in your everyday work with Excel.
Fri, 31 Jan 2020 10: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)
International Keyboard Shortcut Day 2019
The first Wednesday of every November is International Keyboard Shortcut Day. This Wednesday, people from all over the world will become far less efficient for a short time in an effort to be far more efficient the rest of the year. “WASD V2 88-Key ISO Custom” by Bitboxer is licensed under CC BY-NC-SA 2.0 This […]
Mon, 04 Nov 2019 14:12:45 +0000

The Ken Puls Blog

By Ken Puls
Unfill in Power Query

Recently I received a question on how to Unfill in Power Query.  In other words, we want the opposite of the Fill feature, which fills data into blank cells (cells that contain a null value.)  If we see repeating values, … Continue reading

The post Unfill in Power Query appeared first on The Excelguru Blog.


Mon, 13 Jan 2020 20:22:35 +0000

PTS Blog

By Jon Peltier
Assign Chart Series Names or Categories with VBA

This tutorial shows VBA code to find ranges or allow a user to select ranges that have series names or category labels and apply them to the active chart.

The post Assign Chart Series Names or Categories with VBA appeared first on Peltier Tech Blog.


Wed, 12 Feb 2020 19:50:03 +0000

Contextures Blog

By Debrah Dalgleish
Excel Drop Downs from Dynamic Arrays

Written by Debra Dalgleish from Contextures Blog

Select a region name in one Excel drop down list. Then, in the next drop down list, select from a list of employees who work in that region. You've seen this dependent drop down trick before, but watch my latest video below, to see a new twist on this technique. Dependent Drop Downs For a … Continue reading "Excel Drop Downs from Dynamic Arrays"

Excel Drop Downs from Dynamic Arrays is a post from Contextures Blog and is not allowed to be copied to other sites


Thu, 20 Feb 2020 05:02:00 +0000

Microsoft Excel blog on TechCommunity

By various Authors
Using Excel Survey

Do you find Excel easy to use and learnWe want to make your experience in Excel even better. 

 

SurveyCapturev1.JPG

 

Please take this short survey to help us make improvements:

aka.ms/Using-Excel-Survey  


Wed, Feb 12 2020 14:24:52 +0000