Haddii aad leedahay rukunka Xafiiska 365^{(Office 365)} , markaa waxaad marin u yeelan kartaa dhammaan sifooyinka ay bixiyaan noocyada codsiyada xafiiska ee daruuraha ku saleysan. ^(Office)Laakiin taasi miyay ka dhigan tahay in Microsoft Excel online uu leeyahay dhammaan sifooyinka aad ka heli lahayd Excel ee miiska?

Maqaalkan waxaan sameyn doonaa isbarbardhig dhinac-dhinac ah oo labada ah waxaanan muujin doonaa sifooyinka aad heli doonto maqnaanshaha markaad isticmaasho Microsoft Excel Online .

Menu-ga Guriga

Laga bilaabo Menu-ga Guriga^{(Home Menu)} , jaleecada hore waxay u egtahay in liiska Microsoft Excel online uu ka maqan yahay badhamada badan ee Excel ee nooca desktop-ka. 

Farsamo ahaan tani run maaha, waa uun in nooca khadka tooska ah uu ka dhigo isticmaalka badan ee liiska hoos u dhaca.

Haddaba maxaa ka maqan Microsoft Excel online? Menu - ga guriga^(Home) , waxaad ogaan doontaa in dhammaan sifooyinka soo socda ee Excel ee desktop-ka ay ka maqan yihiin nooca internetka.

• Habka boqolkiiba^{(Percent Style)} iyo qaabka Comma^{(Comma Style)} ee kooxda tirada^(Number) .
• Habaynta qaababka cusub ee qaabka miiska
• Habaynta qaababka cusub ee qaabka unugga.
• Ilaalinta xaashida.
• Quful unug.
• Buuxinta safafka ama tiirarka jiho kasta.
• Dhammaan liiska cad ayaa maqan (si loo nadiifiyo qaababka, faallooyinka, iyo in ka badan).
• Inta badan liiska Find & Select menu ayaa maqan (formulas, notes, updates, and more).

Inta badan, marka ay timaado menu-ka guriga^(Home) , run ahaantii ma luminaysid mid ka mid ah shaqada ugu weyn ee aad ka hesho Excel ee desktop-ka. Kaliya dhammaan qaabeynta (oo ay ku jiraan qaabeynta shuruudaha) ee aad ku sameyn karto nooca desktop-ka, waxaad sidoo kale ku sameyn kartaa Excel online.

Gelida Menu

Gelida menu^(Insert) sidoo kale wuxuu u muuqdaa mid aasaasi ah nooca khadka tooska ah ee Excel , laakiin mar labaad tani waa sababta oo ah inta badan astaamaha horumarsan waxay ku duugan yihiin liiska-hoosaadka.

Gelida menu^(Insert) - ka, waxaad ka waayi doontaa sifooyinka soo socda ee Excel ee desktop-ka haddii aad isticmaasho nooca khadka tooska ah ee Excel .

• Abuuritaanka PivotTable^{(Creating a PivotTable)} waxaa ka maqan awoodda isticmaalka isha xogta dibadda ah, oo ma aad falanqayn kartid dhowr miisaska hal mar.
• Ma jiro wax ikhtiyaar ah oo lagu gelin karo astaamo, moodooyinka 3D, ama SmartArt .
• Shaxda iyo fursadaha garaafyada^{(Charts and graph options)} ayaa si weyn u maqan.
• ^(Text)Sanduuqa qoraalka , WordArt , khadka saxeexa, iyo walxuhu waa maqan yihiin.
• Ma jiro calaamado menu

Farqiga ugu weyn ee u dhexeeya Gelida^(Insert) menu ee u dhexeeya noocyada online iyo desktop ee Excel waa hubaal liiska jaantusyada.

Microsoft Excel online waxay leedahay xulasho jaantusyo ah, laakiin waa kuwo aasaasi ah. Waxaad ka heli doontaa tiir 2D, line, pie, bar, iyo jaantusyada agagaaraha. 

Si kastaba ha ahaatee, gudaha Excel ee Desktop -ka , waxaad heleysaa ururin ballaaran oo mid kasta oo ka mid ah noocyada jaantusyadan. Kuwaas waxaa ka mid ah noocyada 2D iyo 3D ee inta badan noocyada garaafyada, khariidadda geedka iyo qorrax-dhaca, histogram, kala firdhisan iyo jaantusyada xumbo, iyo xitaa 2D iyo 3D maab.

