Microsoft Excel & Google Sheets For High Office Productivity

سرفصل های دوره

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

1. First Steps with Microsoft Excel

1. Introduction

2.1 Sales.xlsx

2. Formatting Basics

3. Data Types (Part 1)

4. Data Types (Part 2)

5. Formulas & Dynamic Values

6. Intro to Built-in Formulas

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

8. Adding Images, Shapes, Buttons and Links

9. Assignment - Design the Customers Sheet

10. Assignment Solution - Design the Customers Sheet

11. Hide Cells and Freeze Panels

12. Auto Filters

13.1 Sales.xlsx

13. Data Validation

14.1 Payroll - Assignment 2.xlsx

14. Assignment - Payroll

15.1 Payroll - Assignment 2 - Solution.xlsx

15. Assignment Solution - Payroll

2. Pivot Tables & Advanced Functions

1. Intro to Pivot Tables

2. Pivot Tables on Google Spreadsheets

3. Multilevel Fields on Pivot Tables

4. Preparing Your Database for More Insights

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

6. The VLOOKUP formula

7.1 Sales sheet - With Pivot Tables And VLOOKUP.xlsx

7. Pivot Charts

8.1 Payroll - Assignment 3 - VLOOKUP.xlsx

8. Assignment - VLOOKUP and Pivot Tables

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

9. Assignment Solution - VLOOKUP and Pivot Tables

3. More Advanced Functions

1.1 Students Grades - Initial.xlsx

1. Intro to Project #2 - Students Grades

2. COUNT and COUNTA Formulas - Calculate Student Attendance

3. Using the VLOOKUP Formula to Transfer the Attendance Rates

4. The AVERAGE Formula to Calculate the Final Grade

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

6. Recap About Conditionals

7. Nested Conditionals

8. Recap on Nested Conditionals

9.1 Students Grades - Final.xlsx

9. Conditional Formatting

4. Printing Layouts

1.1 Invoice - Initial.xlsx

1. Project #3 - Invoice Template

2. Setting Layout for Printing

3. Setting Up a Header

4.1 Invoice - Final.xlsx

4. Printing Layouts on Google Spreadsheets

5. Date Functions

1.1 Dates - Initial.xlsx

1. Basic Date Functions - DAY, MONTH, YEAR

2. Calculating Dates

3.1 Dates - Final.xlsx

3. Dates & Conditional Formatting for Follow-up Automation

6. Reporting and Data Analysis Tools

1.1 Sales Projections - Initial.xlsx

1. SUMIF, SUMIFS, COUNTIF, COUNTIFS

2. Basic Charts

3. Creating Management Reports

4. Sales Analysis on Google Spreadsheets

5. Assignment - Sales Projections

6. Assignment Solution - Sales Projections

7. Calculating the Percentage of The Projections Sold

8.1 Sales Projections - Final.xlsx

8. Charts for Growth and Sales Projections

9.1 Covid_Per_Country.csv

9.2 Covid_Per_Country.xlsx

9. Working with CSVs

7. Project - Diet & Meal Planning on Microsoft Excel

1.1 Nutritional Facts & Diet - Initial.xlsx

1. Introduction to the Meal Planner Project

2. Selecting Meals

3. Getting the Nutritional Facts for the Foods

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

5. Setting the Conditional Formatting to the Nutrients

6. Protecting Cells and Locking the Worksheet

7. Ordering Tables of Data

8. Recording Macros - Part 1

9.1 nutritional facts & diet - final.zip

9. Recording Macros - Part 2

8. Useful Projects

1.1 Production Cost & Final Price - Initial.xlsx

1. Production Cost and Price Calculator - Part 1

2.1 Production Cost & Final Price - Final.xlsx

2. Production Cost and Price Calculator - Part 2

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

3. Shipping Costs - Part 1

4. Shipping Costs - Part 2

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

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

6.1 Stock System - Initial.xlsx

6. Stock System - Part 1

7.1 Stock System - Final.xlsx

7. Stock System - Part 2

8.1 Team Performance - Initial.xlsx

8. Team Performance - Part 1

9.1 Team Performance - Final.xlsx

9. Team Performance - Part 2

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training