Microsoft Excel & Google Sheets For High Office Productivity

Focused View

Ivan Lourenço Gomes

10:25:30

148 View

1. First Steps with Microsoft Excel

1. Introduction.mp4

11:25

2.1 Sales.xlsx

2. Formatting Basics.mp4

12:00

3. Data Types (Part 1).mp4

07:05

4. Data Types (Part 2).mp4

09:38

5. Formulas & Dynamic Values.mp4

09:55

6. Intro to Built-in Formulas.mp4

10:53

7. Built-in Formulas SUM, AVERAGE, MAX, MIN, SUMIF, COUNTIF.mp4

06:53

8. Adding Images, Shapes, Buttons and Links.mp4

13:50

9. Assignment - Design the Customers Sheet.mp4

01:51

10. Assignment Solution - Design the Customers Sheet.mp4

15:00

11. Hide Cells and Freeze Panels.mp4

14:59

12. Auto Filters.mp4

07:21

13.1 Sales.xlsx

13. Data Validation.mp4

10:34

14. Coming Soon.html

15.1 Payroll - Assignment 2.xlsx

15. Assignment - Payroll.mp4

01:58

16.1 Payroll - Assignment 2 - Solution.xlsx

16. Assignment Solution - Payroll.mp4

03:15

2. Pivot Tables & Advanced Functions

1. Intro to Pivot Tables.mp4

11:40

2. Pivot Tables on Google Spreadsheets.mp4

04:48

3. Multilevel Fields on Pivot Tables.mp4

08:31

4. Preparing Your Database for More Insights.mp4

10:43

5. Blocking Cell References with the Dollar Sign ($).mp4

08:41

6. The VLOOKUP formula.mp4

12:20

7.1 Sales sheet - With Pivot Tables And VLOOKUP.xlsx

7. Pivot Charts.mp4

09:27

8.1 Payroll - Assignment 3 - VLOOKUP.xlsx

8. Assignment - VLOOKUP and Pivot Tables.mp4

03:50

9.1 Payroll - Assignment 3 - VLOOKUP and Pivot Tables - Soution.xlsx

9. Assignment Solution - VLOOKUP and Pivot Tables.mp4

08:09

3. More Advanced Functions

1.1 Students Grades - Initial.xlsx

1. Intro to Project #2 - Students Grades.mp4

03:06

2. COUNT and COUNTA Formulas - Calculate Student Attendance.mp4

07:31

3. Using the VLOOKUP Formula to Transfer the Attendance Rates.mp4

08:35

4. The AVERAGE Formula to Calculate the Final Grade.mp4

04:22

5. Conditionals IF, OR, AND to Calculate the Final Result.mp4

14:29

6. Recap About Conditionals.mp4

07:20

7. Nested Conditionals.mp4

09:55

8. Recap on Nested Conditionals.mp4

04:10

9.1 Students Grades - Final.xlsx

9. Conditional Formatting.mp4

05:27

4. Printing Layouts

1.1 Invoice - Initial.xlsx

1. Project #3 - Invoice Template.mp4

11:33

2. Setting Layout for Printing.mp4

09:14

3. Setting Up a Header.mp4

08:08

4.1 Invoice - Final.xlsx

4. Printing Layouts on Google Spreadsheets.mp4

08:40

5. Date Functions

1.1 Dates - Initial.xlsx

1. Basic Date Functions - DAY, MONTH, YEAR.mp4

08:27

2. Calculating Dates.mp4

12:42

3.1 Dates - Final.xlsx

3. Dates & Conditional Formatting for Follow-up Automation.mp4

15:30

6. Reporting and Data Analysis Tools

1.1 Sales Projections - Initial.xlsx

1. SUMIF, SUMIFS, COUNTIF, COUNTIFS.mp4

16:02

2. Basic Charts.mp4

13:30

3. Creating Management Reports.mp4

13:59

4. Sales Analysis on Google Spreadsheets.mp4

11:19

5. Assignment - Sales Projections.mp4

01:39

6. Assignment Solution - Sales Projections.mp4

09:54

7. Calculating the Percentage of The Projections Sold.mp4

09:37

8.1 Sales Projections - Final.xlsx

8. Charts for Growth and Sales Projections.mp4

12:56

9.1 Covid_Per_Country.csv

9.2 Covid_Per_Country.xlsx

9. Working with CSVs.mp4

14:02

7. Project - Diet & Meal Planning on Microsoft Excel

1.1 Nutritional Facts & Diet - Initial.xlsx

1. Introduction to the Meal Planner Project.mp4

09:12

2. Selecting Meals.mp4

04:52

3. Getting the Nutritional Facts for the Foods.mp4

11:09

4. Using IF Functions to Show or Hide Values in the Table.mp4

09:12

5. Setting the Conditional Formatting to the Nutrients.mp4

02:52

6. Protecting Cells and Locking the Worksheet.mp4

13:53

7. Ordering Tables of Data.mp4

04:57

8. Recording Macros - Part 1.mp4

07:25

9.1 nutritional facts & diet - final.zip

9. Recording Macros - Part 2.mp4

10:13

8. Useful Projects

1.1 Production Cost & Final Price - Initial.xlsx

1. Production Cost and Price Calculator - Part 1.mp4

12:42

2.1 Production Cost & Final Price - Final.xlsx

2. Production Cost and Price Calculator - Part 2.mp4

08:24

3.1 Shipping Costs and Final Price per Item - Initial.xlsx

3. Shipping Costs - Part 1.mp4

14:15

4. Shipping Costs - Part 2.mp4

13:30

5.1 Shipping Costs and Final Price per Item - Final.xlsx

5. Shipping Costs - Part 3 - Adding Checkers for Accuracy.mp4

05:25

6.1 Stock System - Initial.xlsx

6. Stock System - Part 1.mp4

14:35

7.1 Stock System - Final.xlsx

7. Stock System - Part 2.mp4

08:48

8.1 Team Performance - Initial.xlsx

8. Team Performance - Part 1.mp4

09:10

9.1 Team Performance - Final.xlsx

9. Team Performance - Part 2.mp4

08:03

Description

Complete Microsoft Excel & Google Spreadsheets for Business Data Analysis. Manage Daily Work & Create Management Reports

What You'll 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

Who is this for?

Professionals of any business career seeking to master Microsoft Excel and Google Spreadsheets

Sales managers and employees willing to improve the control over sales data and reports

Any person willing to improve their Microsoft Excel skills for usage in many different applications

More details

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 LoureÃ§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.
Who this course is for:
Professionals of any business career seeking to master Microsoft Excel and Google Spreadsheets
Sales managers and employees willing to improve the control over sales data and reports
Any person willing to improve their Microsoft Excel skills for usage in many different applications

User Reviews

Rating

average 0

Total votes0

Focused display

Ivan is a top Udemy instructor currently teaching 17 courses in 4 languages with 420.000+ students worldwide.He became famous for his hands-on and easy-to-grasp teaching style using techniques that can benefit students from all levels, from complete beginners to advanced professionals.Ivan studied Business in college and has been working for multinational companies since 2004. He has a strong experience in various business areas, such as Sales, Purchasing, Logistics, International Trading, Accounting and Production.In 2014 he made a transition to I.T., where he quickly grew from a Front End Web Developer to the Product Owner and Leader of a Web Development Team at a big e-commerce UK company. Some of his courses include:• HTML / CSS• Javascript• Vue JS, Vue Router and Vuex• PHP• Web Design• Invision Studio• Python• Machine Learning• Microsoft Excel• Email Writing and EtiquetteEnroll now in one of his courses and start learning hot topics in Business, Web Development and Programming!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.