Haddii aad sameyso jaantusyo badan oo horumarsan gudaha Excel , waxay u badan tahay inaad aad uga niyad jabi doonto la'aanta fursadaha Microsoft Excel online.

Liiska Formulas-ka

Haddii aad doorato liiska Formulaska^(Formulas) ee Microsoft Excel online adoo filanaya inaad aragto kala duwanaanta fursadaha Excel ee desktop-ka, waxaad ku jirtaa yaab.

Dhab ahaantii, menu-ku si qurux badan ayaa gebi ahaanba madhan. Markaad tan barbardhigto Excel ee desktop-ka, waa wax laga naxo inta ay le'eg tahay shaqeynta maqan.

Waxaad arki kartaa in liiska Formulas -ka ee ^(Formulas)Excel ee desktop-ka ay ka buuxaan dhammaan liiska hoos-u-dhaca oo dhan oo leh dhammaan hababkaas loo habeeyey liiska hoose. Waxa kale oo jira kooxo ribbon ku jira oo leh astaamo xisaabinta caanaha, iyo daaqadda daawashada^{(a watch window)} .

Sifooyinka kaliya ee Excel Online ee goobtan waa awooda kicinta xisaabinta qaababka xaashida. Taas macnaheedu ma waxa ka maqan qaacidooyinka Microsoft Excel^{(Microsoft Excel)} online? Haba yaraatee. Kaliya waa inaad si ka duwan u hesho.

Haddii aad doorato astaanta shaqada ee u dhow goobta qaaciddada, waxaad arki doontaa daaqad pop-up ah oo aad ka raadin karto mid ka mid ah shaqooyinka badan ee Excel bixiyo.

Haddii aad u bedesho liiska Hoos -u-dhaca Qaybta oo ^{(Pick a category)}dhan^(All) , waxaad arkaysaa in ku dhawaad ​​dhammaan hawlaha qaacidada ee aad filayso inaad ku jirto Excel ay jiraan. Kaliya waa inaad raadisaa sidii aad u heli lahayd xoogaa ka duwan sida aad Excel ugu shaqeyso desktop-ka.

Menu Data

Jaleecada hore, way caddahay in Microsoft Excel online uu leeyahay kaliya kala badh sifooyinka ku jira nooca desktop -ka ee Excel . Midkoodna sifooyinka maqan lagama helo menus qarsoon midkoodna.

Tilmaamaha liiska xogta ee^(Data) soo socda ayaa ka maqan Microsoft Excel online:

• Awood uma laha in " Xogta^{(Get Data)} laga helo" ilaha dibadda sida qoraalka, webka, ama faylasha xogta.
• Ma jiraan doorashooyin shaandhayn^{(filtering options)} sare leh .
• Kooxda agabka xogta^(Data) ayaa ka maqan qoraalka tiirarka^(Columns) , buuxinta toosh, isku-darka, iyo xidhiidhada.
• Ma jiraan wax saadaal ah ama koox tixgalin ah oo aad ka hesho Excel ee ribbon desktop-ka gabi ahaanba.

Xitaa iyada oo dhammaan astaamaha liiska xogta^(Data) maqan yihiin, way wanaagsan tahay ugu yaraan in Microsoft Excel online ay bixiso awoodda kaydinta iyo xogta juqraafiga ee internetka.

Haddii aadan xiisayneynin isticmaalka Excel si aad u soo ceshato ilaha xogta dibadda, markaa inta badan sifooyinka ka maqan liiska xogta^(Data) kuma dhibi doonaan.

Menu Review

Gudaha Excel ee desktop-ka, menu-ka dib u eegista^(Review) ayaa ah meesha aad caadi ahaan aadi doonto si aad wax uga beddesho oo aad u saxdo. Haddii aad tan ku isticmaashay nooca desktop-ka ee Excel , markaa waxaad caadaysteen inaad awood u yeelan karto inaad ku darto faallooyin, qoraallo, iyo xitaa isticmaal thesaurus-gaaban.

Haddaba kee ka mid ah sifooyinkan ayaa ka maqan nooca internetka ee Excel ?

