{"id":2358,"date":"2018-03-16T08:51:11","date_gmt":"2018-03-16T14:51:11","guid":{"rendered":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/"},"modified":"2021-09-13T02:09:58","modified_gmt":"2021-09-13T07:09:58","slug":"tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro","status":"publish","type":"post","link":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/","title":{"rendered":"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro"},"content":{"rendered":"<p>With the 2016 version of Excel, Microsoft has really upped the game for people who aren\u2019t great with numbers. You can now easily use one-click access that can be customized to provide the functionality you need.<\/p>\n<p><span style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span>This is the first of a three-part series about using Microsoft Excel 2016 to help you identify trends, construct helpful charts, and organize information to maximize the value of your data.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20778\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image.png\" \/><\/p>\n<p>You can use Excel Worksheets and Workbooks in conjunction with programs like Microsoft Access and PowerPoint. Excel 2016 possesses many capabilities that aren\u2019t readily apparent. That\u2019s why we\u2019re providing this three-part series for you.<\/p>\n<p><strong>What is Excel and how is it organized?<\/strong><\/p>\n<p>Excel is an electronic spreadsheet program that\u2019s used to store, organize and manipulate data. You enter data into Workbooks that are made up of individual Worksheets. In the Worksheets, you enter data into cells that are organized into rows and columns. Excel data can consist of text, numbers, dates, times and formulas.<\/p>\n<p><strong>Why would you want to use Excel?<\/strong><\/p>\n<p>If you or your employees work with financial data, it\u2019s a great tool to use for:<\/p>\n<ul>\n<li>Basic mathematical operations like adding, dividing, and multiplying.<\/li>\n<li>Finding values like profits or losses.<\/li>\n<li>Calculations like averages, percentages and number counts.<\/li>\n<\/ul>\n<p>Performing calculations in Excel is only the tip of the iceberg. There\u2019s much more you can do like creating charts and graphical layouts to make it easier to recognize trends and more easily analyze data.<\/p>\n<p><strong>Navigation<\/strong><\/p>\n<p>What\u2019s great about Excel is that it has the same set up as other Microsoft products you\u2019re familiar with. You have tabs across the top, where each tab has a corresponding ribbon with many functionalities to choose from.<\/p>\n<p><strong>The Quick Access Toolbar<\/strong><\/p>\n<p>The Quick Access Toolbar is a drop-down menu where you\u2019ll find functions that you commonly use like Print and Save. You can also customize the Quick Access menu with other functions you use on a regular basis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20779\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-1.png\" width=\"547\" height=\"286\" \/><\/p>\n<p><strong>The Formula Bar<\/strong><\/p>\n<p>This is located underneath the ribbon next to the Name Box that shows you where your cursor is located on your Worksheet. The Formula Bar is important because it\u2019s what calculates the math for you. Excel does the calculation and displays the answer in the cell you choose. The Formula Bar also shows you the contents of the particular cell you\u2019re in.<\/p>\n<p><strong>Adding Data<\/strong><\/p>\n<p>There are three ways you can add data to your Excel Worksheet. You can:<\/p>\n<ol>\n<li>Type in the data,<\/li>\n<li>Copy and Paste data, or<\/li>\n<li>Import data from other sources.<\/li>\n<\/ol>\n<p>This is great if you have a large amount of data. For example, if you have customer lists in a database, you can even pull this into Excel.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20780\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-2.png\" \/><\/p>\n<p>You can enter data into only one cell, into several cells at the same time, or even on more than one Worksheet at once. And, as mentioned, the data can be numbers text, formulas, dates, or times.<\/p>\n<p>On your Worksheet, simply click a cell and type in the information that you want to enter. Then hit ENTER or TAB. If you typed in a date, Excel will recognize this and format it the way you\u2019ve specified in your default settings.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20781\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-3.png\" \/><\/p>\n<p><strong>Formulas<\/strong><\/p>\n<p>Excel computes the correct answer when you enter a formula into a cell. Once you\u2019ve done this, it recalculates whenever you change any of the values. The way Excel knows that you\u2019re entering a formula is by starting with an equal sign. Then you follow the equal sign with a SUM or AVERAGE.<\/p>\n<p>For example, C2: =A2+B2 means that the number in C2 is what occurs when you add the numbers in A2 and B2.<\/p>\n<p>You can type this in manually, but now Excel has great functionalities to help you do this. The simple way is to put your cursor in cell C2, hit = and type in A2+B2. The numbers in A2 and B2 will be added, and the SUM will be entered in cell C2.<\/p>\n<p>Note: You always want to calculate using the actual cells rather than typing in numbers like 1 + 2, etc. The reason for this is so you can go back at any time and change the values in cells and the formula will calculate with the new numbers.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20782\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-4.png\" \/><\/p>\n<p>Let\u2019s say you want to add a bunch of numbers together in your Worksheet. You can type <strong>= sum (a1:a5)<\/strong> in the cell where you want the answer to appear. Or you can do this and drag your mouse across the cells you want to add<strong>. <\/strong>Type <strong>=sum (<\/strong> and drag your mouse across the cells and hit ENTER. The sum will appear in the cell without you having to typing in all the numbers! When you put your cursor on the cell, you will see the actual formula you just created.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20783\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-5.png\" \/><\/p>\n<p>There are many ways to do the same thing in Excel. It\u2019s like this across all Microsoft products. You can go to the Ribbon at the top to \u201cAuto Sum\u201d to do the same calculation. Select a cell next to the numbers you want to add, click\u00a0<strong>AutoSum<\/strong>\u00a0on the\u00a0<strong>Home<\/strong> tab and press\u00a0<strong>Enter<\/strong>. Do what works best for you.<\/p>\n<p>Once you create a formula, you can copy and paste it into another cell. You can also copy and paste formulas into different Worksheets as well. This can save you a lot of time.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20784\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-6.png\" \/><\/p>\n<p><strong>Formatting Worksheets<\/strong><\/p>\n<p>With Excel 2016, you can format your Worksheets much more easily than you could before. You can use document themes throughout the Worksheets in your Workbook to present a professional and consistent appearance. You can also apply predesigned formats as well.<\/p>\n<p><strong><img decoding=\"async\" class=\"wp-image-20785\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-7.png\" \/><\/strong><\/p>\n<p>Let\u2019s say you have a Worksheet with many rows that are hard to read. You can go in and create fill colors and more to differentiate the rows, columns, and headers to make reading much easier.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20786\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-8.png\" \/><\/p>\n<p>You have options to create borders around cells, rows or columns from the drop-down menu. You can also shade cells with a solid background. Don\u2019t forget that you can change the style and types of fonts. Right-click the text, and a drop-down menu will appear where you can make these and other selections easily.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20787\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-9.png\" \/><\/p>\n<p><strong>Creating Charts<\/strong><\/p>\n<p>If the data isn\u2019t complex, you can easily read it, but if you have a lot of data, creating a chart will help you better analyze it. You can select specific cells, rows, and columns for your chart. One way to do this is to highlight the data and go to the top ribbon to select the type of chart you want to create.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20788\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-10.png\" \/><\/p>\n<p>With Excel 2016, you have a \u201crecommended charts\u201d option. Excel will help you choose the chart that best suits your data.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20789\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-11.png\" \/><\/p>\n<p>You can then go in and further customize your chart in the \u201cChart Tools\u201d. You can change the color scheme, 3D effects, shading and more. If you change the data in the cells in your Worksheet, your chart will reflect the changes.<\/p>\n<p>Some of the new charts in 2016 include:<\/p>\n<ul>\n<li>Waterfall<\/li>\n<li>Tree Map<\/li>\n<li>Box and Whiskers<\/li>\n<li>Sunburst<\/li>\n<\/ul>\n<p><strong>Creating Tables <\/strong><\/p>\n<p>You may be used to creating tables in Word or PowerPoint. Some people think the format in Excel is already in a table, but it\u2019s not; at least until you tell it to do so. If you want to do this, select your data, go to \u201cInsert\u201d and select \u201cTable.\u201d<\/p>\n<p>Similar to other Microsoft products, tabs will appear to help you format your table.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20790\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-12-1.png\" \/><\/p>\n<p><strong>Viewing Worksheets<\/strong><\/p>\n<p>When dealing with lots of information, it can get unruly trying to work around various rows and columns. This is where Viewing Worksheets can be helpful. You can freeze a portion of your worksheet with \u201cFreeze Panes\u201d to more easily view it.<\/p>\n<p>You also have the ability to \u201csplit\u201d the data to view different parts of your Worksheet. You can compare two Worksheets in the same Workbook or even in different Workbooks by viewing them side by side.<\/p>\n<p><strong>Saving and Printing<\/strong><\/p>\n<p>If you have Worksheets that are so large they won\u2019t fit on one page, go to \u201cSave As\u201d and decide on the name, where it gets saved, and go to \u201cPrint\u201d where you can save the file to a pdf that you can send.<\/p>\n<p>You can select options for printing the entire sheet, part of it, resizing it, and more to suit your needs. Going to \u201cPage Setup\u201d will allow you to shrink the entire Worksheet down to a size that\u2019s more manageable for printing.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20791\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-13.png\" \/><\/p>\n<p><strong>Sharing &amp; Security<\/strong><\/p>\n<p>In Excel 2016 you can share Workbooks and Worksheets with others and password-protect them. The people you send them to need to know your password to open them, whether you send them via email, share them on your network, or via the cloud. From within Excel, you can designate who can access your Worksheets and Workbooks, and also whether they can edit them or not. There are a variety of parameters you can set within a Worksheet.<\/p>\n<p>For example, if you want to hide employees\u2019 salaries, you can hide this section when you share it. Or, you can let people see your data but lock it down, so they can\u2019t change it. You can also protect your Worksheets and Workbooks to keep them secure from non-authorized users.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20792\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-14.png\" \/><\/p>\n<p><strong>The Quick Analysis Tool<\/strong><\/p>\n<p>When highlighting data, click on the Quick Analysis button to create a chart, highlight specific cells, and much more. It doesn\u2019t give you the functionality you\u2019ll find in the Ribbon, but you can get things done quickly and easily with this tool.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20793\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-15.png\" \/><\/p>\n<p><strong>3D Power Maps<\/strong><\/p>\n<p>This is another new tool in Excel 2016 that lets you look at information in ways you might not have seen in the two-dimensional format. This helps you strategically create your data on a 3D map. You need latitude and longitude data to do this. You can also import your own maps into 3D Power Maps.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20794\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-16.png\" \/><\/p>\n<p><strong>PivotTables<\/strong><\/p>\n<p>PivotTables help you analyze your Worksheet data. You can summarize, analyze, explore and present your data in just a few clicks. They are very flexible and can be adjusted to your unique needs. Note: Your data should be organized without blank rows or columns for this to work properly.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20795\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-17.png\" \/><\/p>\n<p>The good news is that Excel 2016 will also help you pick the best format for your PivotTables!<\/p>\n<p><strong>PivotCharts<\/strong><\/p>\n<p>PivotCharts are another great way to add visualizations to your data. You will first need a PivotTable to create a chart. Now, your PivotTable will behave like a PivotChart. When you change the information in your PivotTable, the PivotChart will also reflect this change. The PivotTable is connected to the PivotChart.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-20796\" src=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-18.png\" \/><\/p>\n<p><strong>That\u2019s it for now! For more information on using Excel 2016 like a Pro, feel free to contact the Microsoft Experts at Kraft Technology Group! {phone} {email}<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>With the 2016 version of Excel, Microsoft has really upped the game for people who aren\u2019t great with numbers. You can now easily use one-click access that can be customized to provide [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4836,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_mbp_gutenberg_autopost":false,"footnotes":""},"categories":[17],"tags":[],"class_list":["post-2358","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v19.6 (Yoast SEO v23.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tired Of Amateur Hour? Learn How To Use Excel Like A Pro &#8211; KTG<\/title>\n<meta name=\"description\" content=\"Click Here to learn more \ud83c\udf1f Tired Of Amateur Hour? Learn How To Use Excel Like A Pro - Since 1992 - Nashville&#039;s Top IT Services Company\" \/>\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.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro\" \/>\n<meta property=\"og:description\" content=\"Click Here to learn more \ud83c\udf1f Tired Of Amateur Hour? Learn How To Use Excel Like A Pro - Since 1992 - Nashville&#039;s Top IT Services Company\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/\" \/>\n<meta property=\"og:site_name\" content=\"KTG\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/krafttechgroup\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-16T14:51:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-13T07:09:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-19.png\" \/>\n\t<meta property=\"og:image:width\" content=\"648\" \/>\n\t<meta property=\"og:image:height\" content=\"368\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brian Gray\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/krafttechgroup\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brian Gray\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/\"},\"author\":{\"name\":\"Brian Gray\",\"@id\":\"https:\/\/www.kraftgrp.com\/#\/schema\/person\/d64e95076b360a71439fd86beec62c36\"},\"headline\":\"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro\",\"datePublished\":\"2018-03-16T14:51:11+00:00\",\"dateModified\":\"2021-09-13T07:09:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/\"},\"wordCount\":1805,\"publisher\":{\"@id\":\"https:\/\/www.kraftgrp.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-19.png\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/\",\"url\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/\",\"name\":\"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro &#8211; KTG\",\"isPartOf\":{\"@id\":\"https:\/\/www.kraftgrp.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-19.png\",\"datePublished\":\"2018-03-16T14:51:11+00:00\",\"dateModified\":\"2021-09-13T07:09:58+00:00\",\"description\":\"Click Here to learn more \ud83c\udf1f Tired Of Amateur Hour? Learn How To Use Excel Like A Pro - Since 1992 - Nashville's Top IT Services Company\",\"breadcrumb\":{\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#primaryimage\",\"url\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-19.png\",\"contentUrl\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-19.png\",\"width\":648,\"height\":368,\"caption\":\"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.kraftgrp.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.kraftgrp.com\/#website\",\"url\":\"https:\/\/www.kraftgrp.com\/\",\"name\":\"KTG\",\"description\":\"Nashville IT Support &amp; IT Services\",\"publisher\":{\"@id\":\"https:\/\/www.kraftgrp.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.kraftgrp.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Organization\",\"Place\"],\"@id\":\"https:\/\/www.kraftgrp.com\/#organization\",\"name\":\"Kraft Technology Group\",\"url\":\"https:\/\/www.kraftgrp.com\/\",\"logo\":{\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#local-main-organization-logo\"},\"image\":{\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#local-main-organization-logo\"},\"address\":{\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#local-main-place-address\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":\"36.1941464\",\"longitude\":\"-86.807833\"},\"telephone\":[\"(615) 600-4411\"],\"openingHoursSpecification\":[{\"@type\":\"OpeningHoursSpecification\",\"dayOfWeek\":[\"Sunday\",\"Saturday\"],\"opens\":\"00:00\",\"closes\":\"00:00\"},{\"@type\":\"OpeningHoursSpecification\",\"dayOfWeek\":[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"],\"opens\":\"09:00\",\"closes\":\"17:00\"}],\"email\":\"info@kraftgrp.com\",\"faxNumber\":\"(615) 600-4411\",\"areaServed\":\"Tennessee\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.kraftgrp.com\/#\/schema\/person\/d64e95076b360a71439fd86beec62c36\",\"name\":\"Brian Gray\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.kraftgrp.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/43191bd1c1538b235477a17090600eaf?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/43191bd1c1538b235477a17090600eaf?s=96&d=mm&r=g\",\"caption\":\"Brian Gray\"},\"description\":\"Brian Gray, MCP, is the President at Kraft Technology Group, LLC (KTG), an affiliate of KraftCPAs PLLC. Within his role, Brian is responsible for all aspects of service delivery to our clients. Brian has a decade of experience working for managed service providers. He has worked with clients in a variety of industries, including financial services, accounting, legal, healthcare, manufacturing, and retail.\",\"sameAs\":[\"https:\/\/www.facebook.com\/krafttechgroup\/\",\"https:\/\/www.instagram.com\/kraft.tech.group\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/krafttechgroup\",\"https:\/\/www.youtube.com\/channel\/UCtyhZQ69LpOjdaHg6HxNwQg\/videos\"]},{\"@type\":\"PostalAddress\",\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#local-main-place-address\",\"streetAddress\":\"555 Great Circle, Road Nashville\",\"addressLocality\":\"Nashville\",\"postalCode\":\"37228\",\"addressRegion\":\"TN\",\"addressCountry\":\"US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#local-main-organization-logo\",\"url\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2019\/11\/Nashville-IT-Company.png\",\"contentUrl\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2019\/11\/Nashville-IT-Company.png\",\"width\":504,\"height\":100,\"caption\":\"Kraft Technology Group\"}]}<\/script>\n<meta name=\"geo.placename\" content=\"Nashville\" \/>\n<meta name=\"geo.position\" content=\"36.1941464;-86.807833\" \/>\n<meta name=\"geo.region\" content=\"United States (US)\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro &#8211; KTG","description":"Click Here to learn more \ud83c\udf1f Tired Of Amateur Hour? Learn How To Use Excel Like A Pro - Since 1992 - Nashville's Top IT Services Company","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.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/","og_locale":"en_US","og_type":"article","og_title":"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro","og_description":"Click Here to learn more \ud83c\udf1f Tired Of Amateur Hour? Learn How To Use Excel Like A Pro - Since 1992 - Nashville's Top IT Services Company","og_url":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/","og_site_name":"KTG","article_author":"https:\/\/www.facebook.com\/krafttechgroup\/","article_published_time":"2018-03-16T14:51:11+00:00","article_modified_time":"2021-09-13T07:09:58+00:00","og_image":[{"width":648,"height":368,"url":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-19.png","type":"image\/png"}],"author":"Brian Gray","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/krafttechgroup","twitter_misc":{"Written by":"Brian Gray","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#article","isPartOf":{"@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/"},"author":{"name":"Brian Gray","@id":"https:\/\/www.kraftgrp.com\/#\/schema\/person\/d64e95076b360a71439fd86beec62c36"},"headline":"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro","datePublished":"2018-03-16T14:51:11+00:00","dateModified":"2021-09-13T07:09:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/"},"wordCount":1805,"publisher":{"@id":"https:\/\/www.kraftgrp.com\/#organization"},"image":{"@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#primaryimage"},"thumbnailUrl":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-19.png","articleSection":["Blog"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/","url":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/","name":"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro &#8211; KTG","isPartOf":{"@id":"https:\/\/www.kraftgrp.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#primaryimage"},"image":{"@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#primaryimage"},"thumbnailUrl":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-19.png","datePublished":"2018-03-16T14:51:11+00:00","dateModified":"2021-09-13T07:09:58+00:00","description":"Click Here to learn more \ud83c\udf1f Tired Of Amateur Hour? Learn How To Use Excel Like A Pro - Since 1992 - Nashville's Top IT Services Company","breadcrumb":{"@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#primaryimage","url":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-19.png","contentUrl":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2018\/03\/word-image-19.png","width":648,"height":368,"caption":"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro"},{"@type":"BreadcrumbList","@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.kraftgrp.com\/"},{"@type":"ListItem","position":2,"name":"Tired Of Amateur Hour? Learn How To Use Excel Like A Pro"}]},{"@type":"WebSite","@id":"https:\/\/www.kraftgrp.com\/#website","url":"https:\/\/www.kraftgrp.com\/","name":"KTG","description":"Nashville IT Support &amp; IT Services","publisher":{"@id":"https:\/\/www.kraftgrp.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.kraftgrp.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Organization","Place"],"@id":"https:\/\/www.kraftgrp.com\/#organization","name":"Kraft Technology Group","url":"https:\/\/www.kraftgrp.com\/","logo":{"@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#local-main-organization-logo"},"image":{"@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#local-main-organization-logo"},"address":{"@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#local-main-place-address"},"geo":{"@type":"GeoCoordinates","latitude":"36.1941464","longitude":"-86.807833"},"telephone":["(615) 600-4411"],"openingHoursSpecification":[{"@type":"OpeningHoursSpecification","dayOfWeek":["Sunday","Saturday"],"opens":"00:00","closes":"00:00"},{"@type":"OpeningHoursSpecification","dayOfWeek":["Monday","Tuesday","Wednesday","Thursday","Friday"],"opens":"09:00","closes":"17:00"}],"email":"info@kraftgrp.com","faxNumber":"(615) 600-4411","areaServed":"Tennessee"},{"@type":"Person","@id":"https:\/\/www.kraftgrp.com\/#\/schema\/person\/d64e95076b360a71439fd86beec62c36","name":"Brian Gray","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.kraftgrp.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/43191bd1c1538b235477a17090600eaf?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/43191bd1c1538b235477a17090600eaf?s=96&d=mm&r=g","caption":"Brian Gray"},"description":"Brian Gray, MCP, is the President at Kraft Technology Group, LLC (KTG), an affiliate of KraftCPAs PLLC. Within his role, Brian is responsible for all aspects of service delivery to our clients. Brian has a decade of experience working for managed service providers. He has worked with clients in a variety of industries, including financial services, accounting, legal, healthcare, manufacturing, and retail.","sameAs":["https:\/\/www.facebook.com\/krafttechgroup\/","https:\/\/www.instagram.com\/kraft.tech.group\/","https:\/\/x.com\/https:\/\/twitter.com\/krafttechgroup","https:\/\/www.youtube.com\/channel\/UCtyhZQ69LpOjdaHg6HxNwQg\/videos"]},{"@type":"PostalAddress","@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#local-main-place-address","streetAddress":"555 Great Circle, Road Nashville","addressLocality":"Nashville","postalCode":"37228","addressRegion":"TN","addressCountry":"US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.kraftgrp.com\/tired-of-amateur-hour-learn-how-to-use-excel-like-a-pro\/#local-main-organization-logo","url":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2019\/11\/Nashville-IT-Company.png","contentUrl":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2019\/11\/Nashville-IT-Company.png","width":504,"height":100,"caption":"Kraft Technology Group"}]},"geo.placename":"Nashville","geo.position":{"lat":"36.1941464","long":"-86.807833"},"geo.region":"United States (US)"},"_links":{"self":[{"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/posts\/2358","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/comments?post=2358"}],"version-history":[{"count":0,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/posts\/2358\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/media\/4836"}],"wp:attachment":[{"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/media?parent=2358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/categories?post=2358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/tags?post=2358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}