Open Embedded Visio Flowcharts in Word on Mac and Windows

For some reason, on a Mac using Parallels Desktop to run Word and Visio in Windows, I cannot right click on an embedded Visio flowchart to open it in Visio. Usually, when you right click on an embedded Visio chart, you get the “Visio object” option, which includes an option to “edit”. But mine doesn’t have that option!!

screen-shot-2017-02-15-at-7-30-13-am

However, I figured out that a simple keyboard shortcut can let you open the Visio for editing.

In Word running in Windows, use alt+double click (or option+double click) to open the embedded Visio chart in Visio for editing. When you hold down the alt/option key while double clicking on the embedded flowchart, it will open in Visio. Sweet!

Simple, yet hidden!

Advertisements

Excel COUNTIF Compare To Another Cell Value

So in Excel, the COUNTIF function is very useful. However, I couldn’t figure out how to just use COUNTIF to only count cells if another cell is greater than 0. So here is how you do it:

=COUNTIF(Y12,">=" & $Z$3)

Basically, put your operator in quotes, then use the ampersand, followed by the cell that you want to compare to. Simple!

credit here