{"id":9843,"date":"2008-11-02T00:54:25","date_gmt":"2008-11-02T04:54:25","guid":{"rendered":"http:\/\/www.ewm.com\/internalblog\/?p=9843"},"modified":"2008-11-02T00:54:25","modified_gmt":"2008-11-02T04:54:25","slug":"90-day-challenge-day-exporting-mlx-grid-to-excel-add-logo-and-print","status":"publish","type":"post","link":"https:\/\/blog.myewm.com\/?p=9843","title":{"rendered":"90 Day Challenge- Day 24 -Tools You Can Use &#8211; Exporting MLX Grid to Excel; Add Logo and Print"},"content":{"rendered":"<p>MLXchange has a tremendous amount of listing and tax roll data. Instead of retyping this information by hand into a spreadsheet, the information can be placed in a grid &#8212; that you custom create &#8212; and exported to Excel. Although MLXchange offers extensive report formats,\u00a0the export feature offers you more flexibility.\u00a0 Although there seem to be several steps to\u00a0successfully complete this process, once you understand the logic, you\u00a0will be able to follow the screen prompts and set aside your notes and instructional videos.<\/p>\n<p>Once you have performed your search, the results will be a grid. Whether\u00a0your results grid is listing data or client data from the tax records, this information can be exported to Excel for further manipulation.<\/p>\n<p>The following &#8220;not-too-short&#8221; video demonstrations show you how to:<\/p>\n<ul>\n<li> Obtain the data from a simple search<\/li>\n<li> Use the map feature instead of the area numbers field<\/li>\n<li> Create a custom results grid<\/li>\n<li> Export the data to Excel<\/li>\n<li> Format the Excel spreadsheet<\/li>\n<li> Add logos, word art, photos and personal text<\/li>\n<li> Print the oversized spreadsheet.<\/li>\n<\/ul>\n<p>In a subsequent post, we will export data from the tax records, import to Excel and merge with a Word document.<\/p>\n<p>MLXchange Grid to Export (Part I):<\/p>\n<div class=\"sc-lightbox image\"><span><img class=\"lightbox\" src=\"http:\/\/img.youtube.com\/vi\/\/0.jpg\"><\/span><div class=\"image-overlay\"><div class=\"image-overlay-inner\"><div class=\"hover-icons\"><a class=\"hover-zoom prettyPhoto\" href=\"http:\/\/www.youtube.com\/watch?v=\"\"><i><\/i><\/a><\/div><\/div><\/div><\/div>\n<p>Import into Excel and Format and Print(Part II):<\/p>\n<div class=\"sc-lightbox image\"><span><img class=\"lightbox\" src=\"http:\/\/img.youtube.com\/vi\/\/0.jpg\"><\/span><div class=\"image-overlay\"><div class=\"image-overlay-inner\"><div class=\"hover-icons\"><a class=\"hover-zoom prettyPhoto\" href=\"http:\/\/www.youtube.com\/watch?v=\"\"><i><\/i><\/a><\/div><\/div><\/div><\/div>\n<p>Add the\u00a0EWM logos\u00a0and your personal information (photo optional):<\/p>\n<div class=\"sc-lightbox image\"><span><img class=\"lightbox\" src=\"http:\/\/img.youtube.com\/vi\/\/0.jpg\"><\/span><div class=\"image-overlay\"><div class=\"image-overlay-inner\"><div class=\"hover-icons\"><a class=\"hover-zoom prettyPhoto\" href=\"http:\/\/www.youtube.com\/watch?v=\"\"><i><\/i><\/a><\/div><\/div><\/div><\/div>\n<p>For additional instructions on printing an oversized spreadsheet:<\/p>\n<div class=\"sc-lightbox image\"><span><img class=\"lightbox\" src=\"http:\/\/img.youtube.com\/vi\/\/0.jpg\"><\/span><div class=\"image-overlay\"><div class=\"image-overlay-inner\"><div class=\"hover-icons\"><a class=\"hover-zoom prettyPhoto\" href=\"http:\/\/www.youtube.com\/watch?v=\"\"><i><\/i><\/a><\/div><\/div><\/div><\/div>\n<p>Practice makes excellence!<\/p>\n<p>__________________________<\/p>\n<p>Prior post on the subject of <a title=\"MLX to Excel Prior Post\" href=\"https:\/\/blog.myewm.com\/wp-content\/uploads\/2008\/06\/27\/angelas-tech-tip-exporting-data-from-mlx-to-an-excel-sheet\/\" target=\"_blank\">MLX to Excel grid<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MLXchange has a tremendous amount of listing and tax roll data. Instead of retyping this information by hand into a spreadsheet, the information can be placed in a grid &#8212; that you custom create &#8212; and exported to Excel. Although MLXchange offers extensive report formats,\u00a0the export feature offers you more flexibility.\u00a0 Although there seem to [&hellip;]<\/p>\n","protected":false},"author":1439,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_expiration-date-status":"","_expiration-date":0,"_expiration-date-type":"","_expiration-date-categories":[],"_expiration-date-options":[]},"categories":[59,105],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.myewm.com\/index.php?rest_route=\/wp\/v2\/posts\/9843"}],"collection":[{"href":"https:\/\/blog.myewm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.myewm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.myewm.com\/index.php?rest_route=\/wp\/v2\/users\/1439"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.myewm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9843"}],"version-history":[{"count":0,"href":"https:\/\/blog.myewm.com\/index.php?rest_route=\/wp\/v2\/posts\/9843\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.myewm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.myewm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.myewm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}