Welcome to My Blog

Apple releases iOS 9.3 beta 6 with Night Shift, Touch ID Notes, Verizon Wi-Fi Calling, more

Apple has released sixth iOS 9.3 pre-release beta for developers and public beta testers to use ahead of its release. The software update is expected to be released later this month. Features include a new Night Shift mode which changes the color temperature of displays, Touch ID- and password-protected items in the Notes app, new CarPlay features, expanded 3D Touch options, and much more.

more…

Filed under: iOS Devices Tagged: iOS 9.3

9to5Toys Lunch Break: Apple Watch $100 off + $50 gift card, iTunes gift card 20% off, TP-Link travel router $8, more

Keep up with the best gear and deals on the web by signing up for the 9to5Toys Newsletter. Also, be sure to check us out on: Twitter, RSS Feed, Facebook, Google+ and Safari push notifications.

TODAY’S CAN’T MISS DEALS:

apple-watch

Save $50-$100 on Apple Watch and get a free $50 gift card

itunes-apple-ebay-deal-card

Get a iTunes $100 Gift Card for just $80 delivered via email from PayPal (20% savings)

tp-link-router-deal

This TP-Link 802.11n Wireless Travel Router is a no-brainer at $8 shipped (Orig. $40)

macbook-12-inch-retina-1

12-inch MacBook now $300 off: 256GB $1,000, 512GB $1,300 + extra $50 savings w/ .edu email

Apple Mac Pro 12-core Xeon/64GB/1TB: $8,799 (Reg. $9,599), more

ipad-pro1

Apple 12.9-inch iPad Pro 128GB Wi-Fi + Cellular: $930 shipped (Reg. $1,079)

Apple 12.9-inch iPad Pro 128GB Wi-Fi: $800 shipped (Reg. $949)

throne-watch-band-giveaway

Giveaway: Outfit your Apple Watch with one of Throne’s handmade leather bands ($330 value)

arris-surfboard-docsis-3-0-cable-modem

How-to: Save up to $10/month on your cable bill by buying this $40 DOCSIS 3.0 Modem

MORE NEW GEAR FROM TODAY:

bes1012_fy13_july_brand_english_K06

Gift cards up to 20% off w/ email delivery: Best Buy, Panda Express, Michael’s, Applebee’s, many more

jetdrive-lite-macbook

Put an extra 256GB in your MacBook Air or Retina Pro w/ Transcend’s JetDrive Lite: $139 (Reg. $155)

MORE DEALS STILL ALIVE:

toca-kitchen-2-sale-01

App Store Free App of the Week: Toca Kitchen 2 goes free for the first time ($2 value)

Dr. Seuss Birthday iOS/Android App Sale from $1 ea: The Lorax, One Fish Two Fish, more

mohu-leaf-antenna

Snag one of these discounted HDTV antennas and finally cut the cord, deals from $13 Prime shipped

anker-soundcore-bluetooth-speaker

Anker SoundCore Bluetooth 4.0 Speaker w/ 24-hour battery life: $30 Prime shipped (Reg. $40)

NEW PRODUCTS & MORE:

feature-skills

Amazon launches more affordable Echo Dot and Amazon Tap Bluetooth speaker

new-normal-headphones-lifestyle

New Normal blends style and PowerBeats-like design for a new take on wireless earbuds

lego-minecraft-spring-2016

LEGO releases four new Minecraft sets

Filed under: Tips and Tricks Tagged: 9to5Toys, Amazon, app deals, Best Buy, Daily Deals, free apps, Gold Box, video games

Mini Review: Grovemade’s wooden MacBook dock is solid, attractive, & expensive

Regular readers will know that I’m a sucker for wood. Show me something well-crafted from an attractive chunk of wood and I’m on board.

I’d previously admired Grovemade’s wooden iPad sleeve, and the company’s iPhone cases were featured in our ‘best of iPhone 6/Plus cases’ roundup, so I thought I’d check out its recently-announced MacBook Dock. The dock is available in a range of sizes to suit the 12-inch MacBook, 11- and 13-inch MacBook Air, and 13- and 15-inch MacBook Pro. I tested it with my 11-inch MacBook Air …

more…

Filed under: Reviews Tagged: Grovemade, Grovemade MacBook Dock, Grovemade MacBook Dock review, MacBook, MacBook Air, MacBook desk dock, MacBook dock, MacBook Pro, MacBook wooden dock

Supreme Court won’t hear appeal on Apple’s $450 million e-book price-fixing case

