Working Memo - right tone in an email

A quote I remembered long time ago is that if you work hard, it's not difficult to get a 0 to 60 score. But it is hard though to get a score from 60 to 90. To reach this range, I've set up a long term target.

Today thanks to my leader, I learn something I believe it's critical to my target score. It's about writing a memo to one of the clients. Since it's not a regular memo that I used to communicate with the client,  I made the draft, and asked for direction. When the leader reviewed them, two of three sentences were revised.

Lucky that I asked before sending out, the revised version is very different. It's more specific regarding some technical information that I did not know about. The tone was also adjusted.

🍀 I write a memo to remember today.

P.S.
I usually say, "any questions, please..."
What I learned today, "...please direct any questions to..."

EXCEL EXCEL - Subtotal vs. Pivot Tables

To certain degree, I agree that Pivot Table is more flexible than Subtotal function in Excel. I can group by dates, apply formulas, use slicers for filtering, create impressive charts and make the dashboard.

Subtotal function summaries data with different criteria, such as Date. To do so, I used to sort on the Date first, and then the subtotal will present a desired result.

It depends on the request. I prefer to set up a pivot table in the workbook for testing. Such as a daily report regarding to overnight data updated. Then if raw data changes, by hitting on the refresh button, I can refresh the analysis part. This makes daily data reporting more efficient.

I also use Subtotal for a request to run quick analysis base on one criterion. It's quick and easy to get done.

On writing well

On and off in 3 months, I finished reading William Zinsser's book "On Writing Well".

The key is about Simplicity and Clarity

"We know that verbs have more vigot than nouns, that active verbs are better than passive verbs, that short words and sentences are easier to read than long ones, that concrete details are easier to process than vague abstractions."

...with no end of ways that can improve a manuscript . "pruning, shaping, clarifying, tidying, a hundred inconsistencies of thense and pronoun and location and tone, noticing all sentences that could be read in two different ways, dividing awkward long sentences into short ones, putting the writer back on the main road if he has strayed down a side path, building bridges where the writer has lost the reader by not paying attention to his transitions, questioning matters of judgment and taste." - what a long sentence with all the merits a good writer should have:-). Of course, craft the writing work as many times as 100% satisfied.

Another key note:

"If you would like to write better than everybody else, you have to want to write better than everybody else."

Pumpkin day

One of the major activities in the fall is to pick a big pumpkin, craft it, place it at the door, light up a candle and wait for door bell rings

Not much creative talent that I have, I used to print out a drawing from internet and follow the steps to craft. When I hear the kids saying the pumpkin is very cute and they love it, it makes my day.

When my parents were here during the festival, the candy ran out quickly. They were so generous to give each kid at least 3 candies. Alright, we had to turn the light off fairly early when all candies depleted.

Memory of South Africa ~ Sunshine through the window

November 16, 2015

We woke up very early as usual. When we were up, local friend took us to China Town for a breakfast. It's a small community area, restaurants, supermarkets, small commodity shops.

We stopped at a family style restaurants and had the "BAO ZI" and congee. It's handmade, and I remembered I saw a cat in the shop...

I was not feeling well because of the jetleg, so we only did light activities after that.

Dinner was a big thing, friends took us to a very high end place, there is iron fence around the restaurant...the seafood that friends ordered were fabulous. I believed the price is premium too.

I also felt the climate change. During the day time, it's so hot. But in the night, it's cool and very comfortable for slepping.

Memory of South Africa ~ sunshine through the window

Date of arrival - November 14, 2015

It's really a long long long flight travelling half of the globe. We departed from Toronto, changed the flight in Amsterdam, crossed equator, arrived Johannesburg, the capital of South Africa. It took about 24 hours including 4-hours waiting time in Amsterdam Schiphol Airport.

Climate is also opposite, although not much different. The time we left Toronto home was late autumn, then we arrived to a early summer, warm and humid.

Dear friends came to pick us up at the airport. We were so happy to see them, especially landing in a new continent we never thought off to pay a visit in our life.

Working Memo - Insert a screenshot in Office 365

Screen clipping is the feature I use a lot at the current job. By doing so, I can quickly add a screenshot to any Office file without leaving the program that I am currently working in. I've tested this great feature in Excel, Outlook, PowerPoint, and Word.

One of many working scenarios is to add the screenshot: (Insert tab>>Illustrations group>>Screenshot), or simply by applying the snipping tool.

I also like another option and use it frequently - Click Screen Clipping: It can select portion of a window. Only the windows that have not been minimized in the task bar can be captured. If there are multiple windows open, first is to click the window capture before starting the screenshot process. Then it will move that window to the first position in window gallery, and click Screen Clipping to select a portion of that screen.

I love it and added to the quick acces toolbar.