Excel Essentials: From Basics to Brilliance

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

Microsoft Excel / Office 365 / 2024

1. Introduction

1. Launching Excel

2. Excel Startup

3. Navigating the Interface

4. Customization for Quick Access

5. Exploring Interface Tools Further

6. Unraveling the Framework

7. File Saving Techniques

8. Opening Existing Documents

2. A Guide To Input And Editing

1. Text Entry for Effective Spreadsheet Titles

2. Numeric Data Handling in Excel

3. Date Input in Excel

4. Spreadsheet References

5. Foundational Formula Crafting

6. Navigating Relative and Absolute References

3. Basic Excel Functionality

1. Understanding the Anatomy of Formulas

2. Mastering Data Extremes

3. Working with Averages

4. Excels Count Function

5. Avoiding Adjacent Cell Errors

6. The Power of AutoSum in Excel

7. The AutoSum Shortcut Key

4. Excel Worksheet Modifications

1. Data Movement

2. Row and Column Manipulation

3. Fine-Tuning Cell Sizes

4. Concealing and Revealing Rows and Columns

5. Worksheet Names

6. Excel Worksheet Handling

5. Enhancing Data Presentation with Formatting

1. Font Formatting

2. Transforming Cell Backgrounds with Color

3. Cell Borders

4. Currency Data Formatting

5. Percentage Formatting

6. Excels Format Painter

7. Cell Fusion and Alignment Techniques

8. Techniques in Formatting Rules

6. Image and Shape Integration

1. Image Integration

2. Creating and Customizing Shapes

3. Excel Shapes Formatting Techniques

4. Smart Arts Potential

7. Excel Chart Essentials

1. Crafting Column Charts

2. Visual Insights with the Chart Ribbon

3. Chart Data Manipulation

4. Chart Formatting Techniques

5. Shifting Graphics Across Worksheets

6. Excel Pie Charts

8. Excel Worksheet Printing

1. Document Preview for Print Perfection

2. Margins, Scaling, and Orientations

3. Document Appearance with Page Layout

4. Mastering Headers and Footers

5. Custom Print Areas

9. Template Workflows

1. Excels Template

2. Efficiency through Template Access

3. Designing Personalized Templates

139,000 تومان

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

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

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

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