Friday, November 3, 2023

Top 10 Excel Tips

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.


Tip #46.    Excel – AutoFit Column Width and Height
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.

Tip #26.    Indenting Text in Excel
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.

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.

Tip #33.    Creating Charts in Excel
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.

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.

Tip #93.    Excel Scenario Manager
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 


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 . 

6 comments:

  1. 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.

    ReplyDelete
    Replies
    1. Wait until you see the upcoming Excel tips. I think you might find them useful too. Hope you have bookmarked my blog.

      Delete
  2. Now I'm in a course on Excel, and I think that your post will help me a lot.
    http://tipsworldbd.blogspot.com

    ReplyDelete
    Replies
    1. 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.

      Delete
  3. Really, You have a great collection of tricks and tips which can help to explore the excel functions.

    ReplyDelete
    Replies
    1. Thank you. Look for more in the coming weeks, accompanied by videos to help explain the techniques. Diane

      Delete

Named Cells and Ranger in Excel

Great Computer Tips Named Cells and Ranges in Excel Naming cells Cells already have names such as A1, B27, etc. but you can also give them n...