Haddii aad rajaynayso inaad barato oo aad fahamto aasaaska Microsoft Excel , markaa casharkan wuxuu ku hagi doonaa bilowga dhammaan astaamaha aad u baahan tahay inaad ogaato. Excel waa codsiga horudhaca ah ee ay isticmaalaan warshado badan si ay u dejiyaan qorshayaasha ganacsiga, abuurista warbixinnada maaliyadeed, soo saarista warbixinnada miisaaniyada, iwm. Erayada fudud, xaashiyaha Excel^(Excel) waxaa loo isticmaalaa in lagu habeeyo noloshaada shaqo. In kasta oo Excel uu yahay aalad faafin awood leh, haddana qofku waligiis wuu shaqo geli karaa, maaraynta   Excel waxay noqon kartaa waqti-qaadasho waxayna u badan tahay inay u baahan tahay xoogaa dulqaad ah si ay ula shaqeyso xaashiyaha Excel^(Excel) .

Barashada Microsoft Excel^{(Microsoft Excel Tutorial)} ee Bilowga ah^(Beginners)

Si aad u furto Microsoft Excel , dhagsii badhanka Start oo hoos ugu dhaadhac Excel oo ku hoos jira xulashada Microsoft Office ; ama si fudud uga dhex raadi sanduuqa raadinta.

Guji xaashida shaqo ee banaan^{(Blank Worksheet)} si aad u bilowdo. Tani waa sida xaashida shaqada ee bannaan^{(Blank Worksheet)} u eg tahay.

Waxaad ku arki doontaa dhowr tabo oo ku yaal Ribbon oo ku yaal xagga sare ee xaashida shaqada sida Guriga, Gelida, Sawirka, Laydhka Bogga, Foomamka, Xogta, Dib u eegista, Aragtida, Caawinta, iyo Faylka. ^{(Home, Insert, Draw, Page Layout, Formulas, Data, Review, View, Help, and File.)}Aan soo marno mid kasta oo iyaga ka mid ah.

1) Guriga

Tabka Guriga^(Home) waa tabta ugu habboon ee ku jirta Xaashida Shaqada ee Microsoft Excel^{(Microsoft Excel Worksheet)} . Shabkaan waxa ku jira qaybo ay ka mid yihiin sabuuradaha, xarfaha, toosinta, nambarka, Qaababka, Unugyada, iyo Tafatirka^{(Clipboard, Font, Alignment, Number, Styles, Cells, and Editing)} .

Waxa ugu muhiimsan dhammaan waa Font iyo alignment^{(Font and Alignment)} halkaas oo aad ku dooran karto far cusub qoraalkaaga xulashooyin kala duwan oo jira, beddelo cabbirka iyo midabka xarfaha, ku toosi macluumaadkaaga bidix, midig ama bartamaha, iyo sidoo kale toosin qoraalka sare, hoose ama dhexe. Waxaad ka dhigi kartaa qoraalkaaga mid geesinimo leh, farta ku fiiqaya sidoo kalena hoosta ka xariiqi kartaa ama laba jibaari kartaa. Waxaad mari kartaa xuduudaha unugga la doortay oo waxaad sidoo kale bedeli kartaa midabka asalka ah ee isku midka ah si aad uga dhigto mid muuqda. Waxaad isku dari kartaa oo ku dari kartaa unugyada la doortay hal unug oo weyn.

Hoosta qoraalka ku duub^{(Wrap Text)} , waxaad ku duubi kartaa oo aad ku dhejin kartaa qoraal dheer oo dheeraad ah oo u geli kara sadar badan si ay si fiican ugu muuqato.

Qeybta nambarada, waxaad dooran kartaa qaabka unugyadaada sida tirada, lacagta, taariikhda, waqtiga, boqolleyda, jajabka, iwm. Qeybta Hababka ^{(Number )},^(Styles) waxaad u qaabeyn kartaa unugyo la soo xulay oo leh qaab u gaar ah waxaadna dooran kartaa midabo kala duwan. qaabka unugga si loo muujiyo xogta muhiimka ah ama waxa ku jira.

