التفاصيل

Learn Excel from beginner to advance

2021/01/21   الكاتب :د. يحيي سعد
عدد المشاهدات(247)
Learn Excel from beginner to advance

كورسات Udemy المدفوعة مجاناً 2021
 

مجموعة جديدة من كورسات Udemy المدفوعة مجاناً 2021 والتي يصل سعر الكورس الواحد الي 200 دولار ولكنها مجانية الأن ولفترة محدودة
 

Learn Excel from beginner to advance

What you'll learn

  • Basic excel equations widely used in
  • Email shooting by using VBA Directly from excel to specific users
  • Hands on experience to the excel with understanding of shortcuts
  • Analytical dashboard creation
  • Data filtration, Border, Sr No., Format Painter
  • Codes used in VBA
  • Function today () and Equation additing
  • Command Dollar {$} understanding
  • Data Validation - Drop Down List creation
  • IF, Nested if, if (And) command
  • Use of Conditional Formatting with Example
  • Remove Duplicates value in Excel
  • Automate Boarder - Where data available
  • Understanding of VLOOKUP
  • Index - Match equation
  • Data Filter - Analyze data
  • Bar Chart, Pie Chart Creation - Dashboard
  • VBA Form Creation
  • Password Protected Mail shooting directly from excel

Requirements

  • No prior knowledge is required
  • Any Fresher to the Excel

Description

In this course you are going to learn, daily excel equations which are widely used in daily life with short cut. No prior knowledge is required. We have taken example to teach easily so one can learn from basic with example.

You are going to learn: -

1.  Basic excel equations widely used in

2. Hands on experience to the excel with understanding of shortcuts

3. Analytical dashboard creation

4. Data filtration, Border, Sr No., Format Painter

5. Email shooting by using VBA from excel to specific users

6. Codes used in VBA

7. Data Validation - Drop Down List creation

8. IF, Nested if, if (And) command

9. Use of Conditional Formatting with Example

10. Remove Duplicates value in Excel

11. Linking from excel to mail (You can shoot mail by clicking button from excel directly)

12. Bar Chart, Pie Chart Creation - Dashboard

13. Understanding of VLOOKUP

14. Index - Match equation

15. Data Filter - Analyse data

16. Password Protected Mail shooting directly from excel

17. And many more...

Who this course is for:

  • Beginners to the excel
  • College students
  • To become expert in excel
  • Who wants to learn excel from basic, and want to become expert
  • Want to understand the real-life corporate situation and solve from the basic

 

 

 Download Course Learn Excel from beginner to advance with Example

التعليقات


الأقسام

الوســوم

نبذة عنا

تؤمن شركة دراسة بأن التطوير هو أساس نجاح أي عمل؛ ولذلك استمرت شركة دراسة في التوسع من خلال افتتاح فروع أو عقد اتفاقيات تمثيل تجاري لتقديم خدماتها في غالبية الجامعات العربية؛ والعديد من الجامعات الأجنبية؛ وهو ما يجسد رغبتنا لنكون في المرتبة الأولى عالمياً.

المزيد

اتصل بنا

فرع:  السعودية  +966 560972772 - 00966555026526‬‬

المزيد

تابعونا على تويتر . . .

شارك:
footerimg

جميع الحقوق محفوظة لموقع دراسة ©2017