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.

Career notepad ~~ points about

~~ Some important words ~~

Make mistakes - as long as not critical

Do big things - dream about it

Get rid of should - rule is not everythig

Deviate - excuses

Know myself - locate

Keep options open - opportunities somewhere

Believe - can do

Trust myself - able to

Happiness first - enjoy

Push myself - everyday a bit

Take opportunities - don't give up

Promote myself - as a brand

Give myself credit - take tea break

Don't stop - accumulation

Be patient - good things will happen

Get uncomfortable - walk out of comfort zoom

Be proactive - prepare

Be brave - don't be shy

Trust others - team work

Change is good - keep up to day

Think outside the box - find audience

Money will follow - when things back to right track

Ask for help - it's natural

Go outside the lines - flexible

Be in the moment - be focus

Impact the bottom line - face the challenge

Speak up - brainstorming

Don't gossip - only speak good things

Ask for more money - it's worth

Take risks early - plan ahead

~~