Software

Featured Image- Dominik Scythe

Google Sheets – Query And Other Functions

Photo by Dominik Scythe on Unsplash Google Sheets – Query & Other Functions IF & IFS Functions June 15, 2019 https://youtu.be/hG5vKMb0Lpo IF(logical_expression, value_if_true, value_if_false) Example: IF(A2 = “foo”, “A2 is foo”, “A2 is not foo”) IFS(condition1, value1, [condition2, …], [value2, …])Example: IFS(A1>90, “A”, A1>80, “B”)   Combine Cell Contents June 15, 2019 https://youtu.be/Sg6XTFztZdo =B2&” “&C2 JOIN(delimiter, value_or_array1, [value_or_array2, …]) =TRIM(JOIN(” “,B12:C12,E12, D12)) Mr. Robert B Haight  TRIM: to eliminate the …

Google Sheets – Query And Other Functions Read More »

Microsoft Excel

Microsoft Excel

Background Image: Flower Bucket by Eleanor Lutz Microsoft Excel May 6, 2018 How to Export Facebook Insights and Analyze Using Excel Pivot Tables https://youtu.be/v8q8UN_q4tA

Featured Image- Get to Know Illustrator

Get to Know Illustrator

Photo by Hope House Press on Unsplash Creative Cloud Tutorials – Get to Know Illustrator I. Get to Know Illustrator March 16, 2018 常常我會太投入完成老闆給的任務,而忘記自我進修了,一定要勉強自己每天先自修一下,才能不斷累積進步。只想先學會AI修圖的基本,但是每次進入AI都像走進迷宮,讓我一直抗拒它,Creative Cloud Tutorials (點入標題,可連到課程連結) 給很多基本的課程,就從這裡開始。 1. Illustrator Workspace View > Fit All in Window Top: Menu Bar Left: Tool Bar Right: Panels Essentials: Reset Essentials to original state 2. Zoom and Pan Hand Tool: to …

Get to Know Illustrator Read More »

Import Excel into Access

Photo: Silverton Lookout, BC Import Excel to Access This tutorial maybe just what I need.  Three hours long. https://youtu.be/qCu6ioi1DkM Comparing Access & Excel Screens 4:56 Why You Need Access 7:06 Compare Tables to Excel Sheets 13:08 Add, Edit, Delete Table Records 19:45 Sorting Records Basic Table Filters Create a Table with Primary Key Add More …

Import Excel into Access Read More »

How To Save Web-Optimized Images In Photoshop For WordPress SEO

Sharpen my tool… How To Save Web-Optimized Images In Photoshop For WordPress SEO Thanks Bjorn’s well explained tutorial.  Here is the notes I saved for myself in the future and anyone who maybe benefits from it. 剛開始做網站時,對圖像的比例,解析度,網站速度等問題總是一知半解.這個Bjorn’s的教學影片,解釋的很清楚,我練習我的英翻中,將筆記整理在這裡,你也可以練習你的英文,聽聽他的教學影片喔! How To Save Web-Optimized Images In Photoshop For WordPress SEO 當優化影像圖檔給網站用時,有三個項目可以做的是: 將解析度(Resolution) 降低到72ppi 將圖檔裁到實際所需的尺寸(可參考下面的網站寬度建議) 用JPG或PNG來存檔.通常JPG的file size是比PNG來得小的 通常數位相機或手機的照片的解析度會在300ppi,這樣常常它的檔案大小(file size)會相當龐大(2mb+…). …

How To Save Web-Optimized Images In Photoshop For WordPress SEO Read More »