Apple will be on the hook for $450 million after losing its appeal in the e-book price-fixing case, Bloomberg reports. The United States Supreme Court released the decision after Apple appealed the prior ruling. The high-profile case dates back to a 2012 lawsuit from the United States, which Apple appealed all the way to the Supreme Court, but the justices declined to hear the case which leaves the prior ruling intact.

more…

Filed under: AAPL Company Tagged: Apple, e-books, ebooks trial, IBooks

Leaders – Bringing Out Creativity From Your Employees

Leaders – Bringing Out Creativity From Your Employees
By Neal Burgis
“Creativity is putting your imagination to work, and it’s produced the most extraordinary results in human culture.” – Ken Robinson
In today’s winning companies, leaders look for every advantage as possible. Those leaders of creative and innovative organizations know how to take advantage of the opportunities they […]

from Project Management Articles – PM Hut http://ift.tt/1TZouqB
via pmhut.com

EU competition chief warns “don’t hold your breath” on $8B investigation into Apple’s tax affairs

European Union competition chief Margrethe Vestager has warned reporters not to expect a quick decision from the investigation into whether or not Apple’s tax arrangements in Europe are legal, reports Bloomberg.

“Don’t hold your breath,” she told reporters in Brussels on Monday about the timing of decisions targeting Apple and online shopping giant Amazon.com Inc, whose tax affairs in Luxembourg are also under intense scrutiny. “I’m just warning you.”

Apple uses Ireland as its European headquarters, funneling most revenue through the country, where it has a special arrangement with the Irish government to pay corporation tax of just 2.5%. The EU believes this arrangement may be illegal for two reasons …

more…

Filed under: AAPL Company Tagged: AAPL, Apple tax, Apple tax avoidance, Apple tax avoidance claims, Apple tax Europe, Apple tax Ireland, Europe, European Commission, European Union, Margrethe Vestager

An FBI win could lead iOS users to reject updates and tech companies to leave the USA, says Lavabit

The implications of the FBI forcing Apple to create a compromised version of iOS to break into an iPhone could be profound, argues Lavabit – an encrypted email company that closed its service rather than comply with an FBI demand to hand over its encryption key. Company founder Ladar Levison (above) was found to be in contempt of court when he refused to hand over the key in 2013.

Lavabit is the latest of more than 40 companies and organizations to file an amicus brief in support of Apple, reports TechCrunch.

It warns that iPhone and iPad users may reject future iOS updates, which would leave security holes unplugged.

If the government is successful, however, many consumers may not be as trustful of these updates because of a fear (actual or imagined) that the updates will contain malware to provide a backdoor into the data on their iPhones. The result is that fewer people will automatically accept the automatic updates and the overall security of iPhones across the country will suffer.

But the effects of a ruling against Apple could go even further, the company suggests …

more…

Filed under: AAPL Company, iOS Devices Tagged: Apple Inc, California, Encryption, FBI, Federal Bureau of Investigation, Federal government of the United States, iOS, Lavabit, privacy, San Bernardino

Weird glitch causing some iOS users to receive ghost emails from 1st January 1970

Not long after Apple fixed one 1970-related iPhone glitch, a second one appears to be at work. A number of iPhone and iPad owners are tweeting screengrabs of ghost emails arriving from 1st January 1970. The emails have no sender, subject or content, and cannot be deleted, reports the Telegraph.

The good news is that this glitch doesn’t do any harm. The date is simply the Unix equivalent of zero, so the iOS Mail app would default to this if for some reason the correct date and time were missing, as one Reddit user explained …

more…

Filed under: iOS Devices Tagged: 1970, 1970 email bug, 1970 email glitch, 1970 emails, email, iOS, iPad, iPhone, Unix time

12 Uncomfortable Things That Will Make You More Successful

uncomfortable-things-for-career.jpeg

In a truly beautiful letter to his daughter Yolande, Sociologist W.E.B. Du Bois extolled the virtues of being uncomfortable.

Yolande was headed to a new school half way around the world from the neighborhood and people she knew. It was years before women had the right to vote, and decades before the Civil Rights Movement.

Du Bois knew she would have more than a few fish-out-of-water moments. Instead of trying to shield her from them, he asked her to revel in them:  

Don’t shrink from new experiences and custom. Take the cold bath bravely. Enter into the spirit of your big bed-room. Enjoy what is and not pine for what is not. Read some good, heavy, serious books just for discipline: Take yourself in hand and master yourself. Make yourself do unpleasant things, so as to gain the upper hand of your soul. Above all remember: your father loves you and believes in you and expects you to be a wonderful woman.

