'

Category: Excel Tutorials

Top 10 excel shortcut
Excel Tutorials

Top 10 Excel Shortcut for formatting

Top 10 Excel Shortcut for formatting: In this article we will see the top 10 excel shortcut that is used in formatting, with the help of shortcut you can speed up the excel tasks… so let’s start.. ALT H O I It will feel frustrating when you open the excel workbook but you can not […]

author
SUMIF
Excel Tutorials

SUMIF Function: Sum only cell based on criteria

Suppose you are working in the excel and you came to the situation that you want to sum cell based on certain specific criteria. So to solve this, you can use SUMIF function of excel so let’s explore that…….. What is Excel SUMIF Function SUMIF function to sum the values in a range that meet […]

author
copy folder names in excel
Excel Tutorials

How to Copy Folder Names in Excel – Excel Tips

Copy Folder Names in Excel In excel you can learn every day something new. Today I’m sharing that I learned from the problem that I faced in excel. I got data from my team on OneDrive that contains folder names with clients bank account number, so I want that number in excel as shown below: […]

author
1
Excel sum only numbers ignore #N/A
Excel Tutorials

Excel Sum Only Numbers ignore #N/A – Excel Tips

Excel Sum Only Numbers ignore #N/A While working in excel you may have faced this issue that you want to do sum of column or row that contain “#N/A” due to this you can’t apply sum formula because it will throw error. Here we will understand this and solve this issue with example. Let’s Understand […]

author
Excel Tutorials

How to Copy Excel Table to MS Word

When you are working on some documents in MS Word and you need to do some calculations then you need Excel help to do calculations. In MS Word there is no option to do calculations nor in excel there is an option to convert excel files into word. So, In this Excel tutorial, you will […]

author