A nested IF Function is a logical decision making formula that lets us plan for 3 or more outcomes to any
condition or test. The video below gives us an example of how this works.

You can view the range of Microsoft office courses by clicking on here

A few key tips for the effective management of people are listed below.

1. Reward performance
A key element of any management plan is measuring performance and then putting a system of
rewards in place for achieving these levels. If staff know that they will be rewarded they will have
a high level of job satisfaction. If an employee feels they are not rewarded for good performance
this will lead to resentment building within the employee and spreading within the group.

2. Motivate people
The ability of management to motivate their staff will aid an effective and efficient business plan.
This involve clearly defining the business or organisations vision for the future along with the goals
and objectives of each employee and how they fit into this plan.
Delegating the necessary power or authority to your employees will empower them and motivate them
to achieve their goals and seek greater goals or achievements in the future.

3. Create a plan
If you create a business plan and involve your staff in drafting and setting the plan this will help people know
what direction the business is going in and what is expected of them.
A plan will also create confidence in the management of the business and a sense of direction for staff and
a realisation that everyone is working to the same goals.

4. Provide training and resources
In order to perform their jobs or tasks it is wise to invest in some in-house training or instruction for your business staff. This will allow them achieve their full potential and avod the pitfalls that have been seem before.
They should then be given the right tools and resources to implement their plans and achieve their goals.

5. Monitor and feedback
You will need to monitor the progress of your staff and compare this to their planned goals or objectives.
Positive feedback or even constructive criticism will help a person stay focused and motivated. This feedback can include recognition in front of peers and doesnt have to cost a lot of money but can be meaningfull to the group or the individual.

These Presentation applications include :

1. GoogleDocs – 
The popular online alternative to Office is Google docs.
You can create a new presentation within Google docs and
features a a lot of practical presentations with the same
functionality as MS PowerPoint.

2. Sliderocket –
This option has a full se tof professional design tools to assist you in creating amazing
presentations that will impress your client. With themes and layout structure you
also have shapes & charts, tables & pictures, audio, HD video, and Flash to tell your story without compromise.

3. Prezi – 
You can create powerful presentations and store them online with this tool.
This can then be shared online.

4. Zoho Show – 
Zoho Show’s has a lot of pre-built themes and can be used with clipart along
with features like drag-and-drop which makes it an easy application to use.

5. 280 Slides –
A full featured site allowing you create a powerful presentation and run it in-house or onlline
You can access these from anywhere, and share them with the world

Thanks the TIB Team

What exactly is a management style?

By definition, a management style is a leadership method that manager uses
in running a company or organisation. For example,
how the decision making process is done or how the employees are being treated.
Each style has its own set of characteristics, positives, negatives and
how tasks are done. These are the many management styles in business.

Democratic Management Style

In democratic management style, the manager usually delegates power to
the subordinates and leave the decision making process to themselves.

It is of the highest importance that those given the responsibility are those
who are efficient in executing the tasks. This business leadership style is most
suitable and effective in a situation where the manager wants to
teach employees the process of decision making.

Autocratic Management Style

In autocratic leadership style, manager is fully responsible for making the decisions.
Hence, other employees are left out in the decision making process.
This is most effective in a condition where prompt decision is required to be taken.
This leadership style however, can easily demotivate employees and
dampen their productivity level.

Participative Management Style

In participative management style, the manager gives his staff and
subordinates the chance to be involved in the decision making process.

Believed as one of the best methods to boost the motivation of employees,
this style will make employees feel valued by the management.
While there’s a sense of collective decision, do notethat the manager will have
the final say on the  decision.

Laissez-faire Management Style

The laissez-faire management style is similar to the democratic management one.
In this style, however, the manager lets staff completely do the tasks.
While some argue that the manager is acting irresponsibly,
the laissez-faire is one of the best conflict management styles,
as the manager is not seen as being partial on one side.

Choosing the Best Style

The above explanation should hopefully provide you with a general insight
on some popular management styles in business. Ultimately, the best management
style is one that can get the job done effectively. A leader is expected to
adopt roles, rules and concepts according to the situation and
condition of the company, as well as the skills and mindset of the employees.

3 key features of Microsoft Excel that improves your office productivity

You can improve your office productivity by extensive use of Excel and use of its custom built spreadsheet tools. It is like empowering your data with intelligent processing thus providing you with crucial information. Some of these Excel tools include:

1. Pivot Tables

Storage of high volumes of data and creative information are the pre-requesites to any business. It is just not wise and viable for large amounts of such highly variable data to be stored on a single spreadsheet. It could be confusing and tedious to extract the right information at the right time.

Using pivot tables, such data can be organised into manageable chunks of information. It also allows you to access and compare data instantly. Getting trained to use Pivot tables is one of most beneficial skills that your team will be learning in creatively implementing Excel.
You will learn how rows and columns of data in the Excel spreadsheets become critical sources of information powerhouses. Once you feed data to pivot tables, it can be returned as processed  data or information in innumerable ways. High selling products can be listed out by trained experts for specific time periods or for customer categories etc. You can also chalk out buyer demographics pattern or any other information as per your creative intution.

