With Ola Elhossiny
With Ola Elhossiny
  • Видео 96
  • Просмотров 104 255
كيفية عمل تحليل للبيانات وإنشاء تقرير محترف باستخدام الجدول المحورى - إكسل
فى الفيديو ده هتتعلم كيفية عمل تحليل للبيانات وخاصة لو حجم البيانات كبير وازاى تنشىء تقرير بشكل محترف وهتعرف كمان ازاى تعرض النسبة المئوية للمبيعات بالنسبة لكل منتج من اجمالى مبيعات الشركة المصنعة للمنتج باستخدام الجدول المحورى
برجاء الاشتراك فى القناة لدعمها وتفعيل الجرس لكى يصلكوا الفيديوهات الجديدة
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

Комментарии