Focus video player for keyboard shortcuts
Auto
  • HD
  • 720p
  • 540p
  • 360p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc

We hope you enjoyed this lesson.

Get the Excel for Marketers course for more great video tutorials.

Start free trial

Cool lesson, huh? Share it with your friends

About this lesson

An introduction to the course

Exercise files

There are no related exercise files for this lesson.

Quick reference

In this course, we will cover:

  • Working with Data
    • Importing and Cleaning Data
    • Counting Items Based on Certain Criteria
    • Merging Data from Different Lists
  • Analyzing Data
    • Tables to Make Life Easier
    • Sort & Filter with Tables
    • Pivot Tables from Tables
    • Conditional Formatting to Dynamically Add Color to Reports
  • Visualizing Data
    • Charts as a Visualization Tool
    • Dashboards to Display Critical Information at a Glance
  • Automating the Process
    • Use Power Query to Do the Heavy Lifting
Login to download
  • 00:04 Hi, welcome to this Excel for Marketers course presented by GoSkills.
  • 00:08 Now, Microsoft Excel is like the Swiss Army knife of software tools,
  • 00:13 helping marketers become more efficient and accurate in their jobs every day.
  • 00:18 And this is true across all industries across the globe.
  • 00:22 You only need a basic understanding of Excel to benefit from this course.
  • 00:27 In each video, we'll show you everything you need to know.
  • 00:29 Now for the Excel pros out there, you will be able to pick up some very cool tips and
  • 00:34 tricks from this course to make it even more efficient.
  • 00:39 But for everyone, the objective of this course is to show you how to easily
  • 00:44 use Excel to gain data-driven marketing insights from data like this, right?
  • 00:50 This kind of stuff is really difficult to work with.
  • 00:52 But our aim is to save you time and
  • 00:54 make you more efficient when working with Excel.
  • 00:56 So by the end of this short course, you'll be able to build your own dashboard just
  • 01:01 like this one using traffic data from Google Analytics.
  • 01:04 So this course has three sections plus a bonus lesson,
  • 01:07 let me tell you more about it.
  • 01:09 In the Working with Data section, you'll learn how to import and clean data.
  • 01:14 We'll also show you some time-saving and error reducing techniques and
  • 01:19 functions, like COUNTIF, VLOOKUP, and XLOOKUP.
  • 01:23 Then in the Analyzing Data section, we'll get into the meat of the course,
  • 01:28 when we dig into tables, sorting and filtering data, conditional formatting,
  • 01:33 and the scary but exceptionally powerful pivot tables.
  • 01:37 In Visualizing Data,
  • 01:38 we'll pull it all together to create some beautiful charts with your data.
  • 01:42 Here, you'll also learn the skills to create your own custom dashboard in
  • 01:46 Excel so you can get a bird's eye view of your traffic data.
  • 01:50 And finally, the bonus lesson is to teach you how to automate the entire
  • 01:55 process to save even more time.
  • 01:57 Here, you'll learn how to use Power Query to update your dashboard
  • 02:01 automatically when you add next month's data to your spreadsheet.
  • 02:05 There's plenty to cover here, so let's get started.
  • 02:09 We hope you enjoy the course.

Lesson notes are only available for subscribers.

Gift this course