• Ma jiro thesaurus guntan.
• Aragtida Raadinta Smart ee maqan.
• Qalabka turjumaada luqadda maqan
• Ma jiro sifada " Xusuusyada^(Notes) ", laakiin waxaad u bedeli kartaa Qoraalada ^(Notes)Faallooyinka^(Comments) .
• Ma ilaalin karo buugga shaqada ama xaashida.
• Ma jiro sifa tafatir "inking".

Haddii aad sameyso wax badan oo tafatir ah (gaar ahaan shaqada dadka kale), oo aad runtii u baahan tahay qaab-dhismeedka ama qoraallada aad ku leedahay Excel ee desktop-ka, waxaad aad uga niyad jabi doontaa Microsoft Excel online. Tani waa run gaar ahaan haddii aad isticmaasho thesaurus-ka laga helay nooca desktop-ka.

Muuqaalka Menu

Menu View ee ku jira Excel ee ^(View)desktop^(Excel) -ka waxa ka buuxa astaamo badan. Halkaa marka ay marayso waxaa laga yaabaa inaadan la yaabin inaad ogaato in Microsoft Excel online ay ka maqan yihiin kuwa badan.

Dhab ahaantii, waxa kaliya ee aad samayn karto waa abuurista muuqaal xaashida gaarka ah, fur daaqad cusub oo xaashida faafinta ah, xidhidhiyeyaasha qaboojiya, ama qari oo muuji ciwaanka iyo xariiqyada.

Dhammaan sifooyinka kale ayaa maqan, sida:

• Jebinta bogga, qaabaynta bogga^{(page layout)} , iyo aragtiyaha gaarka ah.
• Qarinta baarka caanaha.
• Sifooyinka soo-dhoweynta
• Habaynta^(Arranging) , kala qaybinta, qarinta, ama beddelka daaqadaha.
• Macros.

Inta badan sifooyinkan run ahaantii maaha kuwo khuseeya abka onlaynka ah si kastaba. Tusaale ahaan, ma jirto si loo abuuro ama loo maamulo VBA macros codsiga ku salaysan browserka. Inta badan sifooyinkan maqan waa in aysan saameyn ku yeelan isticmaalkaaga Microsoft Excel guud ahaan internetka.

Menus-ka Gabi ahaanba Ka Maqan

Iyadoo Microsoft Excel online ay bixiso menu-yada asaasiga ah ee aad ka hesho Excel ee desktop-ka, dhab ahaantii waxaa jira menus dhan oo gebi ahaanba maqan.

Liiskaan waxaa ka mid ah:

• Sawir^(Draw) : Isticmaal jiirkaaga si aad u sawirto khadadka ama u muujiso meelaha
• Qaabka Bogga^{(Page Layout)} : Codso mawduucyada, margins, jihaynta, meelaha daabac, oo toosi ama habee walxaha
• Jadwalka Jadwalka^(Timeline) : Si muuqaal ah oo muujinaya dhacdooyinka taariikh ahaan muddo dheer - faa'iido u leh waxyaabaha sida jadwalka mashruuca
• Soo-saare^(Developer) : Ku-daridda macros ama koodka VBA -ga xaashida

Tan waxaa dheer, ma jirto qaab lagu daro wax-ku-dar-ins dheeri ah ama menus-ka Microsoft Excel online, maadaama menu -ka Faylka uu ka maqan yahay ^(File)Xulashada^(Options) Xulashada halkaas oo aad caadi ahaan aadi lahayd Excel desktop-ka si aad kuwa ugu darto.

Mar labaad, tani maaha wax la yaab leh abka onlaynka ah. Laakiin waa wax la tixgeliyo haddii aad ku raaxaysato inaad ku darto astaamo dheeri ah oo badan oo Excel ah adoo isticmaalaya add-ins ama awood u siinaya qaar ka mid ah menu-yada aan caadiga ahayn ee laga heli karo Excel desktop-ka.

Xukunkii Ugu Dambeeyay

Marka la eego dhammaan sifooyinka aasaasiga ah ee laga heli karo Microsoft Excel online iyo wax kasta oo ka maqan marka la barbar dhigo Excel ee nooca desktop-ka, nooca internetka ayaa laga yaabaa inuu hoos u dhaco. Laakiin taasi macnaheedu maaha inay faa'iido lahayn.

