Archive for the ‘GoogleDocs’ Category
Posted by jpluimers on 2026/04/14
I have been using Microsoft Excel since it beat the Quattro Pro limitation of rows and columns with the version 12.0, on Windows more commonly named Excel 2007 (which also introduced a fully new user experience including the vertical screen estate eating Ribbon – the main reason I like 16:10 monitors over 16:9 ones) and on Mac as Excel 2008.
It means I have like 20 years of Excel experience not just on what it can technically can do (see my Excel posts) but especially on the user experience bit.
Read the rest of this entry »
Posted in Development, Excel, Google, GoogleDocs, GoogleSheets, Office, Office 2007, Power User, Software Development, User Experience (ux) | Tagged: div | Leave a Comment »
Posted by jpluimers on 2025/11/04
Posted in *nix, *nix-tools, Cloud, CSS, Development, Google, GoogleDocs, HTML, HTML5, Infrastructure, JavaScript/ECMAScript, Monitoring, Power User, Scripting, Software Development, TypeScript, Web Development | Leave a Comment »
Posted by jpluimers on 2021/11/09
Posted in Development, Excel, Google, GoogleDocs, GoogleSheets, Office, Office Automation, Office VBA, Power User, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2021/08/02
This was way easier than I thought it would be; it’s just that the meny items are different from Excel: [WayBack] Create & use pivot tables – Computer – Docs Editors Help.
The page has much more, but these are the initial steps:
Add or edit pivot tables
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells with source data you want to use. Important: Each column needs a header.
- In the menu at the top, click Data
Pivot table. Click the pivot table sheet, if it’s not already open.
- In the side panel, next to “Rows” or “Columns,” click Add, then choose a value.
- Note: Sometimes, you’ll see recommended pivot tables based on the data you choose. To add a pivot table, under “Suggested,” choose a pivot table.
- In the side panel, next to “Values,” click Add, then choose the value you want to see over your rows or columns.
- You can change how your data is listed, sorted, summarized, or filtered. Next to what you want to change, click the Down Arrow
.
–jeroen
Read the rest of this entry »
Posted in Google, GoogleDocs, GoogleSheets, Power User | Leave a Comment »
Posted by jpluimers on 2015/11/30
All Google URLs you will ever need in one handy place: How To Work with Google Reference List I. by Dennis Labelle.
–jeroen
Posted in G+: GooglePlus, GMail, Google, Google Analytics, Google Apps, GoogleAuthenticator, GoogleBookmarks, GoogleCalendar, GoogleContacts, GoogleDocs, GoogleDrive, GoogleFlights, GoogleGroups, GoogleHangouts, GoogleMaps, GoogleReader, GoogleSearch, GoogleTranslate, GoogleVoice, Hangouts, Power User, SocialMedia | Leave a Comment »
Posted by jpluimers on 2014/11/10
Wishing an online collaboration tool that supports Markdown, especially since tools like GitHub have native support, and because of the textual nature of the file format, it plays well with version control systems. Until that, I’ll try to use editors on Mac, Windows and my blog, syncing with DropBox.
Some links that might get useful:
What is Markdown?
Online editors:
Windows + Mac:
Windows only:
Mac only:
Mobile:
Chrome plugins:
Comparison of tools and features:
Preview:
Conversion:
Comparison and resource overviews:
Markdown is very common in the scripting world.
A few examples:
On the syntax:
The Markdown syntax can be quite odd. Syntax examples are in http://daringfireball.net/projects/markdown/syntax.text, which is the source code for Daring Fireball: Markdown Syntax Documentation. For instance [WayBack] when nesting ordered and unordered lists, your code needs to be indented like this:
1. Ordered item 1
- Unordered item a
- Unordered item b
1. Ordered item 2
- Unordered item c
- Unordered item d
On CommonMark and John Gruber:
Even though John Gruber – the original Markdown inventor – wasn’t involved with Markdown for like 10 years, in September 2014 he was involved in the [WayBack] “Standard” Markdown Controversy which led to the [WayBack] CommonMark project trying to set a standard for Markdown.
–jeroen
Posted in Google, GoogleDocs, MarkDown, Power User | Leave a Comment »
The Wiert Corner - irregular stream of stuff 