ChatGPT Tips and Tricks

User Scenario Prompt for Cover Letter Write a conversational cover letter for a job application as a [position] at [company] using my resume below as a reference. Draft a persuasive cover letter in 150 words or less highlighting my qualifications and enthusiasm for the [position] at [company] using my resume achievements below. Create a compelling cover letter that explain why I am the best fit for the [position] at [company]. Write the letter using the StoryBrand Framework....

March 27, 2023 · 1 min · 117 words · Eric

Learn In Public

Reference Learn in Public

December 29, 2022 · 1 min · 4 words · Eric

Convert HEIC Images to JPEG with macOS

The reference post can quickly help you create an Automator workflow to convert HEIC images to JPEG. Reference How to Create a Mac Quick Action to Convert HEIC to JPG

December 21, 2022 · 1 min · 30 words · Eric

Using ImageMagick to Add Watermark

When drafting my travel notes, I needs to modify lots of photos I took during the trip. Thus I started to dig again with ImageMagick . Lucky, I found this blog from Amy Tabb that achieves exactly what I am proposing to do. Here is a example code snippet of adding watermark to an image via imagemagick. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 # step 0 - get all available font list convert -list font > fonts....

December 18, 2022 · 2 min · 215 words · Eric

Create Random Pairs in Excel & Google Sheets

This week, I got this task to randomly generate pairs based on a name list. After googling on the internet, I found a perfect solution to achieve this. Here are the detailed steps to achieve a random pair of two. All the example data and formula can be found in this Google Sheet Random Pairs . Step 1 - Generate random numbers using RAND() Step 2 - Copy the random number values to a new column named Value Excel or Google Sheets will automatic re-generate a new series of random numbers with the RAND() function....

November 16, 2022 · 1 min · 213 words · Eric