How to Freeze Top Row and First Column Simultaneously in Excel

How Freeze Top Row First Column Simultaneously in Excel

Sometimes if you’re building a spreadsheet in Excel you want to be able to freeze the top row and the first column simultaneously…   However, with Microsoft Office 365 it’s not clear how to do this. The “Freeze” option only allows you to “Freeze” column A or Row 1 from the menu bar. If you select Freeze Column 1, you can’t also choose to Freeze Row A… However, you can select cell B2 and click “Freeze Panes” this will freeze Row 1 and Column A simultaneously. Selecting “Freeze Panes” in…

Read More

The Upside of The Bottom

Maybe the most common approach to drug and alcohol addiction (of keeping addicts away from the bottom with treatment, interventions, etc.) is all wrong. Perhaps, instead of imploring our friends and loved ones to stop doing whatever it is they’re doing, we should encourage them to do more. Not only keep drinking… Drink more. Don’t stop doing drugs… Do more drugs. Just hopefully they won’t die… But maybe they will kill themselves. I mean, we all die… It’s inevitable. It seems sick, I know… But the world is kind of…

Read More

Is There A LinkedIn Publishing Rel=Canonical Option?

Is there a LinkedIn publishing rel=canonical option

Prior to republishing an article from my blog using LinkedIn Publishing I wondered if LinkedIn includes a Rel=Canonical link option to help publishers avoid duplicate content… It turns out that the answer is “no”. LinkedIn doesn’t offer a rel=canonical option, or build it in by default like Medium does… This a bummer for two reasons: Digital sharecropping is a really stupid long-term business model. Google can penalize you for duplicate content. However, depending on the age of your blog and your goals, reposting an existing article from your blog on LinkedIn…

Read More

Create And Release Tension…

The key to telling a good joke, apparently, is a two step process: Create tension Release it A good comic creates discomfort in the audience and then relieves the discomfort with the punchline. Our brains sense the relief in the situation and we laugh… The same approach can be used in writing a effective blog post, or telling a story, or getting to know someone. It doesn’t have to be funny… But, over time, your audience will appreciate this seemingly dangerous relationship they have with you.

Read More

I Admire You…

Feeling envious when you talk with someone who you think is “better” than you are is often a disingenuous, false signal. Everyone’s dealing with something you have no idea about… Everyone has a struggle. A better approach is to really admire that person for their ability to remain calm on the surface while their world could likely be falling apart. Thinking, I admire you, is a form of mental Aikido will help you in the end.

Read More

Which Foods Help With Depression?

which foods can help with depression?

Which Foods Help With Depression? According to a study titled “The Gut-Brain Axis: The Missing Link in Depression“: “A poor diet is a risk factor for depression… Thus, a healthy diet may prevent depression. Regulation of the gut microbiota using diet, probiotics and FMT may have important benefits for preventing and treating depression… The gut-brain axis could aid in understanding and treating neuropsychiatric disorders, especially depression.” A healthy diet is one that promotes the growth and regulation of beneficial bacteria at levels that are good for your microbiome. Eating processed…

Read More

Mental Aikido

Aikido, jiu jitsu and judo all can turn your opponent’s strength against them… Each is an art form… When mastered, a smaller, physically weaker person can easily overcome a sulphurous, vesuvian beast. Inner struggles are always a mismatch… Weakness is so strong. We shouldn’t try to meet it head on. At least not for the first 5,000-7,000 hours of our hero’s journey. Our higher self is too weak to aggressor the lizard directly… We must perform mental aikido. Practice redirecting the inner beast every day… Catch it off guard. Redirect…

Read More

10 Podcasts With Brendan Eich, Founder of Brave

Brave founder Brendan Eich is Silicon Valley royalty… He worked with Marc Andreessen as part of the original team at Netscape… While he was there he created the JavaScript programming language (in only 10 days). Since that time he’s also been on a roll… He co-founded Mozilla and the Mozilla Foundation. Today Eich is the founder and CEO of Brave Software and Basic Attention Token (BAT), a “utility token based on the Ethereum technology that can also be used as a unit of account between advertisers, publishers, and users in…

Read More

6 Legit Sales Statistics (And Techniques That Work)

6 Legit Sales Statistics and Techniques That Work

For about the past 4 years I’ve had a printout of cold calling sales statistics on the wall of my office… It’s from the “National Sales Executive Association”. You’ve probably seen these before… These sales statistics are a good motivator because they remind me that while cold calling is hard, I should push through the pain because there’s a light at the end of the tunnel if I persevere. The bad news about these stats is that apparently the “National Sales Executive Association” doesn’t exist… So the stats are made…

Read More