Haddii aad caadi ahaan kaliya u isticmaasho Excel isticmaalkeeda ugu badan, sida abuurista xaashiyaha xisaabaadka ama ururka, waxaad ka heli doontaa wax kasta oo aad uga baahan tahay Microsoft Excel online. Haddii aad u baahan tahay inaad keento ilo dibadda ah ama aad sameyso wax badan oo VBA codeing^(VBA) ah ama macros, waxaad u baahan doontaa inaad ku dhejiso isticmaalka Excel ee desktop. 

Differences Between Microsoft Excel Online And Excel For Desktop

If you have an Office 365 subscription, then yoυ have acceѕѕ to all of the features that the cloud-based versions of Offіce applicationѕ offer. But does that mean that Microѕoft Excel onlinе has all of the feаtures yoυ’d find in Excel for deѕktop?

In this article we’ll do a side-by-side comparison of the two and show what features you’ll find lacking when you use Microsoft Excel Online.

The Home Menu

Starting with the Home Menu, at first glance it looks like the menu in Microsoft Excel online lacks a lot of the buttons in the Excel for desktop version. 

This technically isn’t true, it’s just that the online version makes more use of dropdown menus.

So what’s missing in Microsoft Excel online? On the Home menu, you’ll discover that all of the following features from Excel for desktop are missing from the online version.

• Percent Style and Comma Style from the Number group.
• Customizing new table format styles.
• Customizing new cell format styles.
• Protecting a sheet.
• Locking a cell.
• Filling rows or columns in any direction.
• Entire clear menu is missing (to clear formats, comments, and more).
• Most of the Find & Select menu is missing (formulas, notes, constants, and more).

For the most part, when it comes to the Home menu, you really aren’t losing any of the major functionality that you find in Excel for desktop. Just about all of the formatting (including conditional formatting) that you can do on the desktop version, you can do just as well in Excel online.

The Insert Menu

The Insert menu also looks pretty basic in the Excel online version, but again this is because most of the advanced features are buried in submenus.

On the Insert menu, you’ll miss out on the following features from Excel for desktop if you use the online version of Excel.

• Creating a PivotTable is missing the ability to use an external data source, and you can’t analyze multiple tables at once.
• No option to insert icons, 3D models, or SmartArt.
• Charts and graph options are dramatically lacking.
• Text box, WordArt, a signature line, and objects are missing.
• No symbols menu.

The most significant difference in the Insert menu between the online and desktop versions of Excel is definitely the charts menu.

Microsoft Excel online does have a selection of charts, but they are very basic. You’ll find 2D column, line, pie, bar, and area charts. 

However, in Excel for Desktop, you get a massive collection of each of these chart types. These include 2D and 3D versions of most chart and graph types, treemap and sunburst, histogram, scatter and bubble charts, and even 2D and 3D maps.

If you do a lot of advanced charting in Excel, you’re probably going to be very disappointed by the lack of options in Microsoft Excel online.

The Formulas Menu

If you select the Formulas menu in Microsoft Excel online expecting to see the variety of options in Excel for desktop, you’re in for quite a surprise.

In fact, the menu is pretty much completely empty. When you compare this to Excel for desktop, it’s quite shocking how much functionality is missing.

You can see that the Formulas menu in Excel for desktop is just filled with entire dropdown menus with all of those formulas organized into submenus. There are also groups in the ribbon with formula auditing features, and a watch window.

The only features Excel Online matches in this area is the ability to trigger the calculation of formulas in the sheet. Does that mean formulas are missing from Microsoft Excel online? Not at all. You just have to get at them differently.

If you select the function icon near the formula field, you’ll see a pop-up window where you can search for one of the many functions Excel offers.

If you change the Pick a category dropdown to All, you see that just about all of the formula functions you’d expect to be present in Excel are there. You just have to go about finding them somewhat differently than you do in Excel for desktop.

The Data Menu

At first glance, it’s pretty clear that Microsoft Excel online only has about half of the features present in the Excel for desktop version. None of those missing features are found in any hidden menus either.

The following Data menu features are missing from Microsoft Excel online:

• No ability to “Get Data” from external sources like text, web, or database files.
• No advanced filtering options.
• Data tools group lacks text to Columns, flash fill, consolidate, and relationships.
• There are no forecast or outline groups that you find on the Excel for desktop ribbon at all.

