Dad badan ayaa u baahan inay bartaan wax ku filan oo ku saabsan Microsoft Excel si ay u helaan shaqada. Sidaa darteed, waxaan la kulmay dad badan oo soo dhaweeyay warka ah inay u baahan yihiin inay bartaan samaynta xaashida xaashida iyada oo xamaasad ay u qabaan shaqada iyagoo xoqaya xanjada oo ka soo baxaysa laamiga hortiisa ee dugsiga. Dhab ahaantii xaashida faafinta miyaa qalaad oo ay ka buuxaan wasakh sun ah? Buug ma u sharxi karaa Microsoft Excel erayo ka dhigaya mid aan fududayn in la fahmo oo keliya balse si fudud loo isticmaalo? Microsoft Excel 2010 Tallaabo Talaabo^{(Microsoft Excel 2010 Step By Step)} ayaa loo qoray ujeedadaas. Aan eegno oo aragno sida wanaagsan ee qoraaga - Curtis D. Frye - uu u guulaystay.

Talaabooyinka Guusha^(Success) , Ama Ugu Yaraan^(Least) Kaasi waa Qorshaha

Sida aad ogtihiin kuwiina akhriyay faallooyinkayga, waxaan ahay taageere taxanaha Talaabada Tallaabo^{(Step By Step)} . Waxaan jeclahay habka wax looga qabto maadooyinka adag hal tallaabo oo yar markiiba. Waxaan bilaabay inaan akhriyo buuggan anigoo aqoon aasaasi ah u leh sida Microsoft Excel u shaqeyso, laakiin ma ahan wax ka badan, waxaana rajeynayay inaan soo qaato xirfado badan intaan sii socday.

Si la mid ah dhammaan buugaagta taxanahan, waxa jira horudhac siinaya akhristaha warbixin kooban oo ku saabsan barnaamijka, iyo soo koobidda waxyaalihii iska beddelay qaybtan barnaamijka. Dadka isticmaalay Microsoft Excel 2007 waxay u badan tahay inay yaqaaniin inta badan sifooyinkan. Kuwa bilawga ah ama isticmaalay daabacaado hore oo kaliya ayaa laga yaabaa inay u arkaan sharraxaadda amarada cusub si ka sii wareer badan waxtarka leh sababtoo ah qoraagu wuxuu adeegsaday luqadda farsamada. Waxa uu sidoo kale ku bilaabayaa ka hadalka waxyaabaha ay ka mid yihiin xadhkaha laydhka, jeexjeexyada iyo miisaska pivot. Hello ? Aynu^(Let) marka hore hoos u dhaadhacno fikradaha aasaasiga ah ka dibna ka welwelno mawduucyada horumarsan. Dadka raba inay tallaabo-tallaabo u qaadaan barnaamijka waxay rabaan inay bilaabaan bilowga. Microsoftwuxuu sameeyay daraasado badan oo isticmaalka ka hor inta aan la sii dayn Microsoft Excel 2010 , iyada oo ujeedadu tahay in laga dhigo mid saaxiibtinimo leh oo si macquul ah loo dhigay. Horudhacu waxa uu si faahfaahsan uga hadlayaa isbeddelada ku yimi dhammaan noocyada waxyaalaha aanan waligay maqlin. Run^(Quite) ahaantii, halkii laga lumin lahaa boggag waxyaalahan, qoraagu waa inuu u bixiyaa linkiga liiska shabakada Microsoft qof kasta oo laga yaabo inuu xiisaynayo. Qofka bilawga ah ama qofka leh aqoonta aasaasiga ah ma garan karo waxa ay yihiin waxyaalahan, qofna si uu u aqoonsado ma doonayo inuu akhriyo buug Talaabo^{(Step By Step)} ah.

