- Видео 96
- Просмотров 104 255
With Ola Elhossiny
Добавлен 28 мар 2019
The vision Of The Channel is to Provide E-learning Courses To Improve Your Skills And Business For Free.
Microsoft Excel 365 Course Is Available Now And Other Courses Come Out soon.
Support Me And Subscribe To My Channel On RUclips And Hit The Bell Button To Receive The Upcoming Videos And Updates.
Enjoy!!!
Microsoft Excel 365 Course Is Available Now And Other Courses Come Out soon.
Support Me And Subscribe To My Channel On RUclips And Hit The Bell Button To Receive The Upcoming Videos And Updates.
Enjoy!!!
كيفية عمل تحليل للبيانات وإنشاء تقرير محترف باستخدام الجدول المحورى - إكسل
فى الفيديو ده هتتعلم كيفية عمل تحليل للبيانات وخاصة لو حجم البيانات كبير وازاى تنشىء تقرير بشكل محترف وهتعرف كمان ازاى تعرض النسبة المئوية للمبيعات بالنسبة لكل منتج من اجمالى مبيعات الشركة المصنعة للمنتج باستخدام الجدول المحورى
برجاء الاشتراك فى القناة لدعمها وتفعيل الجرس لكى يصلكوا الفيديوهات الجديدة
Source File: 1drv.ms/x/s!AiC0eQKZQgNShAy3Pl7ccmWUKnCx?e=9kcTrf
Video In English Language ruclips.net/video/TYOZgy6rVuE/видео.html
Facebook: WithOlaElhossiny
Group: groups/EXcelTricksWithOlaElhossiny
برجاء الاشتراك فى القناة لدعمها وتفعيل الجرس لكى يصلكوا الفيديوهات الجديدة
Source File: 1drv.ms/x/s!AiC0eQKZQgNShAy3Pl7ccmWUKnCx?e=9kcTrf
Video In English Language ruclips.net/video/TYOZgy6rVuE/видео.html
Facebook: WithOlaElhossiny
Group: groups/EXcelTricksWithOlaElhossiny
Просмотров: 1 814
Видео
How To Make #Analysis To #BigData And Create a Professional #Report Using #PivotTable
Просмотров 2754 года назад
This Video Show You How To make Analysis To Your Big Data And Create a Professional Report By Using Pivot Table. Also You Will Learn How To Display The Share Percentage For Each Item And Its Related Items From The Whole Total. Source File: 1drv.ms/x/s!AiC0eQKZQgNShAy3Pl7ccmWUKnCx?e=9kcTrf If You Like The Contents Please Like The Video And Subscribe To The Channel And Hit The Bell Button To Rece...
How To Summarize #Data Using #PivotTable And Display The Subtotals As Value And As a Percentage
Просмотров 2534 года назад
In This Video You Will Learn How To Create Multilevel Pivot Table, How To Display The Subtotal As Value And How To Display It As a Percentage. Source File: 1drv.ms/x/s!AiC0eQKZQgNSg06C5DVMqGRUDNt3?e=RpAhW7 If You Like The Contents Please Like The Video And Subscribe To The Channel And Hit The Bell Button To Receive The Upcoming Videos And Updates. If You Have Any Feedback Please Comment Below T...
How To Create Sales Transactions App - Data Entry App In Excel Using XLOOKUP Function
Просмотров 1904 года назад
In This Video We Will Learn How To Create An Application Step By Step, You Can Use It In Any Kind Of Transactions Like Sales Transactions, Clients Transactions ...And So On And How To Relate Between The Data By Using XLOOKUP Function. You Should To Know How To Use: 1. XLOOKUP Function. 2. Define Name. 3. Table. 4. Data Validation. 5. IFERROR Function. Source File: 1drv.ms/x/s!AiC0eQKZQgNShApPY-...
How To Summarize Data And Display It As a Percentage Of The Grand Total Using Pivot Table - Excel
Просмотров 2424 года назад
This Video Show You How To Summarize Big Data And How To Make Analysis To It. You Will Learn How To Display The Values As a Percentage Of The Grand Total Of The Values Or Data Points By Using Pivot Table, How To Represent The The Pivot Table Report As a Pivot Chart And How To Make Filter By Using Slicer. Source File: 1drv.ms/x/s!AiC0eQKZQgNSg06C5DVMqGRUDNt3?e=RpAhW7 If You Like The Contents Ple...
How To Use XLOOKUP Function To Evaluate Multiple Conditions In Excel
Просмотров 1,1 тыс.4 года назад
In This Video You Will Learn How To Use XLOOKUP Function To Evaluate Multiple Conditions For Instance Calculate The Salary Tax Rate For Each Employee. When You Use XLOOKUP Your Excel Sheet Will Be More Faster Than You Use Nested IF Function. XLOOKUP Function Available In These Versions: Excel for Office 365 | Excel for Office 365 for Mac | Excel for the web | Excel for iPad | Excel for iPhone |...
How To Create Dynamic Macro - Macros And VBA Series
Просмотров 3,3 тыс.4 года назад
In This Video You Will Know What Is Relative Macro, How To Make Your Macro Dynamic also You Will Learn How To Create Macro That Apply Conditional Format And Apply Currency Format To Your Number Data. Source File: 1drv.ms/x/s!AiC0eQKZQgNShAZXAqrdWsW_oyYX?e=n7vwwe If You Like The Contents Please Like The Video And Subscribe To The Channel And Hit The Bell Button To Receive The Upcoming Videos And...
How To Use XLOOKUP Function In Excel?
Просмотров 3424 года назад
This Video Show You How To Use XLOOKUP Function In Excel, How To Retrieve Data From Another Sheet And Display Data From Multiple Sheets In One Sheet. Source File: 1drv.ms/x/s!AiC0eQKZQgNShARhJZxyYOIw_VZv?e=wcP7aH Office Versions: Excel for Office 365 | Excel for Office 365 for Mac | Excel for the web | Excel for iPad | Excel for iPhone | Excel for Android tablets | Excel for Android phones. If ...
Episode 08 - How To Display Macros, How To Delete It And How To Run Macro By Using Shortcut Key
Просмотров 2094 года назад
This Video Show You How To Know The Macros That Exist In Your File, How To Display It, How To Delete It And How Run The Macro By Using Shortcut Key. If You Like The Contents Please Like The Video And Subscribe To The Channel And Hit The Bell Button To Receive The Upcoming Videos And Updates. If You Have Any Feedback Please Comment Below The Video. Don’t Forget To Like My Page In Facebook. Faceb...
How To Summarize Data By Using Macro - Full Example - Macro And VBA Series - Episode 07
Просмотров 1,8 тыс.4 года назад
This Video Show You How To Create An Automated App By Using Macro And You Will Learn How To Make Data Analysis, Summarize Big Data And How To Display The Subtotals For Data By Just Press a Button. Source File: 1drv.ms/x/s!AiC0eQKZQgNSg1g06AhszL4f3ooa?e=du8jyE Related Videos: How To Sort Data By More Than One Column: ruclips.net/video/x1okI2KWfNQ/видео.html If You Like The Contents Please Like T...
How To Assign Macro To Picture Or Shape - Macro And VBA Series - Episode 06
Просмотров 1 тыс.4 года назад
Do You Know You Can Run Macro By Press a Picture Or Shape, This Video Show You How To Do This, How To Insert Picture And Shape And How To Assign The Macro To It. If You Like The Contents Please Like The Video And Subscribe To The Channel And Hit The Bell Button To Receive The Upcoming Videos And Updates. If You Have Any Feedback Please Comment Below The Video. Don’t Forget To Like My Page In Fa...
How To Run Macro Using Button - Macro And VBA Series - Episode 05
Просмотров 3404 года назад
This Video Show You How To Insert Button And Assign Macro To It To Run The Macro. If You Like The Contents Please Like The Video And Subscribe To The Channel And Hit The Bell Button To Receive The Upcoming Videos And Updates. If You Have Any Feedback Please Comment Below The Video. Don’t Forget To Like My Page In Facebook. Facebook: WithOlaElhossiny Group: groups/EXcel...
How To Save Macro - Macro Security - Macro And VBA Series - Episode 04
Просмотров 2144 года назад
This Video Show You How To Save File Contains Macro And How To Set The Macro Security Settings. If You Like The Contents Please Like The Video And Subscribe To The Channel And Hit The Bell Button To Receive The Upcoming Videos And Updates. If You Have Any Feedback Please Comment Below The Video. Don’t Forget To Like My Page In Facebook. Facebook: WithOlaElhossiny Group: facebook.co...
How MS Excel Record Macro Using VBA - Macro And VBA Series - Episode 03
Просмотров 1454 года назад
This Video Show You How VBA Type The Code For You When Recording Macro And How To Display VBA Window. Related Videos: Macro Overview In Excel - Macro And VBA Series - Episode 01: ruclips.net/video/Y_ytrTwQTYc/видео.html How To Record Macro In Excel - Macro And VBA Series - Episode 02: ruclips.net/video/znLtEK5-EgA/видео.html If You Like The Contents Please Like The Video And Subscribe To The Ch...
How To Record Macro In Excel - Macro And VBA Series - Episode 02
Просмотров 2714 года назад
This Video Show You How To Record Your First Macro, You Are Going To Record a Macro That Print The Active Sheet By Pressing a Button Or Shortcut Key. Related Videos: Macro Overview In Excel - Macro And VBA Series - Episode 01: ruclips.net/video/Y_ytrTwQTYc/видео.html How To Create An Automated Filter App Without Typing VBA In Excel - Macro: ruclips.net/video/Xeh3GLYYOuc/видео.html If You Like T...
Macro Overview In Excel - Macro And VBA Series - Episode 01
Просмотров 2434 года назад
Macro Overview In Excel - Macro And VBA Series - Episode 01
The Best Practice When Using VLOOKUP Function - Tips And Tricks - VLOOKUP Part5
Просмотров 1454 года назад
The Best Practice When Using VLOOKUP Function - Tips And Tricks - VLOOKUP Part5
How To Handle #N/A Error When Using VLOOKUP Function - Trick2 - VLOOKUP Function Part4
Просмотров 2214 года назад
How To Handle #N/A Error When Using VLOOKUP Function - Trick2 - VLOOKUP Function Part4
VLOOKUP Function Tips And Tricks - Trick1 - VLOOKUP Part3
Просмотров 1654 года назад
VLOOKUP Function Tips And Tricks - Trick1 - VLOOKUP Part3
How To Evaluate Multiple Conditions By Using VLOOKUP Function - In Excel - VLOOKUP Part2?
Просмотров 2524 года назад
How To Evaluate Multiple Conditions By Using VLOOKUP Function - In Excel - VLOOKUP Part2?
How To Use VLOOKUP Function In Excel - VLOOKUP Part1?
Просмотров 1954 года назад
How To Use VLOOKUP Function In Excel - VLOOKUP Part1?
How To Compare Between The Sales Using Conditional Format - Excel?
Просмотров 2104 года назад
How To Compare Between The Sales Using Conditional Format - Excel?
How To Use WORKDAY.INTL Function In Excel?
Просмотров 1994 года назад
How To Use WORKDAY.INTL Function In Excel?
How To Create, Save, Modify And Delete Your Won Template In Excel?
Просмотров 3,8 тыс.4 года назад
How To Create, Save, Modify And Delete Your Won Template In Excel?
How To Create Sales Invoice In a Professional Way In Excel?
Просмотров 1114 года назад
How To Create Sales Invoice In a Professional Way In Excel?
How To Create An Automated Filter App Without Typing VBA In Excel - Macro?
Просмотров 3734 года назад
How To Create An Automated Filter App Without Typing VBA In Excel - Macro?
How To Enter The Percentage Value And Limit Its Value - Data Validation - Excel?
Просмотров 3,9 тыс.4 года назад
How To Enter The Percentage Value And Limit Its Value - Data Validation - Excel?
How To Make Sure Of The Date Value Accuracy In Excel - Data Validation - Date?
Просмотров 5404 года назад
How To Make Sure Of The Date Value Accuracy In Excel - Data Validation - Date?
How To Identify Specific Date - Number - Text In Data List By Using Conditional Format In Excel?
Просмотров 1874 года назад
How To Identify Specific Date - Number - Text In Data List By Using Conditional Format In Excel?
Business Solutions And Training Academy - E-learning Courses - Excel
Просмотров 9384 года назад
Business Solutions And Training Academy - E-learning Courses - Excel
Great job thank you 🤯🤯
My pleasure
Perfect thank you a lot
nice
Thank you!
My pleasure
Thank you!
My pleasure
Thanks
My pleasure
Outstanding dear Ola! Best regards from Limón, Costa Rica!
Cool! Thank you!
My pleasure
Right what I was looking 😊 thank you so much
My pleasure
Great way of teaching with clear example
Thank You So Much
Thanks madam for the short but vital excel tutorial
Thank you
Thanks for sharing this..
My Pleasure
الله يعطيك العافية بدي اسئلك كيف بساوي قناتي مقترحة بالبحث باليوتيوب
شكرا جزيلا
@@witholaelhossiny4505 اين الرد على سؤالي
thank you for the video, i couldn't figure out how to set a limit for percentage and now i do :)
My Pleasure
Nice Video many Thanks helps a lot.
My pleasure, glad to hear that.
Thanks, it was short, useful and clear
My Pleasure
10/10
Thank you
This is that I want, AMAZING BROOO
Thank You So Much
Excelent video, simple and straight to the point
Thank You So Much
Thanks!
My pleasure
thank you so much
My pleasure
thanks, Dr. Ola for your efforts
My pleasure ahmed
I tried the cumulative table, but it only shows #N/A. Can you help me please?
You Should To Check The Source Data Maybe The Numbers Formatted As Text.
HOW TO MAKE ACCUMLATED BALANCE IN ACC STATEMENT SUCH AS DIF BETWEEN DB - CR = ACCUMLATED BALANCE
You Can Do That By Using Pivot Table, But You Can Do That By Creating a Formula. First Create a Design For Your Accounts Then Create a Column To Calculate The a Cumulated Value For Your Account.
Need % for sub total from grand total And % items from Sub total
I'm So Sorry I Didn't See Your Comment But This Video Will Help You. ruclips.net/video/Bc9b_1TojZk/видео.html
شرح ممتاز ومبسط، لك خالص الشكر والتحية
شكرا جزيلا
Thank you! This video really helped me.
I'm so glad!
فيديو رائع لكن فين الملف عشان نقدر نتدرب عليه
شكرا جزيلا يمكنك تنزيل الملف من ال Description.
السلام عليكم ورحمة الله وبركاته انا شوفت شغل لحضرتك ممتاز بس بلفت نظر حضرتك ان فيه ناس كتير بيستخدمو اوفس عربى يعنى ياريت تركزى على الشرح عربى
شكرا جزيلا لحضرتك
5:32
Thank you very much this saved my life.
My Pleasure
Thank you soo muchhhh
My Pleasure
How to do same thing in reverse ? Like burn down in pivot table ?
video is good and presentation too but I can't hear your voice
Thank you, it is helpful
Thank you ma'am!
My Pleasure
Thank you so much
My Pleasure
Excellent, your video was very helpful
Glad to hear that!
That was great, thank you so much
My Pleasure
خلى فيديوهاتك يتخللها حوار عربى الى جانب المسطلحات
طب باقى الدوال غير ال sum فى الكنسيليديت
يمكنك إستخدام إى داله من الدوال الإخرى. يتم تطبيق نفس الخطوات ثم يتم إختيار ألداله التى تريد إستخدامها
Thanks, it's exacly what I needed.
Glad to hear that!
Very informative....jazak Allah
My Pleasure
رائع بس ياريت لو تعملي فيديوهات الشرح يكون بالعربي لو امكن
شكرا لحضرتك المتابعين ليا من دول وجنسيات مختلفة لذلك الفيديوهات باللغة الانجليزية وذلك بناء على طلبهم
ده لينك لبعض الفيديوهات إللى باللغة العربية ruclips.net/p/PL8JRiyvIuZu3jjUk5X3PsPJkVfcZ19BfN
Hi Can you show how to create a monitoring base from KPI in excel?
Hi I have a lot of videos about conditional format you can use it to make analysis to your data. This is the link ruclips.net/p/PL8JRiyvIuZu1-uk4cy1Cb_ccUaENi-n-b
nice tutorial! .... the source file link cannot be opened???
The link is working please try again
Dear MRS. OLA Is an interesting article and by the way all your videos are very interesting But My Question is : why you don't let an example or the Excel Sheet so we can get an example to practice it Thanks and Best Regards
Thanks for your feedback Mr. Adel, there's a lot of the videos have the source file you can download it from the video description. Regards
thank you that is great
My Pleasure
And how to add half day?
This Function Couldn't Add Half Day It Calculates The Whole Day
How to insert a new employee in this designed table?
And how if i want to add half holiday?
At The End Of The Employees Table Press Tab New Row Will Be Inserted Then Type The New Employee. Note That I Used a Table To Enter The Employees Data
I Updated The Video With The Source File It Will Help You