Excel Data Analytics and Power BI presented by Dr. Holly Sullenger – Session 1 Smart Worksheet Creation: Best Practices, Tips, Tricks and Shortcuts

Abstract:

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. 

Topics include:

• Understanding Functions (IF, SUMIF, VLOOKUP)
• Sorting, Filtering and Subtotaling Data
• Pivot Tables, Pivot Charts and Slicers
• Overview of the Power BI Tools

This series of 10 sessions will be held for one hour 12pm – 1pm EST on the following dates:

June 25th

Smart Worksheet Creation: Best Practices, Tips, Tricks and Shortcuts

July 2nd

Fun with Functions Part 1: Naming Cells and Ranges, IF, Boolean IF, Nested IF, SUMIF, SUMIFS

July 10th

Fun with Functions Part 2: Concatenation, Text to Columns, Substring Functions, Date Calculations

July 16th

Combining Data: Workbook Concepts with 3D Calculations, Linking External Workbooks, Consolidation

July 23rd

Conquering Data: Custom Sorting, Subtotals, Filters and Advanced Filters

July 30th

Finding and Displaying Relevant Data: VLOOKUP, HLOOKUP, MATCH and INDEX, Goal Seek

August 6th

Troubleshooting:  Data Validation, Auditing tools, IFERROR, Locating Formulas, Worksheet and Workbook Protection

August 13th

Dashboard Visualizations Part 1: Charts and Graphs, Sparklines, Conditional Formatting

August 20^th

Dashboard Visualizations Part 2: Pivot Tables, Pivot Charts, Slicers

August 27^th

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.