all PowerToFly Webinars

Excel Masterclass: Filters & Functions Part II

Excel Masterclass: Filters & Functions Part II

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

1 hours 5 minutes
Watch now
Ready to learn more now that you’ve completed how to use Filters & Functions with Spreadsheets and Excel? (Register now, watch the training session anytime from now until 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.) PowerToFly’s Senior Data and Web Analyst will continue her introductory look into the must-have tools that you will need to make the most out of your data. During this on-demand, on-hour virtual seminar, Vanina will dive deeper into the filters, formulas and functions you will need to master any spreadsheet software. In this seminar, we cover again both Google Sheets and Microsoft Excel as well as: Building conditional functions (AND, OR, IF, SUMIF, COUNTIF, etc) Text Functions (LEFT, RIGHT, MID, etc) Conditional formatting Date and time functions How to split strings Searching for text matches Extracting parts of strings Reconstructing a date from string Color code your tables Quickly create conditional calculations for your data (e.g. how many people live in NYC or what are the sales from Seattle, etc.) And if you like what you see, be sure to join us for the following webinars, too: Excel Masterclass 1: Filters & Functions Part I Excel Masterclass 3: Pivot Tables Excel Masterclass 4: Reporting & Dashboards

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.