LATEST >>

Welcome Here And Thanks For Visiting. Like Us On Facebook...

EXEIdeas – Let's Your Mind Rock » PC / PC Tips » Top Excel Tips From The Experts For Your Daily Use

Top Excel Tips From The Experts For Your Daily Use

Top-Excel-Tips-From-The-Experts-For-Your-Daily-Use
Microsoft Excel is the premier spreadsheet application. Powerful and diverse, there are few actions it can’t do. Yet it’s one of the most complex, and there are few experts who’ve mastered all its’ intricate operations. These tips gathered from The Excel Experts will save you time and effort on Excel.

Autofill:

This is the most basic, but most overlooked of operations. Typing a repetitive sequence, like a series of dates (1/1, 1/2) into each cell can take up hours of your valuable time.

Instead, fill the first few cells in the sequence, then move the cursor to the bottom right corner of the last cell. Hold the cursor over it until it becomes a plus (+) sign. Then click, and drag that to fill as many cells as you need. The sequence will be completed in seconds.

Save Custom Carts:

Using Excel, you can customize charts to suite your needs. But what if you need to re-create that graph in the future? Say, if you’ve got to file the same report every month. You can save your custom charts as templates.

Once your custom chart is perfect, right click it. Select ‘save as template’. You’ll save a new file in the templates folder, with a .CRTX extension. When you need to file next month’s evaluation, select the data you want, go to the insert tab, then go to all charts and find your custom chart type.

Excel-Tips

Conceal Your Data:

Say you’re making a lengthy spreadsheet for a lab report and you need a piece of data, but it’s inconveniently placed? Excel lets you hide it!

Highlight the cells, then right click and choose Format Cells. In the numbers tab, go to category and choose ‘custom’. Type three semicolons (;;;) into the field, then press Okay. Now the data is hidden, but can still be used in formulas.

Whilst this simple tip will help you, there’s a lot more you can do with your data, consider Excel data services from the experts to make Excel work for you.

Organize With Pivot Tables:

Pivot tables are a quality of life function that’s unfortunately overlooked. They summarize your entire collection of data based on your reference points. Say you’ve charted the sales of every employee by week, and want to only see one employee’s sales on a specific week.

To make a pivot table, first, make sure all columns are named correctly. Then go to the insert tab in the toolbar and select ‘pivot table’. Even better, go to ‘recommended pivot tables’ and see if excel can find the right one for you.

Kumarpal ShahAbout the Author:

This is a guest post by Kumarpal Shah, an entrepreneur and blogger at InsideTechno.

Find Me On Facebook | Twitter

You Like It, Please Share This Recipe With Your Friends Using...

4 Responses to “Top Excel Tips From The Experts For Your Daily Use”

  1. Krook says:

    hello,

    thanks for sharing it, if you have stuff like that. please keep update so that i can read know things

  2. daniel says:

    A user (reader) of a text knows that one starts at the beginning and keeps reading sequentially until the end (perhaps skipping or skimming parts). But a user of a spreadsheet has no such implicit path. There is no “narrative”. Have you considered how a spreadsheet could be constructed so that a user could be guided through a spreadsheet, including its multiple tabs, without using VBA?
    “Save Custom Carts” ??

Leave a Reply

Your email address will not be published. Required fields are marked *