UdemyExcelPaid courseAll LevelsCertificate

MICROSOFT EXCEL Complete: Zero to Pro Level With 8 Projects (Udemy.com)

Complete Microsoft Excel and Google Spreadsheets for Business Professionals. Manage Sales, Make Pivot Tables and Reports

4.7

234 reviews

Created by: Ivan Lourenço Gomes

Last updated May 2024

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.

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

Rating4.7 out of 5higher than 81% of them
Reviews234#288 of 356 by number of reviews
Length10.4 hourslonger than 72% of them
Last updatedMay 2024more recently than 54% of them

Course 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.

All Levels

Time: 10.4h

Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

Instructor Details

Ivan Lourenço Gomes

4.7 Rating
234 Reviews

Ivan is a leading tech educator on Udemy.

With 30+ courses under his belt and a community of over 500,000 students worldwide, Ivan's here to guide you through the tech and business skills you need today.

With a solid experience of 18 years in various business and technology sectors, Ivan has dedicated himself since 2016 to transforming his expertise into accessible learning paths for a global audience.

Renowned for a dynamic teaching style that mixes project-based learning with incremental challenges, his courses are the right fit for you, whether you're just starting your learning journey or looking to deepen existing skills.

His courses cover essential foundations and cutting-edge trends in technology and business communication:

• Web Development Essentials: Dive into the world of web development with courses on HTML/CSS and Javascript, and master the art of creating engaging, responsive websites.

• Advanced Frontend Frameworks: Elevate your web projects with Vue JS, React JS & TypeScript, focusing on building dynamic, user-centric applications.

• Software Best Practices: Gain proficiency in Git for version control, ensuring your projects are managed with industry-standard efficiency.