JPG' alt='Excel Edit Table Style Light' title='Excel Edit Table Style Light' />Excel Charts and Graphs Tutorial.When should you use a chartUse a chart whenever you want to visualize your data, making it clear and simple to comprehend.Sometimes one glimpse at a chart can save a lot of effort of figuring out the meaning of your data.Last things to verify before creating a chart Make sure your data is organized in the correct layout It should have a table layout, with no spaces between rows and columns, and no spaces between the headers and the rest of the table.When you select the charts data table, contain the headers in the selection, and dont contain empty rows or columns.Types of charts You can choose between many types of charts, the most popular are Column, Line and Pie.The charts elements Titles You can add titles to the chart a general title to the whole chart, and specific titles to the X axis the horizontal axis and the Y Axis the vertical.Legend The legend which represents the meaning of the columns or lines can be placed in any desired location around the chart, but can also be hidden.Labels You can add small numbers to the columns, to show their exact values.Y axis scale You can set the Y axis scale, and control the range of values depicted on it.Excel Edit Table Style OptionsCreate an Excel Table to organize your data.Quickly sort, filter, change formatting with Table Styles.Create pivot table from the Excel table.How to Make Tables Using Microsoft Excel.This wikiHow teaches you how to create a table of information in Microsoft Excel.You can do this on both Windows and Mac.Excel Online formerly Excel Web App extends your Microsoft Excel experience to the web browser, where you can work with workbooks directly on the website.For example, on a chart comparing a 3.Y axis range is between 3.Formatting the charts elements fonts, colors, backgrounds etc.Every element in the chart titles, legend, columns etc can be formatted as if it was a simple graphic object.All texts and numbers can be simply right clicked and formatted with the mini toolbar.A Marketers Guide To Table Formatting In Excel.If theres one task most marketers share whether their focus is SEO, paid search, or social media its collecting and interpreting data.Being able to slice and dice the data to find actionable insights is key to effective analysis.Yet, one of the biggest mistakes marketers make is trying to wrangle static data instead of taking advantage of Excels table formatting, which basically turns your data range into an interactive database.I hope to rectify that injustice against innocent data with this guide.XutVqdFnFlY/VhXpflPu0qI/AAAAAAAAIXA/xRuxUQXr5IY/s1600/data%2Btable%2B5.png' alt='Excel Edit Table Style' title='Excel Edit Table Style' />Microsoft introduced table formatting in its 2.Mac. For me, it was love at first sight.Youll understand why when you see all the cool things you can do with your data once you format it as a table.Well just use one of the built in styles for now but then customize one later in the post to show how easy it is to create a branded table.Learn creating and making charts in Microsoft Excel 20.Ill demonstrate using a data dump from SEMRush for a shoe website I checked into after seeing the coolest shoe store in Manhattan last week, Shoe Mania.Disclosure I have no affiliation with the store or the site.My poor friend risked life and limb for an emergency stop.SEMRush is a great jumping off point for competitive analysis because it lets you know the keywords that the site is ranking for on the first two pages of Google.It shows you Google US by default, but you can also choose from nine other countries or Bing US only.As with nearly any tool out there, you have the ability to export the data as a CSV file.CSV data dumps epitomize ugly data, but in less than two minutes, you can take a hideous data dump like this and transform it into a work of data art between table formatting and some strategically executed conditional formatting a topic for another post.If you want to follow along, you can download the Excel file I use in the post.The original data dump is in the first tab.Then, I have a tab for the table formatted using a built in style, with a third tab for the same table that is formatted using colors I pulled from the sites logo.The Chrome Eye Dropper extension is a great tool for getting the RGB values of colors you find on a website.Table Setup. To get started, select any cell inside your data set, then choose Home Styles Format as Table On a Mac Tables Table Styles.A Format as Table menu will pop up.This will give you a drop down of table formatting options.I chose to use the middle green format in the Light category.Click for larger image.Excel will auto detect the perimeter of your table and populate the range.It will also auto detect headings.If that option isnt selected which sometimes happens in the Mac version of Excel, just select it.I cleaned the data up a bit by hiding a few columns I dont use select columns right click Hide, adding number formatting under Home Number, auto expanding the column widths double click on any column separator, and turning off gridlines and headings to dial back on some of the noise View Show for PC or Layout View for Mac. Mohabbatein Hindi Film Mp3 Song Free Download . I also added some summary data at the top of the sheet, leaving me with a worksheet that is clean, visually appealing, and interactive.I do this with every data export I open in Excel, without exception.Click for larger image.Sort Filter. The best benefit to formatting your data as a table, in my opinion, is the multiplicity of sort and filter options it affords.You can access these by clicking on any of the down facing triangles in the header row.If your column contains text youll see filter options specific to text, and if your data contains numbers, they will be tailored to numbers, as you can see in this comparison Click for larger image.Sort Options. There are three ways you can sort your table Smallest to Largest or vice versa.This option is self explanatory, really.Click on the down facing triangle in the columns heading you want to sort the table by, and choose your sort option at the top of the drop down menu.Color. Whether you apply a background fill or font color manually or by using conditional formatting, you can use that color to sort your data.I used conditional formatting to format the top 1.Search Volumes with a yellow fill and the bottom 1.You can get to these options under Home Styles Conditional Formatting TopBottom Rules for the PC or Home Format Conditional Formatting TopBottom Rules for the Mac.I wouldnt actually hatchet the formatting like this I just wanted to demonstrate where the different formats show up in the fly out menu.Now, you can sort the column by cells with a yellow fill, red font, no fill, black or Automatic font color, or a combination of factors using the Custom Sort option.So if I wanted the keywords with the highest search volume to float to the top of my table, Id simply click on the yellow bar under Sort by Cell Color.Custom. If you want to sort by more than one value, you can choose Custom Sort under the Color menu.This is a UI faux pas on Microsofts part, in my opinion, since you can use a custom sort that doesnt use color formatting at all.Its even worse on the Mac.You dont even get a Custom Sort option unless the column has some kind of color formatting.If it gets too confusing, just select any cell in the column you want to sort by and choose your sort options under Data Sort Filter Sort same for the Mac.In this example as I frequently do with SEMRush data when analyzing it I sorted first by Search Volume in descending order and then by Keyword in ascending order, which essentially allows me to see if keywords are driving traffic to competing landing pages.Sometimes, especially with branded keywords, this is a good thing because it indicates indented or multiple listings other times it means that Google cant tell which page to send traffic to for a particular keyword.Filter Options. As the name suggests, the filter options hide rows based on the criteria you choose.No data is lost in this process.Its just temporarily hidden to help you hone in on the data youre trying to interpret.At any time, you can release these filters by choosing Clear Filter from Heading from the drop down menu on a PC and the Clear Filter button on a Mac.Text. One great use of text filters is to filter out branded keywords in analytics, webmaster tools, or SEMRush data.Regrettably, Excel doesnt support regular expressions regex out of the box, but fellow columnist Crosby Grant has shared a hack to use Regex via macros in Excel here.Otherwise, you can use two filter options at a time concatenated with and or or.You also have two wildcard characters available to you and The question mark represents a single character, and the asterisk any series of characters.With this example, I was able to filter out all of the branded keywords for Shoe Mania by using a combination filter, as you can see in the screenshot below.Click to enlarge.However, one time I was trying to filter by all keywords that contained halloween, and it was no small task.People have no idea how to spell the word, and I had about 2.I was eventually able to capture all but a few with a Contains filter that employed both the The result was h That translates to, I know it starts with an h and then could have any one letter after that to capture the variations that use an o instead of an a.Then theres an l, followed by a total free for all, finally wrapping up with an en at the end.Then, I used another Contains filter that tacked an e at the end of all that, lassoing the few stragglers that were left.You can also use the URL e.Click for larger image.Number You can take advantage of any of the number filters I showed earlier.Color In the same way you can sort by color, you can also filter by color.Manual Selection This option allows you to select and deselect individual values from the filter drop down.To easily find a particular value, you can also use the search box.Table Formatting.As I mentioned earlier, if you want to choose one of the table styles that come baked into every theme accessed under Page Layout Themes Mac Home Themes you can do that from the Format as Table drop down menu.However, if you want to apply specific colors to keep with your branding, you can create a custom table style by choosing New Table Style under the Format as Table drop down.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |