Uses of SMALL function in MS Excel

In this tutorial we are going to discuss about SMALL Function.

This article will help you to 

• Understand the Small function.
• Uses and requirements of Small function.
• Syntax of SMALL function.
• Description of small function.

Small Function:-

Formula name  :-    Small
Formula Syntax:-    =SMALL(array, k)

                         Array (Required) An array is a range of numerical data for which you want to                         determine the k-th smallest value. 

                         K (Required)  numerical value position (from the smallest) in the range of data                       to return.

Uses of SMALL Function:- this formula is basically uses to determine the #number of smallest number from a data set. 

see the video example below:

Please right your questions in to comment box.


Happy learning
Vikash kumar

Read More

Uses of Left and Right Formula

In this tutorial we are going to discuss about Left And Right formula.

This tutorial will help you to

• Understand the meaning Left and Right formula.
• Uses Of Left and Right Function.
• Syntax and requirements of Left and Right formula.

Watch the full practice video for better understanding:

Left Function:-

Formula name  :-    Left
Category          :-    Text Formula
Formula Syntax:-    =LEFT(text, num_chars)

     In this formula Text can be a word or group of numbers and it is mandatory factor of the formula and num_chars must be a numeric value and it is optional factor of formula also.

Uses of Left Formula:- This formula is basically uses for to copy characters from left from a cell. Like we have a data like below and we want their initials or first character so either we copy each row manually or by use the Left formula.

Example :-

Right Function:-

Formula name  :-    Right
Category          :-    Text Formula
Formula Syntax:-    =RIGHT(text, num_chars)

Requirements and Limitations of Right formula:-
     In this formula Text can be a word or group of numbers and it is mandatory factor of the formula and num_chars must be a numeric value and it is optional factor of formula also.

Uses of Right Formula:- This formula is basically uses for to copy characters from Right from a cell. Like we have a data like below and we want their few last of characters or only last character. So either we copy each row manually or by use the Right formula.


Example :-

Thanks and happy learning
Neeraj kumar

Read More

Free Advance MS Excel Course online

Hi friends hope you are doing well !

Thanks for your Suggestions and enquiries, It is nice to answering you.

As I have so many questions, so I am thinking to start some free MS Excel training courses. Course will start from 5 July 2016.

These training courses are free of cost and i will also provide a document of completion the course. Any one can register and take course for free. Course will be online. I will Publish chapters on the web, videos on youtube and also share links with you on your emails. I will also available Live on web on Saturdays And Sundays via Go To Meeting for answer your questions practically, and i will share meeting codes on your email ids. So please register if you wish to get course materials on your emails and take this course.

Click here to Register for Free

Courses descriptions are mentioned below :-

1. MS Excel basics 

       This course is for excel beginners. For whom they are not familiar with excel, And don’t know more about the MS Excel, its uses and benefits. We will discuss about Customising the Excel as per our need and requirements.

2. MS Excel level 2        

         In this course I am planning to put all type of basic formula like (text, date and time, lookup and references and mathematical). General Usage of all Menu Tabs. 

3. MS Excel level 3

         In this module we will discuss about formatting, number, text, cell and conditional formatting. We also discuss about the Charts, Graphs and Dashboards.

4. Advanced MS Excel

          Nested if formula, functions, formula merging and other advanced tricks. All formula in details. All Menu tabs In details. Advanced protection methods. Sheet sharing methods.

5. Basics of Excel Macros

         In this Module we will cover basics of MS Excel Macros, VBA coding, and all macro creation methods.

                                   Click here to Register for Free

After taking these courses you will able to manage MS Excel Easily. You can create your own functions formula. I am providing this for free because i also need improvement as a trainer

If you think it will be helpful for you, you can register for free by clicking here. Course will start from 5 July 2016.

Thanks for reading.

Read More

How to create an Automatic Invoice or Bill Generator in Excel

After reading this post you are able to create automated Bill Generator in Excel.

Key features Of the Bill Generator

• Creates bill from previous saved databases.
• Fully automated.
• Creates a summary of each bill.
• Automatic generates a unique Invoice number for each bill.
• After submitting a invoice automatically clears the fields.
• Easy to use, user friendly.
• Easy maintenance.
• And many more as you use , you will get.

You can download the file from Here.

Instruction for using

