Excel Masterclass: Pivot Tables
Feb. 12th 2018
Now that you're a spreadsheet wiz after taking Excel Masterclass: Filters and Functions I & II- it's time to take that knowledge you've learned and start creating pivot tables!
Join PowerToFly for Part 3, Excel Masterclass: Pivot Tables
During this on-demand, one hour virtual seminar, PowerToFly's Senior Data and Web Analyst, Vanina, will dive deeper into pivot tables and why they are an awesome tool to organize and summarize your data. The seminar will explore pivot tables in both Excel and Google Sheets so that you can be an expert no matter which system you use.
(Register now and watch the training session anytime - Availability Runs through December 31, 2018! You will receive a separate email in your inbox with a link to the seminar after you have completed your purchase. If you would like to access all of our on-demand webinars for free, sign-up for a PowerToFly VIP membership.)
And if you like what you see, be sure to join us for the following webinar, too:
Excel Masterclass 4: Reporting & Dashboards (Coming Soon)
Are you interested in hosting your own webinar!? If you're a subject matter expert in tech, sales, marketing (and more) send us an email to email@example.com with your idea, and we'll be in touch!
10 Full-Time Roles You Can Do Remotely!
Work-from-home jobs sometimes get a bad reputation: low pay, repetitive work, micromanagement... the list goes on. But if one good thing has come out of the pandemic, it's that it's redefined working from home. Remote work has come a long way, and the opportunities to work from home in 2022 are more promising than ever before.
If you're like me, and freelance, task-oriented remote jobs like article writing, data entry, transcription, or professional survey taking (yep, that exists), aren't your thing - don't worry. There are more full-time remote opportunities than ever before that offer you the freedom to manage your own time, the security of consistent monthly income, the support of a team, and the promise of growth. In fact, we've got over 5,000 on PowerToFly.
So, if you're looking for a remote opportunity in 2022 that will push you to develop professionally, look no further than our list of the 10 best work-from-home jobs. And by best, we mean fun, challenging roles that will help you grow, while making a respectable income.
All the jobs listed have average salaries between 45 and 119k, and have average or higher-than-average growth potential (based off of the U.S. Bureau of Labor Statistics' predictions for growth from 2018 to 2028 and/or LinkedIn's 2020 Emerging Jobs Report).
10 Best Work-From-Home (Remote) Jobs for 2022
Jobs sorted from highest to lowest average salary. (Salary data taken from ZipRecruiter, Glassdoor, LinkedIn, and/or the U.S. BLS depending on availability and specificity to remote roles.)
1. Data Scientist
Who It's Good For: Detail-oriented stats masters skilled at identifying and understanding trends.
Why You Can Do It Remotely: With more data than ever before at our fingertips, companies know the value of hiring folks who know "big data" as more than just a buzzword. True stats buffs are hard to come by, so expertise often outweighs location.
Growth 2018-2028: 33%
Average Annual Salary: $114,000
2. Software Developer/Engineer
Who It's Good For: Self-directed (and disciplined) coding enthusiasts who love problem solving and having the freedom to work whenever they feel most focused.
Sound Like You? Check Out: 5,500+ Software Developer/Engineer jobs on PowerToFly and be sure to check out this Q&A with software engineer, Kasey Champion to learn about her experience working at a fully remote company and get her tips for acing technical interviews!)
Why It Can Be Done Remotely: Arguably, not only can programming be done remotely - it should be! Why? Writing code requires undisturbed blocks of time rarely found in traditional workplaces.
As computer scientist and entrepreneur Paul Graham observed in his essay on makers' vs. managers' schedules:
" Most powerful people are on the manager's schedule...But there's another way of using time that's common among people who make things, like programmers and writers. They generally prefer to use time in units of half a day at least. You can't write or program well in units of an hour. That's barely enough time to get started."
Office culture was designed with managers' schedules in mind, and thus makes adhering to a maker's schedule extremely difficult. Remote work, alternatively, is much more conducive to this. After all, it's a lot easier to snooze your Slack notifications than it is to ignore your boss literally hovering over your shoulder.
Growth for 2018-2028: 22%
Average Annual Salary: $114,000
3. Designer (Web, Graphic, Product, or UI/UX)
Who It's Good For: Designers who do their best work independently or from the comfort of their own home.
Sound Like You? Check Out: Remote Design Roles
Why You Can Do It Remotely: No doubt there's value in brainstorming with your team, but once you know the needs of a project, most design work can be done independently and then shared. With tools like Zoom, Jira, and Slack, it's easier than ever before to share your work, get feedback, and hit deadlines. (And, like programmers/developers, designers are also more likely to benefit from a maker's schedule!)
Average Annual Salary (for UX Design): $89,000
Average Median Salary (for Graphic Design): $50,000 in 2021, according to data from Indeed
4. Product Manager
Who It's Good For: Anyone who loves big-picture strategy and building products that users will love.
(If you enjoy more nitty-gritty task oversight, consider project management instead — both roles can be done remotely! You can learn more about the differences between the two PM roles here.)
Why You Can Do It Remotely: As more and more software engineers and other tech professionals work remotely, it only makes sense that the PMs coordinating with them work remotely. If you're a virtual communication wiz comfortable communicating online and using tools like Zoom, GitHub, Jyra, Slack, and Asana (the list goes on...), then you're all set!
Annual Growth: 24%*
*Based on expected growth for Product Owner from LinkedIn's in demand jobs report. The BLS doesn't currently track growth specifically for Product Manager positions.
Average Annual Salary: $95,000
5. Workplace Diversity Expert
Who It's Good For: HR professionals or creative and strategic individuals who has experience developing and implementing diversity initiatives and strategies.
Sound Like You? Check Out: Remote DEI Expert Jobs
Why You Can Do It Remotely: DEI experts work closely with every team in an organization organization. They can ensure that diversity agendas are successfully implemented and in line with businesses objectives for everyone, hybrid and remote teams included.
Growth for 2018-2028: 56%*
*Based on expected growth for Indeed's Career Guide. The BLS doesn't currently track growth specifically for DEI positions.
Average Annual Salary: $86,000
6. Technical Writer
Who It's Good For: Top-notch communicators (writers) who can explain complex topics succinctly and clearly. (It's helpful if you have expertise in at least one technical subject.)
Sound Like You? Check Out: Remote Technical Writer Jobs
Why It Can Be Done Remotely: Like programmers, technical writers are makers - they need large, undisturbed blocks of time to create content. Technology and the nature of remote work can help ensure writers are able to communicate efficiently with their teams and organize meetings when they'll be constructive, not distracting.
Growth for 2018-2028: 12%
Average Annual Salary: $57,000
7. Customer Success Manager
Who It's Good For: Good communicators who love helping others and problem-solving.
Sound Like You? Check Out: Remote Customer Success Roles
Why It Can Be Done Remotely: Most customer service needs can be met over the phone and online. With a computer and good internet connection (and enough patience), you can handle all your customers' needs from wherever you are.
Growth for 2020: 25% annual growth rate (The BLS doesn't share data specific to customer success, but thanks to the growth of SaaS, Customer Success Specialist made LinkedIn's 2020 list of the top 15 in demand jobs)
Average Annual Salary: $58,000
8. Marketing Manager
Who It's Good For: Folks who are equal parts creative and analytical.
Sound Like You? Check Out: Remote Marketing Manager Jobs on PowerToFly
Why You Can Do It Remotely: Analyzing industry trends and crafting strategy can be done from anywhere. And with teams becoming more and more spread out, you can coordinate cross-functionally with sales people, engineers, and more using Zoom, Slack, and other online tools.
Growth for 2018-2028: 10%
Average Annual Salary: $63,000 (according to data for remote professionals from Indeed)
Average Median Salary: $141,490 in 2020, according to the U.S. BLS (not specific to remote roles)
Who It's Good For: A people-person skilled in market research, project/time management, and negotiation.
Sound Like You? Check Out: Remote Recruiting Roles
Why You Can Do It Remotely: As remote work takes off and fully remote teams become more common, it only makes sense that recruiters at these companies would be remote as well. Although recruiting saw a dip at the start of the pandemic, the number of remote recruiting roles is steadily increasing as companies ramp back up their hiring goals—we have hundreds of open remote recruiter roles on PowerToFly!
Growth for 2018-2028: 10%
Average Annual Salary: $50,000
10. Sales Development Representative
Who It's Good For: A self-starter with previous experience or an interest in Sales, or anyone who's just starting out and eager to prove themselves!
Sound Like You? Check Out: Remote SDR Roles
Why You Can Do It Remotely: You don't need to be in a particular location to make sales calls, deliver pitches, send follow-up emails, or manage your sales team. And if you have to fly from an office to meet a client, you can just as easily fly from your hometown.
Growth for 2018-2028: 7%
Median Annual Salary for SDRs: $64,000
Interested in one of the roles above? Check out these resources for landing your dream remote job and get ready to reap the full benefits of remote work in 2022— doing what you like, where you like. Good luck!
[A version of this article was originally published on Dec. 19, 2018]
During a time period that has changed how we work and caused many of us to refocus what we value, women have continued to find ways to connect and support one another. Financial health and literacy became increasingly important. Inspired by the 2019 Women, Money, and Power Study, commissioned by Allianz Life Insurance Company, which indicated that over half (57%) say they wish they were more confident in their financial decision making, a group of women were inspired to act.
Supported by the Women@ employee resource group and Life@ benefits team, a team of five women joined together to empower their fellow community members and peers to become confident in their finances.
Setting the goal to help women at work: Minki J., Program Manager Product Testing
Leading the effort, Minki J. began with a passion for personal finance and the desire to support the Women@ employee resource group community.
Minki J. is Program Manager Product Testing (New York), brought together a group of five women to create the educational materials for a financial literacy program.
"It is my strong belief that a good financial foundation and the confidence to improve and better manage your money is one of the fiercest forms of female empowerment." Minki shared. "Bring your authentic self to work is one of our core tenets at work - and that's how the program started. Financial empowerment for women is a life mission of mine. I brought the lessons learned and templates from my previous experiences, and was able to congregate a group of superwomen who were willing to volunteer their time and expertise so that more of our female colleagues could lift up and feel confident in their money journeys as well"
Together with Nellie H., Optimization Program Manager, (Dublin), Tricia W., Business Integrity (New York City), Kirsten N., Government, Politics & Non-Profits Partner Manager (Berlin), and Monse M., Global Diversity Brand Strategy Manager (Chicago), they created a six-week Financial Literacy Learning Sprint covering education on topics like fundamental financial wealth, budgeting, debt, investing, and retirement planning (401K, pension). This small team of five volunteers created educational materials, used Workplace groups and other virtual workplace tools to connect participants for the pilot program.
Kirsten N. Government, Politics & Non-Profits Partner Manager (Berlin) gives an overview of the financial literacy program materials.
"The financial literacy program was designed to be a safe space for women to talk about their financial well-being, money matters, and to educate themselves and create more structure when it comes to these financial issues. We put together all of these wonderful materials and shared them with tons of incredible women."
Tricia W. Manager, Business Integrity (New York) speaks to the inspiration of the collective group.
Tricia spoke to the inspiration and collective aspiration of the group, "From wage gaps to pink tax to longer life expectancy, there are many financial challenges that hit women differently. We hoped to build a community of support around these challenges as much as empowering and improving confidence in managing finances."
Creating Connections and Empowering Women Globally
The pilot kicked off virtually in 2020, with 22 Women@ community members. The second cohort grew to 230 women, the third to 756 women and the fourth is set to go live reaching women across the US, Singapore, UK, Ireland, Mexico, Brazil, Canada, Norway, Sweden, Denmark, and Switzerland.
Nellie H., Optimization Program Manager (Dublin) speaks to the growth and global expansion of the program.
Nellie explained, "We've been able to scale FinLit to serve a group of more than a thousand women. There are many opportunities to serve our internal and external communities. I'm proud that through the Financial Literacy program I was able to support my colleagues in empowering them to build their financial expertise."
Monse M., Global Diversity Employment Brand Strategy Lead speaks to the program impact on the founders.
"I've never worked at a company where a group of women have come together to create something that could help so many other women at work." Monse M. explains. "I was amazed by the feedback we received from our peers who participated in the program. I love that Meta is the kind of place where women come together to create ideas, have support and access to resources, and can then bring those ideas to life and impact so many; this is true in creating community at work and through our products and services we build for the world everyday."
More about Women@
We are committed to connecting and building a community of women who feel open and connected to each other. We empower women through professional development opportunities and engage with men as equal partners in advancing gender diversity and inclusion. We celebrate the unique contributions of women to Meta.
When women are empowered, there's no limit to what they can do. Join us on our mission to bring the world closer together.
■Learn about life at Meta on Instagram (@MetaCareers).
■Like our Meta Careers Talent Community Page for the latest updates.
💎 Would you like to work at Automattic? Get some valuable tips that will help you ace your interview with the company!
📼 Watch this video to see what it's like to work at Automattic and get some insights into the interview process from Romina Suarez, an Automattic engineer who focuses on engineering hiring.
📼 If you'd like to work at Automattic, the first thing you need to know is they are hiring pragmatic engineers who get things done. They look for engineers who communicate clearly, learn from feedback, design systems, and who will think of the person to come after them. They value an equal mix of effectiveness, positive attitude, and design know-how.
📼 When applying to work at Automattic, make sure you become familiar with the company creed. It's not just a list of things they wrote once and forgot. They actually use it to make decisions, provide feedback, and become better Automatticians. So as you're preparing to apply, think about the creed and how it impacts your experience, insight, and values, and use that information to show the best version of yourself.
Work at Automattic - Interview Process
The first step in the Automattic interview process is a text-based interview, usually done via Slack, where you'll answer a series of questions. After completing this step, you'll be invited to a code test, which will then lead you to the last step: a trial project, where you'll be guided by one of the company's engineers. Make sure to catch Romina's tips for each step of the process!
🧑💼 Are you interested in joining Automattic? They have open positions! To learn more, click here.
More About Automattic
Automattic are the people behind WordPress.com, Jetpack, WooCommerce, Tumblr, and more. Founded in 2005 and valued at $3 billion, they were one of the first companies to pave the way in remote work culture. The company's 1,400+ people hail from 79 countries and speak 99 languages.
Though the workforce is intellectually and geographically diverse, they share a passion for democratizing publishing and commerce—so that anyone with a story can tell it, and anyone with a product can sell it, regardless of income, gender, politics, language, or country. And the company is growing rapidly!
Learn more about the amazing speakers and sponsors from our November 2021 virtual summit Diversity Reboot: Supporting Veterans and Military Spouses; 4 days of fireside chats, panel discussions, networking sessions, and our 1-day virtual job fair featuring 10 companies.
From transitioning into the civilian world after service to honing your entrepreneurial skills as a MilSpouse, we covered it all! If you didn't get a chance to join, we missed you. But you can relive the entire experience on our PowerToFly website.
We want to extend a HUGE thanks to our Platinum sponsor Infor. Our Gold sponsors Automattic, PwC, and NGA. This summit would not have been possible without the contributions of our Influencer sponsors iRelaunch and U.S. Veterans Magazine.
Also, don't forget to visit our Merch Store and grab yourself some PowerToFly apparel, we donate 100% of the proceeds from our sales to TransTech Social, supporting transgender people in tech.
Special Moments from the Summit
Infor Supporting Military Transition
Infor Supporting Military Transition www.youtube.com
Retired General Lori Robinson on Listening
Listening is the Most Powerful Lesson www.youtube.com
There's no Degree to Getting a CEO
There's no Degree to Getting a CEO www.youtube.com
MMA and the LGBTQIA+ Military Community
MMA and the LGBTQIA+ Military Community www.youtube.com
Carving out my Own Journey as an Entrepreneur
Carving out my Own Journey as an Entrepreneur www.youtube.com
Deploying the Future with Operation Code
Deploying the Future with Operation Code www.youtube.com
Our Platinum Sponsors
Infor is a global leader in business cloud software products for companies in industry specific markets. Infor builds complete industry suites in the cloud and efficiently deploys technology that puts the user experience first, leverages data science, and integrates easily into existing systems.
Our Gold Sponsor
Automattic are the people behind WordPress.com, Jetpack, WooCommerce, Tumblr, and more. Founded in 2005, and valued at $3 billion, they were one of the first companies to pave the way in remote work culture. The company's 1,400+ people hail from 79 countries and speak 99 languages.
They're inspiring and empowering their people to change the world. Here, you'll learn with purpose, lead with heart and put your skills to work to make a meaningful difference in the world. As part of a diverse team, you'll build trust and create innovative client solutions in unexpected ways.
The National Geospatial-Intelligence Agency (NGA) delivers world-class geospatial intelligence that provides a decisive advantage to policymakers, warfighters, intelligence professionals and first responders.Anyone who sails a U.S. ship, flies a U.S. aircraft, makes national policy decisions, fights wars, locates targets, responds to natural disasters, or even navigates with a cellphone relies on NGA.
Their mission is to eliminate bias against people who take extended career breaks. Their vision is that every employer running an entry level university internship program has a mid-career reentry program running side by side. They seek to normalize the decision to take a career break and recognize this untapped talent pool for what it is: highly educated, experienced, and motivated. As the pioneering company in the career reentry space, they're in a position to influence the conversations at employers and among relaunchers about what it means to take a career break and the caliber of the relauncher talent pool. As a result, career breaks have been completely reframed: it used to be that a career break was a reason to reject a candidate. Now career breaks are required to be eligible to apply for and participate in employer return to work programs.
The U.S. Military Spouse Chamber of Commerce is on a mission to ensure that all active duty and veteran military spouse business owners have the tools and resources they need to strengthen their families, communities, and our economy. We provide the first of its kinds Military Spouse Owned Enterprise certification, and are the voice of military spouses, advocating to positively impact the business climate for military spouse owned businesses.
Hire Heroes USA provides free job search assistance to U.S. military members, veterans and their spouses, and we help companies connect with opportunities to hire them.
Hire Heroes USA Logo
Learn about other companies that joined us:
Is This Company Right For Me? 3 Must-haves When Choosing Where to Work
💎 So you've come to the final stages of the interview process, but you're still wondering: Is this company right for me? Learn three must-haves that will help you choose the best place to work!
📼 If you find yourself in front of a job offer thinking, "Is this company right for me?" play this video to get three top must-haves from Dionabel Espinola, Customer Success Manager at Veracode.
👉Want to work at Veracode? They're hiring! Check out the company's open jobs:
Solutions Architect, Channel (remote!) https://bit.ly/VeracodeSolutionsArchitectPTF
Senior Software Engineer (remote!) https://bit.ly/VeracodeSrSoftwareEngineerPTF
Principal Customer Success Manager (remote!) https://bit.ly/VeracodePrincipalCustomerSuccessManagerPTF
📼 Tip #1: Look For Work-life Balance. The first tip that will help you answer "Is this company right for me?" is finding an organization that has a true work-life balance. And what Dionabel means by that is a place that encourages employees to take time off, decompress, disconnect, and do the things they love, whether that's spending time with family or reading a book.
📼 Tip #2: Look For Career Growth. The next tip that will help you answer "Is this company right for me?" is making sure you apply to an organization where you will have career growth. Picture yourself there already. "If I work there, what's my next step? What do I want to do? What do I want to be?" And align yourself with that. And it's totally okay to reach out on LinkedIn to current individuals who have that role and ask, "Hey, what does the career path look like for this specific role?" As Dionabel recalls, it can get a little boring when you have a role that changes over time by title and not responsibility. So for her, it was crucial to continue being challenged, hence the huge career switch she made at Veracode.
Is This Company Right For Me? Last But Not Least Must-Have
The third must-have is diversity and inclusion. Dionabel says, "As a person that identifies as a person of color, I am Dominican, I'm very proud of my roots. I wanted to make sure that where I was going, things like this were being celebrated because I think this is what brings us even closer to each other."
Dionabel knows her must-haves may not be the same for everyone. So she highly encourages you to grab a pen and paper, jot down the top three things you must have at work, and at the end of the day, don't forget that you are your best advocate. Advocate for yourself and the things you want because no one else will do it better than you!
📨 Are you interested in joining Veracode? They have open positions! To learn more, click here: https://bit.ly/VeracodePTF
More About Veracode
Veracode delivers the application security solutions and services today's software-driven world requires. Veracode's unified platform assesses and improves the security of applications from inception through production so that businesses can confidently innovate with the web and mobile applications they build, buy, and assemble as well as the components they integrate into their environments.
Veracode's powerful cloud-based platform, deep security expertise, and systematic, policy-based approach provide enterprises with simpler and more scalable ways to reduce application-layer risk across their software infrastructures. Veracode serves hundreds of customers across various industries, including nearly one-third of the Fortune 100, three of the top 4 U.S. commercial banks, and more than 20 of Forbes' 100 Most Valuable Brands.
0:00 The Perfect Work-life Balance
0:09 Introducing Veracode
0:26 Tip 1: Work-life Balance
1:21 Tip 2: Career Growth
2:11 Tip 3: Diversity and Inclusion
2:51 Tip Summary
3:34 Share Your Own Tips!
#Veracode #jobmusthaves #TopTips #workatVeracode #PowerToFly #careeradvice