Microsoft Excel Training Updates

Hi Binayak,
In Excel, we have datedif(Start date, Date of Birth, format code) function.
Format code are as follow :
"y" -> year differance
"ym" -> year in month
"md" -> month in day
complete syntax:
=datedif(Start date,Date of Birth, "y")&" years "&datedif(Start date,Date of Birth, "ym")&" months&datedif(Start date,Date of Birth, "md")&" days".

Google has done a commendable job in the field of developing cloud-based applications. BUt the applications developed by Microsoft Office suite has been in the market from three decades. It ha taken the customer feedback and improved drastically over time. Thi blows Google's application out of the water in terms of features, interface, performance and portability. This might not matter at all for 80% of the casual user and 20% power users.

Google has done an excellent job in showing what can be done with offline applications, however most of the times, they're not fully functional as the Microsoft applications. It might not make a very drastic change for casual users, who do it for their school or university purpose. But the effect will be visible to the power users. 

The applications of MS Office are much stable, and reliable when it comes to handling a large set of Data. Still, people may find it hard to access, organise and analyze a set of data with more than 10,000 entities (for example), in Google applications. Also, there are multiple functions that MS Office offers that are still missing in Google applications.

I think this can be the reason why people pay for Microsoft applications instead of using the free applications provided by Google.

MS Excel is an extremely versatile and flexible tool. You will be able to perform simple tasks like data entry to running simple analysis to sophisticated data modelling. In short, it can do nothing or a lot, depending on the problem you are trying to solve.

Some of the critical things you should master in Excel are:

Data Scrubbing: Getting your dataset “ready” for analysis. This involves (but isn’t limited to) looking for missing info, identifying outliers (these can hurt a lot when computing averages), creating derived fields using TEXT(), MONTH(), YEAR() etc.