I am no W.E.B. Du Bois. I have neither his fortitude nor his stunning way with words. What I do have, however, is a small history of uncomfortable experiences that have made me stronger, and an endless sea of animated GIFs through which to illustrate those experiences.

Here are a handful of uncomfortable situations in which you should take De Bois’ advice and “Take the cold bath bravely.” You’ll be better off as a result. 

12 Uncomfortable Things That Will Make You More Successful

Brace yourself. It’s about to get awkward.

1) Learning to Take a Compliment

Source: Reaction GIFs

Tell me if this sounds familiar: You work exceedingly hard. You’ve honed your skills. You know when you’ve done great work and take a quiet pride in it. And yet, the moment someone verbalizes it in the form of a compliment you can’t seem to string two words together. Instead, you revert into one of the following: 

  • The babbling-response.
  • The self-deprecating response. 
  • The total and complete blackout. 

That nonsense has to stop. Here’s how to take a compliment.:

  1. Realize that someone is paying you a compliment.
  2. Let them finish.
  3. Seriously, let them finish. 
  4. Take a breath.
  5. Smile and say “Thank you. That’s really good to hear.” 
  6. Move on in the conversation. Don’t over-explain. Don’t undercut yourself. Just thank them sincerely and move on with a question about how their work is going. 

Why is this so hard? According to a study by Acknowledgment Works, nearly 70% of people associate embarrassment or discomfort with the process of being recognized. Sometimes, this response is caused by the dissonance we feel when someone contradicts our own self-doubt.

But that doesn’t explain why people who are genuinely proud of themselves still balk at hearing that same praise from others. For those people, it often comes down to a learned-response. In other words, you are awkward when you receive compliments because I am awkward when I receive compliments — or, if not me, then your mom; your co-workers; your icons. We’re all making each other squirm. 

One way to turn that discomfort on its head is to realize that the compliment has more to do with the person giving it than with you. “When someone is complimenting you, they are sharing how your actions or behaviors impacted them,” explains Business Psychologist Mark Goulston. “They are not asking if you agree.”  So don’t rob them of that moment. 

2) Public Speaking

speaking.gif 

Source: Giphy

You knew this one was coming, right? Fear of public speaking is so common it has its own phobia name: Glossophobia.  

Now, I don’t think I need to go into the reasons behind this particular juggernaut of discomfort. We’ve all been there. Having that many eyes and ears on you is stressful. It makes you feel as though any mistake or imperfection will be amplified a thousand times. I’m also certain you realize how compelling a good public speaker can be, and how much it can advance your ability to lead and inspire.

So all that leaves is the classic glossophobia question:  How do you get over it? The answer is a mix of substantial and superficial changes.

Know the essential points.

Do not attempt to memorize your speeches. Instead, memorize your key points and your pivot lines. Pivot lines are the sentences that will move you from one key point to another. They act as navigational guides for your audience and a momentary comfort zone for you. Use these pivot lines to reset, take a breath, and move to your next key point. 

Understand that everyone wants you to succeed.

You are not going into battle. You are not facing a firing squad. These people you are talking to are all decent, interested folks. Many of whom also suffer from glossophobia. So know they are friendly, and talk to them like it.

Fake it.

For this last point, I turn to Harvard Associate Professor Amy Cuddy. She is a brilliant researcher and a  self-proclaimed introvert who noticed something fascinatingly simple about skilled public speakers: They all looked comfortable, and they all appeared to be in command — even if that appearance was all a big ruse.

So she studied what happens to people’s mindset when they stood up straight, casually used the space around them, and otherwise “power-posed.” Turns out the physical act of power-posing can send biological triggers to your brain to reduce cortisol levels and increase testosterone, calming you down and empowering you simultaneously.

(Here’s a blog post on science-backed tips for better public speaking if you want to learn more.)

3) Working With Data

math-1.gif 

Source: Reddit

If you don’t take to math easily, then delving into data can be intimidating. But learning to use data to find opportunities and underscore your points is a game-changer in your career.

The trick to mastering data is to learn it in context. Start by getting to know the core metrics that reflect your work. Play with spreadsheets at the close of a month. Learn to recognize trends. Alter the data to see how moving one metric would influence the others. The more time you spend with the data the more natural interpreting it will become.  Once you’ve done that, you can dig into the tougher stuff. Here are a couple of resources to get you started:

4) Waking Up Early

Source: ReactionGIFs

