Posts

How To Calculate CAGR in Excel

Image
 Compound Annual Growth Rate, CAGR, is your rate of return for an investment over a specific period. Calculating CAGR by hand is a rather involved process, so below we’ll go over how you can quickly calculate CAGR in Excel CAGR Excel Formula The formula for calculating CAGR in Excel is: =(End Value/Beginning Value) ^ (1/Number of Years) - 1 The equation uses three different values: End value, which is the amount of money you’ll have after the period has passed. Beginning value, which is the amount of money you began with. Number of years, which is the total number of years that have passed. Below we’ll go over an example of how to calculate CAGR for a five years time frame in Excel using the sample data set shown below: 1. Identify the numbers you’ll use in your equation. Using the sample data set above, The end value is 2143 (in cell B6). The beginning value is 1000 (in cell B2). The number of years is 5 (in cell A6). 2. Input your values into the formula.  Excel offers many ...

How to Write A Statement of Qualifications

Image
 Finding a new job can be a nerve-wracking experience. You pour your heart and soul (not to mention your entire work history) into this document and wait by the phone (or your inbox) for the interview requests to come in. Fortunately, there’s a better way to communicate your skills and achievements to a potential employer than the traditional resume and summary. Before you send out resumes for your next career move, learn how a statement of qualifications can help you stand out as a candidate. What is a Statement of Qualifications? A Statement of Qualifications (SoQ) is a shortlist that highlights your most applicable skills and experiences. Your traditional resume, fleshing out each qualification through your relevant work history follows your SoQ. You can think of a Statement of Qualifications in relation to the adage "don’t bury the lead." It comes from the world of journalism and it’s a constant reminder that you should write the most important thing first. Why? Because i...

5 SEO Trends to Leverage in 2022 [HubSpot Blog Data]

Image
 Keeping track of SEO trends is like hitting a moving target. From algorithm updates to evolving innovation — it can feel like the goal post is always moving. And while the goal of SEO remains the same — to boost your presence in relevant search results — the tactics for getting there look different from year to year. Here, we'll cover the top SEO challenges facing marketers in 2022 and the five biggest trends to watch this year. 1. Algorithm changes. The number one challenge for marketers is keeping up with algorithm changes. This doesn't surprise me — in 2020 alone, Google ran more than 500,00 experiments that led to 4,000+ changes to search. If you're like most marketers, this stat can feel pretty overwhelming. After all, how can you succeed when Google keeps rerouting the path to success? The key is to respond to these changes strategically. For one, this means staying on top of industry news. If there's a significant algorithm change, the SEO industry will likely c...

7 Amazing Sample Answers to "What Makes You Unique?"

Image
 The interview question, "What makes you unique?" is not an opportunity to confess weird habits or odd quirks. It's a chance to provide the interviewer with insight into how you'd be the best candidate for a role, while proving you're someone who can think on her feet. Essentially, "What makes you unique" really means, "What makes you an exceptionally good candidate?" To avoid an awkward conversation, you'll want to be prepared to answer "What makes you unique?" in an interview. Here are seven sample answers to ensure you're proving yourself an incredibly valuable company asset. 7 Sample Answers to "What Makes You Unique?" and Why They Work 1. "I am a very good communicator and find it's easy for me to relate to other people." Consider mentioning a personality trait you feel would be a good fit for the business. After reading the job description, make a list of attributes that could make you an exceptio...

How to Pivot Your Content Plan According to HubSpot Marketers

Image
 Imagine this: as a content marketer, things are going pretty well for you — you're confident about your upcoming campaign, the ROI from your last couple were stellar, and projections for the new one looked just as good, if not better, than ever before. And then something happened, and you need to pivot your content. Maybe it's a sudden trend or global event that diverts your audience's attention. Or, perhaps a competitor's campaign launch has everyone talking, and you're unsure if your current content strategy is good enough to outshine theirs. Regardless, this shift has impacted your company directly, which means, your entire campaign is impacted directly. With that being said, now you have to decide if you need to pivot your content plan — and quickly. But how do you respond to an event like this? We asked HubSpot managers to give their insights about how to navigate major changes that alter your content planning. The HubSpot Blog also surveyed 1,000 marketers to...

How One Instagram Influencer Went From 0 to 45K on Reels (And How You Can, Too)

Image
 Over the past few years, TikTok has seen explosive growth, and it shows no signs of slowing down. In fact, by the end of 2022, TikTok is predicted to reach 1.5 billion monthly active users. But there's another big player in the game of short-form video — Instagram Reels, which Instagram launched in 2020 to provide a space for Instagram users to post short, 'snackable' content that mirrors what you'd see on TikTok. We've already covered the debate of TikTok versus Instagram Reels, so I won't go into that here. Instead, I spoke with an Instagram influencer and consultant, Kar Brulhart, who has grown her own Instagram account from 0 to 45,000+ viewers and obtained over six figures in less than 10 months using Reels — all organically. Here, we'll cover Brulhart's tips for how brands can leverage Instagram Reels to reach new audiences and acquire new customers. But first — why Instagram Reels over TikTok? The Benefits of Instagram Reels "A lot of brands...

Best Small Business Ideas

 Are you always fixing things around the house? Often on-call when friends need small projects completed? Create a website, conduct a competitive analysis to determine what your time and expertise are worth, and turn to the friends you’ve helped before for referrals. 2. Woodworker Similarly, if you have a passion for crafting beautiful furniture or other home goods out of wood, that could be a small business niche for you. Get started by listing a few of your pieces on sites like Etsy. Once you build a following, consider starting a website, accepting custom orders, or expanding to refinishing work and upholstery. 3. Online Dating Consultant Dating consultants usually charge for their time. They help people create successful online dating profiles, source possible matches from outside the typical online channels, and offer a level of personalization that a site like Tinder can’t. Think you’ve got a knack for the match? This might be the business for you. 4. Sewing and Alteration Sp...