MS Office Software 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!

First of all, MS Office applications such as MS Excel, Word, Powerpoint, Access are easy to learn. If you know the basics of computer operations such as saving the file, opening a file, left mouse button click, left mouse button click, scrolling the screen, then you can start learning now. 

The best way is to do it yourself, the more you do, the more you learn. The key to learning computer skill is by doing yourself. Understand what is the purpose of using Excel, or word, and start doing it.

To be very basic, Excel is a spreadsheet application. It has a lot of formulas to manipulate data, charts to present data in visual representation. MS Word is a document you can type, format, save, print, share thats it. Menus are very easy to understand; simple English or the language of your selection.

Refer videos online to understand more, search for each of the menu item you see in the excel one by one practice it with sample data. Start using excel or word for your business. If you find it difficult learning by yourself, then you can also seek experts’ guidance to accelerate your MS Excel learning process. 

Hope this helps. All the Best!

Excel has a known issue (sluggishness) with Tables with a thousand rows where one or more columns contain cells with formulas. If you convert the Table into a range of cells (I know, it kind of defeat the excellent features of a Table), you will restore the speed to your workbook. Microsoft is aware of the issue.

If you are using array formulas that refer to entire columns, then it is advised to change those formulas so that they see to a more restricted range of cells, say rows 2 through 6000.

If you are using Volatile formulas, then those would be formulas using INDIRECT, OFFSET, RAND, NOW, or TODAY. Volatile formulas are recalculated whenever you enter data in any open workbook. As you might imagine, thousands of rows full of volatile formulas will spend a lot of time recalculating. In most cases, you can use alternative formulas that aren’t volatile. 

If you are using a lot of VLOOKUP formulas, then you make it a thousand times faster, if you sort the data table and then use the binary search form of VLOOKUP and MATCH.

These are some of the tips for decreasing the bogging down of Excel.

Hope this helps!

To be honest! Neither you’ll be able to master in Excel by just reading a book nor by attending a training course and watching videos. Yes, books are helpful when it comes to learning certain things. For example, books which have the list of the formulas which cover the basics, formulas for all purposes, formatting, charting and Intro to VBA etc. would be of great help in your learning process. But, only by reading those books, you’ll not abe to master in Excel. It is simply because, alongside theoretical knowledge, you also need practical experience to master in it. 

It would help if you learned it by taking one piece at a time by tackling problems you would care about in the job, personal life or classes. You can learn by asking questions to yourself like how you can analyze the data and how can you make the tedious task efficient and how can you make the workbook more persuasive. Analyzing a workbook built by someone skilled would be a great start.

As a learner, you must comprehend the fact that Excel is a skill that you cannot master in a few months. It takes time, patience and a lot of effort as it has many layers to unfold. 

Hope this helps you. All the best!

The problem with Excel is that each step is easy, so it’s a bit like Lego. So very few people put in the effort to master what is a large and sophisticated set of tools, with a dozen different modes of operation. Thus, nearly every spreadsheet is awful and financial regulators are worried that they will cause the next financial crash; some say they created the last one.

A real Excel Expert is someone who can make it quickly do the things that are needed, knowing syntax is less important than the more in-depth knowledge of how things can be best achieved in Excel. Excel development is much more of a real-time thing; an expert knows when to prepare out a quick sheet and when to build something resilient and is skilled at extracting from users what they want without a formal specification.

A top-rate expert knows when to use MSTO to bring it more up to date and has the wisdom to know when to leave VBA and XL4 macros well alone and just patch.

One would be defined as an expert. A reasonably smart person can learn any feature of Excel just like Python, SQL or any other tool. What distinguishes an expert from someone who has merely used something a lot is their ability to make the right decisions. That’s what one would look for when selecting people to recommend.

Hope this helps

Spreadsheets are basically to solve minute problems. You can make several random spreadsheets to track different things. 

You can make a spreadsheet to track your grades in school by reverse-engineering the grade book software you would use. You can also make a spreadsheet that would create a Sudoku puzzle by Random number generators. It will also help you solve a Sudoku puzzle by warning if you break a rule in the process.  Another funny use for excel is if you are married with a kid, you can create an excel sheet as to track whose day it is to change the diaper. Yeah, I know its crazy.

The most common spreadsheet one would think of is to track the expenses, by allocating a score out of 10 to each person and put in the total budget. The spreadsheet then proportionally allocated a budget to each person based on our score. The beauty of it was that when we bought a present, we'd put in how much we'd spent on an individual. 

The spreadsheet then worked out if we'd gone over or under budget then proportionally spread out the over/underspend to all remaining people on the list, ensuring that we remained within budget overall.

Hope this helps!

A VLOOKUP can lookup data automatically instead of a person having to do it manually, so time-saving is the first benefit that springs to mind. How much time a VLOOKUP can save depends on the amount of time it takes a person to look up the data manually, how many records are being looked up and whether the lookup function can be re-used to complete the same or similar tasks in the future.

VLOOKUP takes four arguments, in the following format:

VLOOKUP(Lookup_value, Table_array, Col_index_num, Range_lookup)

Lookup_value is the value that you want to search for.

Table_array is the array of data containing the lookup value and the column containing the data to be returned. The column containing the lookup value has to be the first column in the array.

Col_index_num is the column number at the array that you want to return values from.

Range_lookup is a TRUE/FALSE field indicating whether you want an exact or partial match. You’ll always want this to be False, for an exact match.

VLOOKUP is probably the most commonly used lookup function in Excel, but it’s not the only one, and depending on your situation, it might not be the best one. Other lookup options include HLOOKUP, INDEX MATCH or combinations of all these functions.

Hope this helps!

The companies or organizations which are wise provide Excel VBA access to employees as it helps increases productivity.  Excel VBA access does not create information security risks, Per se'. The risk is instead that of bugs in the code resulting in bad decisions being made.

The reason why VBA is so famous is that every Office user has access to it. If you have a problem, you can actually use VBA to automate the routine tasks in your job and increase productivity. And if you share those VBA tools with peers, you can multiply their productivity as well.

Information security risks occur if parties gain access to corporate databases (or worse yet, change them) who aren't permitted to do so. It requires a pretty sophisticated VBA coder to do that, and such a person can also circumvent any attempt by the IT Department to prevent access to VBA. It is far better to identify the people within the organization who have those skills and make sure you trust them.

It is also to be noted that Information security risks also occur if parties outside the organization are given access to information exported from corporate databases. Lack of VBA access won't stop someone from copying such files onto a flash drive and letting it fall into the wrong hands.

Hope this helps!