Based on the number of views, below is a list of the top ten Excel tips from my blog, 100 Computer Tips In 100 Days.
Don't drag to make columns wider, let Excel determine the best fit. Best fit is a double click away.
Tip #53. Excel Lists
Use the recently included feature of Excel to manage data lists. It will help you sort and filter the data.
Use the recently included feature of Excel to manage data lists. It will help you sort and filter the data.
Tip #26. Indenting Text in
Excel
No more using the spacebar to indent text. This is one tip that will really save you time
No more using the spacebar to indent text. This is one tip that will really save you time
Tip #5. Drag and Drop in
Word and Excel
Information needs to be moved to a different cell, select it, drag it and drop it. Move on to your next task.
Information needs to be moved to a different cell, select it, drag it and drop it. Move on to your next task.
Tip #65. Excel Formula
Auditing – Tracing Dependents and Precedents
Have you ever wanted to see a diagram of what cells change when you adjust an entry? Formula Auditing will draw arrows showing you where the affected cells are. This is a brilliant tool for demonstrating cell relationships.
Have you ever wanted to see a diagram of what cells change when you adjust an entry? Formula Auditing will draw arrows showing you where the affected cells are. This is a brilliant tool for demonstrating cell relationships.
Tip #33. Creating Charts
in Excel
Create a chart with one key on your keyboard...honest! Check it out
Create a chart with one key on your keyboard...honest! Check it out
Tip #56. Excel Conditional
Formatting
Want all of the accounts that are more than 90 days due to become red, Conditional Formatting is for you. This colorful tool can also be used to easy filter data. Want to have an entry turn yellow when a "yes" is inserted in a cell? Use Conditional Formatting to turn these manual tasks into an automatic event.
Want all of the accounts that are more than 90 days due to become red, Conditional Formatting is for you. This colorful tool can also be used to easy filter data. Want to have an entry turn yellow when a "yes" is inserted in a cell? Use Conditional Formatting to turn these manual tasks into an automatic event.
Tip #13. Freezing Panes in
Excel
When panes are frozen in place they allow you to scroll down and across your data while still being able to view the column/row headings. A must know skill when working with data.
When panes are frozen in place they allow you to scroll down and across your data while still being able to view the column/row headings. A must know skill when working with data.
Tip #93. Excel Scenario
Manager
Want to know the impact of "what if" analysis? The Scenario Manager is the tool to do this.
Want to know the impact of "what if" analysis? The Scenario Manager is the tool to do this.
Tip #63. Excel –
Showing/Hiding Formulas
You know those formulas are in some of the cells but can't find them? Use the show/hide formula keyboard shortcut to reveal all of the formulas in your worksheet. This reveal can save you a lot of time. Use it with Formula Auditing to trace the impact of your formulas.
To see a complete list of my Excel tips go to the Index by Category page. Leave a comment and let me know which Excel tip is your favorite. Which tip has saved you the most time?
Happy Computing!
Diane
Want more tech news or interesting links? You'll get plenty of both if you keep up with Diane McKeever, the writer of 100 Computer Tips in 100 Days, by subscribing to her Facebook posts or visiting her web page, www.dianemckeever.com .
You know those formulas are in some of the cells but can't find them? Use the show/hide formula keyboard shortcut to reveal all of the formulas in your worksheet. This reveal can save you a lot of time. Use it with Formula Auditing to trace the impact of your formulas.
To see a complete list of my Excel tips go to the Index by Category page. Leave a comment and let me know which Excel tip is your favorite. Which tip has saved you the most time?
Happy Computing!
Diane
Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via email link on the right side of the screen so you get email alerts when Diane adds a new post.
Want more tech news or interesting links? You'll get plenty of both if you keep up with Diane McKeever, the writer of 100 Computer Tips in 100 Days, by subscribing to her Facebook posts or visiting her web page, www.dianemckeever.com .
MS Excel has so many features and it can perform so many tasks. The tips you have shared above are very useful for the person work in excel, prepares excel sheet regularly.
ReplyDeleteWait until you see the upcoming Excel tips. I think you might find them useful too. Hope you have bookmarked my blog.
DeleteNow I'm in a course on Excel, and I think that your post will help me a lot.
ReplyDeletehttp://tipsworldbd.blogspot.com
I hope you have bookmarked this blog. I will be adding more Excel tips shortly. I'm recording the videos to go with them now.
DeleteReally, You have a great collection of tricks and tips which can help to explore the excel functions.
ReplyDeleteThank you. Look for more in the coming weeks, accompanied by videos to help explain the techniques. Diane
Delete