Data Analysis: Running moderately complex analysis (using pivot tables, VLOOKUP(), MATCH() & INDEX, SUMPRODUCT(), SUMIF(), COUNTIF() etc. Asking questions of the data and looking for answers.

Presentation: Once the data has been crunched and insights found, presenting the data in a clear, crisp and concise manner is critical. This is where you can demonstrate your prowess as an Excel power user.

VBA: Once you have a good handle on the above, you can look at developing macros/procedures in VBA to extend Excel functionality.

I have tried to capture the thought process behind using Excel and not necessarily be (overly) prescriptive. If you can nail the thought process, you will discover the nuances yourself. Being an Excel savant myself, I can tell you that there is a lot of fun you can have in Excel, problems abound all around you that you can use Excel to analyze. 

All the Best!

There are many ways to export a party name from Tally to Excel. You can manually export data to Excel in Tally. There are Master Ledgers, Master stock, daybook, voucher, balance sheet, trial balance & more. 

You can follow these steps given below to export from Tally to Excel.

First of all,  Go to Tally Company

Secondly, Go to DISPLAY option

Now you have select any DATA which you want to export

Press ALT + E

& Follow the instructions carefully.

Remember, you can export data in PDF, Excel, XML & JPG format.

Also, you can automatically export all master ledgers and master stock data to Excel at one click. For this auto service, you have to download XLTOOL software and follow the simple steps to do the same.

Yes, you can follow these steps to export data from Tally to Excel. 

First of all, open one Tally application & open only one company

In XLTOOL software go to TallyLive template

You have to open MY MENU by F1 Key

Click the EXPORT button and the data will be exported in Software Excel format.

Besides the above options given, you can also use Tally Migrations tools such as sheet magic to export data.

Hope this helps you. All the best!

Microsoft took a collection of software programs that were already commonly used by business offices like spreadsheets, word processor, presentation creation and made a version that will not be able to work with other vendors software. They bundled all these and called it as Office.

Then they used their near-monopoly of small business computing to make it ubiquitous so that anyone who wanted to collaborate with one of their users was required to buy a copy too.

The first spreadsheet program for PC's was VisiCalc for the Apple II. The first presentation software was HP Draw which was introduced in 1979. Word processors have a more extended history on mainframes, but it is to be noted that it was terrible when it was launched.

The developments started during the DOS days when there was a need for businesses. Companies found out the spreadsheets, word processors and database program helped with productivity. Word and Excel were single products, and they were bundled together in what was called Office suite.

Businesses used all the tools and suite merged all these products into one, and it was cheaper than buying all four separately. Over the years, there have been a few Office packages, even one with Wordperfect, but they couldn't compete.

Hope this helps!

Following are some of the tips that you can use in MS Word.

A. The Microsoft office was be started in Safe mode. One of the most common uses is to disable a Word add-in that is behaving erratically. You can use Safe mode to suppress any customizations made to the program. One would use to take screenshots of the default word instead of the customized screen.

B. You can disable the start screen because it can be an annoyance for regular word users. You can disable it by Ribbon>File>Options>General.

C. You can use The Touch or Mouse mode for more Precise Taps, Large fingers and a touch-enabled screen, that is a recipe for a few disastrous taps. Word '13 offers a Touch or Mouse Toggle that makes working on touch-enabled screens far easier by enlarging the buttons and increasing the distance between them. You will be able to do that by clicking on the drop-down arrow on the right side of Quick Access Toolbar and select Touch or Mouse Mode from the list.

D. To remove double spaces; here is a quick and easy tip.

Select all text in the document. Open Find and Replace from the Navigation pane (View > Show > Navigation Pane) or press CTRL+H. You need to Place the cursor on the Find what field, then press the Spacebar twice to insert two spaces. Place your cursor in the Replace with a field, then press the Spacebar once.

Hope this helps!

You can use these tips while writing VBA Codes.

1. Use the application screen updating at the starting of the coded so that the user can see the final results directly instead of looking at the whole process of doing the activities which do not look good.

2. Using the Application.Display Alerts to stop showing any alerts in between running the macro. 

3. Using Application.Calculation to speed up your macro and calculate the values in the macro when needed.

4. Using Application.Status Bar which helps the user to know precisely at what process the macro is doing and how much time would it takes to complete the task.

5. Using Objects (Like-Worksheets, Range. With etc.) as much as you can, which helps you to speed up and improve the performance of the macro.

6. If you have a big macro code, then it is suggested to build in parts and always comment which helps to read the code and very quickly whenever changes required.

7. Declaring variable names which helps the coder to understand which variable is used for which purpose.

VBA in Excel can be used in several MS Excel-based Automation use cases. For example, if you want to capture sales orders from users Computer using Excel, then you can use Sales Order capture tools - Excel-based VBA application. 

Hope this helps.

Microsoft Excel is a spreadsheet program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

Microsoft Word is a word processing program designed to make it possible to create a variety of documents that will look the same between different computers and similar on the screen to how they appear on paper. It's used by businesses and individuals to write personal and professional letters, reports for work and school and to take notes on conversations and in seminars and classes. Because it's so widely used, many businesses appreciate that it's possible to send documents created in Word to clients, employees and other business associates without worrying about whether or not they'll be able to open them.

But, unlike MS Word, Excel organises the data into rows and columns, the intersection of which is called a cell. A cell can contain various data forms such as numbers, alphabets, dates, or formulae. It is an efficient tool which helps to organise the data and analyse it with the help of charts, bar graphs, pivot tables etc.

In today’s world, Excel is prominently used in every aspect of life, be it, maintaining personal expenses, or organising a large set of data in an organisation. With the efficiency it possesses, excel has become a necessary tool in every organisation, and every person should have a knowledge of it. 

Microsoft Excel is a spreadsheet program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

Microsoft Word is a word processing program designed to make it possible to create a variety of documents that will look the same between different computers and similar on the screen to how they appear on paper. It's used by businesses and individuals to write personal and professional letters, reports for work and school and to take notes on conversations and in seminars and classes. Because it's so widely used, many businesses appreciate that it's possible to send documents created in Word to clients, employees and other business associates without worrying about whether or not they'll be able to open them.

But, unlike MS Word, Excel organises the data into rows and columns, the intersection of which is called a cell. A cell can contain various data forms such as numbers, alphabets, dates, or formulae. It is an efficient tool which helps to organise the data and analyse it with the help of charts, bar graphs, pivot tables etc.

In today’s world, Excel is prominently used in every aspect of life, be it, maintaining personal expenses, or organising a large set of data in an organisation. With the efficiency it possesses, excel has become a necessary tool in every organisation, and every person should have a knowledge of it.

The essential functions are Index and Match. Index formula is where you can call a reference of a cell in an array based on its location as rows and columns. We use match formula to find the position of a specific value in a selected cell range. This is for those who have some or little knowledge of excel. But if you are fresh to excel, then, it is best to start by entering data into a worksheet, enter numbers as text, flash fill, necessary calculations, copying formulas, using auto calculate. Autosum, average, how to edit formulas, absolute cell reference, freeze panes, moving/copying/deleting data, formatting, list auto-fill, printing

Master, all that, learn shortcuts for some of these necessary actions and you’ll have a reasonable foundation to move on to more topics.

The next step is to work on naming worksheets, reorder sheets, move/copy sheets, insert sheets, linking worksheets and workbooks, paste a link, managing links in workbooks, data validation, protection, conditional formatting, creating and editing charts.

Learning the above-mentioned skills in Excel will make you ready for the tasks that are often used in a typical organisation.

Know all that lot as well, and you’ll find yourself in the above-average group of excel users.

Hope this Helps