{"id":31566,"date":"2024-09-17T10:20:35","date_gmt":"2024-09-17T09:20:35","guid":{"rendered":"https:\/\/blogs3.qub.ac.uk\/digitallearning\/?post_type=tribe_events&p=31566"},"modified":"2026-04-16T10:58:28","modified_gmt":"2026-04-16T09:58:28","slug":"excel-2-managing-data","status":"publish","type":"tribe_events","link":"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/","title":{"rendered":"Excel 2: Managing Data"},"content":{"rendered":"

Continuing from Excel 1: Essentials, this course looks at how to arrange and display both numeric and non-numeric data in Excel to present it in a meaningful manner. Through a series of practical exercises, participants will learn about a variety of techniques which can be employed to make spreadsheets more comprehensible, such as sorting, basic and advanced filtering, conditional formatting and custom number and date formats. Excel Tables and the new data bars, colour scales and icon sets, which can be used for conditional formatting, are among the features that will be explored in this course.<\/p>\n

Aimed at:<\/strong> Staff who wish to learn how to use MS Excel to store and display data and those hoping to take the ICDL Advanced module in Spreadsheets.<\/p>\n

Prerequisites:<\/strong> Previous attendance at Excel 1: Essentials or a similar level of experience of using Excel.<\/p>\n

 <\/p>\n

Access on iTrent<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Continuing from Excel 1: Essentials, this course looks at how to arrange and display both numeric and non-numeric data in Excel to present it in a meaningful manner. Through a […]<\/p>\n","protected":false},"author":524,"featured_media":13892,"template":"","meta":{"jetpack_post_was_ever_published":true,"_tribe_events_status":"","_tribe_events_status_reason":"","_tribe_events_is_hybrid":"","_tribe_events_is_virtual":"","_tribe_events_virtual_video_source":"","_tribe_events_virtual_embed_video":"","_tribe_events_virtual_linked_button_text":"","_tribe_events_virtual_linked_button":"","_tribe_events_virtual_show_embed_at":"","_tribe_events_virtual_show_embed_to":[],"_tribe_events_virtual_show_on_event":"","_tribe_events_virtual_show_on_views":"","_tribe_events_virtual_url":"","footnotes":""},"tags":[349,374,352,348],"tribe_events_cat":[243,240],"class_list":["post-31566","tribe_events","type-tribe_events","status-publish","has-post-thumbnail","hentry","tag-349","tag-data","tag-excel","tag-microsoft","tribe_events_cat-data","tribe_events_cat-office-365","cat_data","cat_office-365"],"yoast_head":"\nExcel 2: Managing Data - Queen's DigiHub<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel 2: Managing Data\" \/>\n<meta property=\"og:description\" content=\"Continuing from Excel 1: Essentials, this course looks at how to arrange and display both numeric and non-numeric data in Excel to present it in a meaningful manner. Through a […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Queen's DigiHub\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/QUBelfast\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-16T09:58:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-content\/uploads\/sites\/7\/2022\/10\/Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@QUBelfast\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/event\\\/excel-2-managing-data\\\/\",\"url\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/event\\\/excel-2-managing-data\\\/\",\"name\":\"Excel 2: Managing Data - Queen's DigiHub\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/event\\\/excel-2-managing-data\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/event\\\/excel-2-managing-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/wp-content\\\/uploads\\\/sites\\\/7\\\/2022\\\/10\\\/Excel.jpg\",\"datePublished\":\"2024-09-17T09:20:35+00:00\",\"dateModified\":\"2026-04-16T09:58:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/event\\\/excel-2-managing-data\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/event\\\/excel-2-managing-data\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/event\\\/excel-2-managing-data\\\/#primaryimage\",\"url\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/wp-content\\\/uploads\\\/sites\\\/7\\\/2022\\\/10\\\/Excel.jpg\",\"contentUrl\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/wp-content\\\/uploads\\\/sites\\\/7\\\/2022\\\/10\\\/Excel.jpg\",\"width\":1920,\"height\":1080,\"caption\":\"MS Excel Logo - Training Event Cover Image\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/event\\\/excel-2-managing-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Events\",\"item\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/events\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel 2: Managing Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/#website\",\"url\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/\",\"name\":\"Queen's DigiHub\",\"description\":\"Learn, Lead, Innovate: Shaping education with technology\",\"publisher\":{\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/#organization\",\"name\":\"Queen's University Belfast\",\"url\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/wp-content\\\/uploads\\\/sites\\\/7\\\/2018\\\/08\\\/cropped-logo-red-1.png\",\"contentUrl\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/wp-content\\\/uploads\\\/sites\\\/7\\\/2018\\\/08\\\/cropped-logo-red-1.png\",\"width\":512,\"height\":512,\"caption\":\"Queen's University Belfast\"},\"image\":{\"@id\":\"https:\\\/\\\/blogs.qub.ac.uk\\\/digitallearning\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/QUBelfast\\\/\",\"https:\\\/\\\/x.com\\\/QUBelfast\",\"https:\\\/\\\/www.instagram.com\\\/qubelfast\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/Come2Queens\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel 2: Managing Data - Queen's DigiHub","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/","og_locale":"en_GB","og_type":"article","og_title":"Excel 2: Managing Data","og_description":"Continuing from Excel 1: Essentials, this course looks at how to arrange and display both numeric and non-numeric data in Excel to present it in a meaningful manner. Through a […]","og_url":"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/","og_site_name":"Queen's DigiHub","article_publisher":"https:\/\/www.facebook.com\/QUBelfast\/","article_modified_time":"2026-04-16T09:58:28+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-content\/uploads\/sites\/7\/2022\/10\/Excel.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@QUBelfast","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/","url":"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/","name":"Excel 2: Managing Data - Queen's DigiHub","isPartOf":{"@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/#primaryimage"},"image":{"@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/#primaryimage"},"thumbnailUrl":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-content\/uploads\/sites\/7\/2022\/10\/Excel.jpg","datePublished":"2024-09-17T09:20:35+00:00","dateModified":"2026-04-16T09:58:28+00:00","breadcrumb":{"@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/#primaryimage","url":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-content\/uploads\/sites\/7\/2022\/10\/Excel.jpg","contentUrl":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-content\/uploads\/sites\/7\/2022\/10\/Excel.jpg","width":1920,"height":1080,"caption":"MS Excel Logo - Training Event Cover Image"},{"@type":"BreadcrumbList","@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/event\/excel-2-managing-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blogs.qub.ac.uk\/digitallearning\/"},{"@type":"ListItem","position":2,"name":"Events","item":"https:\/\/blogs.qub.ac.uk\/digitallearning\/events\/"},{"@type":"ListItem","position":3,"name":"Excel 2: Managing Data"}]},{"@type":"WebSite","@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/#website","url":"https:\/\/blogs.qub.ac.uk\/digitallearning\/","name":"Queen's DigiHub","description":"Learn, Lead, Innovate: Shaping education with technology","publisher":{"@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.qub.ac.uk\/digitallearning\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/#organization","name":"Queen's University Belfast","url":"https:\/\/blogs.qub.ac.uk\/digitallearning\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/#\/schema\/logo\/image\/","url":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-content\/uploads\/sites\/7\/2018\/08\/cropped-logo-red-1.png","contentUrl":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-content\/uploads\/sites\/7\/2018\/08\/cropped-logo-red-1.png","width":512,"height":512,"caption":"Queen's University Belfast"},"image":{"@id":"https:\/\/blogs.qub.ac.uk\/digitallearning\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/QUBelfast\/","https:\/\/x.com\/QUBelfast","https:\/\/www.instagram.com\/qubelfast\/","https:\/\/www.youtube.com\/user\/Come2Queens"]}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-json\/wp\/v2\/tribe_events\/31566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-json\/wp\/v2\/tribe_events"}],"about":[{"href":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-json\/wp\/v2\/types\/tribe_events"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-json\/wp\/v2\/users\/524"}],"version-history":[{"count":2,"href":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-json\/wp\/v2\/tribe_events\/31566\/revisions"}],"predecessor-version":[{"id":34257,"href":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-json\/wp\/v2\/tribe_events\/31566\/revisions\/34257"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-json\/wp\/v2\/media\/13892"}],"wp:attachment":[{"href":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-json\/wp\/v2\/media?parent=31566"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-json\/wp\/v2\/tags?post=31566"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/blogs.qub.ac.uk\/digitallearning\/wp-json\/wp\/v2\/tribe_events_cat?post=31566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}