Microsoft Excel Comprehensive Guide

How to use Excel in your career—a guide on simple functions, Excel tools, and chart creation.
Microsoft Excel Comprehensive Guide
File Size :
772.74 MB
Total length :
1h 10m

Instructor

Anton Voroniuk

Language

Last update

11/2023

Ratings

4.5/5

Microsoft Excel Comprehensive Guide

What you’ll learn

Foundational knowledge in Excel
Simple to complex mathematical functions for calculations
Formula use and data importation into Excel
Table use and functionality
Creation of your own metrics dashboard and automated data updates
The Excel tools that are available to analyze data effectively
Key rules for effective data visualization using charts

Microsoft Excel Comprehensive Guide

Requirements

This course is designed for beginners, so no prior background is needed

Description

As a digital marketer, you rely on various data management technologies like Google Analytics and CRM. But managing and analyzing data across many platforms is time-consuming and tedious. Excel offers a streamlined solution to this problem by combining research, data analysis, and reporting into a single application.Despite its usefulness, many marketers shy away from using Excel because of its complex formulas and functions. That’s why we’ve created a course designed to break down Excel to its basics and allow you to integrate it into your daily work.Our course quickly and effectively covers the essentials of Excel in four sections:FundamentalsCalculationsData AnalysisData VisualizationFrom understanding the interface to creating charts and visualizing data, we’ve got you covered.COURSE INSTRUCTOR​​Denys Sokotov is a Data Analyst with 4+ years of experience working in Excel and 2 years in the data analytics field. He has developed over 40 dashboards and reports, holds a Google Data Analyst Certificate, and was one of 9 finalists in an analytics challenge with over 400 participants.Throughout the course, you’ll have access to many examples and files with keyboard shortcuts to make learning even easier. With this course, you’ll be able to use Excel like a professional and gain the foundational knowledge required by most employers.LEARN HOW TO WORK WITH EXCEL FROM DIGITAL MARKETING AND DATA ANALYTICS PROFESSIONALS:Our course is taught by top professionals with 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.With over 500,000 digital marketing specialists worldwide enrolled in our online courses, we’re dedicated to helping the SkillsBooster community stay up-to-date with the latest tips and trends in digital marketing.OUR EXCEL TRAINING INCLUDES:Theory: 1+ hours of lectures with a multitude of hands-on examples. Lessons are easy to follow and range from 3 to 15 minutes in length.Practice Materials: Checklists, templates, and video tutorials to make the course more interactive and valuable.Lifetime Access to the course and any future updates.24/7 Support: To ensure that you get the most out of your learning experience.After successfully completing the course, participants receive an Udemy certificate.STILL WORRIED?If you’re unsatisfied with the course, we offer a 30-day money-back guarantee.Enroll now and start simplifying your data management tasks with Excel!

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

Section 5: BONUS

Lecture 25 BONUS Lecture

For beginners wanting to learn Excel at a basic level,For marketers wanting to take their data analysis to the next level and achieve higher work results,For anyone wanting to integrate the power of Excel into their personal or professional life

Course Information:

Udemy | English | 1h 10m | 772.74 MB
Created by: Anton Voroniuk

You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com

New Courses

Scroll to Top