Microsoft Excel – Beginner to Advanced – Excellence Course

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

Achieve professional level Microsoft Excel Skills

1. Introduction

1.1 Excel Course Resources.zip

1. Course Introduction and Resources

2. Module 2 - Fundamentals

1. Module 2 Intro - Fundamentals

2. 2.1 - Workbook Components

3. 2.2 - The Excel Ribbon

4. 2.3 - Worksheet

5. 2.4 - Cells And Ranges

6. 2.5 - Rows and Columns

7. 2.6 - The Formula Bar

8. 2.7 - The Range Bar

9. 2.8 - The Status Bar

10. 2.9 - Quick Access Toolbar

11. 2.10 - Saving your workbook

12. 2.11 - Excel File types and PDFs

3. Module 3 - Formatting

1.1 Module 3 - Formatting.xlsx

1. Module 3 Intro - Formatting

2. 3.1 - Text formatting

3. 3.2 - Number formatting

4. 3.3 - Date and time formatting

5. 3.4 - Borders, Grid-lines, Alignments And Colors

6. 3.5 - Merge Cells and Wrap Text

7. 3.6 - Styles

8. 3.7 - Paste Special and the format painter tool

9. 3.8 - Visible Cells only

10. 3.9 - Custom Formatting

11. 3.10 - Data Validation

12. 3.11 - Shape Alignment

4. Module 4 - Conditional Formatting

1.1 Module 4 - Conditional Formatting.xlsx

1. Module 4 Intro - Conditional Formatting

2. 4.1 - Highlight Cell Rules

3. 4.2 - Top and Bottom Rules

4. 4.3 - More Rules

5. 4.4 - Data Bars

6. 4.5 - Color Scales and Heat maps

7. 4.6 - Icon Sets

8. 4.7 - Custom Formula rules

9. 4.8 - Entire data row rule

10. 4.9 - Manage, Edit And Remove Rules

5. Module 5 - Commands

1.1 Module 5 - Commands.xlsx

1. Module 5 Intro - Commands

2. 5.1 - Searching (Worksheet-Workbook)

3. 5.2 - Find and Replace

4. 5.3 - The Autofill Handle

5. 5.4 - Flash Fill

6. 5.5 - Fill Series

7. 5.6 - Go To Special

8. 5.7 - Removing Duplicates

9. 5.8 - Text to Columns

10. 5.9 - Custom Lists

11. 5.10 - Goal Seek

12. 5.11 - Viewing - Freeze Panes

13. 5.12 - Viewing Multiple Windows

14. 5.13 - Viewing Grouping and ungrouping

6. Module 6 - Formulas and Functions

1.1 Module 6 - Functions And Formulas.xlsx

1. Module 6 Intro - Formulas and Functions

2. 6.1 - The difference between a functions And formulas

3. 6.21 - Formula operators (Mathematical)

4. 6.22 - Formula operators (String)

5. 6.23 - Formula operators (Comparison)

6. 6.24 - Formula operators (Logical)

7. 6.25 - Absolute And Relative references

8. 6.31 - Categories of Functions and Availability

9. 6.32 - Date And Time functions

10. 6.33 - Text functions

11. 6.34 - Logical functions

12. 6.35 - Lookup And Reference functions

13. 6.36 - Math functions

14. 6.37 - Statistical functions

15. 6.4 - Wild Cards

16. 6.5 Office 365 Functions

7. Module 7 - Data Analysis

1.1 Module 7 - Data Analysis.xlsx

1. Module 7 Intro - Data Analysis

2. 7.1 - Filtering

3. 7.2 - Sorting

4. 7.3 - Tables

5. 7.4 - Pivot Tables

6. 7.5 - Slicers

7. 7.6 - Timelines

8. 7.7 - Chart building

9. 7.8 - Drop down menus

8. Module 8 - Macros and VBA Introduction

1.1 module 8 - macros and vba (with code).zip

1.2 Module 8 - Macros And VBA.xlsx

1. Module 8 Intro - Macros and VBA

2. 8.1 - What are Macros And VBA

3. 8.2 - The Developer Tab

4. 8.3 - Recording and running a Macro

5. 8.4 - Relative References

6. 8.5 - Macro Buttons

7. 8.6 - Creating simple Macros

8. 8.7 - The VBA interface

9. 8.8 - A look at the code

10. 8.9 - Editing the code

11. 8.10 - Debugging the code

12. 8.11 - VBA Language grammar

9. Module 9 - Protection

1.1 Module 9 - Protection.xlsx

1. Module 9 Intro - Protection

2. 9.1 - Worksheet Protection

3. 9.2 - Macro Protection

4. 9.3 - Workbook Protection

10. Module 10 - Printing and PDFs

1.1 Module 10 - Printing And PDFs.xlsx

1. Module 10 Intro - Printing and PDFs

2. 10.1 - Orientation

3. 10.2 - Scaling

4. 10.3 - Margins

5. 10.4 - Page Brakes And Print Area

6. 10.5 - Repeated Row And Column Headers

7. 10.6 - Header, Footer, page numbers And logos

8. 10.7 - Save as PDF And multiple tabs

139,000 تومان

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

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

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

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