How to add pivot Table in Excel
How to add pivot Table in Excel Pivot table give some clear view for the data structure Select the range Go to inse...Read More
How to merge values in Excel
MERGE VALUES Step 01: We can merge the values which in other cells Step 02: (=concatenate) Step 03: Select the r...Read More
How to convert Lowercase in Excel
LOWERCASE IN EXCEL Step 01: We may covert Uppercase words to Lowercase using formula Step 02: (=lower) Step 03: Select t...Read More
How to change themes in Excel
THEMES IN EXCEL Step 01: Theme may give more attractive to Workbook Step 02: Go to page ...Read More
How to convert Uppercase in Excel
UPPERCASE IN EXCEL Step 01: We may covert lowercase words to uppercase using formula Step 02: (=upper) Step 03: Select the r...Read More
How to Copy Multiple sheets in Excel
COPY FROM ANOTHER EXCEL SHEETS Step 01: Sometimes the we may face trouble to copy and paste a workbook data to another workbook Step 02...Read More
How to Use Text to columns in Excel
TEXT TO COLUMNS IN EXCEL Step 01: We can find text to columns in data tab(data tools) Step 02: Click through the text to c...Read More
How to Use Find & replace in Excel
FIND & REPLACE IN EXCEL Step 01: Find & replace is one of the option which will be used to rewrite the things S...Read More
How to Use Clear formats/Format painter
CLEAR FORMATS/FORMAT PAINTER Step 01: Clear formats, is one of the highly usable option in Excel Step 02: It makes all cell va...Read More
How to auto sum digits without errors
AUTO SUM IN EXCEL Step 01: Sometimes while adding, values in digits we may get some confusion Step 02: ...Read More
How to add or remove background in Excel
ADD REMOVE/BACKGROUND IN EXCEL Step 01: Go with Page layout tab Step 02: We have a option as BACKGROUND Step 03: You can import ...Read More
How to Highlight & Remove duplicates
Highlight & Remove duplicates: Step 01: Select the Column which requires to remove & highlight duplicates Step 02: Go with-...Read More
How to copy and paste in vertical excel
COPY AND PASTE IN VERTICAL EXCEL Step 01: Copy the things which needs to paste in vertical/Horizontal Step 02: Go with Paste special T...Read More
How to Find invisible Sheets in Excel
HOW TO FIND INVISIBLE SHEETS Step 01: Go with F ile tab & click with options Step 02: Click with A dvanced step 03:...Read More
How to fill huge series number in excel
EASY WAY TO FILL SERIES NUMBER Step 01: Open Microsoft Excel Step 02: Enter number as 1 in series number column Step 03: ...Read More
How to check windows property
STEPS TO CHECK WINDOWS PROPERTY Step 01: This is the basic thing that's may irritate to search sometimes Step 02: ...Read More
Is Delete icon is not showing?
STEPS TO ENABLE DELETE NOTIFICATION Step 01: Click the right click button in recycle bin Step 02: Click with the properties Step 03: ...Read More
How to Create multiple folders using Batch files
STEPS TO CREATE MULTIPLE FOLDERS Step 01: Open notepad application Step 02: Type md in excel cell( give a space after md ), and past...Read More
How to open Multiple links in separate browsers using Batch files
STEPS TO OPEN LINKS IN SEPARATE BROWSERS Step 01 : Open notepad application Step 02: P aste the below given Command to open...Read More
How to close an application using Batch Files
STEPS TO CLOSE APP IN SINGLE CLICK Step 01: Open notepad application Step 02: Paste the below given Command to close the application...Read More
How to open share path link using Batch files
STEPS TO OPEN SHAREPATH LINK Step 01: Open notepad application Step 02: Paste the below given Command to open the sharepath/local d...Read More
Subscribe to:
Posts
(
Atom
)