Microsoft Excel Training Updates

There is no direct option to add bullets in EXCEL. So we can create the bullets by the following steps:

1. Select the range where you want to apply the bullets.
2. go to formate cell ==> Custom Formate.
3. delete the General word and do following.
4. add five blank space.
5. add your symbol with Alt+7 then add one space.
6. type @ and press ok.

In the following, You would find lesser-known, unexplored yet Powerful Features of Filter.

Please refer to sample dataset below:

To do Data Analysis:
Step 1) Apply Filter on the dataset.
Step 2) In Sales Amount column, click on Filter drop-down.
Step 3) Take Your cursor to Number Filters. A-List of Options will open up.
As highlighted in the screenshot below:
i) Please click on Top 10 - to see list of Top 10 Performers OR Bottom 10 Performers
ii) Please click on Above Average - to see list of Above Average Performers
iii) Please click on Below Average - to see list of Above Average Performers

Likewise, in the Date column, if You click on Filter drop-down, and take the cursor to Date Filters, a List of Options will open up.
As highlighted in the screenshot below, the Options will allow You to do Data Analysis across different periods, in a Click.

Isn't this Cool. Data Analysis in Few Clicks!

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.

First of all, mastering Excel takes time, effort and patience. If you want to become an expert in Excel, then you must remember that the more you use this spreadsheet, the easier it gets. Coming back to your question, it is normal to make mistakes in the initial stages; it actually helps you learn better. 

Although different people make different mistakes, there are some common mistakes beginners make in Excel.

A. Many beginners do not realize that their work will be used downstream by someone else who likely has to extract information from them and use it for something else.

B. Beginners do not make the extraction of the data from their workbooks easy. Often focusing on the final output and format of their report/analysis and ignoring the powers of Excel to manipulate raw data and aggregate it.

C. Not using cell formatting to align columns of numbers. Unless you format cells to a set number of decimal places, the numbers align to the right - regardless of where the decimal point is. That’s not useful if you’re (for example) adding up columns of money.

D. Formatting the cell to (for example) two decimal places aligns the figures at the decimal point - with two digits to the right and the remainder of the number to the left.

Hope this helps.

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!

It can be, depending on your situation. If you want a job which requires building complex Excel workbooks then, of course, you will need to learn that. If you are asking because you want to learn some new computer language just in case, it’s useful, or because you think it might look good on your resume, then you must learn the fact that VBA is not a simple language to learn. 

It is easy to have the details slip away from you if you are not using it fairly frequently. It Is also to be known that VBA is the back end coding platform for Excel. Professionals who are in commerce, science and even teachers can benefit from learning VBA. So, the answer is yes; every minute you invest in learning VBA is worth it. The whole point of VBA is to make life easier and can make your life more robust.

If not VBA then make an effort to at least learn some front end functions. Hope that helped you decide if it’s worth it or not FOR YOU. Learning new things isn’t always beneficial. Learn something that you think will help you advance and make a difference in your life.

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.

As we all know, everything in this world comes with pros and cons. So, of course, there are pros and cons of MS Office too. The advantages or pros of MS Office are:

First of all, MS Office is cost-effective. Office 265 can be less expensive when it comes to paying for licenses and also each user will be given access to One drive which depending on the level of your service offers up to a 1-year terabyte of storage per user in a cloud environment.

Most of Office 365 plans offer access to word, excel, Powerpoint and other programs through an online web version of the program.

When it comes to the cons of MS office, you must know that:

The cost considerations of office 365 subscription are generally cost-effective for most businesses; it may not work for your business.

Not all companies or firms are one size fits all, and there is less flexibility with customization when using Office 264 because it is built in the cloud. As with any cloud-based solution, the information has not resided. For many firms, this is actually a secure option. Still, there are industries such as financial services and healthcare that must comply with regulatory constraints and require their data to be stored.

Hope this helps!