Excel For Marketers

A simple guide on how to use Excel in your career: basic knowledge of simple functions, Excel tools, charts creation

What you'll learn

You'll get fundamental knowledge of using Excel

You'll understand how to do different types of calculations in Excel: from simple math operations to complicated functions

How to import data into Excel and use formulas

You'll learn the value of tables and how to work with a table’s functionality

How to import your data into Excel

How to create your own metrics dashboard, and how to automatically update your data regularly

What Excel tools can you use to analyze information?

Key rules for effective data visualization using charts

Requirements

This course is for beginners, so no background skills are needed

Description

As a marketer, you most likely use a variety of data management technologies, such as Google Analytics and CRM. Data analysis across many platforms may be challenging. This is where Excel can help. Excel is one of the greatest spreadsheet solutions because it can be used not only for research but also for data analysis and reporting.But, if it's so unique, why don't most marketers employ it? This could be due to the fact that people are scared by a large number of formulas and functions. We created this course to help you understand Excel from A to Z and start to use it in your daily marketing work.In this course, we’ll teach you how to be effective and fast in Excel. For your convenience, the course will be divided into 4 sections:FundamentalsCalculationsAnalyze DataData VisualizationWe’ll start with an introduction to the interface, and finish with creating charts for data visualization. You will gain foundational knowledge that most employers require.WHO IS THE INSTRUCTOR?Denys Sokotov — Data Analyst at an IT Services and Consulting company. 4+ years of experience with Excel, 2 years in the data analytics field, 40+ dashboards and reports developed, Google Data Analyst Certificate, finalist of the analytics challenge (419 participants, 9 finalists).During the course, the instructor will show many examples, so we advise you to repeat them after him so that it is easier for you to remember. We have also prepared files with keyboard shortcuts in Excel, which will make your introduction to Excel even easier. After completing the course, you’ll be able to do work in Excel much faster.YOU’LL HAVE THE OPPORTUNITY TO LEARN HOW TO WORK WITH EXCEL FROM TOP DIGITAL MARKETING AND DATA ANALYTICS PROFESSIONALS:We have over 14 years of experience in online marketing. Our Webpromo Agency has both Google Premier Partner status and Facebook Marketing Partner status.We've launched over 1,500 successful marketing strategies and campaigns throughout our careers.Over 420,000 digital marketing specialists worldwide have enrolled in our online courses. Our free online events, blog, and YouTube tutorials help the SkillsBooster community stay in the loop and get all the tips they need to succeed in digital marketing.OUR EXCEL TRAINING INCLUDES:Theory: 1+ hours of lectures with plenty of hands-on examples. Lessons range from 3 to 15 minutes and are easy to followPractice Materials: Checklists, templates, and video tutorials to make the course more interactive and valuableLifetime access to the course and any future updates24/7 Support: If you have questions, I will always be willing to answerComplete the course and receive an Udemy certificateSHOULD YOU BE WORRIED?This course comes with a 30-day money-back guarantee.Join our course today to improve your Excel skills and simplify your workflow!

Overview

Section 1: Fundamentals

Lecture 1 User Interface

Lecture 2 Tab List

Lecture 3 Different Data Formats

Lecture 4 Smart Tables

Lecture 5 Udemy interface

Section 2: Calculations

Lecture 6 Default Math Operations

Lecture 7 Basic Text Functions

Lecture 8 Basic Number Functions

Lecture 9 Basic Date Functions

Lecture 10 Lookup Functions New

Lecture 11 Combining Functions New

Section 3: Analyze Data

Lecture 12 Tools: Conditional Formatting, Sorting

Lecture 13 Tools: Filtering, Find and Replace

Lecture 14 Data Preparing (Cleaning)

Lecture 15 Pivot Tables

Section 4: Data Visualization

Lecture 16 Key Rules for Effective Visualisation

Lecture 17 Creating and Formatting Charts

Lecture 18 Basic Chart Types: Column, Line, Pie, Bar

Lecture 19 Combo Chart

Lecture 20 Pivot Charts, Slicers and Timelines

Lecture 21 Sparklines

Lecture 22 How to Leave a Review for the Course?

Lecture 23 How to Get Your Certificate for the Course?

Lecture 24 Summary

Beginners who want to learn Excel at a basic level,Marketers who want to organize their work, collect or visualize different types of data, achieve higher work results, etc.,Anyone who wants to integrate the power of Excel into their personal or professional life