Even with all of those Data menu features missing, it is good at least that Microsoft Excel online does provide the ability to bring in stock and geography data sources from the internet.

If you aren’t interested in using Excel to retrieve external data sources, then most of the features missing from the Data menu won’t bother you.

The Review Menu

In Excel for desktop, the Review menu is where you’ll typically go to edit and spell check. If you’ve used this in the desktop version of Excel, then you’re accustomed to being able to add comments, notes, and even use an embedded thesaurus.

So which of these features are missing from the online version of Excel?

• No embedded thesaurus.
• Missing Smart Lookup insights.
• Missing language translation tool.
• No “Notes” feature, but you can convert Notes to Comments.
• Can’t protect the workbook or sheet.
• No “inking” editing feature.

If you do a lot of editing (especially of other peoples’ work), and you really need the inking or notes feature that you have in Excel for desktop, you’re going to be very disappointed by Microsoft Excel online.  This is especially true if you use the thesaurus found in the desktop version.

The View Menu

The View menu in Excel for desktop is filled with a lot of features. By this point you may not be surprised to learn that Microsoft Excel online lacks a lot of those.

In fact, all you can do is create a private sheet view, open a new spreadsheet window, freeze panes, or hide and show headings and gridlines.

All of the other features are missing, such as:

• Page break, page layout, and custom views.
• Hiding the formula bar.
• Zoom features.
• Arranging, splitting, hiding, or switching windows.
• Macros.

Most of these features aren’t really relevant for an online app anyway. For example, there is no way to create or run VBA macros in a browser based application. Most of these missing features shouldn’t impact your use of Microsoft Excel online overall.

Menus That Are Completely Missing

While Microsoft Excel online offers the core menus you find in Excel for desktop, there are actually entire menus that are completely missing.

These menus include:

• Draw: Use your mouse to draw lines or highlight areas
• Page Layout: Apply themes, margins, orientation, print areas, and align or organize objects
• Timeline: Visually showing events chronologically over a timescale – useful for things like project schedules
• Developer: Adding macros or VBA code to a spreadsheet

In addition to this, there is no way to add any additional add-ins or menus to Microsoft Excel online, since the File menu lacks the Options choice where you would normally go to in Excel for desktop to add those.

Again, this isn’t surprising for an online app. But it is something to consider if you enjoy adding a lot of additional features to Excel by using add-ins or enabling some of the non-default menus that are available in Excel for desktop.

The Final Verdict

Given all of the core features available in Microsoft Excel online versus everything that’s missing compared to the Excel for desktop version, the online version might fall short. But that doesn’t mean it’s useless.

If you typically only use Excel for its most common uses, like creating spreadsheets for calculations or organization, you’ll find everything you need in Microsoft Excel online. If you need to bring in external sources or you do a lot of VBA coding or macros, you’re going to want to stick to using Excel for desktop. 

Related posts

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

• Sida loogu daabaco baqshadda gudaha Microsoft Excel

• Sida loo Quful Unugyada Microsoft Excel

• Sida loo tirtiro khadadka banaan ee Excel

• Microsoft Outlook ma furmi doono? 10 siyaabood oo loo hagaajiyo

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• 4 siyaabood oo loo isticmaalo calaamadda jeeg ee Excel

• Hal-Column iyo Xog-urur badan oo Aasaaska ah oo ku kala soocida xaashida faafinta ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida Loogu Mideeyo Xogta Faylal Badan oo Excel ah

• Adeegsiga Qalab Raadinta Hadafka ee Excel Maxaa-Haddii Falanqaynta

• Sida Loo Hagaajiyo Safka gudaha Excel

• Sida loo Furo Word iyo Excel si Badbaado ah

• Sida Loo Muujiyo Tirada Word gudaha Microsoft Word

• Si degdeg ah ugu qor nambarada Word iyo Excel

• Sida loo isticmaalo Flash Fill ee Excel

• Sida loo sawiro Microsoft Word

• U samee qoraha OpenOffice muuqaal oo u shaqeeyo si ka badan sida Microsoft Word

• 2 siyaabood oo loo Isticmaalo Shaqada Transpose ee Excel

• U samee ama u abuur furaha-gaaban ee kiiboodhka ee Microsoft Office