It’s exhausting, this modern life. While it may seem like you should squeeze as many extra minutes of sleep out of the morning as possible, the opposite is usually true. Your energy, focus and mental capacity are at their highest during the morning hours and proceed to wane throughout the rest of the day.

Take advantage of that time before breakfast when the chaos of the day has yet to set in. For most people, waking up early is a learned practice. 

First, make sure you’re cognizant enough to make the decision. Putting your alarm clock right next to your pillow is bound to result in you hitting snooze from a dazed state. You can’t be expected to make smart choices while you’re still dreaming. In addition, waking up early needs to become a pleasant experience. So if the thought of going straight from your warm bed to a shower or treadmill seems abrupt, then don’t do it. Instead, move from your bed to the cozy corner chair in your living room and read for a bit with a mug of coffee. What you do early on doesn’t matter, what matters is that you use the time in productive ways. (Read this blog post for more tips on becoming a morning person.)

5) Taking Critical Feedback

Taking-Bad-Feedback

Source: ReactionGIFs

This one stings sometimes, but it’s important. Learning to hear criticism without turning your back to it can be one of the most fortifying achievements of your career.

Think of critical feedback as a cheat sheet. In giving you direct feedback, your manager or colleague is giving you a shortcut  — your own personal konomi code — to becoming better at your job.

Sometimes, even with the best intentions, taking feedback well can be a struggle. Your impulse will be to protect yourself; to get defensive, or stop listening. So, be conscious of it. Much like accepting a compliment, take a breath when you realize critical feedback is coming your way. Listen to it all without interruption. Write down what you can. Then, ask questions to make sure you’re interpreting it right. 

6) Giving Critical Feedback

Source: Giphy

The only thing worse than taking critical feedback is giving it. I’ve written about this before: Whether you’re a manager or a friend, feedback is an opportunity to help someone get better. Don’t waste it. Good coaches give feedback directly and with respect. Don’t try to soften the blow or talk around the feedback. Doing so may make you feel better but it will only serve to confuse them.

If you’re struggling to be direct, try one clear line followed by detail. For example, “John, what you’re doing isn’t working. Let’s talk through why…”

In addition, feedback is always most constructive if accompanied by recent concrete examples. Telling someone they have a bad attitude isn’t helpful — it’s far better to point to a precise moment in which that bad attitude showed up, and then explain how moments like that can become detrimental in aggregate. Ultimately, knowing how to improve is as important as knowing what to improve. The person receiving the feedback should leave the conversation feeling empowered to change, not broken down. (Here are some more tips on how to give negative feedback without sounding like a jerk.)

7) Fighting through Conflict

 Source: ReactionGIFs

You know what’s more uncomfortable than fighting through a conflict with someone? Settling for an uninspired compromise, and then gossiping about that person over drinks with your coworkers. That’s WAY more comfortable than conflict. (Not to mention, way less productive.)

There are two ways conflict negotiations get botched: Either one side gives in too easily, or both sides are too inflexible to make resolution possible. The cleanest way through conflict is to try to discover what’s motivating the other person. Comment trolls aside, it’s pretty rare for someone to be argumentative for no good reason. Discovering the reason will help you find a better route to solving the conflict. That’s why your best asset in settling conflict is a collection of genuine questions and a patient ear to hear the answers.

8) Exercising

Exercise Gif

Source: Giphy

I keep waiting for the study that says that exercise isn’t all its cracked up to be. It’s fair to say that study isn’t coming. Not only is exercise good for your physical health, the ties between exercise and mental capacity are becoming undeniable. (Thanks, science.)

If you like working out, skip right ahead.  If you don’t, here are the only things I’ve found to work. 

Find your reason.

Maybe you want to lose weight. Maybe it helps you think more clearly. Maybe you have three kids, a constantly buzzing phone, and a dog all demanding your attention and exercise is your only chance to be alone. The reasons don’t matter.  Just find the one that feels authentic for you and use it. 

Make the time.

Treat exercise like you treat showering. It’s just something you do; a non-negotiable daily ritual. (Psst … here are 10 little ways to sneak in exercise at work.)

Get over it.

I used to hear about “runners’ highs,” a sort of delusion that sets in after you’ve done it enough that actually makes you believe jogging is fun. That may be the case for some people. It never happened for me, and wanting to like running made it easy to give up when I ultimately didn’t. Du Bois’ advice is worth hearing again here: “Make yourself do unpleasant things, so as to gain the upper hand of your soul.”

Find your genre.