Unugyada^(Cells) hoostooda , waxaad geli kartaa ama ku dari kartaa unugyo cusub, saf, tiirar, iyo go'yaal sidoo kale waad tirtiri kartaa. Waxaad hagaajin kartaa dhererka safka, ballaca tiirka, qarin oo qarin kartaa safafka iyo tiirarka, dib u magacaabi kartaa iyo sidoo kale guuri ama koobi kara xaashida. Qaybta Tafatirka^(Editing) , waxaad ka heli kartaa oo ku beddeli kartaa qoraalka wax kale, kala saari kartaa oo shaandheyn kartaa xogtaada sidoo kale waxaad u fulin kartaa hawlo kala duwan sida celceliska, wadarta, max, min, iwm. si hufan.

Akhri^(Read) : Xirfadaha Microsoft Excel waqti-badbaadinta ee shaqada degdegga ah .

2) Gelida

Gelida tabku waxa uu ka kooban yahay Shaxano, Sawiro, Ku-dar, Jaantusyo, Dalxiisayaal, Khadadka Spark, Filters, Links, Text, iyo Calaamadaha.^{(Tables, Illustrations, Add-ins, Charts, Tours, Sparklines, Filters, Links, Text, and Symbols.)}

Qaybta Shaxda^(Tables) , waxaad ku dari kartaa miis si aad u habayso, u kala soocdo, u shaandhayso iyo qaabka xogta. Hoosta Sawirrada iyo Jaantusyada^{(Illustrations and Charts)} , waxaad ku dari kartaa sawirada kombiyuutarkaaga iyo sidoo kale internetka. Waxaad ku dari kartaa qaabab, astaamo, moodooyinka 3D, SmartArt , jaantusyada, pie, shaxanka khariidadda, PivotChart , iwm.

Xiriiriyayaashu^(Links) waxay kuu oggolaanayaan inaad ku darto hyperlink dukumeentigaaga kaas oo ku siinaya inaad si degdeg ah u gasho boggaga internetka iyo faylasha kale.

Qaybaha Qoraalka iyo Calaamadaha^{(Text and Symbols)} , waxaad ku dari kartaa sanduuqa qoraalka, madax iyo cageeyaha, WordArt , xariiqa saxeexa, shayga, isla'egta, iyo calaamada.

3) Barbaro

Shabakadda Sawirka^(Draw) , waxaad ka heli doontaa saddex kooxood sida Qalabka, Qalimaan, iyo Beddela^{(Tools, Pens, and Convert)} .

Waxaad ku dari kartaa qalin, qalin ama wax iftiimiye si aad u sawirto qaabab; iyo sidoo kale, tirtir khad haddii si khalad ah loo sameeyo.

4) Qaabka Bogga

Tabaha Layout^(Layout) ee Bogga waxa ku jira amarro tiro badan oo la xidhiidha mawduucyada, Dejinta Bogga, Habayn, Miisaanka ku habboon, iyo Ikhtiyaarada Xaashida^{(Themes, Page Setup, Arrange, Scale to Fit, and Sheet Options)} .

Mawduucyada^(Themes) hoos yimaada , waxaad bedeli kartaa farta iyo palette midabka, waxaadna ku dari kartaa saameyno kala duwan si aad u bedesho muuqaalka iyo dareenka dukumeentiga. Waxaad si toos ah u dooran kartaa mawduuc diyaar ah si aad dukumeentigaaga uga dhigto mid wanaagsan oo soo jiidasho leh.

