Uses of microsoft excel in our daily life

#Uses of microsoft excel in our daily life how to
#Uses of microsoft excel in our daily life pdf
#Uses of microsoft excel in our daily life code

In = InputBox(вЂњEnter the desired number of sheets that you want to insertвЂќ, вЂњEnter Many SheetsвЂќ)Д®nd Sub Example 5: How to Delete All Blank Worksheets?ДЄ workbook might have sheets which have been left blank and are of no use to us.

#Uses of microsoft excel in our daily life code

вЂThis code will help in inserting a desired number of sheets in a workbook Doing it with a code is much easier, and it allows us to insert any number of worksheets in a particular workbook all at once. If WorksheetFunction.CountIf(MyR, Mењњ.Value) > 1 ThenД®nd Sub Example 4: How to Insert Multiple Worksheets in a Workbook in One StepДЄdding worksheets manually to a workbook is tedious. вЂThis code will highlight the duplicate portions of a selection Note that we can even change the color of the duplicated portions along with finding them: Finding duplicate values manually is time consuming and using a macro will speed up the process. In a selection of cells, we might want to match and check for duplicate values.

Example 3: How to Highlight the Duplicate Values from a Particular Selection

#Uses of microsoft excel in our daily life pdf

In the above code, the worksheet will be saved as a PDF in the folder called вЂMyfileвЂ™ on the desktop. Ws.ExportAsFixedFormat xlTypePDF, вЂњC:UsersRishiDesktopMyfileвЂќ & ws.Name & вЂњ.pdfвЂќ вЂThis will store each worksheet of the workbook as a different PDF And there are times we might want to store a worksheet as a PDF, or each worksheet from the workbook as a different or separate PDF-so here again is macros to the rescue! This is a tedious process if done individually and manually, but a code can help us achieve the same result in much less time. Passcode = вЂњPass000вЂќ вЂreplace Pass000 with the code or password that you want to keepД®nd Sub Example 2: How to Save a Worksheet as a PDFДЄs you may know, we can make several worksheets inside each workbook. вЂThis code will secure all worksheets at once

A macro will help us do this with a password which can be assigned in the macro itself, and the same password will help us unlock the sheets too. Macros can help us protect our worksheets with much less effort because all worksheets of a particular book can be protected at once. Example 1: How to Protect All the Worksheets in a Workbook All at Once Here, we will see some examples in order to learn and understand macros perfectly. Due to this outstanding feature, understanding how to deal with macros is really important. Thus, we can allow Excel to study our input sequences and then imitate them in order to generate macros which automate repetitive tasks for us. Once this input is stored, it makes up a macro which is open to any possible changes. A macro helps in automating or repeating tasks by recording or storing our input sequences like mouse strokes or keyboard presses. To do this in Excel, we use macros.ДЄ macro is like an algorithm or a set of actions that we can use or run multiple times. We do tasks regularly and periodically and it would be extremely helpful if some of these repetitive acts could be automated. In our daily life, we do a lot of things which are repetitive. One of these features is of creating macros. Excel has several advanced features too, and we just need a little guidance to master them. It has helped people keep accounts, manage expenses, manage inventory, and numerous other things as well. It has helped us to do our daily tasks in a much easier and simpler way. Microsoft Excel has been of great help to many of us for a very long time. By Harshita Srivastava on Jin Advanced Excel Functions and Formulas, Basic Excel Functions and Formulas