Excel for Analysts

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

Master Excel Skills to Elevate Your Data Analysis and Reporting

1. Introduction to Large Worksheets

1. Introduction

2. Data Analysis.html

3.1 worldbank extract.csv

3. Navigating Excel

4. Viewing Data

5. Viewing Large Workbooks

6. Printing Large Workbooks

7. Large Worksheets Quiz.html

8.1 Wikipedia Data.xlsx

8. Multiple Worksheets

9. Multiple Worksheets Quiz.html

10.1 SalesData.xlsx

10. Formatting and Filtering Data

11. Formatting and Filtering Data Quiz.html

2. Functions

1.1 ListofExcelFunctions.xlsx

1. Functions Overview

2.1 eCommerce 2.xlsx

2. Logic Functions 1 IF Functions and Embedded IF Functions

3. Logic Functions.html

4. Logic Functions 2 SUMIFs, AVERAGEIFs, COUNTIFs, OR, AND, NOT

5. Working With Dates

6. Dates.html

7.1 Register.xlsx

7. TEXT Functions

8. TEXT Functions Part 2

9. TEXT Functions Part 3

10. Text Functions.html

11.1 Functions.xlsx

11. Absolute Referencing

12. Absolute Referencing.html

13. HLOOKUP , VLOOKUP and XLOOKUP

14. INDEX + MATCH

15. HLOOKUP , VLOOKUP and XLOOKUP , INDEX + MATCH.html

3. Data Tools

1. Intro to Data Tools

2.1 Functions.xlsx

2. Scenario Manager

3. Goal Seek

4. Data Validation

5. Scenario Manager, Goal Seek and Data Validation.html

6.1 GrossProfit.xlsx

6. Cell References, Trace Precedents and Dependents and Watch Window

7. Cell References, Trace Precedents and Dependents and Watch Window.html

8. Formatting Tables

9. Pivot Tables

10.1 World Athletic Top 100 M Men.html

10. Importing Data from the Web to Create Tables and Pivot Tables

11. Tables and Pivot Tables.html

12. Charts Part 1

13.1 StudentData.xlsx

13. Charts Part 2

14. Charts.html

15. Analysis Toolpack - Histograms

16. Analysis Toolpack - Regression

17. Analysis Toolpack.html

4. Building Dashboards

1.1 StudentData.xlsx

1. Introduction to Dashboards

2. Dashboard Setup

3. Creating a Dashboard

4. Creating Slicers and Conditional Formatting in a Dashboard

5. Dashboards Quiz.html

139,000 تومان

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

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

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

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