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,466 other followers

Archive for the ‘GoogleDocs’ Category

Create & use pivot tables – Computer – Docs Editors Help

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

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the cells with source data you want to use. Important: Each column needs a header.
  3. In the menu at the top, click Data and then Pivot table. Click the pivot table sheet, if it’s not already open.
  4. 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.
  5. In the side panel, next to “Values,” click Add, then choose the value you want to see over your rows or columns.
  6. You can change how your data is listed, sorted, summarized, or filtered. Next to what you want to change, click the Down Arrow Down Arrow.

–jeroen

Read the rest of this entry »

Posted in Google, GoogleDocs, GoogleSheets, Power User | Leave a Comment »

How To Work with Google Reference List: all Google URLs you will ever need in one handy place – via Denis Labelle

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 »

Markdown notes

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 [WayBackwhen 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 [WayBackCommonMark project trying to set a standard for Markdown.

–jeroen

Posted in Google, GoogleDocs, MarkDown, Power User | Leave a Comment »

 
%d bloggers like this: