Let it be said, who has not already panicked when analyzing an Excel file? “Can you process these results for me please?” It won’t be long, I promise! ”, finally spending hours there. “If only I had the Excel skills to do that”, we often say to ourselves… Luckily for you Cool Business heard your distress! Here’s an article that will allow you to impress your colleagues and analyze files in no time. NB: This article is based on the excellent Twitter account of Blake Burge.
Excel Tip #1: Sparkline Charts
Excel Sparkline Charts are small charts inserted into a spreadsheet. They are very practical for having a visual representation of your data and its evolution.
How to do it:
- Select a horizontal or vertical range with your data
- Click on insert then on “ sparkline graphics“
- Then select the box in which you want to see your graph appear
And there you have it, that’s it!
Excel Tip #2: People Graph
Do you want to impress your office colleagues with innovative graphs made in Excel that are much more visual and quick to create? This is how it works!
- Go to the insert tab
- Click on complement, then on “ people graph“
- Then click on the “data” part of the graph
- Choose your title then select your data in the table
Excel Tip #3: Tables
If you don’t use a table in Excel, you should. This is what it would bring you:
– Clean formatting
– Automatic enlargement as new data is added
– Quick and easy data summaries for each row
– Formulas that apply to entire columns
– Create dynamic charts that update automatically, and much more
- Click on the “Table” icon
- Select your data
- Then configure your board as you wish
Excel Tip #4: Integrate a Segment
Knowing how to integrate segments into your Excel document will make your life easier when analyzing tables. Here’s how to do it!
- Click on the “ Painting“
- Then go to “ Insert a segment“
- Finally, select the segments you want to appear
That’s it!
Excel Tip #5: Data Validation
The drop-down list allows you to ensure the consistency of your data. This will help you take a little “outside” look to avoid typos or inconsistencies that you might not have noticed in your Excel file.
- Click on the “ Data “
- Then click on the “ Data Validation“
Excel Tip #6: Instant Fill
This is one of our favorite Excel tips! What’s more time-consuming than writing data repeatedly? With this shortcut, you will be able to fill your table in no time with all the data you want to include.
- Click on “ Data » in the top panes of your Excel window
- Then click on “ Instant filling » this directly copies what you want!
Excel Tip #7: Consolidate
To summarize and report results from separate spreadsheets, it is possible to “ consolidate » data from each Excel sheet, into a master spreadsheet.
- Click on “ Data“
- Select the entire table you want to consolidate
- Click on “ Consolidate » and press the little plus “+” to the right of the window
- Repeat the operation with the other tables
- Tick ” Link to source data » and if you wish “ top line ” And ” left column“
- Then click on “ok” and your new table is displayed
Excel Tip #8: Automatic abbreviations
This technique can save you precious time on Excel! To do this, simply create a personalized list of shortcuts. Here’s how to do it:
- Click on the Excel tab at the top left of your screen
- Then click on “ Preferences“
- And, finally, click on the icon “ Automatic correction » and fill in your words and the abbreviations you want
Easy you see?
Excel Tip #9: Conditional Formatting
Conditional formatting in Excel is a useful tool for highlighting tables, reports or cells. It is also possible to target an area or several columns to analyze certain very specific data. Proof in pictures!
- Select the data part of your data table
- Go to the part “ welcome » from your Excel window
- Click on “ conditional formatting » then on the element you want.
This action will make your sheets much more visual.
Excel Tip #10: Format Paint
Are your paintings dull? If you want to bring a little visual and standardize everything at the same time, the format paint on Excel is what you need!
- Select the data whose formatting you want to copy
- Click on the paintbrush icon at the top left of your screen
- Select the data you want to modify
- Hop, magic! They have the same properties as the table next to it!
Bonus: Camera Snapshot
This tip allows you to transfer your tables to another Excel window, while keeping the formulas. Practical !
