جاري التحميل
يكتب...
بحث
 
+

Tutor available for Ms Excel / MS Office / Tally and Computer

أم القيوين أم القيوين >
المجتمع المجتمع >
تعليم تعليم >
التفاصيل
https://dbzstatic-a.akamaihd.net/.dist_55c6d6f34ceabb122cbd1b1c913c867432d5c382/ 9918169

الوصف: نُشِر بتاريخ: 11 إبريل 2018

Everybody knows Excel to some extent.....want to go further.....
Take this course to take your Excel skills to the next level.....

What I cover in this course ?

* Understanding and familiarizing yourself with the Excel 2016 environment and Ribbon
* Start from Filtering Data with different techniques
* Learn how to use subtotals to summarize large data sets
* Master the commonly used formulas for summing thousands of rows
* Understanding when and how to use Absolute Reference and Relative reference
* Counting, Summing and Average Formulas with multiple criteria
* Running Advanced Filter with multiple criteria
* Extract unique entries from thousands of rows
* Master Formulas, Audit them, Decode them, Build Formulas inside Formulas, Arrays
* IF formulas, with AND criteria
* Vlookup with single and multiple criterias
* Text Formulas and its uses
* How to use sparklines
* Goal Seek, Data tables, Sensitivity Analysis
* Use of Index, Match , Offset Formulas
* Formula Auditing tools
* Use of Pivot tables in depth
* Slicers and how to use them effectively
* Conditional Formatting in Excel
* Flash Fill
* Named Ranges and why and how to use them
* Introduction to Macros
* Effective use of Excel Tables
* Using PasteSpecial and its features effectively
* Tons of Excel shortcuts to make you an Excel Star
* How to make effective Charts
* Introduction to Macros, what they are, why use them with live examples.


Days and timings flexible as per your call.
One to One training to get the maximum benefit.

Tag along a friend for the course and get yourself a 30% Discount!!

Other courses I offer:
* Charts and Dashboards
* PowerPoint Essentials
* Mastering Pivot tables in 3 hours
* MS Word for Beginners to Intermediate

Anywhere in Dubai, Sharjah, and Ajman


Call: اعرض رقم الهاتف

انشره مع الأصدقاء

 

راسل المُعلن:

تحذير من رسائل النصب "السكام"
أمثلة على رسائل النصب "السكام"

لا ترسل أموال أو معلومات بنكية لأي بائع عبر الإنترنت. من أجل الحصول على تجربة آمنة، احرص على أن تقوم بالأمور المالية بنفسك.

بلّغ عن رسائل النصب سكام

اعرض رقم الهاتف
أو
دردش اعرض رقم الهاتف

الموقع غير محدد