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