50 Excel important skills for business

Microsoft Excel has grown to become one of the essential computer programs around the globe since it was released in 1985. Any field can benefit from Excel skills, including business.…

Comments Off on 50 Excel important skills for business

50 Excel tips and tricks for beginners

As a beginner, the process of creating excel spreadsheets, completing formulas and functions can be devastating. If you ever find yourself in a situation where you put data manually, you…

Comments Off on 50 Excel tips and tricks for beginners

How to recover and repair corrupt excel files

Any computer user knows that there is no guarantee that their data is hundred percent safe. Data insecurity implies hacking and viruses, and other reasons that may lead to corrupt…

Comments Off on How to recover and repair corrupt excel files

How to send excel report to outside clients

Microsoft Excel is a program used every day in companies and businesses. Many analysts, agencies, and consulting firms use Excel to create reports for internal and external clients. They do…

Comments Off on How to send excel report to outside clients

How to add odd numbers only in range

If you have a worksheet full of odd numbers and you want to add them, you can use this formula to get their sum. The formula {=SUM(Range*(MOD(Range,2)=1))} Do not type…

Comments Off on How to add odd numbers only in range

How to fix Excel keeps shutting down problem

Excel is undoubtedly a very useful and good application when it comes to editing and scripting documents. However, they say anything with advantages has corresponding disadvantages; the same applies when…

Comments Off on How to fix Excel keeps shutting down problem

How to do a case sensitive lookup in Excel

Most users know the VLOOKUP function is not that case-sensitive. For example, when you look up for DAN, dan, Dan to VLOOKUP, all this is the same. The function will…

Comments Off on How to do a case sensitive lookup in Excel

How to create and edit a drop-down in Excel

Working with Excel worksheets can be more efficient and straightforward by using drop-down lists. These lists allow you to create a list of choices that you can select from a…

Comments Off on How to create and edit a drop-down in Excel

How to reduce Excel file size

Excel worksheet files can be too large sometimes. Such files need a lot of patience when dealing with them as they take a lot of time to update when you…

Comments Off on How to reduce Excel file size

How to calculate YTM in Excel

YTM means yield to maturity. It is also known as the internal rate of return. If you are dealing with finances, this is one of the values you have to…

Comments Off on How to calculate YTM in Excel