{"id":54,"date":"2015-05-18T12:27:00","date_gmt":"2015-05-18T17:27:00","guid":{"rendered":"http:\/\/itsnotaboutthecell.com\/?p=54"},"modified":"2017-06-11T20:04:26","modified_gmt":"2017-06-12T01:04:26","slug":"how-to-create-a-table-in-excel","status":"publish","type":"post","link":"https:\/\/itsnotaboutthecell.com\/2015\/05\/18\/how-to-create-a-table-in-excel\/","title":{"rendered":"A Five Star Dinner On A Table With A Broken Leg"},"content":{"rendered":"

There\u2019s nothing better than releasing the final version of your workbook – every bit of sacrifice, blood, sweat and coffee stain for the world to bask in its majesty, for small children to sing songs about and draw pictures of in kindergarten classrooms. Having finally realized Maslow\u2019s theory of self actualization<\/a> in this single project – you<\/a><\/b> are the workbook messiah.<\/p>\n

\n

The real question is<\/p>\n

\u201cAre you eating a five star dinner on a table with a broken leg?<\/i><\/strong>\u201d<\/h3>\n
\n

What does this mean? It means you can put forth a great front end experience but if the building blocks are unstable it will be the only thing that matters when it comes to managing your finished project. Too often people are working harder, rather then smarter with managing their data,\u00a0so right now I ask that you place your right hand on the workbook and repeat after me:<\/p>\n

\n

MsgBox “I ” & InsertNameHere<\/i> & “do solemnly swear from this day forward to adhere to the laws of fields and records.”, vbOKOnly<\/strong><\/p>\n

\n

The first step in correcting our problems is in admitting them and being given the tools to a successful workbook recovery.<\/p>\n

What are the laws of fields and records?<\/p>\n

Fields<\/strong>\u00a0– commonly shared values – think of dates, state abbreviations, employee names, movie titles, authors – identifiable items that can be easily pooled together under a shared theme.<\/p>\n

Records<\/strong> – <\/b>individual data entries under each field type<\/p>\n

How do I apply these laws?<\/h4>\n

1. First things first – no matter what it takes – and let me repeat this<\/i><\/strong> – no matter what it takes – for long term management in reporting you must find the commonalities within your data to get them into fields and records. If you can not find the similarities you should be using Microsoft Word because you are doing text editing not data analysis.<\/p>\n

2. From this day forth the sky is blue, grass is green and data moves top to bottom. There are too many valuable functions you are leaving off the table (pun intended<\/i>) if you are managing your data from left to right:<\/p>\n

    \n
  • Data Filtering<\/li>\n
  • Data Sorting<\/li>\n
  • Removing Duplicates<\/li>\n
  • Pivot Tables<\/li>\n<\/ul>\n
    \"Vertical<\/figure>\n

    No. Just No.<\/p><\/blockquote>\n

    3. Getting your data into order is a lot easier than you think –<\/p>\n