{"id":58080,"date":"2021-01-22T14:01:07","date_gmt":"2021-01-22T13:01:07","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=58080"},"modified":"2021-03-15T17:25:19","modified_gmt":"2021-03-15T16:25:19","slug":"lijsten-databanken-beheren-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/lijsten-databanken-beheren-in-excel\/","title":{"rendered":"Lijsten  \/ databanken beheren in Excel"},"content":{"rendered":"<p>Er zijn voornamelijk drie applicatiedomeinen voor Excel.<\/p>\n<ol>\n<li>Cijfers en grafieken &#8211; het meest bekende<\/li>\n<li>Lijsten en databanken<\/li>\n<li>Gegevensanalyse op basis van grote, externe databanken.<\/li>\n<\/ol>\n<p>Ik wil hier even ingaan op het tweede deelaspect. Wat moet een gebruiker zeker weten als hij Excel daarvoor wil inzetten?<\/p>\n<ul>\n<li>Het verschil tussen numerieke en alfanumerieke gegevens<\/li>\n<li>Gegevensopmaak<\/li>\n<li>Celopmaak<\/li>\n<li>Tabellen maken in Excel<\/li>\n<li>Gegevens importeren (en de valstrikken erbij)<\/li>\n<li>Gegevens filteren<\/li>\n<li>Voorwaardelijke opmaak<\/li>\n<li>Dubbels verwijderen<\/li>\n<li>Rijen en kolommen vastzetten<\/li>\n<li>Named ranges<\/li>\n<li>Datavalidatie<\/li>\n<li>Draaitabellen<\/li>\n<li>Gegevensbeveiliging<\/li>\n<li>Plakken in Word: kolomhoogte<\/li>\n<li>Afdrukken \/ PDF maken: kolomkoppen \/\/ paginanummers<\/li>\n<\/ul>\n<p>Enkele referenties:<\/p>\n<ul>\n<li>How to create a database in Excel | The JotForm Blog<br \/>\n<a href=\"https:\/\/www.jotform.com\/blog\/how-to-create-a-database-in-excel\/\" rel=\"nofollow\">https:\/\/www.jotform.com\/blog\/how-to-create-a-database-in-excel\/<\/a><\/li>\n<li>How to Create an Excel Database<br \/>\n<a href=\"https:\/\/www.lifewire.com\/create-a-database-in-excel-3123446\" rel=\"nofollow\">https:\/\/www.lifewire.com\/create-a-database-in-excel-3123446<\/a><\/li>\n<li>Database in Excel | Step-by-Step Guide to Creating Database in Excel<br \/>\n<a href=\"https:\/\/www.wallstreetmojo.com\/database-in-excel\/\" rel=\"nofollow\">https:\/\/www.wallstreetmojo.com\/database-in-excel\/<\/a><\/li>\n<li>How to Create a Searchable Database in Excel<br \/>\n<a href=\"https:\/\/smallbusiness.chron.com\/create-searchable-database-excel-42711.html\" rel=\"nofollow\">https:\/\/smallbusiness.chron.com\/create-searchable-database-excel-42711.html<\/a><\/li>\n<li>Introducing Excel\u2019s Three Types of Spreadsheet Databases &#8211; ExcelUser.com<br \/>\n<a href=\"https:\/\/exceluser.com\/996\/introducing-excels-three-types-of-spreadsheet-databases\/\" rel=\"nofollow\">https:\/\/exceluser.com\/996\/introducing-excels-three-types-of-spreadsheet-databases\/<\/a><\/li>\n<\/ul>\n<p>Een stap verder: relationele databanken<\/p>\n<ul>\n<li>Excel databases: Creating relational tables | PCWorld<br \/>\n<a href=\"https:\/\/www.pcworld.com\/article\/3234335\/excel-databases-creating-relational-tables.html\" rel=\"nofollow\">https:\/\/www.pcworld.com\/article\/3234335\/excel-databases-creating-relational-tables.html<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Er zijn voornamelijk drie applicatiedomeinen voor Excel. Cijfers en grafieken &#8211; het meest bekende Lijsten en databanken Gegevensanalyse op basis van grote, externe databanken. Ik wil hier even ingaan op het tweede deelaspect. Wat moet een gebruiker zeker weten als hij Excel daarvoor wil inzetten? Het verschil tussen numerieke en<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":3,"footnotes":""},"categories":[464,54,375,79,10],"tags":[],"class_list":["post-58080","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-excel-office-2010","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 17:39:25","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/58080","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=58080"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/58080\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=58080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=58080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=58080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}