• Download file and save as Billgenarator.xlsm, any where on your computer.
• Enter your latest Invoice number in cell A2 in sheet "Output database table".
• Your invoice number must be a number.
• Paste you data on sheet "Master Databases".
• Please do not Cut or Delete any cell.
• please do not Rename any Sheet of the workbook.
• Please Do not change code, ask any VBA expert to do the same. however i am here to help you.

     One of my social networking friend ask me to crate a automated bill generator file and he shared his requirements. He also shared a sample sheet for the same. So i made this and hoping i have fulfilled his requirements.

I love to share with you all if you need please feel free to use. There is no fee and this is for education purpose only.

Thanks In advance.

Read More

Hack your Excel: Unprotect Excel sheet without Password (No VBA, No Software)

Hack your Excel: Unprotect Excel sheet without Password 

      Have you forgotten MS Excel sheet’s password and you are trying to get it done from google, trust me you will redirect to various websites? They suggest you download their software, add-ins applications. But will not solve your purpose. Read this full article and follow the steps. You will be able to make an Excel password remover. And You will be able to unprotect excel sheet online.

Try this trick

          Here is the way you which can help you to crack your excel sheet password and unlock excel file. This article will help you to "Unprotect you protected sheet without a password".

Please mind this with this trick you can only unprotect SHEETS, not the WORKBOOKs.

We have two well known methods here which you can use for this purpose. See below:

Method 1. Using PassCue for Excel

Instantly Remove Worksheet Password with PassCue for Excel

Using a tool to recover lost Excel password is quite a professional approach taken by most of the computer experts since it reduces effort and time. Thus we have chose a best Excel Password Recovery tools of all time.

One that we are going to take up for discussion is PassCue Excel Password Recovery, which can quickly recover your lost Excel open password with three attack types (Dictionary attack, Brute-force attack and mask attack), one of  the most effective attack is mask attack, which can ensure 98% success rate of password recovery. Besides, PassCue for Excel can be able to instantly remove worksheet/workbook protection without damaging internal data. It supports recovering open password from all Excel version like Excel 2007/2010/2013/2016.

Step 1. Download the PassCue for Excel to your operational computer. Install and run it as an admin. Then select the second options “Remove Excle worksheet/workbook password” 

Step 2. Click the Add Files button to batch import your locked Excel files to program, and click Start button, it will remove protection at a time.

If you forgot your Excel password, just free download Passcue for Excel to recover your Excel password now!

Method 2. Unlock excel file without any software.

Please do following necessary changes in your system as shown below:-

Disclaimer: This tutorial is for educational purposes only and is not intended to be put into practice unless you have authorized access to the files you are trying to break into.

1. Open Control Panel and Select Folder Option

2. Menu bar click View and Do uncheck the “Hide Extensions from known files types”. Click Apply and OK.

Now your system is ready for unprotect sheets without the password.

Follow the steps shown below:

1. Select the Desired Excel File, change extension (Press F2) .zip.

2. Open zipped Folder

3. Open xl folder and forget about others.

4. In the xl folder, you will get few more folders, open worksheets folder and forget about others.

5. In the worksheets folder, you will able to see all your sheets with are already in your protected sheet.

6. Extract you protected sheet in a new folder(outside the current zipped folder).

7. Open the file with Notepad or Right Click on the file and select Edit option.

8. If you are using MS office version 2007/2010 then search  <sheetProtection password=****/> tag  and delete it.

9. If you are using MS office version 2013 then search  < sheetProtection algorithmName=****/> tag  and delete it.

10. Save the file and Close. Replace new XML file with the original XML files which are in the Zipped folder.

11. Close the zipped file.

12. Change the extension from .zip to .xlsx.

Enjoy you have unprotected the sheets successfully.

Most commonly used Excel formulas.

How to use Vlookup in Excel.

How to import data from the web into Excel.

How To Make Shared Excel File And Allow To Edit By Multiple Users at one time.

Thanks For reading, I hope you got your problem. Please like and share this article on facebook if you found this useful. You can also comment your queries for fast response.

Click Here To contact us

Tags: how to unprotect excel, how to unprotect excel sheet without password, how to protect excel sheet with a password, remove password from excel 2013,

unprotect workbook, how to unprotect excel workbook, how to unprotect excel file, how to protect excel workbook, 

unprotected, how to unprotect excel 2016 without password

.

Read More