Kooxda Dejinta Boggu^{(Page Setup)} waxay kuu ogolaanaysaa inaad dejiso oo aad hagaajiso cabbirada margin iyo sidoo kale inaad beddesho jihaynta bogga iyo cabbirka warqadda dukumeentiga. Sawir asal ahaan sidoo kale waa lagu dari karaa. Arag ikhtiyaarka Miisaanka ku^{(Scale to Fit)} habboon si aad u yarayso ballaca ama dhererka daabacaada si ay ugu habboonaato tiro bogag ah.

Akhri^(Read) : Microsoft Excel Talooyin iyo tabaha khadka tooska ah ee kaa caawinaya inaad bilowdo.

5) Foomamka

Hoosta Formulas tab, waxaad ku dari doontaa qaybo ay ka mid yihiin Maktabada Shaqada, Magacyada La Qeexay, Xisaabinta Formula, iyo Xisaabinta^{(Function Library, Defined Names, Formula Auditing, and Calculation)} .

Bilawga, waxaas oo dhan waxay u eegi doonaan kuwo aad u adag. Markaa, waxyaabaha aasaasiga ah ee aad u baahan tahay inaad fahanto waa sida loo fuliyo hawlaha wadarta baabuurta sida wadarta, celceliska, iwm. iyo sida loo xisaabiyo qaacidooyinka. Ka dib markaad ka doorato xogta unugyada, dhagsii liiska hoos u dhaca ee amarka wadarta otomaatiga ah ee Maktabada Hawlaha^{(Functions Library)} ka dibna dooro shaqada aad rabto inaad qabato. Qaybta Xisaabinta^{(Calculation)} , waxaad dooran kartaa inaad xisaabiso qaacidooyinka si toos ah ama gacanta. Si fudud^(Simply) , dhagsii liiska hoos u dhaca ee ku hoos jira xulashooyinka xisaabinta.

6) Xogta

Qaybta xogta^(Data) , waxaad ka heli doontaa qaybo kala duwan oo lagu magacaabo Data Tools, Su'aalo iyo Xiriirinta, Kala-soocida iyo Filter, Hel oo Beddel Xogta, Saadaasha, iyo Muuqaalka.^{(Data Tools, Queries and Connections, Sort and Filter, Get and Transform Data, Forecast, and Outline.)}

Waxaad xogta ka soo saari kartaa ilo badan sida shabakada ama ilo kasta oo dhow. Waxaad xaqiijin kartaa xogta adiga oo dejinaya shuruucda ansaxinta oo ka saar nuqullada adiga oo dooranaya tiirka aad rabto inaad hubiso.

7) Dib u eegis

Tabka dib u eegista^(Review) waxa ku jira amarada la xidhiidha caddaynta, Helitaanka, Aragtida, Luuqadda, Faallooyinka, Ilaalinta, iyo Khadka^{(Proofing, Accessibility, Insights, Language, Comments, Protect, and Ink)} .

Shaqada higgaadu^(Spelling) waxay hubin doontaa dhammaan khaladaadka qoraalka iyo naxwe ahaaneed ee ku jira dukumeentigaaga waxayna ku weydiin doontaa inaad dib u eegto si waafaqsan. Haddii ay dhacdo xog sir ah ama muhiim ah, waxaa jira ikhtiyaar lagu ilaalinayo xaashida ama buugga shaqada. Tani waxay ka hortagtaa kuwa kale inay wax isbedel ah ku sameeyaan dukumeentiga ama guuraan, ku daraan ama tirtiraan xaashida. Sidaas awgeed xogtu waxay ahaanaysaa badbaado iyo dhawrsanaan.

8) Daawo

Gudaha View tab, waxaad ku arki doontaa qaybo ay ka mid yihiin Aragtida Buuga Shaqada, Show, Zoom, Window, iyo Macros^{(Workbook Views, Show, Zoom, Window, and Macros)} .

Dukumeentigaaga waxaad ku arki kartaa muuqaal caadi ah; ama aragtida jebinta bogga, halkaas oo aad ka arki karto sida dukumeentigaagu u ekaan doono marka la daabaco.

