MARKETING

Power Query Overview

Power Query Overview: An Introduction to Excel’s Most Powerful Data Tools

Key takeaways: Learn how a great Excel and Power BI feature called Power Query helps you automate the import, transformation, and deletion of your data to save your work time. Skill Level: For Beginners Table of Contents1 Introduction to Power Query1.1 Power Query Data Machine1.2 Power Query works in a very similar way!1.3 Responsible for […]

Continue Reading
3 time-saving tips when working with Pivot Table Fields lists

3 time-saving tips when working with Pivot Table Fields lists

Table of Contents1 Prevent actions Pivot Table ( Pivot Table Task Pane )1.1 Tip # 1: Change the layout of the list of schools1.2 Tip #2: Unlock and move the field list1.3 Tip #3: Reopen the field list when closed2 Bonus: Manage multiple task panes Prevent actions Pivot Table ( Pivot Table Task Pane ) […]

Continue Reading
Split delimiters into rows (and columns) with Power Query

Split delimiters into rows-columns with Power Query

Key takeaways: Learn how to use Power Query’s row and column separator features. Also, see how to trim gaps and replace values. Skill Level: Medium Table of Contents1 Convert email addresses into an organized list2 Use Power Query to create a table2.1 1. Split the delimiter into rows2.2 2. Split the delimiter into columns3 Clean […]

Continue Reading
10 Must-have digital marketing tools to help you grow

10 Must-have digital marketing tools to help you grow

Table of Contents1 1. Effortlessly2 2. Hotjar3 3. Clearbit4 4. Datanyze5 5. OptiMonk6 6. Use a Typeform7 7. MailMunch8 8. Creatopy9 9. Visme10 10. VenngageVenngage is another graph 1. Effortlessly Optimizely, which focuses on landing page experiments, combines graphic creation and audience targeting capabilities to allow you to swiftly perform tests on different parts of […]

Continue Reading