NCPMI in partnership with Dr. Holly Sullenger, also known as Dr. Holly Speaks, is offering a Web Seminar Series on Excel Data Analytics. These $10 sessions will be hosted online via ZOOM by Dr. Holly Sullenger and associates.
This series of 10 sessions will be held for one hour 12pm – 1pm EST on the following dates:
Smart Worksheet Creation: Best Practices, Tips, Tricks and Shortcuts
Fun with Functions Part 1: Naming Cells and Ranges, IF, Boolean IF, Nested IF, SUMIF, SUMIFS
Fun with Functions Part 2: Concatenation, Text to Columns, Substring Functions, Date Calculations
Combining Data: Workbook Concepts with 3D Calculations, Linking External Workbooks, Consolidation
Conquering Data: Custom Sorting, Subtotals, Filters and Advanced Filters
Finding and Displaying Relevant Data: VLOOKUP, HLOOKUP, MATCH and INDEX, Goal Seek
Troubleshooting: Data Validation, Auditing tools, IFERROR, Locating Formulas, Worksheet and Workbook Protection
Dashboard Visualizations Part 1: Charts and Graphs, Sparklines, Conditional Formatting
Dashboard Visualizations Part 2: Pivot Tables, Pivot Charts, Slicers
Introducing the Excel Power BI tools: Power Query and Power Pivot
IMPORTANT NOTE: Registration is on a first come, first serve basis. These sessions will be led by Dr. Holly Sullenger, an NCPMI Chapter meeting speaker. You can attend all ten sessions to earn a total of 10 PDUs and you will need to self-report. By registering, you agree to share your contact information with the facilitator. One day prior to the event, you will be emailed the URL to join the session. Be sure to log in to the website in order to get the member discount.
About the Speaker:
Dr. Holly is a life-long professional in the field of corporate speaking, training, and consulting. She offers corporate speaking services, seminar facilitation and edutainment in the areas of leadership, professional development and technology. Dr. Holly has a passion for helping employees stay relevant in their fields.
Dr. Holly has worked with individuals representing a vast array of different occupations and industries. She is a sought-after speaker, trainer and facilitator known for being able to present high-level topics in ways that make the content easy to understand, to assimilate, and to act on.
Dr. Holly has a PhD in Adult, Workforce and Continuing Professional Education from NC State University, as well as degrees in Adult Education, Business Management, Computer Science and Liberal Arts. This enables her to combine an in-depth knowledge of business and industry with adult-education techniques and infused humor in order to bring unparalleled knowledge and assistance to those she partners with.
|Event Date||08-27-2020 12:00 pm|
|Event End Date||08-27-2020 1:00 pm|
|Registration Start Date||06-17-2020|
|Cut off date||08-25-2020 11:55 pm|
|Individual Price||$10 for members (be sure to login to website); $15 for non-members|
|No. of Technical PDUs||1|
|Location||Virtual (URL for the session will be provided prior to each weekly session)|
Dr. Holly A. Sullenger 919-649-8068 DrHollySpeaks@gmail.com http://www.DrHollySpeaks.com http://www.Facebook.com/DrHollySpeaks www.LinkedIn.com/in/HollyASullenger