After creating spreadsheets in Microsoft Excel, you can perform data analysis and track changes with your peers andText and data segmentation And much more. Most importantly, Excel lets you format your data into tables to plot your data points and present them in an organized way, such as graphs or other visual tools. Spreadsheets full of numbers can be boring, and you can give them a fun spin using Excel's built-in features. This post will show you the best tips for formatting table data in Microsoft Excel. We're using a Mac, and the same steps apply to Windows users.
1. SPARKLINES
Let's say you're creating a table containing data such as monthly sales or daily weight loss progress. Sparklines is a feature in Microsoft Excel that allows you to create a small graph within a cell. This will help you better visualize the data. Follow these steps.
Step 1: Open Microsoft Excel on your computer.
Step 2: Open spreadsheet file that you want to edit.
Step 3: Locate fields that you want to visualize its data points.
Step 4: Click "Insert" In the top menu bar.
Step 5: Look for Sparklines option Towards the top right.
Step 6: Click الخيار and select Chart pattern Your.
It will open Sparklines window It asks you to select the cell to place. Indicator lines.
Step 7: after Select cell , click the . button "OK".
Excel will create a small graph within the selected cell. You can repeat the steps and create bright lines for each cell of your choice.
You can also change Color of the highlights By clicking on the option in the top menu bar towards the right.
2. People chart
If you create reports with data points like app downloads, social media engagement, newsletter subscribers, and more, the People Graph feature will be helpful for visualizing your data. It will make your spreadsheet more dynamic and make your tracking metrics more human-like. Follow these steps.
Step 1: Open Microsoft Excel Select your spreadsheet file.
Step 2: Click "Insert" In the top menu bar.
Step 3: Click green code next to My Add-ons to add People chart.
The default people chart will appear on the sheet above the table.
Step 4: Click and drag to move the people chart away from the table.
Step 5: Locate People Graph image and click Data icon in the top right.
Step 6: Change address People Graph Yours to match your table.
Step 7: Click Specify your data.
Step 8: Locate Data points From the table you want to add to People Graph.
Step 9: Click construction.
You will see New chart For people in your paper represents the metrics of your table.
To change the icon type, theme, and shape, simply click the settings icon in the top right corner of the "People chart".
3. Slices
Sometimes when analyzing data in a table, viewing metrics can be overwhelming. You might feel confused or lost while examining numbers grouped under different categories. You can avoid all the hassle by using the Slicer tool. It's a great option for filtering your data into small, digestible tables. Here's how.
Step 1: Open data table Yours in Microsoft Excel.
Step 2: Click on Command + A (Mac) Or Control + A (Windows) To set your schedule.
Step 3: Click "Insert" In the top menu bar while keeping the table selected.
Step 4: Locate Slicer From the top menu bar towards the right.
Step 5: in Slicer window , Locate Your data categories for inserting Slicers For herself.
Step 6: Click "OK" to confirm your choice.
Slicers for the selected data categories will appear in the spreadsheet.
You can now select individual data filters from your table to view metrics separately.
To deselect your filters, simply click Clear Filter icon in the upper right.
4. Paint the shape
Format Paint allows you to maintain consistent table formatting while adding different tables to the same spreadsheet. If you want to use this feature in your spreadsheet files, follow these steps.
Step 1: Open spreadsheet file In Microsoft Excel.
Step 2: Locate table cells whose format you want to copy.
Step 3: Click paintbrush icon In the upper left corner within Home tab.
Step 4: Bring the cursor to the unformatted table and select All cells.
You will see that both tables now have the same formatting consistency.
5. Data unification
If your spreadsheet file contains more than one sheet tab, you can combine all the data from the sheets into a single tab using this feature. The best part is, you don't need to insert any specific formulas! You can use sum, average, calculation, and more in the source tabs, and the combined tab will update automatically. Follow these steps.
Step 1: Open spreadsheet file Which contains more than One sheet tab.
Step 2: Click Plus icon Below to create New Sheet Tab Name it as per your preference.
Step 3: In the new sheet tab, select the cell from which you want to place the merged data.
Step 4: Click the Data tab in the top menu.
Step 5: within Data tab , Locate Symbol of monotheism on the right side.
Step 6: On the Merge tab, click the reference icon to add source data.
Step 7: Once you The Unification tab contracts , Open First Sheet Tab and select All data existing therein.
Step 8: Click Reference Code Again to pull the window.
Step 9: Click Plus code once again.
You will see the first sheet data reference added in All References box.
Step 10: Click Reference Code Again, repeat the steps to add reference sheet data in the Consolidation window.
Step 11: After selecting the date, make sure to select Create links to source data option. Do the same with My options are “Top Row” and “Left Column”.
Step 12: After enabling all the options, click on "OK".
You will see a new table in the Sheet tab with all the data merged from the previous sheets.
Figure tables in Microsoft Excel
Formatting table data in Microsoft Excel is one of its greatest assets. The features discussed in this post will enhance your productivity and data presentation skills. Just make sure you're using the latest version of Microsoft Excel on your desktop.
