Beginner to Pro in Microsoft Excel: Business Data Analysis

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

Analyze business data: includes business scenarios, loan data, real estates data, pivot table analysis, and more!

1. Introduction Shopping List Data

1.1 Quick Guide to the Excel Worksheet Window.html

1. The Excel Window

2. Entering Data & Performing Simple Calculations

3. Knowledge Check.html

4. Quick Overview Editing and Formatting

5. Visualizing Data

6. Basic Formatting and Calculation Practice.html

2. Getting Familiar With Excel E-Commerce Data

1.1 Lecture 5.xlsx

1. Formatting

2. Functions and Formulas

3. Basic Data Analysis Descriptive Statistics

4. Introduction to Microsoft Excel.html

5. Mixed and Cross Referencing

6. Visual Analysis Graphs and Sparklines

7. Cross Referencing.html

3. Advance Formulas, Functions, and Formatting Real Estate Data

1.1 Real Estate Mortgage.xlsx

1. Loan Terms Analysis Interest Rates, Monthly Payments, Name Range

2. Multi-Level Sorting, Subtotals, Interactive Summary Report and Chart

3. Accuracy Check.html

4. Data Filtration With Excel

5. Progress Assessment.html

6. Advance Formatting Conditional Formatting

7. Grouping with Pivot Tables

8. Pivot Table Assignment.html

4. Data Consolidation and Validation IT Services Business Data

1.1 Grouping Data.xlsx

1. Grouping and Formatting Multiple Worksheets

2. 3D Formulas for Consolidation

3. Data Validation Rule Error Alert

4. SUMIF and Cell Linking

5. Demo Calculator Validation Rules and VLOOKUP

6. VLOOKUP Exercise.html

5. Advance Applications Mortgage & Rental Income Data

1.1 Section 5.xlsx

1. Logic Operations Logical Comparison

2. Create a Search Function Index, Match, IFERROR, and Freeze Panes

3. Loan Amortization Monthly Pay, Payment Date, Principle Payment, Ending Balance

4. Test your understanding.html

5. Excel Efficiency AVERAGEIF vs Pivot Tables

6. Section 6 Income Statement Analysis

1.1 Section 6_.xlsx

1. What If Analysis One-Variable Table

2. What If Analysis Two-Variable Table and Goal Seek

3. What If analysis Scenario Summary

4. Scenario Summary Practice.html

7. Section 6 Expert Tools

1. Upload and Format TXT file

2. Email Automation Customer Thank You Email

3. Simple Data Entry Forms

4. Macros in Excel

5. Import Text to Excel.html

45,900 تومان

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

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

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

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