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
*LIVE* Interview Coaching 2/27
*LIVE* Interview Coaching 2/27

Do you want to ace your next interview? Join this free interview coaching session with our Career Coach, Heather Coll, to learn the expert tips you need to succeed! One lucky attendee will score a free session during the call, LIVE with Heather! How can I get chosen!? Register for this chat Email your resume and ONE JOB LISTING you're interested in applying for, to Heather@powertofly.com by 12:00pm EST the day of the chat (3/27) Join the call! Only those on the call will be eligible. Didn't get selected? Don't worry! Sign up for a 1:1 session with Heather here!

*LIVE* Profile Review With PowerToFly Career Coach 3/2
*LIVE* Profile Review With PowerToFly Career Coach 3/2

Want to get your LinkedIn and PowerToFly profiles reviewed by a career coach… for free? Then join us for this live virtual chat with PowerToFly’s Career Coach, Heather Coll, for the chance to get her expert tips on how to make your profiles stand out to recruiters! How can I get my profile reviewed by Heather, Live? Register for this chat Join the call early Share the link to your profile in the chat The profile will be selected randomly at 3:01! Didn't get selected? Don't worry! Sign up for a 1:1 session with Heather here!

Virtual Book Club - February Discussion
Virtual Book Club - February Discussion

February — Becoming In her memoir, Michelle Obama takes us all the way from her years growing up on the Southside of Chicago to her time in the White House and her life afterwards. She shares everything from the struggle she felt as an executive balancing her career and motherhood to her triumphs in the White House, and reflects on how she persevered through it all. Click here to see the complete list of our 2020 Virtual Book Club picks and follow us on Instagram to join our book giveaway!