How to create a Drop-down list in Excel (with in 30 Seconds-With Example)

drop-down-list-in-excel

Give 5 minutes to read this article and you will learn, How to make Dropdown list in excel. this is a very important command in excel to minimize your time work. So first of all I want to tell why the dropdown list is important for us- For example:- There are a lot of people … Read more

How to Protect & How to Unprotect an Excel Sheet with a Password

Sometimes we work on a very important sheet and suddenly somebody comes and delete our data from our excel sheet and we have to prepaid that data again, so friends don’t worry here is a solution, do you know that we can protect our excel sheet with a password, if not, then you can learn … Read more

How to Lock an Excel file with a Password (very easy)

protect excel bypassword

Most of the people didn’t know that how to protect excel file with a password. So in this tutorial I am going to tell you that how can be an excel file protect by a password, that will make your excel data secure. Follow these steps to protect your excel file with a password. Protecting … Read more

How to Create a Form in Excel (containing submit button-with example)

Friends do you know that we can make small software in Microsoft excel using by the formulas and menu buttons. So in this article I am going to tell you that how to create form in MS Excel. How to Create Menu in MS Excel:- First of All Click on Menu Icon and click on “Excel … Read more

How to Learn Pivot Table Quickly in MS Excel (With Example)

pv table, create a pivot table, pivot table tutorial, how to create a pivot table, how to make a pivot table, how to create pivot table, create pivot table, what is a pivot table, pivot tables for dummies, how to use pivot tables, what are pivot tables, refresh pivot table, pivot table,

Pivot Table is a very important command in MS Excel. It reduces our working time and reduces the chances of error in calculation. So, first of all I want to tell you what we can do with the help of pivot table- We will take an example to understand the pivot table in MS Excel. … Read more

Using of Vlookup Command in Excel (With Example)

Hay Viewers, Do You know how to use vlookup command in excel. if no, then this is a very important article for you to learn about use of vlookup command in ms excel. So first of all let me tell you, what is vlookup in micro soft  excel. vlookup stands for Vertical lookup. Vertical Lookup … Read more

Mac Shortcuts Keys (155 Mac Keyboard Shortcuts) Download in Excel (.xls file)

Since January 1984, Apple Inc. has created, manufactured, and sold the Macintosh computer line. 1 What is the difference between a Mac and Apple computer? Apple is the business. A machine that runs any Mac OS is referred to as a “Mac” (Macintosh System 7, Mac OS 8, Mac OS 9, Mac OS X, etc.). … Read more

All Shortcuts of Microsoft Word (191 Shortcut Keys) Download in Excel (.xls file)

1 What is Microsoft Word?  What Is the Purpose of MS Word? MS Word is a word processing software from Microsoft that may be used to generate professional-looking documents, letters, reports, and other documents. It offers powerful capabilities that let you prepare and modify your files and documents in the most efficient way possible.  2 … Read more

All Shortcuts of Microsoft Excel (256 Shortcut Keys) Download in Excel (.xls file)

Here Are Very Useful Shortcut Keys Of Microsoft Excel, That Will Help You To Speed Up Your Work And Short The Time Consumption Of Work, So Check Out Below:- Select cells, columns, rows, or objects in worksheets and workbooks by using shortcut keys :- CTRL+SHIFT+* (ASTERISK) Select the current region around the active cell (the current region … Read more

Tally ERP 9 All Shortcut Keys (60 Shortcut Keys) Download in PDF & Excel .xls

Tally ERP 9 is the most powerful accounting software. Almost every company loves to use this software. so if you want to work faster in Tally you should use shortcut keys and there are many types of shortcuts in Tally, below given all shortcuts are very useful to minimize your time to work, using shortcuts … Read more