Microsoft Excel Mastery: From Beginner to Expert- 2024

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

Excel for Beginners

1. Introduction

1. Introduction

2. Definitions

3. Saving & Opening a WorkBook

4.1 Fundamentals.pptx

4.2 Test Your Understanding.xlsx

4. Navigating the Worksheet

5. Ribbon, Tabs

2. Entering & Editing Worksheet Data

1.1 Entering & Editing Worksheet Data.pptx

1.2 WLD RTFP country 2023-10-02.csv

1. Data Types

2. Entering Text

3. Entering a Formula

4. Entering Dates

5. Inserting Charts

6. Inserting Objects & Pictures

7. Modifying Cell Contents

3. Working with Worksheets

1.1 Modifying an Excel Worksheet.pptx

1. Delete & Name a Worksheet

2. Add a Worksheet, Change a Tab Colour

3. Hiding Rows & Columns, Zoom In & Zoom Out

4. Formatting & Aligning Data

1.1 Formatting and Aligning Data.pptx

1. Formatting Data 1

2. Formatting Data 2

5. Working with Cells & Ranges

1.1 Working with Cells & Ranges.pptx

1. Define Cells & Ranges

2. Selecting Cells & Ranges

3. Adding Comments to Cells

6. Printing Your Work in Excel

1. Printing Navigation 1

2. Printing Navigation 2

3. Convert Excel Worksheet to PDF

4. Page Breaks

5. Manual Page Breaks

7. Working with Tables in Excel

1.1 Tables.pptx

1. Define & Create Tables, Examples

2. Filter & Sort Data in an Excel Table

3. Sorting Continued

4. Formatting a Table

5. Formatting a Table

8. Protecting Your Worksheet & Workbook

1.1 Credit Notes.xlsx

1.2 Protecting a Workbook.xlsx

1.3 Protecting a Worksheet.xlsx

1. Protect a Workbook 1

2. Protecting a Workbook 2

3. Protecting a Worksheet

9. Working with Formulas & Functions

1. Add, Subtract, Multiply, Devide

2. Relative & Absolute References

3. V-Lookup

4. V-Lookup Application

5. H-Lookup

6. X-Lookup

7. SUM, MAX, MIN, AVERAGE

8.1 Practice Data Set.csv

8. SUMIF, COUNTIF, AGGREGATE

9. CONCANTENATE & TEXT JOIN

10. TRIM, LEFT, RIGHT

11.1 student math clean.csv

11. UPPER, LOWER, PROPER

12.1 1.1 Examples.xlsx

12. Date Formulas NOW, TODAY, DAYS, NETWORKING DAYS

13. Date Formulas WORKING DAY

14. Date Formulas YEAR, MONTH, DAY

15.1 DATA.xlsx

15. IF FUNCTIONS BASIC IF FUNCTION

16. IF FUNCTION NESTED IF FUNCTION

17. IF FUNCTION IF ERROR

18. IF FUNCTION IF AND, IF OR

10. PIVOT TABLES

1.1 Data 1.csv.xlsx

1.2 Data 1.xlsx

1.3 Pivot Tables.pptx

1. Definition, Navigation

2. EXAMPLE PIVOT TABLE

11. POWER QUERY

1.1 Data Normalisation.xlsx

1.2 Getting Data from the WEB.xlsx

1.3 Malawi Stock Exchange.xlsx

1.4 Practice.xlsx

1.5 Sales Report.xlsx

1. DEFINITION

2.1 POWER QUERY.pptx

2. Getting Data From Excel, PDF, WEB

3. Cleaning Data

4. Connecting Power Query to the WEB

5. Consolidating Data From Different Files into One File

12. CHARTS

1.1 ds salaries.csv

1.2 Excel Charts.pptx

1.3 OECD Alcohol Consumption per Capita.csv

1. Definition, Types and Examples

2. Example, Pie Chart, Customisation, Formatting

13. PIVOT CHART

1.1 ds salaries.xlsx

1.2 Pivot Chart.pptx

1. Definition, Example Pivot Charts

14. CONDITIONAL FORMATTING

1.1 Conditional Formatting.pptx

1.2 Practice Data.xlsx

1. Definition & Examples

15. DATA VALIDATION

1.1 Data Validation.pptx

1.2 housing price dataset.csv

1. Definition, Examples

16. AUDITING AN EXCEL WORKSHEET

1.1 Annual 2019 Budget COMREP - 23-09-19 (004).xlsx

1.2 Auditing an Excel Worksheet.pptx

1. Auditing Excel Formulas in a Worksheet

17. FLASH FILL

1.1 CustomterMaster.xlsx

1.2 Flash Fill.pptx

1. Definition, Examples

139,000 تومان

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

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

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

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