MS Excel 41+Master Tricks : Time Saving Tricks

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

"Excel Efficiency: Mastering Time-Saving Tricks!"

1. Introduction

1. Welcome to the Course

2. Time Saving Excel Tips

1. Find & replace in MS Excel

2. Add Bullet points

3. Formula Text Unleash the Power of Text Manipulation in Excel!

4. Easy Excel Security How to Password Protect Your Files!

5. Convert TRUEFALSE to 1 & 0 with Ease

6. Data Filtering with Find Criteria

7. Excel Magic Transform Data with Flip Data!

8. Effortless Data Validation in Excel!

3. Advanced Formulas and Functions

1. INDEX Function

2. MATCH Function

3. INDEX-MATCH for Advanced Lookups !

4. MINIFS and MAXIFS

5. Excel Magic Mastering DMAX and DMIN!

6. Excel VLOOKUP Simple Data Lookup!

7. Excel HLOOKUP Easy Data Retrieval!

8. VSTACK Easy Data Stacking in Excel!

9. HSTACK Align Data Horizontally in Excel!

10. BYROW Uncomplicated!

11. AutoSum for Quick Totals

12. Series Function Streamline Data Sequences!

13. Excel Text Watermarks Effortless Branding!

14. Excel Image Watermarks Easy Branding!

15. Creating Hyperlinks Easy Linking!

16. LARGE, SMALL, RANK Explained !

17. COUNTIF Easy Data Analysis!

18. Excel Made Simple SWITCH Function Explained!

4. Must Have Tricks !

1. Todays Date in Excel Easy!

2. Find Duplicates with Conditional Formatting

3. Remove Duplicates Effortlessly !

4. Number Customization in Excel!

5. Hide Data with Custom Formatting!

6. Effortless Formatting Cleanup in Excel!

7. Easy Age Counting in Excel!

8. Add Input Messages Easily!

9. Create Emails Quickly!

10. Name Ranges

11. Data Flipping

12. Excel Indirect Function

13. Calculate % of Totals Easily!

14. SUMPRODUCT

15. Heat Map

16. Sparklines for Visual Insights!

17. AI Formula Editor Excels Efficiency Booster!

179,000 تومان

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

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

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

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