- Видео 335
- Просмотров 1 645 144
Balawii Tech
Великобритания
Добавлен 28 фев 2019
Waa kusalaamay magaceygu waa Ibrahim Adam Mohammed .
Kusoo dhowow chanalkeena ee Balawii
Adigoo rukumanayo ama subscribe saaraayo
Waayo waxaad kabarandoontaa casharo kusaabsan
video editing , graphic design iyo mobile📱&coputer👩💻
Waliba si bilaash ah ama lacag la aan ah
Inta lagu guda jiro casharka si toos ah ayaa kuu tusinayaa waxa aan ka hadlaayo markaas
👩💻📲 ha iska ilaawin inaad subscribe dhahdo
Mahad sanid 100%
Kusoo dhowow chanalkeena ee Balawii
Adigoo rukumanayo ama subscribe saaraayo
Waayo waxaad kabarandoontaa casharo kusaabsan
video editing , graphic design iyo mobile📱&coputer👩💻
Waliba si bilaash ah ama lacag la aan ah
Inta lagu guda jiro casharka si toos ah ayaa kuu tusinayaa waxa aan ka hadlaayo markaas
👩💻📲 ha iska ilaawin inaad subscribe dhahdo
Mahad sanid 100%
17.Ms Excel- Top 30 Shortcut-yada loogu isticmaal Badan yahay Excel || Frequently Excel Shortcuts.
Muuqaalkan Waxaad ku baran doontaa shortcut yada loogu isticmaal badan yahay ee Microsoft Excel.
Top 30 Shortcuts:
1 Ctrl + C Copy
2 Ctrl + V Past
3 Ctrl + X Cut
4 Ctrl + Z Undo
5 Ctrl + Y Redo
6 Ctrl+B Apply bold Formatting
7 Alt+H Go To the Home Tab
8 Alt+N Go To the Insert Tab
9 Alt+M Go To the Formulas Tab
10 Alt+H,B Add Borders
11 Ctrl+Shift+L Add/Remove Filter
12 Ctrl+T Create Table
13 Ctrl + Arrow key Move To the Edge
14 Ctrl + Shift + Arrows Selection of Cells
15 Ctrl + 1 Format Cells
16 Alt+ = Automatic Sum
17 Alt+E , S , V Past as Values
18 Alt + Enter New Line in Cell
19 Cltr+A Select Data in Current Range
20 Alt+F1 insert Chart
21 Ctrl+E Flash Fill
22 Shift+Space Select Entire Row
23 Ctrl + Space Sel...
Top 30 Shortcuts:
1 Ctrl + C Copy
2 Ctrl + V Past
3 Ctrl + X Cut
4 Ctrl + Z Undo
5 Ctrl + Y Redo
6 Ctrl+B Apply bold Formatting
7 Alt+H Go To the Home Tab
8 Alt+N Go To the Insert Tab
9 Alt+M Go To the Formulas Tab
10 Alt+H,B Add Borders
11 Ctrl+Shift+L Add/Remove Filter
12 Ctrl+T Create Table
13 Ctrl + Arrow key Move To the Edge
14 Ctrl + Shift + Arrows Selection of Cells
15 Ctrl + 1 Format Cells
16 Alt+ = Automatic Sum
17 Alt+E , S , V Past as Values
18 Alt + Enter New Line in Cell
19 Cltr+A Select Data in Current Range
20 Alt+F1 insert Chart
21 Ctrl+E Flash Fill
22 Shift+Space Select Entire Row
23 Ctrl + Space Sel...
Просмотров: 375
Видео
16.MS Excel- Sida Loo Soo Galiyo Xog Microsoft Excel || import Data & objects || From Pdf or Web.
Просмотров 29114 дней назад
Muuqaalkan Waxaad Ku Baran Doontaa Sida Loo Soo Galiyo Xog Microsoft Excel iyo Objects, Xogta la soo galinaayo Waxaa ka mid ah Pdf ama website xog laga soo qaaday iyo sida loo soo galiyo loona Abuuro Objects, Objects ka waxaa ka mid ah sida word , Power Point ama video iyo Wlm. Si Gaar ah Qodobadan Ayaad Ku Baran Doontaa Muuqalkan: 1) Import Data from Pdf 2) Import live Data from web 3) Insert ...
15.Ms Excel- Sida loo isticmaalo Data Validation in Excel by @Balawii
Просмотров 29514 дней назад
Muuqaalkan Waxaad Ku Baran doontaa Sida loo isticmaalo Data Validation in Excel, sida loo Sameeyo Drop Down list iyo wlm. Si Gaar Ah Waxaad Ku Baran doontaa Qodobadan Hoose: Data Validation *Whole Numbers *Text Length *Date *DropDown List input Messages Error Messages *stop *warning *information Dependent Dropdown List Required: Name Range Formula: indirect Waan Ku Mahad santahay Daawashadaa da...
14.MS Excel - Sida loo isticmaalo Conditional Formatting in Excel. by Eng @Balawii #tutorial
Просмотров 21014 дней назад
Muuqaalkan Waxaad Ku Baran doontaa Sida loo isticmaalo Conditional Formatting in Excel Ayadoo Faahfaahsan. Conditional Formatting Waxaa la isticmaalaa Marka Aad Ubaahantahay inaa Falanqeydo xogta ama wixii muhiim ah inaa kalar gooni ah aad mariso, Siyaabo kala Duwan baa loo isticmaali karaa sida inaa calamadeysato faaiidada ama khasaaraha aad sameysay iyo wlm. Conditional formatting waxay door ...
13.Ms Excel- Sida la isugu xiro Waraaqado Badan loogadhigo halwarqad | Consolidation. @Balawii
Просмотров 23514 дней назад
Muuqaalkan Waxaad ku baran doontaa sida loo isticmaalo Consolidation Si gaar ah waxaad ku baran doontaa Qeybahan: introduction 3DSum Static All same Consolidation Linked All Same Consolidation Static All Different data Consolidation Linked All Different data Consolidation Format painter Summery leaning more... ▶ ▶ Waan Ku Mahad santahay Daawashadaa da Waxaan Filayaa inaa nagu soo biirtay #balaw...
12.Ms Excel - Sida loo Abuuro Pivot Table in Excel. @Balawii
Просмотров 29114 дней назад
In this step-by-step tutorial for beginners, learn how to create a pivot table in Microsoft Excel. With an Excel Pivot Table, you can very quickly and easily analyze data without needing to use any formulas or functions. You can generate insights just by dragging and dropping fields. We start with how to prep your data and then walk through all the core functionality of pivot tables, including ...
11.MS Excel-Sida loo sameeyo Charts in Excel Tutorial. @Balawii
Просмотров 22221 день назад
Hi everyone, balawii here. Today, we're going to learn how to make a chart in Excel. Charts are a great way to visualize and analyze your data, and Excel offers a variety of different chart types. You have line charts, pie charts, pivot charts, and many more. We're going to start with the basics of creating a chart, formatting it, and then also modifying it, and we'll also cover some tips and t...
10. Ms Excel- Sida loo Abuuro Table iyo Subtotal By Eng @Balawii .
Просмотров 22221 день назад
Muuqaalkan waxaad Ku Baran Doontaa Sida Loo Abuuro Table iyo Subtotal Anagoo Adeeg Saneyno Microsoft Excel. Qodobada Aad Ku Barandoonto Casharkan Waa: 1.Basic Table Create Table(Shortcuts) Design Tab Filter,Sort, sort by Color Table Style Options 2.Advanced Table Rename Table Resize Table Slicer for Table Remove Duplicates Convert to Range 3.Subtotal Sort first Add Subtotal Remove Subtotal Daaw...
9. Ms Excel - Sort & filters ⋙ Sida loo isticmaalo. #balawii
Просмотров 25321 день назад
Muuqaalkan waxaa ku baran doontaa 3 cashar oo kala ah: 1. Data sorting 2. Basic filtering 3. Advanced filters sida xogta loo kala sooco loona shaandheeyo ayaad ku baraneysaa. si gooni ah waxaad ku baran doontaa qodobadan:- 1. Data sorting: Numbers Text Dates Color Sort MultiColumn Sorting 2. Basic filtering: Filter Drop Arrows Check boxes Date Filter Number Filter Text Filter Search Copy Paste ...
8.Ms Excel -Sida loo Daabaco Waraaqad Excel ah » Page Setup →Header & Footer.
Просмотров 32921 день назад
Muuqaalkan Waxaad Ku Baraneysaa Inta Aad Daabacin Waraaqad Excel ah Qaabka Aad U Hagaajin Laheyd ,Waraaqada Qeybta Kore(Header) iyo Qeybta Hoose(Footer) loo Maamulo. Wax Yaabaha Aad Ku Baran Doonto Muuqaalkan Waxaa Ka Mid Ah: 1.Page Setup: » Margins = Top →Bottom, Left →Right » Size of Letter » Orentation → Portrait→Landscape » Print Area » Print Titles »Rows to Repeat at top »Columns to Repeat...
5 Farsamo Kor Loogu Qaado Xawaaraha Computer-ka || 5Tricks to speed up Windows. @Balawii
Просмотров 30328 дней назад
Muuqaalkan waxaad ku baran doontaa 5 farsamo kor loogu qaado xawaaraha computer ka si uu u noqdo isticmaal kiisa mid fudud.
7. Ms Excel - Hyperlinks || Baro dhamaan Hyperlinks ka Excel sida loo sameeyo. #balawii #excel
Просмотров 29128 дней назад
Muuqaalkan waxaad ku baraneysaa How to Insert Hyperlink Edit Hyperlink Remove Hyperlink Change Hyerlink color Formula Hyperlink Daawasho wacan Hadii Aad Nagu soo biirin Fadlan Subscribe Dheh si Aad noo dhiiri galiso,Thanks.
6.Ms Excel - Protection || Sida Password Loogu xiro sheets, Cells, File iyo Workbook.
Просмотров 278Месяц назад
Cutubkan waxaa Ku baraneysaa Wax Walboo La xariira Password ka sida password loogu xiro sheets, Cells, File iyo Workbook ga.
5.Ms Exce - Lookup sida loo isticmaalo
Просмотров 266Месяц назад
Cutubkan waxaad ku baran doontaa Lookup. Qodobadan soo socdo ayaa ku baran doontaa: 1) VLOOKUP with exact match 2) VLOOKUP approximate match 3) VLOOKUP with Trim 4) VLOOKUP Rules 5) H-Lookup 6) Lookup function 7) Index function 8) Match function
4.Ms Excel - Functions and Formulas sida loo isticmaalo. @Balawii
Просмотров 710Месяц назад
4.Ms Excel - Functions and Formulas sida loo isticmaalo. @Balawii
3.Ms Excel - Logical Functions Sida loo isticmaalo. @Balawii
Просмотров 563Месяц назад
3.Ms Excel - Logical Functions Sida loo isticmaalo. @Balawii
1.ms Excel - Basics || Aas Aaska Microsoft Excel. by @Balawii
Просмотров 1,8 тыс.Месяц назад
1.ms Excel - Basics || Aas Aaska Microsoft Excel. by @Balawii
Hordhaca Barashda Mircrosoft Excel VIP Online Training Course || Ogeysiis koorso Cusub. @Balawii
Просмотров 1,2 тыс.Месяц назад
Hordhaca Barashda Mircrosoft Excel VIP Online Training Course || Ogeysiis koorso Cusub. @Balawii
67.Ms Excel- Top 30 Shortcut-yada loogu isticmaal Badan yahay Excel || Frequently Excel Shortcuts.
Просмотров 843Месяц назад
67.Ms Excel- Top 30 Shortcut-yada loogu isticmaal Badan yahay Excel || Frequently Excel Shortcuts.
66.MS Excel- Sida Loo Soo Galiyo Xog Microsoft Excel || import Data & objects || From Pdf or Web.
Просмотров 541Месяц назад
66.MS Excel- Sida Loo Soo Galiyo Xog Microsoft Excel || import Data & objects || From Pdf or Web.
65.Ms Excel- Sida loo isticmaalo Data Validation in Excel by @Balawii
Просмотров 704Месяц назад
65.Ms Excel- Sida loo isticmaalo Data Validation in Excel by @Balawii
64.MS Excel - Sida loo isticmaalo Conditional Formatting in Excel. by Eng @Balawii #tutorial
Просмотров 663Месяц назад
64.MS Excel - Sida loo isticmaalo Conditional Formatting in Excel. by Eng @Balawii #tutorial
63.Ms Excel- Sida la isugu xiro Waraaqado Badan loogadhigo halwarqad | Consolidation. @Balawii
Просмотров 937Месяц назад
63.Ms Excel- Sida la isugu xiro Waraaqado Badan loogadhigo halwarqad | Consolidation. @Balawii
Mobile kaada Ku isticmaal App Microsoft Office IOS ama Android labaduba.
Просмотров 282Месяц назад
Mobile kaada Ku isticmaal App Microsoft Office IOS ama Android labaduba.
Barashada Sida Loo isticmaalo Microsoft To Do List. by @Balawii
Просмотров 4072 месяца назад
Barashada Sida Loo isticmaalo Microsoft To Do List. by @Balawii
62.Ms Excel - Sida loo Abuuro Pivot Table in Excel. @Balawii
Просмотров 8752 месяца назад
62.Ms Excel - Sida loo Abuuro Pivot Table in Excel. @Balawii
61.MS Excel-Sida loo sameeyo Charts in Excel Tutorial. @Balawii
Просмотров 1,2 тыс.2 месяца назад
61.MS Excel-Sida loo sameeyo Charts in Excel Tutorial. @Balawii
Sida loogu qoro Outline Ms Word || How to Write an Outline in MS Word.
Просмотров 1,1 тыс.2 месяца назад
Sida loogu qoro Outline Ms Word || How to Write an Outline in MS Word.
Natiijada Imtixaan ka Sida loogu Dejiyo Excel Wado Fudud. #balawii #excel
Просмотров 1,4 тыс.2 месяца назад
Natiijada Imtixaan ka Sida loogu Dejiyo Excel Wado Fudud. #balawii #excel
Koorsadan waa dhahay stay aad baan kaga mahadcelinayaa ustaad
macalin khyr alle haku siyo hada bilabanyye❤
Ishallh sxb korsadan wa dhamesandoa❤❤❤😅
Ishallh sxb kor😊😊😊😊sadan wa dhamesandoa
Ilahay cilmiga ha ku barakeeyo
Thank you sxb
Sidee marka hore sawirada loo soo gashtaa computerka
Fadlan macalin casharadaada ajar iyo xasanaad allaha kaa siiyo laakiin muusiga da oo ku daaran ayaa Naga qashqashaadayee ma Naga xiri kartaa adooadoo raaliya
Macalin Halkee kaala soo xariiri karaa koorso dhamaystiran ayaan u baahanahay
Cypero meshan ugeyay weykuwareren cashirkan ubaahanyihin umaleya
M'a ustad cashir lobahanyahy waye
Ustaad course excel and data analysis ah noo soo samee adoo mahadsan
Thanks, ustaadi si fcn ayaan u fahmey casgarka
Telegram link noo soo dhig ustaad
Mahadsand maclin
mahadsanid wu is anfacay
Contact ka macalin
Data base teacher
waxaan rabna in aad noo bilawdo cours cusub oo ku saabsan powerpoint
Ctrl +E= flash fiil hal jimel leen qoran kuwa kale hakuu kaimaady
Courseka kale database noo bilaaw bilaaw ilaa dhamaad ustaad❤
Thanks
sir marka jido aniga wax uu iga noqana wada #### camal wa maxay
𝑇ℎ𝑎𝑛𝑘𝑠 𝑦𝑜𝑢 𝑚𝑐𝑛
😂😂
Nio course cusub ayan ubahanahy iso qabo
Ustaad Course Ms-accesses inoo biloow
Wll cilad baan ku arkay hadii aan true galiyo xisaab qaldan baa so baxaysa false hadan galiyana xisaab saxan
Anna wan u bahanahy wlh
Walada kushaysha Tamara dabka koritadda ooogt ulhe in eey xog aqbasho shandheso keydisho isla marka soban dhito najidada ama fiso ĥwsha lodiray iyada ooracesha tilmaha lasiiyey😊
Vlookup,hlookup ka soo hadal abti
Ustdii hadii aad dhameyso coursigah excelka. Nogu xiji word
Waxbadan Ayaan Kaa Fa,idey Runtii
Ustaad courses ayaa rabaa whatsapp waaye namberka
Ustdii cousegah Excel hadii dhamaato word noo soo gali ustdii advaced io basic🙏🙏
Thanks
Thanks teacher balawi