9) Caawin

Tabinta Caawinta waxay kaa^(Help) caawinaysaa inaad caawimo ku hesho adigoo isticmaalaya xafiiska Microsoft ama la xidhiidh wakiilka Taageerada Xafiiska^{(Office Support Agent)} . Waxaad wax badan oo ku saabsan Excel ka baran kartaa adiga oo sii maraya tababar online ah. Waxaad sidoo kale bixin kartaa talooyin iyo faallooyin.

10) File

Tabaha Faylka^(File) waxaa ku jira amarada si loo kaydiyo, loo daabaco, loo wadaago, loo dhoofiyo, loona daabaco dukumeentiga. Waxa kale oo aad geli kartaa fursadaha dheeraadka ah ee Excel oo aad samayn kartaa isbeddellada lagama maarmaanka ah ee goobaha.

Sidan, adoo isticmaalaya talooyinkan iyo tabahan, waxaad ka dhigi kartaa dukumeentigaaga Excel si fiican u habaysan oo la soo bandhigi karo si hufan oo habboon.

Waxaan rajeynayaa in casharkan ku saabsan Microsoft Excel uu waxtar lahaa.

Hadda akhri^{(Now read)} : Talooyinka Microsoft Excel si aad u badbaadiso wakhtiga oo aad si dhakhso leh u shaqeyso.

Microsoft Excel Tutorial, for Beginners

If you are looking forward to lеarning and understand the basics of Microsoft Excel, then this tutorial will guide beginners through all the features you need to know. Excel is the premiere application used by many industries to frame business plans, create financial reports, produce budget reports, etc. In simple words, Excel spreadsheets are used to systematize your work life. While Excel is a powerful spreadsheet tool, one can ever get to work, mastering  Excel can be time-consuming and it would probably require some patience to work with Excel spreadsheets.

Microsoft Excel Tutorial for Beginners

To open Microsoft Excel, click on the Start button and scroll down to Excel under the Microsoft Office option; or simply search for it in the search box.

Click on Blank Worksheet to begin. This is how a Blank Worksheet looks like.

You will see several tabs in the Ribbon at the top of the worksheet such as Home, Insert, Draw, Page Layout, Formulas, Data, Review, View, Help, and File. Let us go through each one of them.

1) Home

The Home tab is the default tab in the Microsoft Excel Worksheet. This tab includes sections such as Clipboard, Font, Alignment, Number, Styles, Cells, and Editing.

The most important of all is Font and Alignment where you can choose a new font for your text from a variety of options available, change the size and color of the font, align your content to left, right or center, and also align text to top, bottom or middle. You can make your text bold, italicize it as well as underline or double underline it. You can apply borders to the selected cell and also change the background color of the same in order to make it stand out. You can combine and merge the selected cells into one large single cell.

Under Wrap Text, you can wrap and fit in extra long text into multiple lines so that it appears properly.

In the Number section, you can choose the format for your cells such as number, currency, date, time, percentage, fraction, etc. In the Styles section, you can format selected cells to a table with its own style and choose a colorful cell style to highlight important data or content.

Under Cells, you can insert or add new cells, rows, columns, and sheets as well as delete them. You can adjust the row height, column width, hide and unhide rows and columns, rename as well as move or copy sheets. In the Editing section, you can find and replace text with something else, sort and filter your data as well as carry out various functions such as average, sum, max, min, etc. in an efficient manner.

Read: Microsoft Excel time-saving tricks for fast working.

2) Insert

The Insert tab comprises of Tables, Illustrations, Add-ins, Charts, Tours, Sparklines, Filters, Links, Text, and Symbols.

In the Tables section, you can add a table to organize, sort, filter and format data. Under Illustrations and Charts, you can add pictures from your computer as well as online. You can add shapes, icons, 3D models, SmartArt, charts, pie, map chart, PivotChart, etc.

