7 Excel Shortcuts You Should Know

Emails, task sheets, calendars, and spreadsheets are crucial for businesses to stay on top of their organization game. Excel is popular for organizing spreadsheets of important information and numbers that can ultimately hold the core activities of business together. Here are 7 great shortcuts for Excel on Mac that will maximize your efficiency so you can spend less time crunching numbers and more time making meaningful connections and doing what you love.

1. Date and Time- If you need to quickly add today’s date or time to a spreadsheet

Date- Command +  ;

Time- Command +  :

2. Fill Down- If you need to copy information in a cell down a column without having to copy/paste

Command + D

3. Select All- To select all cells in a particular region without having to click and drag

Command + A

4. Repeat- To repeat your previous action and place it a new cell

Command + Y

5. Extend Selection- To select a large amount of data without having to scroll down 200+ cells

Command + Shift + Arrow Key

6. Edit Cell- To edit the contents of a cell without having to double click the cell

Command + U

7. Multiple Cell Entries- To enter the same formula into multiple cells

Select All Cells - Command + Enter

Just these seven simple shortcuts can save you so much time and effort, and you’ll find your work day much more efficient. Still want to know more? You can find 222 more Excel shortcuts here.

Content originally created and published for Imagine Media Consulting blog

United Airlines is Done For

Twitter has become a prominent platform to reach out to businesses for easily accessible customer service. As Twitter is a social site for people to express their opinions, it is important for businesses to monitor consumers' perceptions about their brand.

Back in 2009, a musician named Dave Carroll flew on United Airlines, and the luggage handlers broke his guitar. When he attempted to reach out to United Airlines, they were apathetic and didn't do anything to assist him. He then wrote a song describing his grievances called "United Breaks Guitars," and it went viral overnight. Everyone knew that United breaks guitars.

This viral video taught businesses the importance of handling customer service issues promptly and professionally, they didn't want to go viral in a negative light! Now, 8 years later, United Airlines has an even bigger issue to recover from.

On April 9th, United Airlines staff forcefully removed a passenger from an airline in Chicago after the flight needed 4 additional seats to accommodate staff members. When nobody volunteered, they had to randomly choose 4 people to leave the plane. When one customer refused, he was forcefully removed, and was hit in the face during the removal. The removal was caught on video, and it immediately went viral, even getting President Trump to comment that this service was "horrible."

The outraged public immediately went to Twitter, making all sorts of memes to make fun of United and even satirically tweeting at them to incite responses.

United has gone from being a mediocre airline, to the laughing stock of social media. Their stock has plummeted, and their damage control team's work has been less than promising. What does the future hold for United?

Not So Sneaky Native Advertising

In the last 5 years, Facebook has increasingly become the platform for people to promote their original content, driving traffic and awareness to their personal and professional blogs and websites. If I'm scrolling through Facebook, I often see The Odyssey Online or Thought Catalog articles that have a catchy title that will bring me to their site.

Just last week, I was on my Facebook timeline, and I found my way to an article that really struck my interests. (as I was most likely in the target audience.)

This is How I Afford Luxury Travel on a Super Low Budget

As a broke college student with a deep desire to travel the world, I thought this article would be super insightful and give me great insights to go on adventures without having to break the bank.

It turned out, that the article was merely a 250 word promotion for Honey, a Google Chrome add-on that automatically applies discounts and promo codes to your cart before you make an online purchase. Basically, it has nothing to do with travel, but you can use it for traveling.

Native advertising is a great way to drive traffic to your website, however, if your native advertising isn't relevant or subtle under engaging content, you can run the risk of your audience feeling like they fell victim to click-bait. 

Virtual Reality Delivers the Royal Treatment

The live action Beauty and the Beast movie released in theaters this past Friday dazzling fans and critics alike. Disney lovers all over have been anxiously awaiting the revamp of the 1991 classic using #BeOurGuest across social media platforms.

Friday afternoon, the official Beauty and the Beast Facebook page released a virtual reality video, powered by Oculus. This video was of Lumiere, the famous showman candlestick, performing Be Our Guest. During his performance in the video, the virtual reality technology allows viewers to a 360 degree view of the grand dining room as he performed. You can turn to your left and see the coat hanger offer you a napkin, and you can even tilt your phone up to see Lumiere swinging across the chandeliers.

The pairing of Oculus technology and the Disney classic is a perfect way to highlight the release the film, as viewers get a chance to step into Belle's magical world and look around from her perspective. It's every Beauty and the Beast lover's dream.