The softer alternative to the above point is to find the exercise format that you hate least. If a crowded gym makes you want to run for the hills, then work out at home or outside on your own. If you find jogging boring, join a class or sports league. Work at it — it’s worth it.

9) Unplugging

Source: Giphy

I love the internet. And smartphones? They’re like personal escape hatches that you carry with you all the time. But maybe “all the time” is not such a good idea.

According to a TIME poll of more than 5,000 people, 84% of respondents said that they could not go a single day without their cell phones, and 20% said they check them once or more every 20 minutes.

It’s not the frequency of usage that’s the problem; it’s what that level of usage does to our focus. Using our smartphones at night can make it a lot harder to sleep. When we use our smartphones nonstop it can be harder to think clearly.

So, here’s an experiment. For two weeks, set aside some screen free time blocks in your day. During that time fight the urge to open your laptop, watch TV, or glance at your phone. Sustain it for 60 minutes or more and see if you’ve gained better focus at the conclusion of the experiment. Then, go find some cat videos on YouTube to celebrate.

10) Networking and Making Small Talk

 brie.gif

Source: Giphy

Everyone has a small-talk formula. Some people start with the weather (nice, mild winter we’re having, eh?), while others ask how things are going with you at work. But here’s the trick to mastering small talk: Get fascinated by it and the person wielding it. It’s a little like being dealt a hand of cards, you can use what you have to get to bigger and more interesting plays.  

If someone asks you how work is, don’t say “fine” — or worse, “busy.” Tell them it’s good and follow up with, “You know, there’s one project in particular that you may find interesting.” If you’re doing the asking, take any opportunity to dive deeper. Use each question as a spring board to the next one. Eventually, you’ll hit on something substantial. 

11) Admitting a Mistake

Source: ReactionGIFs

You know that moment right after you realize you’ve accidentally made a mistake? You know, that moment when the dread plummets into your stomach in one sweeping motion? Uncomfortable doesn’t even begin to describe it.

However, even that can be turned around. The most effective way to replace that sinking feeling in your gut is to assess the situation and take action. Ask yourself:

Is it immediately reversible?

On my last blog post, I had a glaring typo. This was not some extra spacing after a period, this was a blatant blemish smack in the middle of my post. And I missed it. Thankfully Claire Autruong caught it and let me know via Twitter so I could edit the post before it was too late. Claire is my favorite person of the week. (Incidentally, she is also a full-stack freelance marketer — inbound certified and nice as can be — if you’re looking.)

Who should know?

Whom does your mistake affect? Who is in the position who can help you solve it? Quickly scan the list of people that need to know about your mistake and contact them explaining what happened and what you’re doing about it.

What’s your plan?

If the mistake isn’t immediately reversible, you’ll need a plan of action. A good plan is the best antidote to mistake-induced discomfort. Shift from panic to determination as soon as possible, and that discomfort will subside.

12) Getting in Over Your Head

Source: ReactionGIFs

Of all the uncomfortable moments, getting in over your head is probably the one most worth pursuing. Sure, it’s a little scary , and there’s always the chance of failure, but nothing stretches you more or makes you more creative than having no idea what you’re doing.

So how do you put yourself in an over-your-head style situation? Raise your hand. When there’s a project no one wants, step up. When there’s a problem that has existed for years, have at it. Then break it down. Take big challenges and tackle them piece by piece. It may not always be fun, but you will almost always be better for the effort. 

I’ll stop there …

… but this is really just the beginning. Who knew there were so many uncomfortable things in the world? (Michael Cera. Michael Cera probably knew.)

From negotiating salary to reading “some good, heavy, serious books” as Du Bois suggests, this list could go on and on. Hopefully it will, in the comments below.

What uncomfortable moment have you conquered as a professional? Which are you still working on that you’d add to this list? Share with us in the comments.

free ebook: leadership lessons  

War of words on FBI case continues as NYPD counter-terrorism chief accuses Apple of ‘providing aid to murderers’

The battle between the FBI and Apple continues to be played out in the media. On the same day that Apple SVP Craig Federighi said that the FBI wanted to create a weakness that could be used by hackers and criminals, NYPD’s head of counter-terrorism weighed in during a radio interview. The Daily News quotes John Miller accusing Apple of providing aid to murderers, among other things.

I still don’t know what made [Apple] change their minds and decide to actually design a system that made them not able to aid the police. You are actually providing aid to the kidnappers, robbers and murderers.

He cited the same quote used by Manhattan District Attorney Cyrus Vance during the Congressional hearing to support this contention, that a criminal described iOS 8 as ‘a gift from God’ …

