all PowerToFly Webinars

Excel Masterclass: Filters & Functions Part I

Excel Masterclass: Filters & Functions Part I

For quick access to this video only, please enter your email.

1 hours 19 minutes
Watch now
Up Your Excel Skills With This Busy Mom Who Won’t Waste Your Time (Download Now and Take the Class 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.) Have one hour to learn everything you need to know about Excel and Google Spreadsheet filters and functions? We made this quick - yet full and valuable - course that won’t waste your time. PowerToFly’s Senior Data and Web Analyst (and mom of two) will guide you through key formulas to make the most of your data. In this masterclass, we cover both Google Sheets and Microsoft Excel and the following topics: Formatting LOOKUP functions Conditional Functions (IF, etc) Sorting, TRIM Concatenate Basic statistical functions including correlation and forecast Remove duplicates from lists Merge data from several sources into a single table Calculate the correlation between variables Perform a simple linear forecast model You will receive access to webinar materials you can complete in your own time as soon as you complete payment. Once you’re done with the first Excel Masterclass, you can download: Excel Masterclass 2: Filters & Functions Continued (Coming Soon) Excel Masterclass 3: Pivot Tables (Coming Soon) Excel Masterclass 4: Reporting & Dashboards (Coming Soon) "I already know a decent amount about excel and learned some new tricks- so worth the hour! This helped me think about its uses in new ways- thank you!" - Blair

More Live Chats That Might Be Interesting For You

see all upcoming live chats
Pivoting Into An Engineering Career
Pivoting Into An Engineering Career

Career pivots are becoming the norm thanks to bootcamps and a plethora of online resources. It's safe to say that pivoting into a career in engineering isn't as challenging as it once was - but still a pretty daunting task! Anjali Merchant and Hannah Barton are both career pivoters who've found a home at Polis, a company that's reinventing how people communicate. Ask Anjali and Hannah anything about becoming engineers in this live chat - and find out more about the company they call home! You asked, they're answering: What did you do before working at Polis? Which route did you take to become engineers? What advice do you have for other pivoters looking to start a career in Engineering? Is Polis hiring? & more! MEET THE SPEAKERS: Anjali Merchant Anjali graduated with a B.A. from Middlebury College and M.S. from Yale University. After working as a technology consultant, Anjali studied full-stack software engineering at the Grace Hopper Program, an all women programming school. She is currently a software engineer at Polis. Hannah Barton Hannah received her bachelor’s degree in Philosophy with a minor in Physics at Brandeis University. After working in sales at a large organic food company for several years, she attended Grace Hopper and switched careers into software development. She works as a software engineer at Polis.

How To Be Customer Centric | Tips For Nailing Your Next Leadership Role
How To Be Customer Centric | Tips For Nailing Your Next Leadership Role

Customers are at the core of most businesses, but not every business takes the time to understand what their customers actually want and need. Great Leaders are customer centric - and in this live Q&A you'll learn how to leverage those customer relationships to nail your next leadership role! Ask Irit Eizips, a Customer Success thought leader anything, and take your career (and your Customer Success program) to the next level. MEET THE SPEAKER: Irit Eizips is Customer Success thought leader who’s mission is helping high growth companies, establish a proactive and scalable customer success practice. Irit is frequently featured in podcasts, books, and industry events as a subject matter expert on customer success strategy. In 2014, Irit founded CSM Practice, a boutique consulting firm providing scalable solutions to reducing churn, increasing upsells and growing advocacy. Connect with Irit Eizips on Twitter, YouTube or sign up for her weekly Customer Success newsletter. About CSM Practice: CSM Practice specializes in the design and implementation of best of breed scalable customer success programs using an optimal combination of strategy, playbooks, and technology. CSM Practice is the first to develop accelerated methodologies for customer success programs and is continuously producing thought leadership content for the Customer Success community. The company was founded in 2014 and is headquartered in Sunnyvale, California. Additional information can be found at www.csmpractice.com or connect with CSM Practice on Twitter, Pinterest, Instagram and Facebook.

Making Your Workplace Supportive For Women To Thrive As Leaders
Making Your Workplace Supportive For Women To Thrive As Leaders

How can we foster more inclusive workplaces where women can not only become leaders at their organizations, but thrive in these leadership roles? Join Anya Cherneff, Founder of Empower Generation and member of the AAA Community Impact team, for a live, virtual Q&A, to learn how she's helped support and implement changes to help women level-up their careers globally. MEET THE SPEAKER: Anya Cherneff is the founder of Empower Generation and currently serves on the Board of Directors. (merged with The Pollinate Group in 2018) — a social enterprise that trains and supports rural women to lead inclusive businesses that deliver clean energy solutions to remote and slum communities in Nepal and India. Anya has dedicated her career to empowering women to power the world. She currently works at AAA as part of the Community Impact team, where she manages the AAA School Safety Patrol Program and serves as Chair of the Women.Empower Business Resource Group, where she builds and manages the leadership team and guides strategy that improves the workplace for women company-wide. Anya holds a MA in International Human Rights from the University of Denver and a BA in Anthropology from Columbia University.