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

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.

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

The Excel VBA Masterclass
I have scheduled a new run of my Excel VBA Masterclass. Make sure you register now
Tue, 26 Nov 2019 12:45:00 GMT
New download: Excel Spreadsheet Model Template
To help in the battle towards better spreadsheets I have uploaded an Excel Spreadsheet Model Template.
Wed, 20 Nov 2019 09:05: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
Using Script Lab to Create a PivotTable with JavaScript

"Microsoft Excel is not a spreadsheet application anymore, it’s a medium to store, present, and analyze data." - Puneet Gogia The way Excel has evolved in the past few years, it’s almost impossible to work without it in this present … Continue reading

The post Using Script Lab to Create a PivotTable with JavaScript appeared first on The Excelguru Blog.


Fri, 15 Nov 2019 00:03:47 +0000

PTS Blog

By Jon Peltier
Geography and Maps in Excel

Excel has introduced Geography Rich Data Types and Filled Maps, making it easy to acquire, analyze, and visualize geographical information, as shown here.

The post Geography and Maps in Excel appeared first on Peltier Tech Blog.


Wed, 06 Nov 2019 15:00:25 +0000

Contextures Blog

By Debrah Dalgleish
Count Duplicate Number Sets in Excel

Written by Debra Dalgleish from Contextures Blog

Recently, someone asked me how to count duplicate number sets. There were hundreds of rows, with 6 numbers in each row. Did any of the number sets appear in the list more than once? How would you solve this problem, and count duplicate number sets? Count Duplicate Number Sets To find a solution, I set … Continue reading "Count Duplicate Number Sets in Excel"

Count Duplicate Number Sets in Excel is a post from Contextures Blog and is not allowed to be copied to other sites


Thu, 05 Dec 2019 05:01:00 +0000

Microsoft Excel blog on TechCommunity

By various Authors
Sheet View is generally available

Have you ever collaborated with someone else in a worksheet, looking at a large data set, and suddenly the table shrinks and you’re unable to finish your work? Often, this happens when someone adds filters to or sorts a column in a table of your worksheet. We love all the benefits of collaboration, but it does mean that when collaborating, everyone's changes are immediately seen in the document by you. We realize that our users want to collaborate in a document, but also accomplish their own tasks while sorting or filtering data in a table. 

 

Introducing Sheet View 

You spoke – we listened. Introducing Sheet View on Excel for the web, a new way of letting you create customized views in an Excel worksheet to sort and filter your data.  You can filter to display only the records that are important to you without being affected by others collaborating in the document. All your cell level edits propagate through the file regardless of your view, so you can make all of your in-cell edits in your Sheet View, too. 

 

Let’s see it in action: 

171609_FY20Q2_M365_APPS_Excel_Sheet_View_GIF_v05.gif

 

If you’re in the document with others, you’ll receive a prompt to enter a Sheet View if you want to sort and filter in a separate view. You can also create a new Sheet View by going to the View tab and clicking the eye icon labelled ‘New’.  

 

clipboard_image_0.png

 

Sheet Views are temporary initially, so once you’re done with your work, you can choose to save the view to reuse later or discard it. To discard, simply exit the Sheet View.  Views can be accessed again in the document at a later time once saved. All you need to do is click on the View tab and find the Sheet View you saved in the drop down list on the left side of the ribbon. 

 

Availability Notes 

We’ve started the rollout to users on Excel for the web and will be available to all Excel for the web users within the coming weeks. 

 

Learn More 

Sheet View in Excel for the web

Learn more about Sheet View 

 

To stay connected to Excel and its community, read the Excel blog posts and send us ideas and suggestions via UserVoice. You can also follow Excel on Facebook and Twitter.  Let us know your thoughts on Sheet View! 


Mon, Nov 25 2019 16:15:08 +0000