- Tapa blanda
- Nuevo

Librería: preigu, Osnabrück, Alemaniapreigu
Vendedor de IberLibro desde 5 de agosto de 2024
Condición: Nuevo
EUR 33,65
Cantidad disponible: 5 disponibles
Añadir al carritoDescripción del artículo del vendedor
Easy MS Excel 2007 | Thong Ong | Taschenbuch | Kartoniert / Broschiert | Vietnamesisch | 2009 | AuthorHouse | EAN 9781438992242 | Verantwortliche Person für die EU: Libri GmbH, Europaallee 1, 36244 Bad Hersfeld, gpsr[at]libri[dot]de | Anbieter: preigu Print on Demand.
N° de ref. del artículo 109211730
- Título
- Easy MS Excel 2007
- Autor
- Thong Ong
- Editorial
- AuthorHouse
- Año de publicación
- 2009
- Estado
- Neu
- Encuadernación
- Taschenbuch
- Idioma
- inglés
- ISBN 10
- 1438992246
- ISBN 13
- 9781438992242
- Peso del artículo
- 824 gramos
- Dimensiones
- 280 x 210 x 18 mm
- Catálogos de vendedores
- Bücher
“Sinopsis” puede pertenecer a otra edición de este título.
Fragmento. © Reproducción autorizada. Todos los derechos reservados.
Easy MS Excel 2007
By Thong OngAuthorHouse
Copyright © 2009 Thong OngAll right reserved.
ISBN: 978-1-4389-9224-2
Chapter One
Computer for EveryBody TIN HOC CHO MOI NGU''IGi'i thieu:
VE MICROSOFT EXCEL 2007
Thu'a cc ban,
Microsoft Excel l phan mem chuyn dng cho bang tnh dien tu' (Worksheet). Ban cung dong y rang d l mot phan mem hau nhu' khng th' thieu tai van phng lm viec cua mnh. T' phin ban thuo' so' khai l Excel 4.0, hng Microsoft d lin tuc nng cap thnh cc phin ban Excel 5.0, Excel 7.0, Excel 97, Excel 2000, Excel XP, v gan dy Excel 2003. Tat ca cc phin ban nay deu c mot giao dien hao hao giong nhau, nn ngu'i su' dung de dng tiep thu phin ban m'i du'a trn kinh nghiem phin ban tru''c.
The nhu'ng v'i phin ban Microsoft Office Excel 2007 (Excel Version 12), bang mot giao dien rat la lam, c the gy nh'c dau cho ngu'oi da t'ng su' dung Excel ! Chnh ban thn chng ti cung ho ang hon v ngan ngo' khi tiep can lan dau v'i Excel 2007, do vay chng ti thay can phai viet lai tap gio trnh nay, nhu' mot cch gip ban doc nhanh chng lm chu du'o'c Excel, neu my cua ban da ci bo Microsoft Office 2007.
Tru''ng hop ban dang ci bo Office XP hoac Office 2003, chng ti khuyn ban c' de vay m dng, v cc bo Office nay, theo chng ti, l rat thn thien v hau nhu' da dat den dinh cua su' hoan hao.
1. BO CHU'O'NG TRNH EXCEL 2007 :
De dng du'o'c Microsoft Excel 2007, ban phai c mot my vi tnh v'i cau hnh tu'o'ng doi manh, v'i he giao dien Windows XP hoac Windows Vista, c ci dat Microsoft Excel 2007 (trong bo Office 2007) dng cch. Ngu''i su' dung di nhin da quen thao tc trn giao dien Windows. Neu c nhu cau hien thi van ban tieng Viet, can ci dat thm bo go de go tieng Viet, v du phan mem VietKey.
2. KHO'I DONG EXCEL 2007 :
(1) Mo my, he Windows (cc Version Windows XP hoac Vista) du'o'c nap.
(2) Kch hoat Excel bang cch:
Thng thuong, ban goi Excel qua con duo'ng chnh ngach bang cach nhan Start, chon All Programs, chon Microsoft Office, roi chon Excel 2007 theo hnh du''i tri.
Neu Excel v'a du'oc su' dung tru''c d, th khi goi Start, trong Start Menu thu''ng c san bieu tu'o'ng Excel trong do nhu' hinh trn phai, ban nhap vo de kch hoat.
* Viec Excel nam trong nhnh no cua Start Menu th phai ty vo thu'c te cua he Windows trn my m ban dang dng.
Hoac neu da c tao mot Shortcut cho Excel 2007 trn mn hnh Desktop nhu' hnh sau thi bn nhap dup vo bieu tu'o'ng nay hoac nhap chon n roi Enter.
* Ve cch lm the no de tao Shortcut trn Desktop cho mot 'ng dung, xin xem cc ti lieu Giao dien do hoa Windows.
* Neu ban chu'a tien xem cc ti lieu Windows, hay nhan nt Start, chon All Programs, chon Microsoft Office, r den Microsoft Excel, roi nhan nt phai chuot (right click) de goi Menu di dong, trong d chon Send To -> Desktop nhu' hnh sau.
3. MN HNH EXCEL 2007 KHI V'A KHO'I DONG :
Sau khi du'o'c nap, mn hnh Excel 2007 c dng dap gan nhu' trn, l cua bo Excel 2007, du''i mi tru''ng Windows Vista, du'o'c dng de soan sch nay, thu'c te c the khc di cht, nhu'ng khng anh hu'o'ng nhieu den viec lap v xu' ly bang tnh cua ban.
Bang tnh Excel du'o'c to ch'c nhu' mot quyen tap (workbook) gom nhieu trang (goi l worksheet), ngam dinh c 3 sheets (c the thm b't). Moi Sheet gom nhieu hang (Row) dnh so 1, 2, 3 ..., moi hng c nhieu cot (Column) ky hieu A, B, C ... Khu vu'c giao nhau giu'a hng v cot to thnh mot goi l Cell. Trong Cell c the ch'a tri so, van ban, hoac tri cng th'c.
V'i mn hnh trn dy:
1. Dng trn cng goi l Title Bar (thanh tiu d) d d c tn ti liu (Book1) v tn ca 'ng dung (Microsoft Excel), bn tri c bieu tu'o'ng Office Button hnh trn, m khi nhap chuot vo d se by ra Menu (hnh sau) v'i cc linh nhu' New, Open, Save, Save As, Print ... den Close, neu nhap vo nt Exit Excel, ban dng cc bang tnh dang xu' ly dong th'i ket thc Excel.
2. Bn tri Title bar l thanh Quick access toolbar, ch'a cc cng cu thu''ng su' dung nhu' Save, Undo ... Ban c the gan thm hoac bo bt cc bieu tu'o'ng ty thch. Bn phai Title bar l cc nt Minimize (thu nh), Maximize (phng l'n) v Close (dng).
3. Dng th' hai l mot Ribbon (dai ru bang) gom nhieu Tab (t' Home den View), Ribbon du'o'c thiet ke nham gip ngu''i su' dung nhanh chng tm cc linh can thiet de hon thnh cng viec. Trong moi Tab, cc linh du'o'c ket thnh t'ng nhm goi l cc Group. V du trong Tab Home c cc Group Clipboard, Font v.v ... Ribbon c tnh thun gian cnh cup cnh xo, khi cu'a so Excel no' rong th cc Group by ra du cc linh con, neu thu hep cu'a so th cc Group co cum lai, nhap vo m'i xo ra.
De do roi mat, mot so Tab c th du'o'c Excel giau b't di, chi by ra trong tnh huong thch ho'p. V du Tab Format ca Picture Tools hoac Tab Format cua Drawing Tools chi xuat hien khi doi tu'o'ng lin he l Picture hay AutoShape dang du'o'c chon.
Neu ban chon mot Ribbon Tab bat ky (v du Tab Home) roi nhan nt phai chuot de mo Menu di dong, xong chon Minimize the Ribbon th phan Ribbon du'o'c thu gon lai chi cn tn cc Tab m thi, cc Group deu bi che nhu'o'ng cho cho bang tnh.
Khi dng Ribbon dang du'o'c thu gon, ban thao tc tu'o'ng tu' se bung ra nhu' cu.
Thao tc nhap dp vo mot Tab bat ky cua Ribbon (hoac bam Ctrl-F1) cung thu gon Ribbon neu dang hien cc Group, v ngu'o'c lai, by ra cc Group neu dang thu gon. Viec thu gon dai Ribbon khng anh hu'o'ng den viec xu' ly bang tnh, v'i Ribbon dang thu gon, ban c the nhap vo mot Tab no d, cc Group trong Tab s hien ra, ban su' dung ty y, sau d Ribbon tu' dong thu lai. Khng thay cch no de xa bo hoac thay Ribbon bang cc Menu v Toolbar nhu' trong Excel cua cc phin ban tru'o'c.
Ghi ch : Ribbon du'o'c to ch'c theo he thong gom 3 cap :
1. Tabs: Cc go Tab giang ngang pha trn. Moi Tab ch'a bieu tu'o'ng cc linh lin quan den mot linh vu'c thao tc.
2. Groups: Trong Tab c nhieu Group (nhm), mot Group tap ho'p cc cng viec lin he v'i nhau. Trong Group c nhieu Commands (linh), v du Group Font cua Tab Home ch'a bieu tu'o'ng dng vo muc dch trnh by nhu' dng khung, chon Font chu', co' chu', mu chu', dng chu' ... Tu'o'ng tu', Group Alignment th gom cc bieu tu'o'ng canh bin, ch'a le v.v.... Neu gc du'o'i phai cua mot Group co bieu tu'o'ng Dialog Box Launcher [??] th khi nhap ch uot vo d se mo hop thoai tu'o'ng 'ng, v du hop thoai Format Cells - Font de dinh dang Font chu, hop thoai Format Cell - Alignment de dinh dang doan v.v....
3. Commands: Mot Command c the du'o'c bieu hien du'o'i dang mot nt (button), neu c thm nt [down arrow] bn canh th dng mo' hop thoai de chon, hoac mo menu tiep theo.
Khi nhap bieu tu'o'ng Office Button (hnh trn), Excel se by ra Menu v'i cc linh t' New den Close nhu' trn.
Nt Excel Options dng quy dinh cc ty chon khi su' dung Excel v cch thao tc khi nhap so lieu. Excel 2007 thu'o'ng dinh san kh nhieu ch'c nang dieu chinh tu' dong, tuy kh thng minh nhu'ng di khi lm ban bu'c mnh v qu lm linh. Nt Excel Options se gip ban chi dinh cc ty chon theo y mnh.
Nt Exit Excel th dng cc bang tnh hien hnh dong th'i ket thc Excel.
4. Thanh doc bn phai khu vu'c bang tnh goi la Vertical Scroll bar (thanh tru'o't doc) dng de tru'o't ln hoac xuong theo chieu doc bang cch nhap vo mui tn ln hay mui tn xuong cua thanh nay, hoac r khoi vung trong thanh tru'o't. Thanh ngang pha du''i khu vu'c bang tnh l Horizontal Scroll bar (thanh tru'o't ngang) dng tru'o't qua hay lai theo chieu ngang.
5. Bn tri gan thanh tru'o't ngang l cc g' Sheet Tab, thao tc trn Sheet no th nhap chuot vo g' Sheet d. Bieu tu'o'ng Insert Worksheet dng de chn thm mot Sheet m'i. Dn nt Sheet navigator bn tri dng de cuon cc g' Sheet Tab qua lai, trong tru''ng ho'p bang tnh c nhieu Sheet khong nhn thay het trong vng Sheet Tab.
6. Dng pha du''i cng l Status bar (thanh tnh trang) trn d cho biet mot so chi tiet ve bang tnh dang thu'c hien.
* Bn tri cho biet tnh trang hien hnh cua bang tnh l Ready (san sng) hoac Edit (dang hieu dnh).
* Vng ke tiep hien thi cc so tm lu'o'c cua khoi Cell dang chon nhu' so trung binh, so dem, v tong.
* Khoang giu'a l dn nt chon che do hien thi cho ti lieu: (1) Normal l cch nhn bnh thu'o'ng v quen thuoc, (2) Page Layout nhn ti lieu gan giong nhu' khi in ra giay, v (3) Page Break Preview cho php chi dinh phai ngat trang o' vi tr no. Thng thu'o'ng, ban nn chon che do Normal v de thao tc.
* St bn phai l thanh tru'o't Zoom, dng dieu chinh l'n nho cho kch co nhn cua ti lieu, nhap vo cc nt se tang hoac giam 10%.
4. KHI NIEM VE BANG TNH EXCEL
4.1 VAI TR BANG TNH
Microsoft Excel l mot phan mem cu'c manh dng de to ch'c, phn tch, v trnh by so lieu. Microsoft Excel gom c 5 ch'c nang chnh :
(1) Worksheet (Bang tnh) Nhap, lu'u tru', phn tch, tnh ton trn so lieu.
(2) Chart (Do thi) Bieu dien so lieu du'o'i dang do thi.
(3) Database (Co' so du' lieu) Quan ly so lieu c khoi lu'o'ng lon.
(4) Macro (Linh vi m) Tu' dong ha cc cng viec can lap lai nhieu lan
(5) Advanced Formatting Graphics Tao lap cc bo bieu chuyn nghiep (Dinh dang v do hoa cao cap)
Bang tnh Excel l mot loai ti lieu c kha nang bien doi nhu'ng noi dung thng tin hon don tro thnh mot tap hop so lieu c to ch'c. Bang tnh du'o'c bo tr trong mot tap sch (Workbook) gom nhieu trang (Worksheet), moi trang l mot bang phn chia thnh cc cot (Columns) v hng (Rows) lap thnh nhu'ng do'n vi xu' ly du'o'c goi l (Cells), ngu'o'i ta c the nhap vo Cell cc dang so lieu khc nhau nhu' van ban (text), tri so (number), cng th'c (formula) hay ngy gi' (date and time). Chng ta c the sao chep (Copy) hay di chuyen (Move) so lieu t' Cell nay sang Cell khc bang cch ban hnh cc linh thch hop qua bn phm hoac r chng t' noi nay den tha xuong noi khc bang thiet bi chuot. The manh cua bang tnh dien t' l cc cng th'c (Formula). fl c th l nh~ng biu th'c ton hqc (s hqc hay di s) hoc biu th'c x' ly chui (ghp ni, ct, trch dgan ...) hay biu th'c luan ly (Logic hay Boolean). Bieu th'c trong cng th'c bao gi' cung cho mot tri v d l tri linh hoat lun phan anh tnh hnh thu'c tai cua bang tnh. Khi mot thnh phan lien quan den cng th'c du'o'c (hay bi) thay doi, thi tri cua cng th'c lap t'c tu' dong diu chinh theo. Chng ta c the sap xep so lieu trong bang tnh theo trt tu' can khai thc, thu'c hien cc php phn tch hay tong hop. Neu can, c the bo cuc thnh dn bi phn ra tu'ng dang cap cho cc dng trong bang tnh. Ngoi ra cn c the lin ket so lieu giu'a cc bang tnh voi nhau, tao thnh mot the thong nhat giu'a hai hoac nhieu bang tnh trong cng mt co' so du' lieu, de cho khi thay doi so lieu trong bang tnh nay, th bang tnh khc cung dong thoi bien chuyen theo. Trong tru'ong hop can thiet, thng qua ch'c nang Visual Basic Editor, ngu'oi ta c the lap trnh bang ngn ngu' Excel Basic de xu' ly tu' dong thay cho nhu'ng loat thao tc thu cng, hoac can thiep su ho'n vo qu trnh tnh ton o hau tru'ong.
4.2 MOT SO MINH HOA
Du'oi dy l minh hoa cho mot vi bang tnh don gian :
Bang tnh thu'ong can du'o'c in an ra phuc vu ngu'oi su' dung. Viec trnh by v dinh dang cho bang tnh cung nhu' xem thu' tru''c khi in l mot thu'c te can thiet nhu'ng rat de dng. So lieu trong bang tnh c the dng de tao ra cc do thi, mt dang thng tin de tiep nhan v t nh'c dau.
5. CO' CAU CUA MOT BANG TNH :
Bang tnh Excel 2007 du'o'c xem nhu' mot quyen tap (Workbook) gom tu' 1 den toi da bao nhiu to (Worksheet) chu'a xc dinh du'o'c, ve ly thuyet th toi da 255 to, nhu'ng ti da thu' toi 4.096 to van khong thay cu' nu' g, khng dm thu' thm v so my diec (ch' Excel chu'a diec). Moi Sheet xem nhu' mot trang giay ke gom 16.384 cot (t'c 128^2 Columns) v 1.048.576 hng (t'c 1.024^2 Rows). Khu vu'c giao nhau giu'a mot cot v mot hng th goi l Cell (), nhu' vay moi Sheet c tat ca:
1.048.576 Hng x 16.384 cot = 17.179.869.184 Cells
cn trong mot Workbook neu c 4.096 Sheet th c
17.179.869.184 Cells x 4.096 to = 70.368.744.177.664 Cells
Trong Cell th ch'a so lieu v Cell l don vi co so de xu' ly cua bang tnh. Moi Cell c the ch'a du'o'c mot chuoi den 32.767 ky tu' (tu'o'ng du'o'ng 7 trang giay dnh my). Neu dn so nu'oc ta cho l 80 trieu, so lieu moi ngu'oi ghi trong mot Cell th chi can 1 Workbook trong d c 1 Worksheet l du' s'c qua cau.
Cc Worksheet du'o'c dat tn ngam dinh bat dau l Sheet1, den Sheet2, Sheet3, v.v ... Ngu'oi dng c the su'a lai tn cho cc Sheet neu muon.
Cc cot du'oc dat nhan tu' tri sang phai, bat dau l cot A tiep theo l cot B, C, ... cho den Z. Lien sau cot Z, la cc cot AA, AB, ... den AZ, roi BA, BB, ... den BZ, ... roi ZA, ZB, ... den ZZ, tiep theo l AAA, AAB, ... den AAZ, roi ABA, ABB, ... den ABZ, c' vay cho den XEA, XEB, ... XEZ v nhm cuoi cng l XFA, XFB, XFC v XFD l du 16.384 cot.
Cc hng du'o'c dnh so lien tuc tu' trn xuong, t' hng 1 den hng 1.048.576.
Neu ngu'oi su' dung khng quen voi cch dat nhan A, B, C, ... cho cot, th c the chon so th' tu', lin tuc tu' 1 den 16384 tnh t' bn tri tro di. Tuy nhin cch nay se gap kh nhieu bat tien khi tham chieu den dia chi cc Cell nn chng ti khng khuyen khch dng trong gio trnh nay.
De phn biet Cell nay voi Cell khc trn cng mot Sheet (trong so hon 17 ty Cells cua mot Sheet), moi Cell deu co mot dia chi (Cell Address). Dia chi Cell du'o'c lap thnh bang cch :
* Neu chon cch goi cot bang cc nhan A, B, C.... : Dia chi Cell gom ky hieu cot v so hieu hng, v du Cell A130, B747, Z27, X30, v.v... V Cell cuoi cng trong mot Sheet l Cell XFD1048576.
* Neu goi cot bang so th' tu' t' 1 den 16384 : Dia chi Cell c dang RnCm (t'c Row no, Column no), v du R1C1, R5C7 v.v... v Cell cuoi cng cua mot Sheet l R16384C1048576.
* Ca 2 tru'o'ng hop, dia chi Cell khng phn biet chu hoa hay chu' thu'o'ng.
De phn biet Cell nay voi Cell khc giu'a cc Sheet (trong so ho'n 4.096 Sheet cua mot Workbook), phai ghi dia chi Cell lien sau tn Sheet noi voi nhau bang dau cham than. V du Sheet3!B12 l Cell nam trn cot B hng 12 cua Sheet3.
Trong gio trnh nay chng ti khng p dung kieu dia chi RnCm. Neu ban gap phai mot bo Excel no m khi ln mn hnh, cc cot deu mang so thay v chu, th ban hay nhan Office Button, chon Excel Options, Formulas, du'i muc Working with Formulas ban nhap tat muc [x] R1C1 Reference Style (xem hnh sau), xong OK.
6. SO LIEU TRONG BANG TNH :
Ban du'a so lieu hay cng th'c vo bang tnh bang cch nhp vo cc Cell nhu'ng noi dung m ban can. Noi dung Cell c the l van ban (Text), tri so (Numbers), hay cng th'c (Formulas). Excel tu' dong tnh lai gi tri cho cc cng th'c moi khi bn thm hay su'a doi so lieu trn bang tnh. Hnh th'c bieu dien thng tin bn trong cc Cell cung de dng dieu chinh ve kch co (Size), kieu dng (Style), hay mu sac (Color). Bn cung c the gan vo bang tnh cc doi tu'o'ng do hoa (Graphic Objects) nham t diem thm cho bang tnh cua ban. Ban cn c the lin ket (Link) cc bang tnh lai voi nhau, v du nhu' lin ket so lieu cua cc bo co hng thng de san xuat ra bo co cuoi quy hay cuoi nam. V trong tru''g hop nay, nhu'ng su'a doi thu'c hien trn cc bang tnh hang thng se su'a doi lun ca so lieu tu'o'ng 'ng lin he trong bang tnh cua quy hay cua ca nam.
(Continues...)
Excerpted from Easy MS Excel 2007by Thong Ong Copyright © 2009 by Thong Ong. Excerpted by permission.
All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.
Excerpts are provided by Dial-A-Book Inc. solely for the personal use of visitors to this web site.
“Acerca de” puede pertenecer a otra edición de este título.
preigu
Osnabrück, Alemania
Vendedor de IberLibro desde 5 de agosto de 2024
Tarifas de envío de Alemania a Estados Unidos de America
| Artículo | De 60 a 60 días hábiles | De 60 a 60 días hábiles |
|---|---|---|
| Primer artículo | EUR 70,00 | EUR 70,00 |
Métodos de pago
- PayPal
Descripción de la tienda
preigu betreibt einen Onlineversandhandel mit über 1 Mio. Produkten in verschiedenen Sortimenten. Das Kernsortiment besteht aus Büchern, Medien und Spielwaren. Ein gelungenes Einkaufserlebnis ist das Ziel einer jeden Bestellung bei preigu, denn der Kunde und seine Zufriedenheit stehen an erster Stelle. preigu setzt daher auf einen kompetenten Kundenservice, funktionierende Prozesse und schnelle Reaktion.
Especialidad
Bücher, SpielwarenInformación empresarial del vendedor
preigu GmbH & Co. KG
Lengericher Landstraße 19
Osnabrück, Alemania 49078
About Us
Legal website operator identification:
preigu GmbH & Co. KG
Lengericher Landstr. 19
49078 Osnabrück
Germany
Telephone: +49 (0) 541 / 580 72 84
Email: mail@preigu.de
VAT No: DE 455 380 498
AG Osnabrück - HRA 209647
PhG: preigu Verwaltung GmbH
AG Osnabrück - HRB 221793
CEO: Ansas Meyer
We are neither willing nor obliged to participate in dispute resolution proceedings before consumer arbitration boards.
We are a member of the initiative "FairCommerce" since 30.11.2016.
For more information, see: https://www.haendlerbund.de/de/haendlerbund/interessenvertretung/faircommerce
Condiciones de venta
Standard Business Terms and customer information
I. Standard business terms
§ 1 Basic provisions
(1) The following terms and conditions of business apply for all contracts concluded with us as the supplier (preigu GmbH & Co. KG) via the websites AbeBooks and/or ZVAB. Unless otherwise agreed, the inclusion of your own terms and conditions is explicitly rejected.
(2) A ‘consumer' in the sense of the following regulations is every natural person who concludes a legal transaction which, to an overwhelming extent, cannot be attributed to either his commercial or independent professional activities. The term ‘businessman' refers to every natural person, legal person or legally responsible partnership that concludes a legal transaction in pursuance of his/its independent professional or commercial activity.
§ 2 Conclusion of the contract
(1) The subject-matter of the contract is the selling of products .
(2) If an article is placed by us with AbeBooks or ZVAB, the activation of the page on AbeBooks or ZVAB shall involve the binding offer to conclude a contract under the terms and conditions contained in the article page.
(3) The contract shall become effective via the online shopping cart system as follows:
The products intended for purchase are moved to the "shopping cart". You can select the "Shopping Cart" using the appropriate buttons on the navigation bar and make changes there at any time.
After calling up the "Checkout" page and entering the required personal data and payment and shipping conditions, all order information is then displayed again on the order summary page.
Before submitting the order, you have the ability once more to review or change any information here (you may also use the "back" button on the Internet browser), or to cancel the purchase.
By clicking the "Buy now" button to submit the order, you declare your legally binding acceptance of the order which makes the contract effective.
(4) The execution of the order and the sending of all the details necessitated by the conclusion of the contract take place via e-mail, in a partially-automated manner. Consequently, you have to ensure that the e-mail address that you have deposited with us is the correct one, and that the receipt of the respective e-mails is guaranteed. In particular, you have to ensure that the respective e-mails are not blocked by a SPAM filter.
§ 3 Right of retention, reservation of proprietary rights
(1) You can only exercise a right of retention if the situation in question involves claims arising from the same contractual relationship.
(2) The goods remain our property until the purchase price is paid in full.
§ 4 Warranty
(1) The statutory warranty rights are applicable.
(2) As a consumer, you are requested to promptly check the product for completeness, visible defects and transport damage as soon as it is delivered, and promptly disclose your complaints to us and the shipping company in writing. Even if you do not comply with this request, it shall have no effect on your legal warranty claims.
(3) If a characteristic of the goods deviates from the objective requirements, the deviation shall only be deemed to be agreed if you were informed of the same by us before submitting the contractual declaration and the deviation was expressly and separately agreed between the contracting parties.
§ 5 Choice of law, place of fulfilment, jurisdiction
(1) German law shall apply. This choice of law only applies to customers if it does not result in the revocation of the protection guaranteed by the mandatory provisions of the law of the country in which the respective customer's usual place of residence is located (benefit-of-the-doubt principle).
(2) If you are not a consumer, but a businessman, a legal entity under public law or an institutional fund governed by public law, our place of business is the place of jurisdiction as well as the place of fulfilment for all services that follow from the business relationships that exist with us. The same condition applies to situations in which you are not associated with a general place of jurisdiction in Germany or the EU, as well as situations in which the place of residence or the usual place of residence is not known at the time of commencement of proceedings. This has no bearing on the capacity to call upon the court associated with another place of jurisdiction.
(3) The provisions of the UN Convention on Contracts for the International Sale of Goods are explicitly inapplicable.
II. Customer information
- Identity of the seller
preigu GmbH & Co. KG
Lengericher Landstr. 19
49078 Osnabrück
Germany
Telephone: 0541-580 72 84
E-Mail: mail@preigu.de
We are neither willing nor obliged to participate in dispute resolution proceedings before consumer arbitration boards.
- Information regarding the conclusion of the contract
The technical steps associated with the conclusion of the contract, the contract conclusion itself and the correction options are executed in accordance to the regulations "conclusion of the contract" in our standard business terms (part I.).
- Contractual language, saving the text of the contract
3.1 Contract language shall be English.
3.2 The complete text of the contract is not saved with us. Before the order is sent, the contract data can be printed out or electronically saved using the browser's print function. After the order is received by us, the order data, the legally-mandated details related to distance selling contracts and the standard business terms are re-sent to you via e-mail.
- Main features of the product or service
The key features of the goods and/or services can be found in the respective quote.
- Prices and payment arrangements
5.1 The prices mentioned in the respective offers represent total prices, as do the shipping costs. They include all the price components, including all the incidental taxes.
5.2 The dispatch costs that are incurred are not included in the purchase price. They can be viewed by clicking the appropriate button on our website or in the respective quote, are shown separately over the course of the order transaction and must additionally be borne by you, insofar as free delivery is not confirmed.
5.3 If delivery is made to countries outside of the European Union, we may incur unreasonable additional costs, such as duties, taxes or money transfer fees (transfer or foreign exchange fees charged by the banks), which you must bear.
5.4 You must also bear the costs arising from money transfers in cases in which the delivery is made to an EU Member State, but the payment is initiated outside of the European Union.
5.5 The payment methods that are available to you are shown by clicking the appropriate button on our website or are disclosed in the respective quote.
5.6 Unless otherwise specified for the respective payment methods, the payment claims arising from the contract that has been concluded become payable immediately.
- Delivery conditions
6.1 The delivery conditions, delivery date and existing supply restrictions, if applicable, can be found by clicking the appropriate button on our website or in the respective quote.
Unless a different period is specified in the item description or our delivery conditions, the goods are delivered within 3-5 days after the conclusion of the contract (in case an advance payment has been agreed upon, after the payment authorisation).
6.2 If you are a consumer, the following is statutorily regulated: The risk of the sold item accidentally being destroyed or degraded during shipping only passes over to you when the item in question is delivered, regardless of whether or not the shipping operation is insured. This condition does not apply if you have independently commissioned a transport company that has not been specified by us or a person who has otherwise been appointed to execute the shipping operation.
- Statutory warranty right
Liability for defects is governed by the "Warranty" provisions in our General Terms and Conditions of Business (Part I).
Information on battery disposal
In connection with the sale of batteries or the delivery of devices containing batteries, we are obliged to inform you of the following:
Batteries must not be disposed of with household waste.
You can either return used batteries that we carry or have carried in our range as new batteries to us at your own expense or return them free of charge to our shipping warehouse (shipping address). Alternatively, you can hand in the batteries at your local collection points.
As an end user, you are legally obliged to return used batteries so that they can be recycled or disposed of properly.
Used batteries may contain harmful substances that can damage the environment or your health if not stored or disposed of properly. However, batteries also contain important raw materials such as iron, zinc, manganese or nickel and can be recycled.
The symbols on the batteries have the following meanings:
The symbol of the crossed-out wheelie bin means that the battery must not be disposed of with household waste.
For batteries containing a certain amount of lead, cadmium or mercury, the following additions below the symbol with the crossed-out wheelie bin indicate the respective pollutants:
Pb = Battery contains more than 0.004% lead by weight
Cd = Battery contains more than 0.002% cadmium by weight
Hg = Battery contains more than 0.0005% mercury by weight
Information on the costs involved in accordance with Article 56 (4) of the EU Battery Regulation (Regulation 2023/1542) can be found at the ‘Batterie-Zurück (https://www.batterie-zurueck.de/de/bewirtschaftungvonaltbatterien/)' initiative.
Please pay attention to the above instructions.
Derecho al desistimiento
Instructions for revocation
Right of withdrawal for the sale of goods
Revocation right for consumers
(A ‘consumer' is any natural person who concludes a legal transaction which, to an overwhelming extent, cannot be attributed to either his commercial or independent professional activities.)
Instructions for revocation
Revocation right
You have the right to revoke this contract within 14 days without specifying any reasons.
The revocation period is 14 days with effect from the day,
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the products, provided you had ordered one or more products within the scope of a standard order and this/these product/products is/are delivered uniformly;
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the last product, provided you had ordered several products within the scope of a standard order and these products are delivered separately;
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the last part delivery or the last unit, provided you had ordered a product, which is delivered in several part deliveries or units;
To exercise your right of withdrawal, you must inform us (preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabrück, Telephone number: +49 (0) 541 / 580 72 84, E-Mail address: mail@preigu.de) by means of a clear declaration (e.g. a letter sent by post, or an e-mail) of your decision to withdraw from this contract. You can use the attached model withdrawal form for this purpose, which is, however, not mandatory.
You can also exercise your right of withdrawal online by clicking on a button labelled accordingly (such as ‘Withdraw from contract' or similar) on the AbeBooks/ZVAB website. If you use this online function, you will immediately receive a confirmation of receipt on a durable medium (e.g. via email) containing information on the content of the withdrawal notice, as well as the date and time of its receipt.
In order to safeguard the revocation period, it is sufficient that you send the notification about the exercise of the revocation right before the expiry of the revocation period.
Consequences of the revocation
If you revoke this contract, we shall repay all the payments, which we received from you, including the delivery costs (with the exception of additional costs, which arise from that fact that you selected a form of delivery other than the most reasonable standard delivery offered by us), immediately and at the latest within 14 days from the day on which we received the notification about the revocation of this contract from you. We use the same means of payment, which you had originally used during the original transaction, for this repayment unless expressly agreed otherwise with you; you will not be charged any fees owing to this repayment.
We can refuse the repayment until the products are returned to us or until you have furnished evidence that you have sent the products back to us, depending on whichever is earlier.
You must return or transfer the products to us immediately and, in any case, at the latest within 14 days with effect from the day on which you inform us of the revocation of this contract. The deadline is maintained if you send the products before the expiry of the 14 day deadline.
You bear the direct costs for returning the products.
You must pay for any depreciation of the products only if this depreciation can be attributed to any handling with you that was not necessary for checking the condition, features and functionality of the products.
Criteria for exclusion or expiry
The revocation right is not available for contracts
-
for delivery of products, which are not prefabricated and for whose manufacturing an individual selection or stipulation by the consumer is important or which are clearly tailored to the personal requirements of the consumer;
-
for delivery of products, which can spoil quickly or whose use-by date would be exceeded quickly;
-
for delivery of alcoholic drinks, whose price was agreed at the time of concluding the contract, which however can be delivered 30 days after the conclusion of the contract at the earliest and whose current value depends on the fluctuations in the market, on which the entrepreneur has no influence;
-
for delivery of newspapers, periodicals or magazines with the exception of subscription contracts. The revocation right expires prematurely in case of contracts
-
for delivery of sealed products, which are not suitable for return for reasons of health protection or hygiene if their seal has been removed after the delivery;
-
for delivery of products if they have been mixed inseparably with other goods after the delivery, owing to their condition;
-
for delivery of sound or video recording or computer software in a sealed package if the seal has been removed after the delivery.
Specimen - revocation form
(If you wish to revoke the contract, please fill up this form and send it back to us.)
-
To preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabrück, Email address: mail@preigu.de :
-
I/we () herewith revoke the contract concluded by me/ us () regarding the purchase of the following products ()/
the provision of the following service () -
Ordered on ()/ received on ()
-
Name of the consumer(s)
-
Address of the consumer(s)
-
Signature of the consumer(s) (only in case of a notification on paper)
-
Date
(*) Cross out the incorrect option.
Privacidad y seguridad
Data protection declaration
Unless stated otherwise below, the provision of your personal data is neither legally nor contractually obligatory, nor required for conclusion of a contract. You are not obliged to provide your data. Not providing it will have no consequences. This only applies as long as the processing procedures below do not state otherwise.
"Personal data" is any information relating to an identified or identifiable natural person.
Responsible person
Contact us at any time. The person responsible for data processing is: Ansas Meyer, Lengericher Landstr. 19, 49078 Osnabrück Deutschland, +49 (0) 541 / 580 72 84, mail@preigu.de
Collection and processing when using the cancellation button
If you have entered into a contract via this platform for which a statutory right of cancellation applies, the platform provides you with a cancellation function (cancellation button) through which you can submit your notice of cancellation immediately.
When using the cancellation function, your personal data (name, email address, details identifying the contract or part of the contract you wish to withdraw from, and the time (date and time) of sending the notice of withdrawal) will only be collected to the extent that you have provided it.
The purpose of data processing is to provide you with the statutory option to withdraw from your contract and to ensure the proper processing of your withdrawal.
The platform operator collects your data on the basis of Article 6(1)(f) of the GDPR, namely the legitimate interest in ensuring the general accessibility of the statutory withdrawal function on the platform. You will receive a confirmation email from the platform operator acknowledging receipt of your notice of withdrawal.
The data is then transmitted to us by the platform operator.
If the contact relates to a contract already concluded between you and us, this data processing is carried out on the basis of Article 6(1)(b) of the GDPR. Otherwise, data processing is carried out on the basis of Article 6(1)(c) of the GDPR, to fulfil a legal obligation to provide an electronic withdrawal function.
We use your email address solely to process your notice of withdrawal. Your data will subsequently be deleted in accordance with statutory retention periods, provided you have not consented to further processing and use.
Collection, processing, and transfer of personal data in orders
When you submit an order we only collect and use your personal data insofar as this is necessary for the fulfilment and handling of your order as well as processing of your queries. The provision of data is necessary for conclusion of a contract. Failure to provide it will prevent the conclusion of any contract. The processing will occur on the basis of Article 6(1) b) GDPR and is required for the fulfilment of a contract with you.
Your data will be shared, for example, with shipping companies, dropshipping or fulfillment providers, payment service providers, service providers for order processing, and IT service providers. We will comply strictly with legal requirements in every case. The scope of data transmission is restricted to a minimum.
Duration of storage
After contractual processing has been completed, the data is initially stored for the duration of the warranty period, then in accordance with the retention periods prescribed by law, especially tax and commercial law, and then deleted after the period has elapsed, unless you have agreed to further processing and use.
Rights of the affected person
If the legal requirements are fulfilled, you have the following rights according to art. 15 to 20 GDPR: Right to information, correction, deletion, restriction of processing, data portability. You also have a right of objection against processing based on art. 6 (1) GDPR, and to processing for the purposes of direct marketing, according to art. 21 (1) GDPR.
Right to complain to the regulatory authority
You have the right to complain to the regulatory authority according to art. 77 GDPR if you believe that your data is not being processed legally.
You can lodge a complaint with, among others, the supervisory authority responsible for us, which you may reach at the following contact details:
Landesbeauftragte für den Datenschutz Niedersachsen Prinzenstraße 5 30159 Hannover Tel.: +49 511 1204500 Fax: +49 511 1204599 E-Mail: poststelle@lfd.niedersachsen.de
Right to object
If the data processing outlined here is based on our legitimate interests in accordance with Article 6(1)f) GDPR, you have the right for reasons arising from your particular situation to object at any time to the processing of your data with future effect.
If the objection is successful, we will no longer process the personal data, unless we can demonstrate compelling legitimate grounds for the processing that outweigh your interests or rights and freedoms, or the processing is intended for the assertion, exercise or defence of legal claims.