Qaybtan waxa kale oo ka xumaaday, siday ila tahay, habka qoraal ee qoraaga. Waxa uu leeyahay waxyaabo ay ka mid yihiin: "Iyadoo la adeegsanayo PivotTables, isticmaalayaashu waxay si hufan u soo koobi karaan xogta waaweyn ee xogta, sida dib u habeynta qiimaha si ay u xoojiyaan dhinacyada kala duwan ee xogta. Inta badan waa faa'iido leh in la xaddido xogta ka muuqata PivotTable, sidaas darteed Excel kooxda waxaa ku jiray shaqada isticmaalayaasha si ay u shaandheeyaan miisaska Pivot." Taasina waxay ka timid hordhaca. Waxay u adeegtaa sidii digniin wixii soo socda.

Sidaasna Ay Ku Bilaabantay

Ka dib in ka badan 40 bog oo ah agab hordhac ah, buuggu wuxuu ugu dambeyntii hoos ugu dhacayaa ganacsiga isticmaalka Microsoft Excel 2010 . Waxay kula talisaa dadka inay si joogto ah u badbaadiyaan shaqadooda, iyadoo aan la xusin Microsoft Excel ee^{(Microsoft Excel's)} ku dhex dhisan AutoRecover^{(AutoRecover)} function. AutoRecover waa wax ay tahay in qof kastaa ka ogaado. Wax kasta oo lagu magacaabo, waxay badbaadinaysaa shaqadaada dhowrkii daqiiqoba mar si aadan wax badan u lumin, haddii ay wax dhacaan, haddii ay wax dhacaan. Waxa jira faylal-dhaqameed diyaar u ah in loo isticmaalo buuga, qoraaguna waxa uu si cad u malaynayaa layliga isticmaalaya faylalkani inay yihiin kuwo is-sharaxaya. Wuxuu ka hadlayaa Guryaha Dukumentiga^{(Document Properties)}, tusaale ahaan, ka dibna ku amraya akhristaha inuu buuxiyo dhowr kelmadood oo muhiim ah oo ku jira faylka tababarka. Waa maxay sababta shuruudahan gaarka ah? Sharaxaad ma leh. Cutubka "Dejinta Buug-hawleed"^{("Setting Up a Workbook")} wuxuu ku dhammaanayaa qayb ballaadhan oo ku saabsan habaynta Microsoft Excel 2010 si loogu waafajiyo dookhaaga. Waxa jirtay qayb cutubka hordhac ah oo ka hadlaysay habaynta Ribbon . Dhammaan agabka ku saabsan siyaabaha barnaamijka looga dhigi karo mid ku habboon qofka dookhiisa ah waxay ahayd in la geliyo cutub gaar ah oo "Customizing" . Yaa ka eegi doona cutubka la yiraahdo "Dejinta Buug-hawleed"^{("Setting Up a Workbook")} si loo habeeyo Microsoft Excel 2010 guud ahaan?

Xogta, Gelitaanka Xogta iyo Shaxda

Qaybta gelitaanka xogta waxaa ku jira macluumaadka ku saabsan qalabka waxtarka leh sida AutoFill, FillSeries^{(AutoFill, FilllSeries )} iyo AutoComplete , laakiin waxay ku guuldareystaan ​​inay ogaadaan waxyaabaha fudud sida waxa dhacaya markaad riixdo Geli^(Enter) ama Tab ka dib markaad gasho hal qiime. Waxyaabaha menu ee AutoFill Options waxa lagu sharaxay "tech-ese" halkii ay ka ahaan lahaayeen ^{(AutoFill Options)}Ingiriisi^(English) cad . In lagu sameeyo layliga faylka barbaradka ah ayaa kaa caawin lahayd in la caddeeyo waxa socda, haddii aanu layligu ahayn mid aan waxba ka jirin. Mar labaad^(Again), Isticmaale khibrad leh wax dhib ah uma yeelan lahaa inuu si dhakhso ah u maro arrintan, laakiin bilawga ayaa hubaal ah inuu rabo wax badan oo ku saabsan habka sharaxaadda iyo ku dhaqanka, iyo buug si macquul ah loogu talagalay bilowga, tani waa mid kale oo ka mid ah liis dheer oo guuldarrooyin ah. Qaybaha ku saabsan dhaq-dhaqaaqa xogta iyo raadinta iyo beddelka xogta ayaa waxoogaa ka sii wanaagsan, iyo faylalka dhaqanka waxay u muuqdaan kuwo waxtar leh. Paste Live View View^{(Paste Live Preview)} waa muuqaal cusub oo aad faa'iido u leh oo si wanaagsan ayaa loo sharraxay. Nasiib darro, tani waa tusaale naadir ah oo sharraxaad toos ah. Qaybta samaynta miisaska waxay qaadataa fikrad si fudud loo fahmi karo waxayna maamushaa inay ku aasto qulqulka erayada. Marka hore^(First)sidaan samee,kadibna taas samee Halkaa marka ay marayso buugga fikradda "tallaabo tallaabo" waxay ku luntay meel bannaanka sare ah.

Xisaabinta, Ma aha Mid Cad^(Plain) oo Fudud^(Simple)

Ujeedada aasaasiga ah ee xaashida xaashida waa in lagu sameeyo xisaabinta safafka iyo tiirarka tirooyinka. Si aad tan u samayso, waxaad u baahan tahay inaad ogaato sida saxda ah ee loo galo caanaha unugyada, iyo inaad u sheegto qaaciidooyinka unugyada aad rabto inaad xisaabiso. Sida walxahaas loo soo galay maaha kuwo dareen gaar ah u leh bilawga, iyo fahamka sida ay u wada shaqeeyaan ayaa lagama maarmaan u ah guusha. Waxa kaliya ee aan dhihi karo waa, waan ku faraxsanahay in aan horay u aqaanay sida tan loo sameeyo. Isku dayga in aan ka ogaado tilmaamahan waxa ay u baahan doontaa dadaal badan oo ka badan inta aan awoodi karo. Halkan waxaa ah tusaale tusaale ah:Marka aad gujiso tiro la magacaabay, Excel waxa uu soo bandhigayaa unugyada uu ka kooban yahay ee ku jira Refers To field, marka aad gujiso badhanka Edit waxa ay soo bandhigaysaa sanduuqa wada hadalka Magaca Magaca Edit, kaas oo ah nooca sanduuqa wada hadalka Magaca Cusub, kaas oo awood kuu siinaya in aad beddesho qeexida tirada la magacaabay. Tusaale ahaan, adoo ku daraya tiir, waxaad sidoo kale isticmaali kartaa kontaroolada ku jira sanduuqa wada hadalka Maareeyaha Magaca si aad u tirtirto baaxadda la magacaabay (kala duwanaanshaha, maaha xogta) adigoo gujinaya badhanka Delete, ka dibna riix OK ee xaqiijinta sanduuqa wada hadalka furmaya." U cad sida dhoobada!

Joogteynta Muuqda

Qaybta sharraxaysa sida loo beddelo muuqaalka xaashidaada ayaa si macquul ah si fiican loo sameeyay, laakiin waxay aad ugu tiirsan tahay adeegsadaha oo ka shaqaynaya nidaamka faylalka dhaqanka. Waxa jira waxyaabo badan oo qofku samayn karo si uu xaashida akhriska u noqdo mid la akhriyi karo, iftiimiyo xogta muhiimka ah iyo in daabacadu u ekaato mid wanaagsan, qoruhuna dhammaantood si toos ah ayuu u mariyey. Si kastaba ha ahaatee, mar kale, ujeedada xaashida xaashida waa in wax laga qabto xogta. Waxaan filayaa in qaybtan ku saabsan habaynta muuqaalka xaashida ay ahayd in ay timaado cutubyada sharaxaya sida loo maareeyo xaqiiqada iyo tirooyinka. Faylasha dhaqanka waxaa loo dejiyay tusaaleyaal waxyaallaha ganacsiga khiyaaliga ah laga yaabo inuu rabo inuu ku sameeyo xaashida xaashida, sidaa darteed cutubyada ka hadlaya shaandhaynta, dib-u-habaynta, isku darka iyo falanqaynta xogta dhammaantood waxay si weyn u isticmaalaan faylasha dhaqanka.Mar kale^(Again) , sharraxaadda waxa la qabanayo ayaa ah mid been abuur ah oo hab-qoraalka qoraagu ma hagaajiyo. Wax walba waa la sharraxay, laakiin ka dib markii la mariyo in ka badan boqol bog oo kaliya si loo gaaro "hilibka" isticmaalka xaashida, ma hubo in qofna uu dhab ahaantii diyaar u yahay inuu halkaa ku sii socdo. Daacad baan kuugu sheegi doonaa—haddii aanan akhrin lahayn Microsoft Excel 2010 Talaabo Talaabo^{(Microsoft Excel 2010 Step By Step)} ah si aan dib ugu eego, ma aanan heleen ilaa hadda.

Waan sii socon karaa, laakiin....

Waxaan filayaa inay aad u caddahay hadda in buuggani aanu u qalmin wakhtigaaga. Waa mid si liidata loo qoray oo si liidata loo habeeyey, iyo halka qoraagu si cad u garanayo wax badan oo ku saabsan Microsoft Excel 2010 , wuxuu sidoo kale lumiyay raadkii dhagaystayaashiisa bartilmaameedka - soogalootiga cusub ee u baahan wax kasta oo lagu sharraxay luqad cad, tallaabo tallaabo ah. Anigoo ah qof mar walba taageere u ahaa Taxanaha Taxanaha Tallaabo^{(Step By Step)} , oo u taagan cabsida tayada joogtada ah, waxaan u imid anigoo la yaaban haddii qof ka mid ah shaqaalaha tifaftirka uu fasax ku maqnaa markii kan kani uu aadi jiray saxaafadda.

Xukun

Caadiyan, markaan qoro dib u eegis buug aanan aad u jeclayn, weli waxaan ku dadaalaa inaan helo waxyaabo aan ku ammaano. Waxaan isku dayaa inaan si taxadar leh u akhriyo oo aan raadiyo waxyaabo wanaagsan oo aan sheego. Waxaan lahaa dickens dhammaystiran ee waqtigaas oo aan ku sameeyay buuggan, xitaa waxaan u galay sidii labadaba isticmaale Microsoft Excel oo leh aqoonta aasaasiga ah oo keliya iyo taageere Taxanaha Talada Tallaabo^{(Step By Step)} . Xitaa kuma talin lahaa inaan kan ka eego maktabadda, iyo qof kasta oo akhriyay faallooyinkayga kale wuu ogyahay inay taasi aniga ii tahay. Waxaa jira buugaag ka fiican. Kan ku dhaaf shafka dushiisa.

Book Review - Microsoft Excel 2010 Step By Step

Many people have to learn just enough about Microsoft Excel to get by on the job. As a result, I've met a lot of people who've greeted the news that they need to learn to create spreadsheets with all the enthusiasm they'd have for a job scraping chewing gum off the sidewalk in front of a school. Is a spreadsheet really an alien minefield filled with toxic waste? Can a book explain Microsoft Excel in terms that make it not only easy to understand but easy to use? Microsoft Excel 2010 Step By Step was written for that purpose. Let's take a look and see how well the author - Curtis D. Frye - succeeded.

Steps to Success, Or At Least That's the Plan

As those of you who've read my reviews know, I am a fan of the Step By Step series. I like the approach of tackling difficult subjects one small step at a time. I began reading this book with a basic knowledge of how Microsoft Excel works, but not much more, and hoped to pick up more skills as I went along.

As with all the books in this series, there is an introduction that gives the reader a brief overview of the program, and a summary of the things that have changed in this version of the program. People who have used Microsoft Excel 2007 will probably be familiar with most of these features. Those who are beginners or have only used earlier editions may find the explanation of the new commands more confusing than helpful because the author used such technical language. He also starts out by talking about things like sparklines, slicers and pivot tables. Hello? Let's get the basic concepts down first and then worry about the advanced topics. People who want a step by step approach to learning a program want to begin at the beginning. Microsoft did extensive usability studies before releasing Microsoft Excel 2010, with the goal of making it more user-friendly and more logically laid out. The introduction goes into quite a bit of detail about the changes to all kinds of things I never heard of. Quite frankly, instead of wasting pages on these things, the author should have provided a link to a list on the Microsoft web site for anyone who might be interested. A beginner or person with only basic knowledge won't know what these things are, and a person advanced enough to recognize them isn't going to be reading a Step By Step book.

This section is also marred, in my opinion, by the author's writing style. He says things like: "With PivotTables, users can summarize large data sets efficiently, such as by rearranging values dynamically to emphasize different aspects of the data. It's often useful to be able to limit the data that appears in a PivotTable, so the Excel team included the functionality for users to filter Pivot Tables." And that's from the introduction. It serves as a warning for what lies ahead.

And So It Begins

After more than 40 pages of introductory material, the book finally gets down to the business of using Microsoft Excel 2010. It advises people to save their work frequently, with no mention of Microsoft Excel's built-in AutoRecover function. AutoRecover is something everyone should know about. Whatever it's named, it saves your work every few minutes so you don't lose much, if anything, if something crashes. There are practice files available to be used with the book, and the author clearly thinks the exercises that use these files are self-explanatory. He talks about Document Properties, for example, and then directs the reader to fill in several keywords on the practice file. Why these particular terms? No explanation. The "Setting Up a Workbook" chapter ends with an extensive section on customizing Microsoft Excel 2010 to suit your own preferences.There was a section in the introductory chapter that dealt with customizing the Ribbon. All the material about ways to make the program suit one's own preferences should have been placed in a separate "Customizing" chapter. Who would look in a chapter called "Setting Up a Workbook" for instructions for customizing Microsoft Excel 2010 as a whole?

Data, Data Entry and Tables

The section on data entry includes information about helpful tools like AutoFill, FilllSeries and AutoComplete, but fails to note simple things like what happens when you press Enter or Tab after entering a single value. The AutoFill Options menu items are explained in "tech-ese" instead of plain English. Doing the exercise with the practice file could have helped to clarify what's going on, if the exercise had not been so perfunctory. Again, an experienced user would have had no problem going through this quickly, but a beginner would almost certainly want more in the way of explanation and practice, and for a book ostensibly aimed at beginners, this is just another in a long list of failures. The sections on moving data and finding and replacing data are a little better, and the practice files seem to actually be helpful. Paste Live Preview is an extremely useful new feature and it's explained pretty well. Unfortunately, this is a rare example of straightforward explanation. The section on creating tables takes a fairly easy-to-understand concept and manages to bury it under an avalanche of words. First you do this, then you do that, and oh, if you do this it also does this and if you didn't mean to do this you fix it and... you get the idea. By this point in the book the "step by step" concept has vanished somewhere in outer space.

Calculations, Not So Plain and Simple

The primary purpose of a spreadsheet is to do calculations on rows and columns of numbers. To do this, you need to know how to enter formulas properly in cells, and to tell the formulas which cells you want to calculate. The way those things are entered is not particularly intuitive for the beginner, and understanding how it all works is essential for success. All I can say is, I'm glad I already know how to do this. Trying to figure it out from these instructions would require a lot more dedication than I can muster up. Here's a sample explanation: "When you click a named range, Excel displays the cells it encompasses in the Refers To field. Clicking the Edit button displays the Edit Name dialog box, which is a version of the New Name dialog box, enabling you to change a named range's definition; for example, by adding a column. You can also use the controls in the Name Manager dialog box to delete a named range (the range, not the data) by clicking it, clicking the Delete button, and then clicking OK in the confirmation dialog box that opens." Clear as mud!

Keeping Up Appearances

The section that explains how to change the appearance of your spreadsheet is reasonably well done, but relies too heavily on the user working through the process on the practice files. There are many things one can do to make a spreadsheet more readable, highlight important data and make a printout look good, and the author goes through all of them in a fairly straightforward manner. However, again, the purpose of a spreadsheet is to deal with the data. I think this section on customizing the look of the spreadsheet should have come after the chapters that explain how to manipulate the facts and figures. The practice files are set up as examples of things a fictitious business might want to do with a spreadsheet, so the chapters that talk about filtering, reorganizing, combining and analyzing data all make heavy use of the practice files. Again, the explanation of what's being done is perfunctory and the author's writing style doesn't improve. Everything is explained, but after having to slog through over a hundred pages just to get to the "meat" of spreadsheet use, I'm not sure anyone's really willing to keep going at this point. I'll be honest with you—if I hadn't been reading Microsoft Excel 2010 Step By Step to review it, I wouldn't have gotten even this far.

I Could Go On, But....

I think it's pretty clear by now that this book isn't worth your time. It's poorly written and poorly organized, and while the author clearly knows a lot about Microsoft Excel 2010, he's also lost track of his target audience—the newcomer who needs everything explained in clear language, step by step. As someone who's always been a fan of the Step By Step series, and who stands in awe of their consistent quality, I came away wondering if someone on the editorial staff was on vacation when this one went to press.

Verdict

Usually, when I write a review of a book I'm not so enthusiastic about, I still do my best to find things to praise in it. I try to read carefully and look for positive things to say. I had the absolute dickens of a time doing that with this book, even going into it as both a Microsoft Excel user with only basic knowledge and as a fan of the Step By Step series. I wouldn't even recommend checking this one out of the library, and anyone who's read my other reviews knows that's a first for me. There are better books out there. Leave this one on the shelf.

Related posts

• Dib u eegis buug - Microsoft Office Professional 2010 Talaabo Talaabo ah

• Dib u eegis buug - Microsoft Office 2010 Inside Out

• Dib u eegida buugaagta - Windows 7 iyo Office 2010 ee Dummies, Book + DVD Bundle

• Dib u eegis buug - Microsoft Office Professional 2013 Talaabo Talaabo ah

• Dib u eegista buug - Microsoft Office 2010 ee Dummies

• Dib u eegista buug - Windows 8 siraha

• Dib u eegis buug - Xafiiska 2013: Buugga maqan

• Dib-u-eegis Buugaag - Wada-shaqeynta Kooxda, Isticmaalka Microsoft Office si loo helo Shaqa Kooxeed Waxtar leh

• Dib-u-eegis Buugaag: Dhiso Mareegtaada: Hagaha Majaajilada ah ee HTML, CSS iyo Wordpress

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

• Dib u eegista buug - Windows 8 ee Dummies, waxaa qoray Andy Rathbone

• Dib u eegis buug - Windows 7 ee Dummies

• Dib-u-eegis buug - Ku- xisaabinta Windows 7 ee Waayeelka iyo Caqliga

• Dib u eegis buug - Windows 7 Talaabo Talaabo ah

• Dib-u-eegis Buug-Isku Bar muuqaal ahaan Windows 8

• Microsoft Office Professional 2013 Tallaabo Talaabo - Buugayada saddexaad

• Dib u eegis buug - Windows 8.1 Buugga Maqan, ee David Pogue

• Dib u eegis buug - Google+ Buuga maqan

• Dib u eegista buug - Cilad-baadhista & Ilaalinta PC-gaaga Dhammaan-In-Mid ee Dummies-ka

• Dib u eegis buug - WordPress for Dummies