Home Excel


Find the best tips and shortcuts for Excel, from basic to advanced, and discover the wonders that this tool can do for your life and career!

Category of our blog with Excel tips and shortcuts. Made for you who already use the tool on a daily basis or are flirting with it and need to learn. We already dealt with Excel in LIGHT there are over 5 years creating spreadsheet. We hope you enjoy it and feel at home here!

If you would like to suggest new posts, just leave a comment on any of our articles. Your suggestions will be greatly appreciated!

Do not forget to also meet our Excel courses online. At LUZ, the largest ecommerce spreadsheet in the world, you can also make money selling excel spreadsheets that you have already done. Or by making new spreadsheets and making them available for sale on our ready spreadsheet marketplace.

Create a histogram in Excel

Create a histogram in Excel

Through a histogram it is possible to graph a frequency distribution of a given measurement. So, you are able to understand determining process as well ...
How to use the Transpose function in Excel

How to use the Transpose function in Excel

It is known that Excel has numerous features ready to make life easier for users on many occasions. But without the knowledge of some options ...
How to create automatic calculations in Excel

How to create automatic calculations in Excel

If you are introducing Excel in your company, or use it frequently, but you usually fill it out manually, we have two magic words that help a lot: ...
How to calculate percentage in Excel

How to calculate percentage in Excel

While some are able to do simple mathematical calculations in their heads, many face difficulties when working with percentages. For both cases, Excel can be a ...
Subtraction Formula in Excel

Learn how to apply subtraction formulas in Excel

Excel has several tools that can and should be used to facilitate the day-to-day of your users, with it's activities ...
Indirect function in excel 2

Know 9 Excel formulas and what to do with them

Excel makes many professionals' daily lives easier because of their ability to analyze data and expose results. However, whoever thinks that ...
How to do rounding in excel

How to do rounding in Excel

Excel is an excellent tool for performing calculations of all types. If you are a financial manager, for example, you can use it to calculate ...
financial mathematics in excel

Financial Mathematics in Excel

Financial mathematics aims to analyze financial data in relation to the value of money over time and how it is applied to loans, investments and ...
How to open XML file

How to open XML file in Excel

A file in XML format is a document with hierarchically organized data. As you can see in the image above, it already comes ...