How to create a automatic presentation (SOP) in windows 10
STEPS TO USE STEPS RECORDER Step 01: This is one of the way to create a automatic presentation (Default Application) Step 02: Open step...Read More
How to Record screen using VLC media player
STEPS TO RECORD SCREEN USING VLC Step 01: Open the VLC media player Step 02: Click with the media Step 03: Go with open capture dev...Read More
How to Copy Folder Names
STEPS TO COPY FOLDER NAMES Step 01: Review the folders that need to copy as text Step 02: Select the Location path in Address bar ...Read More
How to Recover Unsaved Microsoft Excel , Word, PowerPoint
STEPS TO RECOVER WORD Here are the steps to take to recover your unsaved new document in Microsoft Office Excel, Word, or PowerPoint if you ...Read More
How to Recover Deleted Excel File
How to Recover Deleted Excel File Go to the file tab and click on 'Open' Now click on the Recent Workbooks option on the to...Read More
How to reduce Excel File Size
How to reduce Excel File Size i) Sometimes we can see that Excel workbook may contain more size ii) Now will see how to reduce the Siz...Read More
How to see numbers in percentage
How to see numbers in percentage Choose the cells which need to show as percentage Divide by 100(USE THE FORMULA SEEN IN IMAGE...Read More
How to Create a Data entry form in Excel
How to Create a Data entry form in Excel i) To create a data entry form in Excel ii) Write a format for data entry that ...Read More
How to Trim In Excel
How to Trim In Excel Trim option is helpful to remove the spaces in cell Select the range Use this formula(=trim...Read More
How to Merge cells in Excel
How to Merge cells in Excel Merge cells will help to Create a workspace for multipurpose Click with home tab- we can see ...Read More
How to add a New Tab in Excel
How to add a New Tab in Excel New tab will be helpful to use some options Click on file tab Click customize ribbon Click through new group/n...Read More
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
Subscribe to:
Posts
(
Atom
)