more…

Filed under: AAPL Company, iOS Devices Tagged: Apple Inc, California, Encryption, FBI, Federal Bureau of Investigation, iPhone, John Miller, New York, NY, NYPD, privacy, San Bernardino

40 Excel Shortcuts You’ll Definitely Want to Bookmark

excel-shortcuts.png

Many marketers use Microsoft Excel every single day, whether it’s to create a waterfall report, analyze data, or run a report to present at the next team meeting.

Creating reports like these in Excel is time-consuming enough. How can we spend a little less time navigating, formatting, selecting, and entering formulas for our data? Wouldn’t it be great if there were keyboard shortcuts that could help us get our work done faster?

So glad you asked.

We’ve put together a list of 40 keyboard shortcuts for Microsoft Excel. Although you can do all of these maneuvers manually, knowing these tricks will help save you time so you can focus on the stuff that really matters.

Download our free guide to Excel here to learn the essential Excel skills you should know.

All of these shortcuts can be accessed on PC and Mac, so we’ve included both types below if applicable.

(Note for Mac users: To access the F keys (F1–F12), you’ll have to hold the Fn key before pressing any F key — unless you’ve enabled those keys as standard function keys.)

40 Excel Shortcuts You’ll Definitely Want to Bookmark

Navigation

These simple shortcuts can help you navigate between workbooks, sheets, rows and columns.

Shift + Enter (PC and Mac) = Move up through a selection

CTRL + ↑ (PC); Command + ↑ (Mac) = Jump to the top of a column

CTRL + ↓ (PC); Command + ↓ (Mac) = Jump to the bottom of a column

CTRL + . (PC and Mac) = Jump to the corner of a selection (Note: Rotate to each corner by repeating this keystroke)

CTRL + w (PC); Command + W (Mac) = Close the active workbook window

CTRL + Shift + F6 (PC); Command + Shift + F6 (Mac) = Switch to previous workbook window

CTRL + Tab (Mac only) = Switch to the next open worksheet

CTRL + Shift + Tab (Mac only) = Switch to the previous open worksheet (Mac)

F11 (PC and Mac) = Start a new chart sheet

Shift + F11 (PC and Mac) = Insert a new sheet

CTRL + y (PC); Command + Y (Mac) = Repeat the last action

CTRL + d (PC and Mac) = Fill selected cell with the content in the cell above selected cell

CTRL + r (PC and Mac) = Fill selected cell with the content in the cell to the left of selected cell

Formatting

Formatting in Excel can be difficult if you don’t know of what you’re doing. Here are a few shortcuts that to help you easily format your cells.

CTRL + F (PC); Command + F (Mac) = Find and replace values

CTRL + Shift + % (PC and Mac) = Show all values as percentages

CTRL + Shift + $ (PC and Mac) = Show all values as currency (Note: Replace $ with your own country’s currency key)

CTRL  + Shift + ~ (PC and Mac) = Show all values in general number format

CTRL + Shift + & (PC); Command + Option + 0 (Mac) = Apply an outline border to selected cells

Here’s what cells look like with (left) and without (right) a border:

   Screen_Shot_2016-02-24_at_3.29.24_PM.png        Screen_Shot_2016-02-24_at_3.30.53_PM.png

 

 

CTRL + 2 (PC); Command + b (Mac) = Apply or remove bold formatting to selected cells

CTRL + 3 (PC); Command + i (Mac) = Apply or remove italic formatting to selected cells

CTRL + 9 (PC and Mac) = Hide selected rows

CTRL + Shift + ( (PC and Mac) = Unhide selected rows

CTRL + 0 (PC and Mac) = Hide selected columns

CTRL + Shift + ) (PC and Mac) = Unhide selected columns

CTRL + ; (PC and Mac) = Insert current date

CTRL + Shift + : (PC); Command + ; (Mac) = Insert current time

CTRL + k (PC); Command + k (Mac) = Insert a hyperlink

Selecting Rows & Columns

Save yourself the manual dragging and selecting rows and columns with these handy keyboard tricks.

Shift + ↑ [or] Shift + ↓ (PC and Mac) = Expand the selection by one cell either upward (↑) or downward (↓)

CTRL + Shift + Arrow Key (PC); Command + Shift + Arrow Key (Mac) = Expand the selection to the last non-empty cell

CTRL + [spacebar] (PC and Mac) = Select entire column

Shift + [spacebar] (PC and Mac) = Select entire row

