team
Excel Pivot & Datenbanken
{"total":1,"documents":[{"data":{"defaultCategories":[{"id":33,"parentCategoryId":null,"level":1,"type":"item","linklist":true,"right":"all","sitemap":false,"updatedAt":"2019-07-11T14:25:55+02:00","manually":false,"plentyId":44696}],"filter":{"hasManufacturer":true,"isSalable":true,"isSalableAndActive":true,"hasActiveChildren":false},"images":{"all":[{"names":{"imageId":169,"lang":"de","name":"","alternate":""},"path":"S3:212:212-Microsoft-Excel-Pivot-und-Datenbanken.png","position":0,"url":"https:\/\/cdn02.plentymarkets.com\/5gssvyve4cok\/item\/images\/212\/full\/212-Microsoft-Excel-Pivot-und-Datenbanken.png","urlMiddle":"https:\/\/cdn02.plentymarkets.com\/5gssvyve4cok\/item\/images\/212\/middle\/212-Microsoft-Excel-Pivot-und-Datenbanken.png","urlPreview":"https:\/\/cdn02.plentymarkets.com\/5gssvyve4cok\/item\/images\/212\/preview\/212-Microsoft-Excel-Pivot-und-Datenbanken.png","urlSecondPreview":"https:\/\/cdn02.plentymarkets.com\/5gssvyve4cok\/item\/images\/212\/secondPreview\/212-Microsoft-Excel-Pivot-und-Datenbanken.png","cleanImageName":"212-Microsoft-Excel-Pivot-und-Datenbanken.png"}],"variation":[{"names":{"imageId":169,"lang":"de","name":"","alternate":""},"path":"S3:212:212-Microsoft-Excel-Pivot-und-Datenbanken.png","position":0,"url":"https:\/\/cdn02.plentymarkets.com\/5gssvyve4cok\/item\/images\/212\/full\/212-Microsoft-Excel-Pivot-und-Datenbanken.png","urlMiddle":"https:\/\/cdn02.plentymarkets.com\/5gssvyve4cok\/item\/images\/212\/middle\/212-Microsoft-Excel-Pivot-und-Datenbanken.png","urlPreview":"https:\/\/cdn02.plentymarkets.com\/5gssvyve4cok\/item\/images\/212\/preview\/212-Microsoft-Excel-Pivot-und-Datenbanken.png","urlSecondPreview":"https:\/\/cdn02.plentymarkets.com\/5gssvyve4cok\/item\/images\/212\/secondPreview\/212-Microsoft-Excel-Pivot-und-Datenbanken.png","cleanImageName":"212-Microsoft-Excel-Pivot-und-Datenbanken.png"}]},"item":{"id":212,"add_cms_page":"0","condition":{"id":0,"names":{"lang":"de","name":"Neu"}},"storeSpecial":null,"manufacturerId":19,"producingCountryId":1,"revenueAccount":0,"conditionApi":{"id":0,"names":{"lang":"de","name":"Neu"}},"ageRestriction":0,"itemType":"default","producingCountry":{"names":{"name":"Deutschland","lang":"de"},"lang":"de","storehouseId":0,"name":"Germany","shippingDestinationId":101,"id":1,"active":1,"isoCode2":"DE","isCountryStateMandatory":null,"isoCode3":"DEU"},"manufacturer":{"name":"team","logo":"","externalName":"team","nameExternal":"team"},"rebate":0,"salableVariationCount":1,"customsTariffNumber":""},"variation":{"position":20201231,"number":"1040005005","model":"","externalId":"","availabilityId":5,"maximumOrderQuantity":null,"minimumOrderQuantity":1,"intervalOrderQuantity":1,"availableUntil":null,"releasedAt":null,"name":"","weightG":0,"weightNetG":0,"widthMM":0,"lengthMM":0,"heightMM":0,"unitsContained":1,"vatId":0,"bundleType":null,"mayShowUnitPrice":false,"customsTariffNumber":"","availabilityUpdatedAt":"2019-07-18T12:08:05+02:00","availability":{"id":5,"icon":"av5.gif","averageDays":60,"createdAt":"2019-08-07 11:06:43","updatedAt":"2019-08-07 11:06:43","names":{"id":29,"availabilityId":5,"lang":"de","name":"ACHTUNG: Die Preise k\u00f6nnen abweichen.","createdAt":"2022-04-21 15:44:27","updatedAt":"2022-04-21 15:44:27"},"iconPath":"\/tpl\/availability\/av5.gif","mappedAvailability":""},"id":1162,"unitCombinationId":1},"properties":[{"propertyId":2,"propertySelectionId":2,"surcharge":0,"property":{"id":2,"position":0,"names":{"lang":"de","name":"Freigabestufe","description":"Bestimmt wie mit dem Artikel im Ticket verfahren wird.","propertyId":"2"},"valueType":"selection","isOderProperty":false,"isShownOnItemPage":true,"isShownOnItemList":true,"isShownAtCheckout":false,"isShownAsAdditionalCosts":false,"surcharge":0},"group":{"id":1,"names":{"lang":"de","name":"Topdesk","description":"","propertyGroupId":"1"},"backendName":"Topdesk","orderPropertyGroupingType":"none","isSurchargePercental":false,"ottoComponent":0,"updatedAt":"2019-07-09T15:55:58+02:00"}}],"texts":{"id":414,"lang":"de","name2":"","name3":"","description":"<hr style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Verdana, Arial, Helvetica, sans-serif; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\" \/><p style=\"font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.4em; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; margin: 1em 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\"><strong style=\"font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Dauer:<\/strong> 2 Tage nach Absprache<\/p>\n<p style=\"font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.4em; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; margin: 1em 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\">Ansprechpartner: F\u00f6rde Campus<\/p>\n<p style=\"font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.4em; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; margin: 1em 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\"><strong style=\"font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Seminarziel: <\/strong>In diesem Seminar k\u00f6nnen Sie ihre Kenntnisse beim Umgang mit Excel vertiefen. Sie werden mit weiterf\u00fchrenden Funktionen mit dem Schwerpunkt Pivot und Datenbanken..<\/p>\n<p style=\"font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.4em; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; margin: 1em 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\">Die folgend aufgef\u00fchrten Seminarinhalte dienen als \u201eroter Faden\u201c und werden zusammen mit Ihnen, direkt durch den jeweiligen Dozenten, in einem Vorgespr\u00e4ch abgestimmt. Dadurch k\u00f6nnen Sie gezielt auf die Inhalte Ihrer Standortschulung einflussnehmen und Schwerpunkte setzen.<\/p>\n<ul style=\"font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; margin: 1em 0px 1em 1em; padding: 0px; border: 0px; vertical-align: baseline; list-style: square inside; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\">\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Pivottabellen und -diagramme in Microsoft Office Excel<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">MSQuery<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Datenbankfunktionen<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">weitere Funktionen<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Teilergebnisse\/Gruppierungen<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Konsolidierung<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Datenanalyse mit Microsoft Office Excel<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Excel mit Datenbanken nutzen<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Bin\u00e4rdateien<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Datenschnitte<\/li><\/ul>\n<hr style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Verdana, Arial, Helvetica, sans-serif; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\" \/><p style=\"font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.4em; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; margin: 1em 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\"><strong style=\"font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Zielgruppe<\/strong><br style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: normal;\" \/>Anwender, die mit den fortgeschrittenen Funktionen von Excel 2010 arbeiten wollen.<\/p>\n<hr style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Verdana, Arial, Helvetica, sans-serif; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\" \/><p style=\"font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.4em; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; margin: 1em 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\"><strong style=\"font-style: inherit; font-variant: inherit; font-stretch: inherit; line-height: inherit; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Kosten \/ Fahrkosten \/ Hotelkosten*<\/strong><\/p>\n<ul style=\"font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; margin: 1em 0px 1em 1em; padding: 0px; border: 0px; vertical-align: baseline; list-style: square inside; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\">\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Tagessatz: 625\u20ac<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Teilnehmer: bis 10 Personen<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Bis 50 km > im Tagespreis enthalten<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Bis 200 km > 0,30 pro KM\/pro Tag<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Ab 200 km -> Hotel pro Schulungstag 80\u20ac + 30cent\/km (Wegstrecke 2x)<\/li>\t<li style=\"font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: 1.4em; font-size: inherit; font-family: inherit; margin: 0px; padding: 0px; border: 0px; vertical-align: baseline;\">Schulungshardware: 150\u20ac (soweit notwendig)<\/li><\/ul>\n<p style=\"font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.4em; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; margin: 1em 0px; padding: 0px; border: 0px; vertical-align: baseline; color: rgb(72, 72, 72); background-color: rgb(255, 255, 255);\">* Durch den individuellen Zuschnitt der Schulungen auf Ihren Standort, erhalten Sie nach der direkten Abstimmung mit unserem Dienstleister ein verbindliches Angebot incl. aller Nebenkosten. Die Aufgef\u00fchrten Preise dienen zur Orientierung.<\/p>","title":"","itemId":212,"metaDescription":"","technicalData":"","urlPath":"schulungen\/microsoft-excel-pivot-datenbanken","name1":"Excel Pivot & Datenbanken","shortDescription":"","keywords":""},"unit":{"names":{"unitId":1,"lang":"de","name":"St\u00fcck"},"unitOfMeasurement":"C62","content":1},"hasOrderProperties":false,"hasRequiredOrderProperty":false,"prices":{"default":{"price":{"value":625,"formatted":"625,00\u00a0EUR"},"unitPrice":{"value":625,"formatted":"625,00\u00a0EUR"},"basePrice":"","baseLot":null,"baseUnit":null,"baseSinglePrice":null,"minimumOrderQuantity":1,"contactClassDiscount":{"percent":0,"amount":0},"categoryDiscount":{"percent":0,"amount":0},"currency":"EUR","lowestPrice":{"value":null,"formatted":""},"vat":{"id":0,"value":19},"isNet":false,"data":{"salesPriceId":1,"price":625,"priceNet":525.21008403361,"basePrice":625,"basePriceNet":525.21008403361,"unitPrice":625,"unitPriceNet":525.21008403361,"lowestPrice":null,"lowestPriceNet":null,"customerClassDiscountPercent":0,"customerClassDiscount":0,"customerClassDiscountNet":0,"categoryDiscountPercent":0,"categoryDiscount":0,"categoryDiscountNet":0,"vatId":0,"vatValue":19,"currency":"EUR","interval":"none","conversionFactor":1,"minimumOrderQuantity":"1.00","updatedAt":"2019-07-18 12:08:05","type":"default","pricePosition":2}},"rrp":{"price":{"value":0,"formatted":"0,00\u00a0EUR"},"unitPrice":{"value":0,"formatted":"0,00\u00a0EUR"},"basePrice":"","baseLot":null,"baseUnit":null,"baseSinglePrice":null,"minimumOrderQuantity":0,"contactClassDiscount":{"percent":0,"amount":0},"categoryDiscount":{"percent":0,"amount":0},"currency":"EUR","lowestPrice":{"value":null,"formatted":""},"vat":{"id":0,"value":19},"isNet":false,"data":{"salesPriceId":2,"price":0,"priceNet":0,"basePrice":0,"basePriceNet":0,"unitPrice":0,"unitPriceNet":0,"lowestPrice":null,"lowestPriceNet":null,"customerClassDiscountPercent":0,"customerClassDiscount":0,"customerClassDiscountNet":0,"categoryDiscountPercent":0,"categoryDiscount":0,"categoryDiscountNet":0,"vatId":0,"vatValue":19,"currency":"EUR","interval":"none","conversionFactor":1,"minimumOrderQuantity":"0.00","updatedAt":"2019-07-18 12:08:05","type":"rrp","pricePosition":0}},"set":null,"specialOffer":null,"graduatedPrices":[{"price":{"value":625,"formatted":"625,00\u00a0EUR"},"unitPrice":{"value":625,"formatted":"625,00\u00a0EUR"},"basePrice":"","baseLot":null,"baseUnit":null,"baseSinglePrice":null,"minimumOrderQuantity":1,"contactClassDiscount":{"percent":0,"amount":0},"categoryDiscount":{"percent":0,"amount":0},"currency":"EUR","lowestPrice":{"value":null,"formatted":""},"vat":{"id":0,"value":19},"isNet":false,"data":{"salesPriceId":1,"price":625,"priceNet":525.21008403361,"basePrice":625,"basePriceNet":525.21008403361,"unitPrice":625,"unitPriceNet":525.21008403361,"lowestPrice":null,"lowestPriceNet":null,"customerClassDiscountPercent":0,"customerClassDiscount":0,"customerClassDiscountNet":0,"categoryDiscountPercent":0,"categoryDiscount":0,"categoryDiscountNet":0,"vatId":0,"vatValue":19,"currency":"EUR","interval":"none","conversionFactor":1,"minimumOrderQuantity":"1.00","updatedAt":"2019-07-18 12:08:05","type":"default","pricePosition":2}}]},"facets":[],"attributes":[]},"id":1162}],"inactiveVariationIds":[]}
Artikelnummer 1040005005
Dauer: 2 Tage nach Absprache
Ansprechpartner: Förde Campus
Seminarziel: In diesem Seminar können Sie ihre Kenntnisse beim Umgang mit Excel vertiefen. Sie werden mit weiterführenden Funktionen mit dem Schwerpunkt Pivot und Datenbanken..
Die folgend aufgeführten Seminarinhalte dienen als „roter Faden“ und werden zusammen mit Ihnen, direkt durch den jeweiligen Dozenten, in einem Vorgespräch abgestimmt. Dadurch können Sie gezielt auf die Inhalte Ihrer Standortschulung einflussnehmen und Schwerpunkte setzen.
- Pivottabellen und -diagramme in Microsoft Office Excel
- MSQuery
- Datenbankfunktionen
- weitere Funktionen
- Teilergebnisse/Gruppierungen
- Konsolidierung
- Datenanalyse mit Microsoft Office Excel
- Excel mit Datenbanken nutzen
- Binärdateien
- Datenschnitte
Zielgruppe
Anwender, die mit den fortgeschrittenen Funktionen von Excel 2010 arbeiten wollen.
Kosten / Fahrkosten / Hotelkosten*
- Tagessatz: 625€
- Teilnehmer: bis 10 Personen
- Bis 50 km > im Tagespreis enthalten
- Bis 200 km > 0,30 pro KM/pro Tag
- Ab 200 km -> Hotel pro Schulungstag 80€ + 30cent/km (Wegstrecke 2x)
- Schulungshardware: 150€ (soweit notwendig)
* Durch den individuellen Zuschnitt der Schulungen auf Ihren Standort, erhalten Sie nach der direkten Abstimmung mit unserem Dienstleister ein verbindliches Angebot incl. aller Nebenkosten. Die Aufgeführten Preise dienen zur Orientierung.