Published 4/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 814.22 MB | Duration: 1h 9m
A simple guide on how to use Excel in your career: basic knowledge of simple functions, Excel tools, charts creation
Free Download 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
Homepage
https://www.udemy.com/course/excel-guide/