Only basic knowledge of Excel is required to benefit from this course. Current Excel pros will also pick up some useful tips and tricks to harness the power of Excel for marketing analytics.
Learn how to:
- Import and clean data to ensure it’s error-free.
- Organize your data with tables, sorting, and filtering.
- Merge data from different lists with functions like VLOOKUP, and XLOOKUP.
- Count data based on certain criteria with COUNT and COUNTIFS functions.
- Create the often-feared but exceptionally helpful Pivot Tables.
- Apply conditional formatting to better visualize your data.
- Produce beautiful charts to present your data.
- Build a custom dashboard and automatically update it with Power Query.
Once enrolled, our friendly support team is here to help with any course-related inquiries.
Summary
- Skill level: Beginner
- Lessons: 11
- Pre-requisites: None
- Estimated study time: 1h 15m
- Certificate: Yes
- Accredited by: CPD
- Versions supported: 2016, 2019, 365
- Video duration: 4h 30m for all materials
Features
Premium video tutorials
Personalized Learning
Learn at your own pace
Tests and Quizzes
Award winning instructors
Get Certified
Mobile - Learn on the go
Regularly updated content
Accreditations & Approvals
All courses under each learning path are accredited and approved by one or more of the following bodies as is applicable.
Instructors
All courses are taught by reputed trainers with relevant accreditations and industry experience.
Modules
Introduction
An introduction to the course
Importing and Cleaning Data
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.
Counting Items Based on Certain Criteria
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.
Merging Data from Different Lists
XLOOKUP and VLOOKUP enable you to merge data to add greater context to the data.
Tables to Make Life Easier
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.
Sort & Filter with Tables
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.
Pivot Tables from Tables
You often need to make sense of data using a variety of reports and stats. Pivot tables help you do just that.
Conditional Formatting to Dynamically Add Color to Reports
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.
Charts as a Visualization Tool
In our quest to visually represent data, a chart is indispensable.
Dashboards to Display Critical Information at a Glance
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.
Use Power Query to do the Heavy Lifting
Power Query automates the process of getting data into a table and performing routine edits.z
Target Audience
- Graduates exploring placement in the Microsoft Excel positions across industries
- Professionals needing upskilling to be future-ready or become more productive in their current roles
- Experienced individuals exploring Excel for Marketers
How do I Access The Program
- Buy the course online
- Save your payment transaction receipt for any future reference
- Our team will share the credentials to enable you access your course online within 2 business days of payment transfer
Bulk Orders
Incase you are looking for bulk user licenses, or customized Learning Paths for various Job Roles, reach out to us with your detailed requirements.
Reviews
There are no reviews yet.