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
*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!