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

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. Coming Soon.html
  • 15.1 Payroll - Assignment 2.xlsx
  • 15. Assignment - Payroll
  • 16.1 Payroll - Assignment 2 - Solution.xlsx
  • 16. 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
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 5284
    حجم: 4684 مگابایت
    مدت زمان: 626 دقیقه
    تاریخ انتشار: 12 بهمن 1401
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید