The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,318 other followers

Archive for the ‘Office’ Category

How to count the number of days / workdays / weekends between two dates in Excel?

Posted by jpluimers on 2021/03/09

For my link archive as the Excel functions WORKDAY [WayBack] and NETWORKDAYS [WayBack] helped me finding the working days in a month a while ago: [WayBack] How to count the number of days / workdays / weekends between two dates in Excel?.

Note:

–jeroen

Posted in Development, Excel, Office, Power User, Software Development | Leave a Comment »

Office 2013 Proofing tools downloads

Posted by jpluimers on 2021/03/05

For my link archive:

Via:

Posted in Office, Office 2013, Power User, Word | Leave a Comment »

Word Shortcuts links

Posted by jpluimers on 2021/02/12

I was trying to get the love of my life from using a mouse into keyboard shortcuts.

They come natural to me as I learned them step by step from Word for Windows 1.0 until now as I have been a keyboard person since the early 1990s.

But she has been a mouse person all her life, struggling to become faster using word. The mouse became a hindrance, especially since so much has moved around to deeper levels in the Word user interface over time.

This is what I came up with after doing a few searches on-line:

I was amazed at how scattered out and incomplete the information in these links is.

–jeroen

Posted in Office, Power User, Word | Leave a Comment »

How to quickly add hours/minutes/second to date and time in Excel?

Posted by jpluimers on 2020/11/11

Excel date times are almost identical to OLE/COM automation date times (that used in many Windows applications).

Which means that dates are 1 unit apart, and:

  • Weeks = 7
  • Days = 1
  • Hours = 1/24
  • Minutes = 1/(24*60) or 1/1440
  • Seconds = 1/(24*60*60) or 1/86400

That way you can easily add one hour to a date/time value by adding 1/24.

Source: How to quickly add hours/minutes/second to date and time in Excel?

Related:

–jeroen

Posted in Development, Excel, LifeHacker, Office, Power User, Software Development | Leave a Comment »

Add or edit words in a spell check dictionary – Office Support

Posted by jpluimers on 2020/06/26

[WayBack] Add or edit words in a spell check dictionary – Office Support:

By default, the words are stored in a text file called “RoamingCustom.Dic” – Google Search.

You can get there from the menu:

  1. Menu “File”, “Options”, then “Proofing”
  2. In the dialog, click on “Edit Word List…”

–jeroen

 

Posted in Office, Power User | Leave a Comment »

 
<span>%d</span> bloggers like this: