Corso Excel for Marketers Crash Course: Learn the Fundamentals of Microsoft Excel

Abstract

Course delivered in English
Lessons: 3
Level: Beginners
Access: Free Online Course (Audit)

Course info:

As a marketer, you are likely using multiple systems to manage your data, including Google Analytics and a CRM. Analyzing data across disparate systems can be a challenge. That's where Excel comes in. In this course, you'll learn how to import your data into Excel and use functions, the value of tables and how to use them, how to create your own metrics dashboard, and how to automatically update your data regularly.

Excel for Marketers Crash Course has 11 videos and can be completed in just 60minutes

  • Importing and Cleaning Data - 7 minutes
  • Counting Items Based on Certain Critera - 5 minutes
  • Merge Data From Different List - 6 minute
  • Quiz yourself - 4 questions
  • Tables to Make Life Easier- 9 minutes
  • Sort and Filter With Tables - 5 minutes
  • Pivot Tables From Tables - 8 minutes
  • Conditional Formatting to Dynamically Add Color to Reports - 6 minutes
  • Quiz yourself - 7 questions
  • Charts as a Visualization Tool - 8 minutes
  • Dashboards to Display Critical Information - 10 minutes
  • Quiz yourself - 4 questions
  • Bonus: Using Power Query to do the Heavy Lifting - 7 minutes
  • Level Up Your Skills With the GoSkills Basic & Advanced Excel Course - 1 minutes
  • Preview the Excel Basic & Advanced Course From GoSkills - 2 minutes

Obiettivi didattici

Who is this for?

  • Marketers
  • StudentsStudents
  • Individual Contributors

What you'll learn:
- Format data in Excel and use formulas to gather insights
- Use tables to sort data and create pivot tables.
- Create your own metrics dashboard.

Why this Certification might prove useful to you?

Improve CV

  • By becoming certified, you can demonstrate to employers that you have a clear understanding of ecommerce Email Marketing
  • You can also add the certification to your CV and easily upload it to your LinkedIn profile.

Building a Career

  • Certification is proof of your real digital skills and your desire to learn - two essential qualities in today's business world.
  • If you demonstrate these qualities, you are more likely to find the job you want.
  • By improving your digital knowledge, you can find a job, get a promotion or start a new career.
  • Learn new skills with short video tutorials, then test your preparation with quick quizzes.
  • Take the final exam

Struttura del corso

This course is managed by the external partner Hubspot Academy. In order to take this course you will need to register on their Academy platform where you can take advantage of this and many other courses on offer.Hubspot Academy will not issue you a Certification. We will do it!

Once you have finished the course, go back to the course page in Guilds42 to upload proof of completion (jpg / png / pdf). Your document will be evaluated and if appropriate and verifiable, you will find this certification validated in the dashboard.

Foto di HubSpot
HubSpot
Lead Generation
Corso aperto dal 16/02/2021
Durata 1

Questo corso include: