all PowerToFly Webinars

Excel Masterclass: Filters & Functions Part I

 Excel Masterclass: Filters & Functions Part I

Just want to see this video? 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
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.

Don't Take It Personally... How To Use Feedback For Growth
Don't Take It Personally... How To Use Feedback For Growth

The ability to take negative feedback and turn it into an opportunity for growth isn't something that happens overnight. In fact, there's a large movement surrounding entire organizations adapting their cultures to embrace growth vs fixed mindsets. Let's be clear, changing your mindset doesn't require a movement, but it does require the tenacity to think differently and evaluate how you, yourself provide feedback. Join this live Q&A to discuss how embracing the growth mindset will help us further our careers and stop taking feedback so personally!