all PowerToFly Webinars

Excel Masterclass: Filters & Functions Part II

 Excel Masterclass: Filters & Functions Part II

Just want to see this video? 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
Preparing For Maternity Leave - And What To Expect When Coming Back
Preparing For Maternity Leave - And What To Expect When Coming Back

For any expectant mother, it's nearly impossible to feel fully prepared to go on maternity leave. For expectant mothers at high-growth startups, or women in managerial or c-level roles, this stress is compelled with the notion that the company and team you're leaving will not be the same upon your return. Martha Dreiling, Head of Analytics and Corporate Operations at Attune Insurance, wants you to know that that's ok! Martha has been in your shoes, and is joining PowerToFly to chat about how you can adequately prepare for maternity leave, what you can expect upon return, and how to support your team throughout the process.

Why Customer Success Is Critical For a SAAS Company - The Role Of Women In Customer Success
Why Customer Success Is Critical For a SAAS Company - The Role Of Women In Customer Success

In SAAS, products are changing faster than ever thanks to the evolution of technology. It's safe to say the best way to keep a customer happy during the customer journey is to provide them with the best customer service possible - and this starts with a great customer success program. Join Kamakshi Narasimhan, Senior Director of Technical Success at Netskope for a live Q&A to understand the inter-workings of a SAAS Customer Success team, and the role women play in CS!

Using Public Relations Techniques to Enhance your Personal Brand
Using Public Relations Techniques to Enhance your Personal Brand

"Your brand is the center of everything" says Allison Schroeder, owner of Pomme Communications. But how does one "brand" themselves in today's crowded market? Ask Allison anything, and hear her tips for using public relations techniques she's honed as an accredited public relations practitioner and entrepreneur, building a brand for herself and clients alike.