Microsoft Excel Complete Course Including Google Sheets

Complete Microsoft Excel & Google Spreadsheets for Business Professionals. Manage Sales, Create Pivot Tables & Reports

4.50 (111 reviews)
Udemy
platform
English
language
Microsoft
category
2,439
students
10.5 hours
content
Nov 2022
last update
$74.99
regular price

What you will learn

Learn all the most important Excel & Google Spreadsheets built-in functions with practical examples: SUM, COUNT, SUMIF, COUNTIF, VLOOKUP, IF, AND, OR, etc.

Apply formulas and use dynamic values for high productivity with your day-to-day work

Master both Micosoft Excel and Google Spreadsheets for office use and collaborative work

Create dynamic management reports and have a better understanding of your business data

Have a deep understanding of pivot tables & charts and create corporate knowledge from your data

Control the sales, purchases, stock, payroll and other management areas of your organization

Create invoices and documents with formulas & calculations

Work with several real-life projects: stock system, consumer price calculator, students grades & attendance control, sales projections, meal planner, etc.

Learn how to work with CSV files that are interoperable with most software programs in the market to analyze external sources of data on Microsoft Excel

Work with Macros and automate actions

Protect your workbooks with password and block specific cells to make your worksheets safe and error-free

Format your sheets for better usability and add menu with buttons to create your own system for all your office tasks

Description

Microsoft Excel and Google Sheets are powerful applications that allow you to create sophisticated spreadsheets. They can help you organize, analyze, and understand your business's most important data.

In this 2-in-1 course, we'll cover everything you need to know to master both Google Sheets and Microsoft Excel. Using these two applications, you'll learn how to create supercharged spreadsheets with sophisticated functions and visualizations that will allow you to speed up data analysis and communicate actionable findings with your team.

Follow along as we go through the exercises, and use multiple spreadsheets to practice your new and exciting skills.

At the end of this course, you’ll be able to master:


  • Sorting and filtering data, filtering views, publishing files, and other data preparation tasks.

  • Increasing productivity by using different data types, formatting cells, formulas, and other advanced techniques.

  • Creating sales sheets, printable invoice templates, pivot tables, and charts for sales statistics.

  • Creating Google spreadsheet scripts to perform programmable actions.

  • Working faster with keyboard shortcuts and techniques.

Now the real office productivity begins! Learn Excel and Google Sheets from the ground up!

This course offers 67 lessons with more than 10 hours of video content, multiple assignments and real-life projects.

About the Instructor

This course is ministered by Ivan Lourenço Gomes, a top-rated Udemy instructor, famous for his easy-to-follow and hands-on teaching style. Ivan has more than 16 years of experience working for multinational companies and has ever since used Microsoft Excel and more recently Google Spreadsheets to boost the productivity and data analysis of his team.

Enroll now and master these wonderful tools for businesses and individuals.

Content

Introduction

Introduction
Formatting Basics
Data Types (Part 1)
Data Types (Part 2)
Formulas & Dynamic Values
Built-in Formulas
Adding Images, Shapes, Buttons and Links
Assignment - Design the Customers Sheet
Assignment Solution - Design the Customers Sheet
Hide Cells and Freeze Panels
Coming Soon

Screenshots

Microsoft Excel Complete Course Including Google Sheets - Screenshot_01Microsoft Excel Complete Course Including Google Sheets - Screenshot_02Microsoft Excel Complete Course Including Google Sheets - Screenshot_03Microsoft Excel Complete Course Including Google Sheets - Screenshot_04

Reviews

Nancy
March 17, 2023
Very easy to understand and the instructor is very clear as to what he is explaining. The lessons are nice and short.

Charts

Price

Microsoft Excel Complete Course Including Google Sheets - Price chart

Rating

Microsoft Excel Complete Course Including Google Sheets - Ratings chart

Enrollment distribution

Microsoft Excel Complete Course Including Google Sheets - Distribution chart

Related Topics

4593208
udemy ID
3/12/2022
course created date
11/12/2022
course indexed date
Bot
course submited by