CTRL + a (PC); Command + a (Mac) = Select entire sheet

Alt + ; (PC); Command + Shift + z (Mac) = Select only the visible cells in the current selection

Formulas

Formulas are a huge part of every marketer’s Eccel toolkit. Here are a few shortcuts that’ll make you a formula wiz.

= (i.e. press the “equals” sign; PC and Mac) = Start a formula (e.g. “=A4+A5”)

Alt + (PC); Command + Shift + t (Mac) = Insert AutoSum formula

F2 (PC); CTRL + u (Mac) = Edit active cell

CTRL + a (PC and Mac) = Display the Formula Builder after you type a valid function name in a formula

Miscellaneous

Here are a few more time-saving shortcuts.

F7 (PC and Mac) = Open spelling & grammar check

Shift + F2 (PC and Mac) = Insert a comment

insert-comment-excel.png

Control + Shift + s (PC); Command + Shift + s (Mac) = Save your work as

Can you think of any shortcuts that we missed? Feel free to add your favorites in the comments section below!

free guide: how to use excel

How to Pin Your Facebook Carousel Ad as a Page Post

kh-facebook-carousel-post-560

Do you want more organic traffic from Facebook? Have you considered pinning your ads as Facebook page posts? In this article you’ll discover how to drive organic traffic and conversions by pinning a Facebook carousel ad to your page as a post. #1: Set Up Your Facebook Carousel Ad First, you need to create your Facebook […]

This post How to Pin Your Facebook Carousel Ad as a Page Post first appeared on .
– Your Guide to the Social Media Jungle

from http://ift.tt/1YlRA2X
via socialmediaexaminer

The Power of Teamwork: 31 Quotes That Celebrate Collaboration

power-of-teamwork-quotes.jpg

We’ve all been a part of that group project. You know, the project where one person takes the lead, leading some members to conclude their ideas are unwelcome, while a select few ride the others’ coattails.

Thanks to experiences like this, it’s no surprise why so many people have been scarred by the nightmares of past group projects.

And yet, something incredible happens when teamwork happens the way it’s supposed to happen. Things change when everyone on the team is equally invested in the overall purpose and goal. You find yourself working faster, finding mistakes more easily, and innovating better.

Ultimately, you reach a point where you’re certain each person on your team has your back — and both your job satisfaction and performance skyrocket. (Getting inbound certified doesn’t hurt, either.)

To inspire your team to band together and celebrate collaboration, we’ve gathered some of our favorite quotes on the power of teamwork. Flip through the SlideShare below and share how teamwork shapes your work culture. 

31 Tweetable Quotes on the Power of Teamwork & Collaboration

1) “Alone we can do so little; together we can do so much.” – Helen Keller (Click to Tweet!)

2) “If everyone is moving forward together, then success takes care of itself.” – Henry Ford (Click to Tweet!)

3) “Many ideas grow better when transplanted into another mind than the one where they sprang up.” – Oliver Wendell Holmes (Click to Tweet!)

4) “If I have seen further, it is by standing on the shoulders of giants.” – Isaac Newton (Click to Tweet!)

5) “No one can whistle a symphony. It takes a whole orchestra to play it.” – H.E. Luccock (Click to Tweet!)

6) “Teamwork is the ability to work together toward a common vision. The ability to direct individual accomplishments toward organizational objectives. It is the fuel that allows common people to attain uncommon results.” – Andrew Carnegie (Click to Tweet!)

7) “It is the long history of humankind (and animal kind, too) that those who learned to collaborate and improvise most effectively have prevailed.” – Charles Darwin (Click to Tweet!)

8) “Coming together is a beginning, staying together is progress, and working together is success.” – Henry Ford (Click to Tweet!)

9) “Talent wins games, but teamwork and intelligence win championships.” – Michael Jordan (Click to Tweet!)

10) “The strength of the team is each individual member. The strength of each member is the team.” – Phil Jackson (Click to Tweet!)

11) “The best teamwork comes from men who are working independently toward one goal in unison.” – James Cash Penney (Click to Tweet!)

12) “Politeness is the poison of collaboration.” – Edwin Land (Click to Tweet!)

13) “Find a group of people who challenge and inspire you, spend a lot of time with them, and it will change your life.” – Amy Poehler (Click to Tweet!)

14) “Effectively, change is almost impossible without industry-wide collaboration, cooperation, and consensus.” – Simon Mainwaring (Click to Tweet!)

15) “Teamwork begins by building trust. And the only way to do that is to overcome our need for invulnerability.” – Patrick Lencioni (Click to Tweet!)

