Home Excel

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

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 usually fill it manually, we have two magic words that help a lot: ...
How to calculate percentage in Excel

How to calculate percentage in Excel

While some can do simple mathematical calculations of the head, many face difficulties when working with percentage. 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 facilitates the day-to-day lives of many professionals by virtue of their ability to analyze data and expose results. However, who thinks that ...
How to do rounding in excel

How to do rounding in Excel

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

Financial Mathematics in Excel

Financial mathematics has as purpose the analysis of financial data regarding 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 ...

Advanced Excel Tips for the Job Market

In this article we will talk about: Deadline for date control Other advanced functions Conditional Formatting Pivot Tables and Macros Charts How to be a master of ...