'Excel tips and how-to' category archive

Quick tip for beginners: Hide and show formulas in Excel

Excel formulas are really helpful. There can be times when you don’t want formulas to be displayed when the cell is selected. For example, when sending your table to other people. Well, there is an option to hide formulas on your worksheet... Continue reading

 

Office charts for Friday fun

Today you are welcome to learn why people hate projects, what sites your internet browser remembers, what is the chance of doing amazing things this summer and plunge into the world of Outernet... Continue reading

 

Tutorial with Excel examples about Macros

Many people think that it is extremely hard to learn Excel Macros, but it is not. This article contains some nice and simple Examples to automate your daily tasks in Excel... Continue reading

 

Quick tip for beginners: Excel Relative and Absolute References

Today we are going to talk about cell references in Excel formulas. Once you understand how they work your spreadsheet experience will improve really much... Continue reading

 

Friday thoughts in Excel charts and graphs

Chart posts are the most informative I think. Seriously. Where else you can learn about the best things to eat Nutella with, or how to always know if it will rain... Continue reading

 

How to perform VLOOKUP: tips and tricks

Excel’s VLOOKUP function has been always seen as bringing Excel beginners into panic. At the same time power users can’t live without it. In this digest we offer you the best web articles about this feature... Continue reading

 

How to rotate Excel charts or worksheets: quick tip

Certain worksheets or charts may look much better if you change their orientation. So in today’s how-to article we’ll have a look at how to rotate Excel table or chart. Continue reading

 

Excel tip for beginners: Enter multiple lines in one cell

When you have a lot of text in your Excel cells it can be a good idea to show it on more than one line. But how? Every time you enter text into a cell it longs to be on one line however long it is. Here is how you can insert more than one line into one cell on your worksheet... Continue reading

 

Convert rows to columns and back in Microsoft Excel

Sometimes you notice that there are tables that look better if arranged in a row or a column style. In this article you can read how to rotate your data easily and quickly... Continue reading

 

Excel charts for fun and pleasure

Have you ever thought how many emails the sender labels "High importance" are really important? And how soon is "too soon" Continue reading

 


What's new



Join us on Facebook

Click Like and get 15% discount on all our products right now!




Categories



List of authors



Sign in







Plug-ins for Microsoft Excel and Outlook

Copyright © 2003 - 2012 Add-in Express Ltd. All rights reserved.

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.