16) “You need to be aware of what others are doing, applaud their efforts, acknowledge their successes, and encourage them in their pursuits. When we all help one another, everybody wins.” – Jim Stovall (Click to Tweet!)

17) “The way a team plays as a whole determines its success. You may have the greatest bunch of individual stars in the world, but if they don’t play together, the club won’t be worth a dime.” – Babe Ruth (Click to Tweet!)

18) “There is no such thing as a self-made man. You will reach your goals only with the help of others.” – George Shinn (Click to Tweet!)

19) “It is literally true that you can succeed best and quickest by helping others to succeed.” –Napolean Hill (Click to Tweet!)

20) “The whole is other than the sum of the parts.” – Kurt Koffka (Click to Tweet!)

21) “A group becomes a team when each member is sure enough of himself and his contribution to praise the skills of others.” – Norman Shidle (Click to Tweet!)

22) “The ratio of We’s to I’s is the best indicator of the development of a team.” – Lewis B. Ergen (Click to Tweet!)

23) “Individual commitment to a group effort — that is what makes a team work, a company work, a society work, a civilization work.” – Vince Lombardi (Click to Tweet!)

24) “One piece of log creates a small fire, adequate to warm you up, add just a few more pieces to blast an immense bonfire, large enough to warm up your entire circle of friends; needless to say that individuality counts but teamwork dynamites.” – Jin Kwon (Click to Tweet!)

25) “No matter how brilliant your mind or strategy, if you’re playing a solo game, you’ll always lose out to a team.” – Reid Hoffman (Click to Tweet!)

26) “Keep away from people who try to belittle your ambitions. Small people always do that, but the really great make you feel that you, too, can become great.” – Mark Twain (Click to Tweet!)

27) “If you want to lift yourself up, lift up someone else.” – Booker T. Washington (Click to Tweet!)

28) “Great things in business are never done by one person; they’re done by a team of people.” – Steve Jobs (Click to Tweet!)

29) “Individually, we are one drop. Together, we are an ocean.” – Ryunosuke Satoro (Click to Tweet!)

30) “Cooperation is the thorough conviction that nobody can get there unless everybody gets there.” – Virginia Burden (Click to Tweet!)

31) “None of us, including me, ever do great things. But we can all do small things, with great love, and together we can do something wonderful.” – Mother Teresa (Click to Tweet!)

get a free inbound certification

3 Tools That Speed Influencer Outreach

dk-influcencer-outreach-560

Are you trying to connect with influencers? Looking for ways to streamline the process? You can make your influencer outreach more efficient and save yourself time by combining three free tools. In this article you’ll discover how to automate your influencer outreach with BuzzSumo, Buffer, and Twitter. #1: Identify Influencers Who Shared Similar Content The […]

This post 3 Tools That Speed Influencer Outreach first appeared on .
– Your Guide to the Social Media Jungle

from http://ift.tt/1nqRTvT
via socialmediaexaminer

Craig Federighi writes op-ed on Apple/FBI encryption battle: ‘to slow our pace … puts everyone at risk’

As part of Apple’s continuing quest to raise support for its side of the Apple/FBI iPhone encryption backdoor debate, Craig Federighi has written an opinion piece in The Washington Post. Unsurprisingly, the Apple executive repeats much of the arguments Apple has already made, indicating that hampering security efforts in technology is counterproductive:

To get around Apple’s safeguards, the FBI wants us to create a backdoor in the form of special software that bypasses passcode protections, intentionally creating a vulnerability that would let the government force its way into an iPhone. Once created, this software — which law enforcement has conceded it wants to apply to many iPhones — would become a weakness that hackers and criminals could use to wreak havoc on the privacy and personal safety of us all.

more…

Filed under: AAPL Company, iOS, iOS Devices, Tech Industry Tagged: Apple, FBI, Federighi, security encryption

First OS X ransomware detected in the wild, will maliciously encrypt hard drives on infected Macs

OS X users have today been hit with the first known case of Mac ‘ransomware’ malware, found in the Transmission BitTorrent client released last week. Infected versions of the app include ‘KeyRanger’ malware that will maliciously encrypt the user’s hard drive after three days of being installed. The malware then asks for payment to allow the user to decrypt the disk and access their data — the ‘ransom’.

more…

Filed under: AAPL Company, iOS, iOS Devices, Mac Tagged: keyranger, Mac, money, OS X, ransom, ransomware, scary, Transmission, virus, welfare