MacOS use notes

files system:

• type absolute path:  Command + Shift + g while in any Finder window or select "Go to Folder…"

• files search in spotlight to exclude a certain folder: 1) Launch System Preferences from the  Apple menu and choose the “Spotlight” preference panel, 2) Click on the “Privacy” tab, 3) Drag & drop folders or drives to exclude from the Spotlight index, or click the “+” plus icon in the corner to manually select hard drives or directories

screeshot:

• Shift-Command (⌘)-5 on your keyboard to see all the controls you need to capture still images and record video of your screen.

terminal:

• open files from terminal: open -a TextEdit filename should do the trick. The -a flag specifies any application you want, so it's applicable to any number of situations, including ones where TextEdit isn't the default editor.

macbook pro battery drain fast during sleep:

• pmset for macos power management controls
• Excessive battery drain while sleeping after 10.13.4 update
• is your Mac waking on its own, draining battery and then just plain powering down?

Excel usage:

• plot stacked column and bar chart