{"id":5430,"date":"2015-02-09T16:31:56","date_gmt":"2015-02-09T16:31:56","guid":{"rendered":"https:\/\/www.investintech.com\/resources\/blog\/?p=5430"},"modified":"2021-08-09T09:48:19","modified_gmt":"2021-08-09T09:48:19","slug":"excel-data-tips","status":"publish","type":"post","link":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html","title":{"rendered":"Work With Excel Data Like A Pro With 9 Simple Tips"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"\/resources\/blog\/wp-content\/uploads\/2021\/08\/Work-With-Excel-Data-Like-A-Pro-With-9-Simple-Tips.jpg\" alt=\"Excel Spreadsheet Diagram\" width=\"1200\" height=\"628\"><\/p>\n<p>Without doubt, an Excel spreadsheet is one of the most advanced tools for working with raw data\u2014and one of the most feared. &nbsp;The application looks complicated, way too advanced, and like something that would take hours to figure out.<\/p>\n<p>I wouldn\u2019t be surprised if upon hearing that you had to start using MS Excel, your heart started to pound. Is there any way to make Microsoft Excel less scary and intimidating? Yes.<\/p>\n<p>By learning a few spreadsheet tricks, you can bring Excel down to your level and start looking at the application in a different light.&nbsp; We rounded up some of the simplest yet powerful MS Excel spreadsheet tips you can start using on your data.<\/p>\n<h2><strong>1. Use MS Excel Format Painter<\/strong><\/h2>\n<p>To start you off, get yourself familiar with formatting your spreadsheet cells. A visually organized spreadsheet is highly appreciated by others as it can help them follow your data and calculations easily. To quickly apply your formatting across hundreds of cells, use the Format Painter:<\/p>\n<ol>\n<li>Select the cell with the formatting you wish to replicate<\/li>\n<li>Go to the <strong>Home<\/strong> menu and click on the Format Painter. Excel will display a paintbrush next to the cursor.<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5437 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Format-Painter.jpg\" alt=\"Using Excel Format Painter\" width=\"248\" height=\"238\">While that paintbrush is visible, click to apply all of the attributes from that cell to any other.<\/li>\n<\/ol>\n<p>To format a range of cells, double-click the Format Painter during step 1. This will keep the formatting active indefinitely. Use the <strong>ESC<\/strong> button to deactivate it when you\u2019re done.<\/p>\n<h2><strong>2. Select Entire Spreadsheet Columns or Rows<\/strong><\/h2>\n<p>Another quick tip&#8211; use the <strong>CTRL<\/strong> and <strong>SHIFT<\/strong> buttons to select entire rows and columns.<\/p>\n<ol>\n<li>Click on the first cell of the data sequence you want to select.<\/li>\n<li>Hold down&nbsp;<strong>CTRL + SHIFT<\/strong><\/li>\n<li>Then use the arrow keys to get all the data either above, below or adjacent to the cell you\u2019re in.<\/li>\n<\/ol>\n<p>You can also use <strong>CTRL + SHIFT + *<\/strong>&nbsp; &nbsp;to select your entire data set.<\/p>\n<h2><strong>3. Import Data Into Excel Correctly<\/strong><\/h2>\n<p>The benefit of using is Excel is that you can combine different types of data from all kinds of sources.&nbsp; The trick is importing that data properly so you can&nbsp;create <a href=\"https:\/\/trumpexcel.com\/excel-drop-down-list\/\" target=\"_blank\" rel=\"nofollow\">Excel drop down lists<\/a> or pivot tables from it.<\/p>\n<p>Don\u2019t copy-paste complex data sets. Instead, use the options from the <strong>Get External Data<\/strong> option under the <strong>Data <\/strong>tab. There are specific options for different sources. So use the appropriate option for your data:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5432\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Import-Data.jpg\" alt=\"Importing Data to Excel\" width=\"342\" height=\"289\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Import-Data.jpg 342w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Import-Data-300x253.jpg 300w\" sizes=\"auto, (max-width: 342px) 100vw, 342px\" \/><\/p>\n<h2><strong>4. Enter The Same Data Into Multiple Cells<\/strong><\/h2>\n<p>At one point, you may find yourself needing to enter the same data into a number of different cells. Your natural instinct would be to copy-paste over and over again. But there\u2019s a quicker way:<\/p>\n<ol>\n<li>Select all the cells where you need the same data filled in (use <strong>CTRL + click<\/strong> to select individual cells that are spread across the worksheet)<\/li>\n<li>In the very last cell you select, type in your data<\/li>\n<li>Use <strong>CTRL+ENTER. &nbsp;<\/strong>The data will be filled in for each cell you selected.<\/li>\n<\/ol>\n<h2><strong>5. Display Excel Spreadsheet Formulas<\/strong><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5433\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Show-Formulas.jpg\" alt=\"Viewing Spreadsheet Formulas\" width=\"515\" height=\"125\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Show-Formulas.jpg 515w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Show-Formulas-300x72.jpg 300w\" sizes=\"auto, (max-width: 515px) 100vw, 515px\" \/><\/p>\n<p>Jumping into a spreadsheet created by someone else? Don\u2019t worry. You can easily orient yourself and find out which formulas were used. To do this, use the <strong>Show Formulas <\/strong>button. Or you can use <strong>CTRL + `<\/strong>&nbsp; on your keyboard. This will give you a view of all formulas used in the workbook.<\/p>\n<h2><strong>6. Freeze Excel Rows And Columns<\/strong><\/h2>\n<p>This is a personal favourite of mine when it comes to viewing lengthy spreadsheets. Once you scroll past the first 20 rows, the first row with the column labels annoyingly disappear from view and you begin to lose track of how the data was organized.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5438 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Freeze-Rows-Columns.jpg\" alt=\"Freezing Excel Columns Rows\" width=\"365\" height=\"308\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Freeze-Rows-Columns.jpg 365w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Freeze-Rows-Columns-300x253.jpg 300w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/p>\n<p>To keep them visible, use the <strong>Freeze Panes<\/strong> feature under the <strong>View<\/strong> menu. You can opt to freeze the top row or, if you have a spreadsheet with numerous columns, you can opt to freeze the first column.<\/p>\n<h2><strong>7. Enter<\/strong><strong> Data Patterns Instantly<\/strong><\/h2>\n<p>One great feature in Excel is that it can automatically recognize data patterns. But what\u2019s even better is that Excel will let you enter those data patterns to other cells.<\/p>\n<ol>\n<li>Simply enter your information in two cells to establish your pattern.<\/li>\n<li>Highlight the cells. There will be a small square in the bottom right hand corner of the last cell.&nbsp;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5435 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Data-Pattern.jpg\" alt=\"Excel Data Patterns\" width=\"218\" height=\"119\"><\/li>\n<li><span lang=\"EN-US\">Place your cursor over this square until it becomes a black cross.&nbsp;<\/span><\/li>\n<li>Then click and drag it with your mouse down to populate the cells within a column<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5436\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Enter-Data-Patterns.jpg\" alt=\"Entering Spreadsheet Data Patterns\" width=\"505\" height=\"172\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Enter-Data-Patterns.jpg 505w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Enter-Data-Patterns-300x102.jpg 300w\" sizes=\"auto, (max-width: 505px) 100vw, 505px\" \/><\/li>\n<\/ol>\n<h2><strong>8. Hide Spreadsheet Rows and Columns<\/strong><\/h2>\n<p>In some cases, you may have information in rows or columns that are for your eyes only and no one else\u2019s. Isolate these cells from your work area (and prying eyes) by hiding them:<\/p>\n<ol>\n<li>Select the first column or row in the range you want to hide.<\/li>\n<li>Go to <strong>Format <\/strong>under the <strong>Home<\/strong> menu.<\/li>\n<li>Select <strong>Hide &amp; Unhide&gt;Hide Rows <\/strong>or <strong>Hide Columns<\/strong>.&nbsp;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5439 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Hide-Columns-Rows.jpg\" alt=\"Hiding Excel Rows Columns\" width=\"357\" height=\"463\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Hide-Columns-Rows.jpg 357w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Hide-Columns-Rows-231x300.jpg 231w\" sizes=\"auto, (max-width: 357px) 100vw, 357px\" \/><\/li>\n<\/ol>\n<p>To unhide them, click on the first row or column that occur just before and after the hidden range. Repeat steps 2 and 3, but select <strong>Unhide Rows <\/strong>or <strong>Unhide Columns.<\/strong><\/p>\n<h2><strong>9. &nbsp;Copy Formulas Or Data Between Worksheets<\/strong><\/h2>\n<p>Another helpful tip to know is how to copy formulas and data to a separate worksheet. This is handy when you\u2019re dealing with data that\u2019s spread across different worksheets and requires repetitive calculations.<\/p>\n<ol>\n<li>With the worksheet containing the formula or data you wish to copy opened, <strong>CTRL + click<\/strong> on the tab of the worksheet you want to copy it to.<\/li>\n<li>Click on or navigate to the cell with the formula or data you need (in the opened worksheet).<\/li>\n<li>Press <strong>F2<\/strong> to activate the cell.<\/li>\n<li>Press Enter.&nbsp; This will re-enter the formula or data, and it will also enter it into the same corresponding cell in the other selected worksheet as well.<\/li>\n<\/ol>\n<p>These general tips won\u2019t turn you into an Excel guru overnight. But they can help you take that first step towards becoming one! Are you a well-seasoned Excel user? Which of your spreadsheet tricks would you add?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Without doubt, an Excel spreadsheet is one of the most advanced tools for working with raw data\u2014and one of the most feared. &nbsp;The application looks complicated, way too advanced, and like something that would take hours to figure out. I wouldn\u2019t be surprised if upon hearing that you had to start using MS Excel, your &#8230; <a title=\"Work With Excel Data Like A Pro With 9 Simple Tips\" class=\"read-more\" href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html\" aria-label=\"More on Work With Excel Data Like A Pro With 9 Simple Tips\">Continue reading \u2192<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,332,8],"tags":[267,92,45,85,39,59,122],"class_list":["post-5430","post","type-post","status-publish","format-standard","hentry","category-investintech-tips","category-tech-tips-tutorials","category-5-top-tech-lists","tag-document-management","tag-microsoft","tag-ms-excel","tag-pdf-to-excel","tag-productivity","tag-tips","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Work With Excel Data Like A Pro With 9 Simple Tips<\/title>\n<meta name=\"description\" content=\"Not sure how to get started with Microsoft Excel? Discover some basic Excel spreadsheet tips to work with your data quickly and easily.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Work With Excel Data Like A Pro With 9 Simple Tips\" \/>\n<meta property=\"og:description\" content=\"Not sure how to get started with Microsoft Excel? Discover some basic Excel spreadsheet tips to work with your data quickly and easily.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html\" \/>\n<meta property=\"og:site_name\" content=\"PDF Blog | Investintech PDF Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-09T16:31:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-09T09:48:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Format-Painter.jpg\" \/>\n<meta name=\"author\" content=\"Reena\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@able2extract\" \/>\n<meta name=\"twitter:site\" content=\"@able2extract\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html\"},\"author\":{\"name\":\"Reena\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409\"},\"headline\":\"Work With Excel Data Like A Pro With 9 Simple Tips\",\"datePublished\":\"2015-02-09T16:31:56+00:00\",\"dateModified\":\"2021-08-09T09:48:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html\"},\"wordCount\":1006,\"publisher\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Format-Painter.jpg\",\"keywords\":[\"Document Management\",\"Microsoft\",\"MS Excel\",\"PDF to Excel\",\"productivity\",\"tips\",\"tutorial\"],\"articleSection\":[\"Investintech Tips\",\"Tech Tips and Tutorials\",\"Top Tech Lists\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html\",\"name\":\"Work With Excel Data Like A Pro With 9 Simple Tips\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Format-Painter.jpg\",\"datePublished\":\"2015-02-09T16:31:56+00:00\",\"dateModified\":\"2021-08-09T09:48:19+00:00\",\"description\":\"Not sure how to get started with Microsoft Excel? Discover some basic Excel spreadsheet tips to work with your data quickly and easily.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#primaryimage\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Format-Painter.jpg\",\"contentUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Format-Painter.jpg\",\"width\":248,\"height\":238,\"caption\":\"Using Excel Format Painter\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.investintech.com\/resources\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Work With Excel Data Like A Pro With 9 Simple Tips\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#website\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/\",\"name\":\"PDF Blog | Investintech PDF Solutions\",\"description\":\"Everything PDF\",\"publisher\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.investintech.com\/resources\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\",\"name\":\"PDF Blog | Investintech PDF Solutions\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp\",\"contentUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp\",\"width\":270,\"height\":40,\"caption\":\"PDF Blog | Investintech PDF Solutions\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/able2extract\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409\",\"name\":\"Reena\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g\",\"caption\":\"Reena\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Work With Excel Data Like A Pro With 9 Simple Tips","description":"Not sure how to get started with Microsoft Excel? Discover some basic Excel spreadsheet tips to work with your data quickly and easily.","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:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html","og_locale":"en_US","og_type":"article","og_title":"Work With Excel Data Like A Pro With 9 Simple Tips","og_description":"Not sure how to get started with Microsoft Excel? Discover some basic Excel spreadsheet tips to work with your data quickly and easily.","og_url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html","og_site_name":"PDF Blog | Investintech PDF Solutions","article_published_time":"2015-02-09T16:31:56+00:00","article_modified_time":"2021-08-09T09:48:19+00:00","og_image":[{"url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Format-Painter.jpg","type":"","width":"","height":""}],"author":"Reena","twitter_card":"summary_large_image","twitter_creator":"@able2extract","twitter_site":"@able2extract","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#article","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html"},"author":{"name":"Reena","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409"},"headline":"Work With Excel Data Like A Pro With 9 Simple Tips","datePublished":"2015-02-09T16:31:56+00:00","dateModified":"2021-08-09T09:48:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html"},"wordCount":1006,"publisher":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Format-Painter.jpg","keywords":["Document Management","Microsoft","MS Excel","PDF to Excel","productivity","tips","tutorial"],"articleSection":["Investintech Tips","Tech Tips and Tutorials","Top Tech Lists"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html","url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html","name":"Work With Excel Data Like A Pro With 9 Simple Tips","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#primaryimage"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Format-Painter.jpg","datePublished":"2015-02-09T16:31:56+00:00","dateModified":"2021-08-09T09:48:19+00:00","description":"Not sure how to get started with Microsoft Excel? Discover some basic Excel spreadsheet tips to work with your data quickly and easily.","breadcrumb":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#primaryimage","url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Format-Painter.jpg","contentUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2015\/02\/Excel-Format-Painter.jpg","width":248,"height":238,"caption":"Using Excel Format Painter"},{"@type":"BreadcrumbList","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/5430-excel-data-tips.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.investintech.com\/resources\/blog\/"},{"@type":"ListItem","position":2,"name":"Work With Excel Data Like A Pro With 9 Simple Tips"}]},{"@type":"WebSite","@id":"https:\/\/www.investintech.com\/resources\/blog\/#website","url":"https:\/\/www.investintech.com\/resources\/blog\/","name":"PDF Blog | Investintech PDF Solutions","description":"Everything PDF","publisher":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.investintech.com\/resources\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization","name":"PDF Blog | Investintech PDF Solutions","url":"https:\/\/www.investintech.com\/resources\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp","contentUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp","width":270,"height":40,"caption":"PDF Blog | Investintech PDF Solutions"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/able2extract"]},{"@type":"Person","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409","name":"Reena","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g","caption":"Reena"}}]}},"_links":{"self":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/5430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/comments?post=5430"}],"version-history":[{"count":14,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/5430\/revisions"}],"predecessor-version":[{"id":10306,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/5430\/revisions\/10306"}],"wp:attachment":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/media?parent=5430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/categories?post=5430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/tags?post=5430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}