Training

Excel Masterclass: Filters & Functions Part II

This event has ended. You can watch the recording here.
Excel Masterclass: Filters & Functions Part II
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