Links will allow you to add a hyperlink in your document which will give you quick access to other webpages and files.

From the Text and Symbols sections, you can add a text box, a header and a footer, WordArt, signature line, object, equation, and symbol.

3) Draw

In the Draw tab, you will find three groups such as Tools, Pens, and Convert.

You can add a pen, pencil or a highlighter to draw shapes; and also, erase the ink if done wrongly.

4) Page Layout

The Page Layout tab includes a wide number of commands related to Themes, Page Setup, Arrange, Scale to Fit, and Sheet Options.

Under Themes, you can change the font and the color palette, and add different effects to change the look and feel of the document. You can directly choose a ready theme in order to make your document look pleasant and attractive.

The Page Setup group allows you to set and adjust the margin sizes as well as change the page orientation and paper size of the document. A picture as a background can also be added. View the Scale to Fit options to shrink the width or height of your printout to fit a certain number of pages.

Read: Microsoft Excel Online tips and tricks to help you get started.

5) Formulas

Under the Formulas tab, you will categories such as Function Library, Defined Names, Formula Auditing, and Calculation.

For a beginner, all this will look pretty complex. So, the basic things you need to understand are how to perform the auto sum functions like sum, average, etc. and how to calculate formulas. After having selected the data from the cells, click on the dropdown menu of the auto sum command from the Functions Library and then select the function you wish to perform. In the Calculation category, you can choose to calculate the formulas automatically or manually. Simply, click on the dropdown menu under calculation options.

6) Data

In the Data tab, you will find different sections named Data Tools, Queries and Connections, Sort and Filter, Get and Transform Data, Forecast, and Outline.

You can extract data from multiple sources like the web or any recent sources. You can validate the data by setting the rules for validation and remove duplicates by selecting the column that you want to check.

7) Review

The Review tab features commands related to Proofing, Accessibility, Insights, Language, Comments, Protect, and Ink.

The Spelling function will check for all typos and grammatical errors in your document and will ask you to review them accordingly. In case of confidential or important information, there is an option to protect your sheet or workbook. This prevents others to make any changes to the document or move, add or delete sheets. The information thus remains safe and intact.

8) View

In the View tab, you will see sections such as Workbook Views, Show, Zoom, Window, and Macros.

You can see your document in normal view; or in page break view, where you can view how your document will look like when it is printed.

9) Help

The Help tab aids you to get help by using Microsoft office or by contacting an Office Support Agent. You can learn more about Excel by going through online training. You can give suggestions and feedback as well.

10) File

The File tab includes commands to save, print, share, export, and publish the document. You can also access the additional Excel options and make the necessary changes to the settings.

In this way, by using these tips and tricks, you can make your Excel document look well organized and presentable in an efficient and most convenient manner.

I hope this tutorial on Microsoft Excel was helpful.

Now read: Microsoft Excel Tips to Save Time and Work Faster.

Related posts

• Casharrada Aasaasiga ah ee Microsoft Excel - Barashada Sida loo Isticmaalo Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida Looga Badalo Saafka ama Saafka Excel [Tallaabo Talaabo]

• Sidee Loo Xidhaa Ama Loo Furaa Unugyada Excel? (2022)

• Sida loogu daabaco baqshadda gudaha Microsoft Excel

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel

• Sida loo rakibo oo loo isticmaalo add-ins gudaha Microsoft Word iyo Excel ee iPadka

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• 40 ka ugu wanaagsan ee Keyboard-ka Microsoft Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Farqiga u dhexeeya Microsoft Excel Online iyo Excel ee Desktop

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Hagaaji Microsoft Excel furitaanka daaqad banaan

• Sida loo tirtiro qiyamka unugyada laakiin ku ilaali qaacidooyinkaaga, gudaha Microsoft Excel

• Tababarka Qorsheeyaha Microsoft: Wax kasta oo aad u baahan tahay inaad ogaato