An introduction to the course
Video time: 02m 19s
As a Marketer, it’s incredibly important to have up-to-date, clean data. In this lesson we apply some common edits to unusable data to clean it up for use.
Video time: 07m 35s
This lesson will show you COUNTIF and COUNTIFS that will allow you to quickly gather insights from your data based on the frequency of information.
Video time: 04m 58s
XLOOKUP and VLOOKUP enable you to merge data to add greater context to the data.
Video time: 06m 36s
If you often work with data sets that are quite large, then you might consider using an Excel table. Tables have a lot of functionality automated and make life easier.
Video time: 09m 02s
If you have a large dataset, it’s easy to get overwhelmed with too much information. Sorting and filtering help you reduce large amounts of data so that you can focus on only the relevant data.
Video time: 05m 32s
You often need to make sense of data using a variety of reports and stats. Pivot tables help you do just that.
Video time: 07m 49s
Conditional formatting can highlight items based on rules you set and, as the data changes and other data meets the requirements, your highlights will change automatically.
Video time: 05m 46s
In our quest to visually represent data, a chart is indispensable.
Video time: 08m 34s
Having a macro-level - or a birds-eye view - of your marketing efforts is essential. It allows you to see trends, make better business decisions, and point out areas to investigate.
Video time: 09m 50s
Power Query automates the process of getting data into a table and performing routine edits.
Share this course
Start a tour to see how the lessons work
or dive right into your course. You can always access the tour at a later time.
How is your GoSkills experience?
Your feedback has been sent
© 2023 GoSkills Ltd. Skills for career advancement