Excel Crash Course: Grow Better with Microsoft Excel Skills

Hi, and welcome to this Excel for marketers course presented by GoSkills in partnership with HubSpot Academy. Microsoft Excel is like the Swiss Army knife of software tools, helping marketers become more efficient and accurate in their jobs every day. This is true for marketers across all industries across the globe. You only need a basic understanding of excel to benefit from this crash course, and each video will show you everything you need to know. On the other hand, if you've never worked with Excel before, GoSkills free Excel in an hour course can quickly get you up to speed.

Now for the Excel pros out there, you will be able to pick up some very cool tips and tricks from this course to make your work even more efficient. But for everyone, the objective of this course is to show you how to efficiently use Excel to gain data-driven marketing insights from

data. Large data sets can be complicated to work with, but our aim is to save you time and make sure you are more efficient when working with Excel. So by the end of the short course, you will be able to build your own dashboard just like this one using traffic data from Google Analytics.

This course has three lessons, plus a bonus video. Let me tell you more about it. In the working with data lesson, you'll learn how to import and clean data by learning time-saving techniques and functions like Count If and V look-Up. In the analyzing data lesson, we'll get into the

meat of the course as we delve into tables, sorting and filtering data. We will also cover critical topics such as conditional formatting and the often feared but compelling pivot tables. In the visualizing data lesson, we will pull it all together with some beautiful charts you can create with your data, and you'll walk away with the skills to create your own custom dashboards.

Finally, the bonus video will teach you how to automate the entire process to save you even more time. Here, you will learn how to use a power query to update your dashboard automatically when you add data to your spreadsheet. 

So if you enjoy this course and you'd like to learn more about Excel, visit GoSkills and get a free seven-day trial to learn more about Excel and many of our other courses. I hope you enjoy the course.