2. Sales Tracking Tools
The winning formula for any marketing business would be the creation of friendly competition among co-staff in an office – coupled with good incentives. The main motivations for any sales personnel are:

1. Monetary reward
2. competition and
3. recognition.

Learning to use all functons of Excel graphs in ways never thought of before, would most certainly help you build an all inclusive sales dashboard. Since every business could have its own specific statistics to track in terms of sales, you can create custom sales tracking tools in Excel.
Your sales team can document their vital sale statistics on Excel documents (created by the Sales Manager) with data representing the number of sales, number of inquiries, sales by product etc. This data can then be used to generate a whole series of visually appealing graphs and charts that instantly displays sales percentages by product, productivity, percentage of leads that become sales, and much more. Instant and accurate graphical data has become a boon for the sales associates beause it helps them identify their strengths and weaknesses. It motivates them to compete with themselves and also with others, for driving more sales.

3. Interactive Web Spreadsheets

With some good Excel training, you can acquire knowledge on how to create interactive web spreadsheets. Being quite interesting and informative, it not only draws visitors to your website, but also entices them in coming back sooner or later. The interactive web spreadsheet tools include bulk sales calculators, loan calculators, and investment growth prediction calculators that are automatically updated based on the values entered.

As long as visitors get quality information from your website, through the various interactive web spreadsheet tools, they will keep coming back. Getting along from here, as long as potential customers stay on your website, they are more likely to purchase your product or service. This can increase the number of backlinks to your website in the long run. More quality backlinks means higher ranking on the results page of top search engines. Hence, interactive tools are priceless in items of search engine rankings.

We hope this information was of assistance

the TIB Team

The Microsoft Office suite of products is a store-house of vast functonal features that
are constantly updated with newer versions of the improved product.
If you are not entirely making use of the full functionality of these products,
you are t missing out on the “power to manipulate and process data”.

Collecting huge amounts of strategic data for your organization to
serve your business needs, becomes immaterial if you do not have an innovative way to
organize and analyse it.

3 key features of Excel that improves your office productivity

You can improve your office productivity by extensive use of Excel and
use of its custom built spreadsheet tools. It is like empowering your data with
intelligent processing thus providing you with crucial information.
Some of these Excel tools include:

1. Pivot Tables

Storage of high volumes of data and creative information are the pre-requesites to
any business. It is just not wise and viable for large amounts of
such highly variable data to be stored on a single spreadsheet.
It could be confusing and tedious to extract the right information at the right time.

Using pivot tables, such data can be organized into manageable chunks of information.
It also allows you to access and compare data instantly. Getting trained to
use Pivot tables is one of most beneficial skills that your team will be learning
in creatively implementing Excel.

You will learn how rows and columns of data in the Excel spreadsheets become
critical sources of information powerhouses. Once you feed data to pivot tables,
it can be returned as processed  data or information in innumerable ways.

High selling products can be listed out by trained experts for specific time periods or
for customer categories etc. You can also chalk out buyer demographics pattern or
any other information as per your creative intution.

2. Sales Tracking Tools
The winning formula for any marketing business would be the creation of
friendly competition among co-staff in an office – coupled with good incentives.
The main motivations for any sales personnel are:

1. Monetary reward
2. competition and
3. recognition.

Learning to use all functons of Excel graphs in ways never thought of before,
would most certainly help you build an all inclusive sales dashboard.
Since every business could have its own specific statistics to track in terms of sales,
you can create custom sales tracking tools in Excel.

Your sales team can document their vital sale statistics on Excel documents
(created by the Sales Manager) with data representing the number of sales,
number of inquiries, sales by product etc. This data can then be used to
generate a whole series of visually appealing graphs and charts that
instantly displays sales percentages by product, productivity, percentage of
leads that become sales, and much more.

Instant and accurate graphical data has become a boon for the sales associates beause
it helps them identify their strengths and weaknesses. It motivates them to
compete with themselves and also with others, for driving more sales.

3. Interactive Web Spreadsheets

With some good Excel training, you can acquire knowledge on how to
create interactive web spreadsheets. Being quite interesting and informative,
it not only draws visitors to your website, but also entices them
in coming back sooner or later.

The interactive web spreadsheet tools include bulk sales calculators,
loan calculators, and investment growth prediction calculators that
are automatically updated based on the values entered.

As long as visitors get quality information from your website, through the various
interactive web spreadsheet tools, they will keep coming back.
Getting along from here, as long as potential customers stay on your website,
they are more likely to purchase your product or service.

This can increase the number of backlinks to your website in the long run.
More quality backlinks means higher ranking on the results page of top search engines.
Hence, interactive tools are priceless in items of search engine rankings.

All this can be achieved by taking an Excel training course to
attain the knowledge required and putting it into action.