6 Hr Excel Mastery: Beginner to Pro (2023)

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

Everything you need: Excel functions, Excel formulas, Excel Macros, VBA, Pivot Tables, Excel options.

1. Introduction

1. Start Your Excel Journey

2. Read me.html

2. Start with Excel

1. Open and save a Workbook

2. Workbook structure

3.1 Project.xlsx

3. Entering data & Cell formatting

3. Page setup and layout

1.1 Project.xlsx

1. Page setup, Print layout, Header & Footer

4. Workbook navigation

1.1 Foodsales Dataset 4.0.xlsx

1. Intro Dataset

2. Find&Replace function

3. Notes and comments

4.1 Foodsales Dataset 5.0.xlsx

4. Hyperlinks

5. Data manipulation

1. Copy and paste

2. Paste special options

3. Autofill and Flashfill

4.1 Foodsales Dataset 6.0.xlsx

4. Hide and manage rows and columns

6. Tables

1. Create a table

2. Modify a table

3.1 Foodsales Dataset 7.0.xlsx

3. Sort and filter

7. Base formulas

1. SUM, MAX, MIN, AVERAGE (Calculation functions)

2. Lock cells

3. COUNT, COUNTA, COUNTBLANK (Count functions)

4. IF (Conditional function)

5. RIGHT, LEFT, MID, UPPER, LEN (Text functions)

6. CONCAT, TEXTJOIN (Text functions)

7.1 Foodsales Dataset 8.0.xlsx

7. Show formulas

8. Options and views

1. Personalizing Views, Ribbon, Quick Acces Toolbar

2. Workbook properties

9. Import Data

1. .TXT and .CVS import formats

2.1 incidents dataset 1.0.zip

2.2 Safety Dataset 11.0.xlsx

2. Import project dataset

10. Format and Summarize Data

1. Text to columns function

2. Clean the dataset

3. Conditional formatting

4. Find and remove duplicates

5. Go-to function

6.1 Safety Dataset 12.0.xlsx

6. Sparklines

11. Intermediary Formulas

1. Nested IF, IFS

2. AND, OR

3. COUNTIF, SUMIF, AVERAGEIF

4. COUNTIFS, SUMIFS, AVERAGEIFS (Multiple criteria)

5.1 Safety Dataset 13.0.xlsx

5. MINIFS, MAXIFS

12. Dates Formulas

1. TODAY, NOW

2. YEAR, MONTH, DAY, HOUR, MINUTE, SECOND

3. WEEKDAY, WORKDAY, NETWORKDAYS

4. SWITCH

5.1 Safety Dataset 14.0.xlsx

5. Apply dates functions to the dataset

13. Charts

1. Create a chart

2.1 Safety Dataset 15.0.xlsx

2. Modify chart elements and format

14. Lookup formulas

1. VLOOKUP, HLOOKUP

2.1 Safety Dataset 16.0.xlsx

2. INDEX, MATCH

15. Formatting Data

1. Data validation

2. Grouping Data

3. Subtotals

4. Formula-based conditional formatting

5.1 Safety Dataset 17.0.xlsx

5. Manage conditional formatting rules

16. Advanced functions management

1. PMT, NPER

2. Scenario manager

3. Goal seek

4.1 Safety Dataset 18.0.xlsx

4. Error checking

17. Pivot Tables

1. Create a pivot table

2. Modify a pivot table

3. Values options and Cell formats

4. Pivot table options and dynamic filters

5. Pivot charts

18. Advanced Charts

1. Tree Map and Sunburst

2. Histogram

3. Box & Whisker

4. Filled map

5. Waterfall

6. Funnel

7.1 Safety Dataset 19.0.xlsx

7. Combo

19. Macros

1. Record a macro

2. Control buttons

3. Form controls

4.1 safety dataset 20.0.zip

4. Copy macros with VBA

20. Advanced Workbook Options

1. Link data

2. Protect Sheet

3. Macros on protected sheets

4. Protect Workbook

5.1 safety dataset 21.0.zip

5. Recover Workbook (Autosave - Autorecover)

139,000 تومان

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

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

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

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