If you want to select range of cells – without using Mouse selection Or Shift key, you can use F8 key as briefed below :-
Suppose you wish to select the range A1 to D3. Select cell A1 and press F8 key. Now this will freeze the A1 cell and now select the cell D3, you will find that the range A1:D3 gets selected automatically.
You can use this technique to define a named range for the selection A1:D3 or to format them.
Use a Macro to Add Multiple Sheets
To add multiple sheets, use a simple macro. In this example, I want a tab for each week of the year. The default is three sheets in Excel, so we need 49 more. Select the Developer tab, select Macros. In the Macro Name box, enter Add_49_Sheets and select Create. In the VB Editor, you’ll see
On the next line paste:
Worksheets.Add After:=Worksheets(Worksheets.Count), Count:=49
This line should be followed by
Now close the VB Editor, select Macros, select Add_49_Sheets, and select Run. You should now have 52 worksheets. To change the number of sheets, simple replace the 49 (Count:=49) with the number of required worksheets.
Freeze Panes to See Headings When Working with Multiple Columns and Rows
When working with multiple rows and columns, you may want to see your column and row headings. To freeze a single row or column, go to the View tab, select Freeze Panes. To free only the top row, select Top Row or to freeze only the first column, select First Column. In this case, I wanted to see both by first row and column, so I selected the entire first row. Holding control, select the entire first column, then go to Freeze Panes, and select Freeze Panes. Go to back to the View tab, select Freeze Panes and then Unfreeze Panes to unfreeze.
Visualize data trends with Sparklines
Sparklines allow quick graphical representation of data with a couple of mouse clicks, fitting a graph within a single specified cell. Select the Insert tab, above Sparklines, select the style of graph – column, bar, or win/loss. Chart options, such as color may then be further specified.
Filter and Sort Data in Excel
Select the cells to be filtered and sorted, select the Data tab, select Filter. Use the dropdowns at the top of each column to sort alphabetically, numerically, or manually check/ uncheck desired values.
Use Text to Columns to Separate Text (for example First and Last Names)
Select the column or cells containing data to be separated, select the Data tab, select Text to Columns, select delimited (in this case because we will use the spaces to separate), select Space, select Next, select the first cell in which the new text should begin (destination), click Finish.
In an organization , this may always happen that you are not a decision taker, but remember you can always be a part of decision makers.
The idea is to be part of game or starting a game by providing your insights and facts to decision takers...
So for those who always think that decisions are not in our hands , I will suggest them to think with different perspective ....
happy Decision making !!!!
In a traditional mentoring , A senior colleague, having more experience and knowledge in the relevant field helps to guide less knowledgeable and less experience team member.This is the way we all are grown up and we always try to catch up with seniors offline as well as online for relevant guidance and counselling. A personal development program in an organization where a mentor is assigned to each of the employee who guides him in his initial career path in an organization.
But today I am sharing with you a new and beautiful concept - "Reverse mentoring" - A reversal process where an entry-level, often tech-savvy employees the chance to school senior executives about business interests, such as trends in social media, consumer culture and unconventional methods to boost office morale. The practice continues to gain popularity as rapid advances in technology widen the generation gap in virtually every business. To put it simply, if you’re in your 40s or 50s and beyond, the 20-somethings are more technologically savvy than you are, and you can learn a lot from them.
People love it when someone asks for their opinion or advice. When younger people feel that their knowledge and input is valued by senior management, they are motivated to do more and do it better. And senior managers can use their new knowledge to improve bottom-line results.
Reverse mentoring lets junior employees see the larger corporate picture, giving them a glimpse of macro-level management issues. It also increases retention of Generation Y or Millennial employees. It increases multigenerational cooperation and reduces conflicts between age groups in the workplace.
So is your organization ready for reverse mentoring or as a person are you ready to learn from your juniors ?
How often do you have an idea that you want to tell your boss, or your boss's boss, or your boss's boss's boss, and actually say it?
And more important, if you do say it, how often do you feel the boss really listens?
What would you recommend others to do when there are no takers to your ideas?
Who owns the responsibilities - the employees, the bosses and the organization.?
What practices would you recommend to streamline the process of communication, to structure things so that good ideas can flow from bottom to top and quickly become a reality.?
Please do add your suggestions/ comments/ feedback by replying to this post. Remember - You can make a difference !!!
Disruptive innovators approach networking in a unique way. They talk with people who don't look, think, or act like them to help spark a deeper understanding of jobs-to-be-done that currently aren't being done. They follow a "not like me" attitude when trying to get other's perspectives to identify the critical jobs-to-be-done.
As a "job creator" you can approach networking this way too. When talking with people who are different from you, you're more likely to spark new ways of thinking about jobs-to-be-done or other ways your skills might be deployed. Set aside a lunch or dinner once a week to visit with people who see the world differently. Share your observations about important jobs-to-be-done and chat about how to do them better. Explore how the other person's background and experience might shape your initial ideas into something even better. After five to ten of these conversations, step back and look for trends and patterns. As with your observations of the world, look for surprises and unexpected angles that just might spur a new job creation angle.
We at Management wall believe in Disruptive innovation and for same we invite you to be part of management wall journey to create new market & value network for your management profession.
Most commonly heard and known by all of us. All of us are facing or had faced this problem in our life.
A young boy going school didn’t find time. A teenager going college do not have time. The working professional does not have time. The husband does not have time for his wife. The father does not have time for his children. A friend does not have time for another friend.
All of us don’t have time for something. So the question which we should ask ourselves is where all the time is going. We just keep working and doing the thing expected from us without taking care about the most precious asset of a person “HIS TIME”.
Have you ever heard Dr. A.P.J Abdul Kalam, Narayana Murthy., Azim Premji, or any success personalities complaining about the time management. They also have only 24 hours in a day as do we get.
Do they are born with special power or do they know some special formula or capability which we are missing.. The answer is big “NO”. They had learned everything here only and from the many things they had learned, one of the important things they had learned is HOW TO MAKE BEST USE OF THEIR TIME.
The only difference between them and us is the one which I can see is That they make sure that whatever time they spend show productive result rather than just working and ignoring the result.
It takes a lot of courage to stop and turn around and see the result of the time and effort spend on a particular task and then to make it productive.
So if you have a courage then stop turn back and compare time with your productive output. Analyze it and work to improve on the same.
Finally then one day when you had done it, you will stop complaining about the time and will write such article in some forum.
Have a Nice Time…
For all those employers who have everything under control - I have a question Why....
More than 30% believe they’ll be working someplace else inside of 12 months.
More than 40% don’t respect the person they report to.
More than 50% say they have different values than their employer.
More than 60% don’t feel their career goals are aligned with the plans their employers have for them.
More than 70% don’t feel appreciated or valued by their employer.
there can be a little variation in percentage numbers...and still they say - everything is under control
Probable reasons ??????
Employees who are challenged, engaged, valued, and rewarded (emotionally, intellectually & financially) rarely leave, and more importantly, they perform at very high levels. However if you miss any of these critical areas, it’s only a matter of time until they head for the elevator.
Do you agree???
In long race of professional journey, we intend to measure our performance and desire to get best outcomes. The focus is on results and we put our best efforts to achieve the same, however It is equally important to keep a consistent pace on up-skill activity. It is like keeping your tools pointed so that leverage upon the hard work you do can be taken for your performance.
Up skills refers to add on the current skills which keep us moving with assertiveness and aggressiveness. The question is - How should we up-skill ourselves? Sharing with you the four steps which we all must take care of and practice them with utmost sincerity.
External training / certifications / education - This can be self-nominated or it can be also provided by the organization you work for. Whatever be the case is, the important point is to make most of it and don't ever just do it for just sake of doing it. Give time and prepare for such training - Do the elementary homework before appearing in such trainings such that you are on the same tuning the very first minute of the opportunity provided to you.
Consistent Reading - The more you read the better you will be. It is the food that your brain needs - Reading newspapers, journals, magazines keeps you upfront with the latest innovations, practices in your industry. With consistent readings, the results can do wonders and one can start feeling a change in his/ her confidence within a month or so. In short consistent reading gives you the content.
Ask others - We all are surrounded by our friends and colleagues - Share / Express & Discuss the better ways of doing the same thing. Everyone will be free to give 10 seconds to you and it’s up to you how can you make most of it. Remember to help others too. This can be done with colleagues in your office, your friends, online communities, networks.
Reflect - Reflection is the key - Whatever you learn in above three steps - apply it. Try to bring them in practice. It can be in verbal communications, or it can be in your analysis activity. You can even write a blog of what you learnt today. This will give you chance to interact with others having similar interest. Without reflection, the learning are sure to fade.
We are always sincere for the task we are given in office. On the other hand we have no other option else we might be fired, but when it comes to us, we seems to be lazy as we are the boss of our own and so no one will fire us. So the discipline in all above four steps with only come once you show same dedication as you show for the official task which you are paid for. In short it’s all about Self-management.
Wish you long tern success in your professional journey!
Managers do not need answers to operate a successful business; they need questions. Answers can come from anyone, anytime, anywhere in the world - thanks to the benefit of all the electronic communication.
For all managers in any situation at any time - start with basic question list
These questions are universally applicable. If you ever in a situation where you need a question, or if you want to be certain all questions have been asked, just run down the list. This list also serves as a handy checklist when you need to make a quick decision.
There is a lot more to asking a question then merely using an interrogative, but these words do cover the full managerial spectrum of interrogation.
Based on what you expect to accomplish - there can also be a second list where you can add number of other questioning words and phrases such has which, is, could, would, do, can , will and so on...
Do you use your own question list ??? We welcome your comments / thoughts on same.
Everyday at work, we struggle with what seems like an insurmountable obstacle – a feeling of being handcuffed, a feeling of being victimized. There are no leaders worth their salt here, we say. We are not getting the proper direction! The leaders are just selfish, they look after their own interests…..and where does that leave us, we lament.
Of course there is a leadership vacuum today – in business, in politics and in our personal lives. What are we going to do about it? As Superman said – “You’ve got to look inside; you can’t expect some leader to take you anywhere.” – Christopher Reeve, 17th April 1997. That’s the essence of “living leadership” daily. True leaders in everyday life accept leadership as a duty in daily behavior, and begin to break the shackles of this crisis. As a framework for change – let’s commit to one tenet of leadership dharma – “Minimum acceptable is no longer acceptable”! A variety of reasons make us settle for what is “mimimally acceptable” (I abhor that term!) so that we deem our obligations complete. Make a move from that.
The only realistic result of minimally acceptable work (whether that is in your projects, in your product’s quality, in your behavior with your teams, peers and managers) is mediocrity. And mediocrity is a synonym for irrelevance. Most of us are striving for relevance in this turbulent world and it is an attribute of daily leadership. So, cast off the “normal” mode of working – even if you feel shackled by the “lack of leadership” out there – accept that responsibility yourself and start making the journey towards being exceptional. Here is a great technique leaders use to make a move from mediocrity:
Own the outcome, not the task. This is all about keeping your eye on why you are executing a task – i.e. how does your task combine with the tasks of others and move the dial. As you embrace this, you will move from responsibility, accountability to true ownership – where you don’t stop at a task completion level; (minimally acceptable) but operate at the outcome level (leadership dharma level).
Sharing a few money saving tips with new college graduates starting their careers.
This is the moment you’ve been waiting for. You’ve finally obtained your college degree, landed your dream job (or a job), and you’re officially part of the real world. Your high school teachers may have told you college was the real world, but now you’ve realized that is definitely not the case. As a young professional, you have much more to do than you did in high school or college. You have to worry about balancing your budget and creating an ample savings account. After all, your parents won’t always be there to save you on a rainy day. Creating good saving habits now will be immensely beneficial for your future. Here are some simple ways to save money on a daily basis.
Take Your Lunch to Work
This may seem like a daunting task. However, you will be surprised how much money you save by taking your lunch to work instead of eating out every day. Although it can be fun to go out with your co-workers for lunch, the weekly tab can be stressful on your wallet. For example, let’s say you eat a pretty modest lunch even at a chain like Mc Donalds . You will probably spend at least Rs 100 per meal. If you work 5 days a week, that adds up to Rs 1000 Instead, you could probably spend Rs 200 on a week’s supply of groceries. If you make yourself a sandwich every day, you will be saving additional close to Rs 800 a month! Plus, you’ll be saving your waistline from extraneous calories. That extra Rs 1000 - 2000 could be useful if your car needs repair on a random day!
Investing 101: Diversify your Polio
So, here is a way to increase your available cash flow: Investing a part of your salary. Of course, you need to decide how much you’d like to invest. Also, if you have any of those really successful friends in investment banking, now may be the time to invite them over for dinner or drinks. Here is a link that can help you get started, with basic tips on investing.
Be a Sensible Socialite
It can be really exciting to be a salaried employee. You always have a cash flow. Plus, every time you get a paycheck, you feel like you are being rewarded for your hard work! However, with great power comes great responsibility. It can be easy to spend your money on extravagant nights out on the town. It is important to spend your money wisely, and in moderation. Rather than spending Rs 5000 at a bar, invite your friends over to have drinks and hors d’oeuvres. Make it a potluck, where every person brings some sort of alcohol or appetizer. Even if you want to go out afterwards, you probably won’t spend even half the same amount as you would have without the pre-party! Plus, the pre-party will be fun, personal, and cheaper!
Get Rid of Your Credit Cards
Even rappers who make $50 million a year have become destitute after putting too many expenses on their credit cards. There’s no class in overspending. If you think you are likely to spend more than the available supply in your account, leave your credit cards at home! Or better yet, don’t have one. You may need one for emergencies, but if it is not necessary, just stick to using your debit card!
Think Before You Buy
So, practicing restraint may not be one of your strong suits. It is definitely not one of mine. However, exercising your critical thinking skills before making a purchase can help you save a lot of money. Every time you are considering a big purchase, write out a pros and cons list. How badly do you need the item? How often will you use it? Take a look at every store/outlet offering the item to find the best price. The more time you spend thinking about it, the less likely you are to buy unnecessary items!
I would be happy to read feedback / suggestions.
In any organization , there is a system which produces the results and we people manage those already created system.
The hierarchy is composed of four components for the same system -
The first one is - "How We do it Here"
The second is - "How We Recruit, Hire and Train People to do it Here"
The third is - "How We Manage it Here"
The Fourth is - "How We Change it Here"
And the "It" I am referring is the stated purpose of your organization/ business".
So next time when you enter in you work space - do try to observe the system you are part of, and try to observe all the four components stated above with growth perspective of your organization.
I would appreciate your observations and welcome them as a part of comments on this page.
Our Leadership Dharma:
We will strive to lead ourselves and others without regard to position or status and find fulfillment: (a) by embracing the duty of leadership as a daily behavior, (b.) by a sharp focus on core competence, and ( c) by an unflinching intensity on serving and fulfilling others, thereby achieving our purpose.
Our Leadership Resolve (Sankalpa):
We will focus on our core skills and values with a “mad” intensity.
We will always be partial to positive forward movement.
We will lead with H.E.A.T – by being Humble, Exceptional, Authentic & Transparent.
We will focus on execution and value the outcome and not the credit.
We will focus on clasping hands rather than wringing hands.
Everyday, we will BET on ourselves – Be Exceptional Today!
For a business to be healthy and sustainable , a lot depends on how effective is the correlation/chemistry in between its stakeholders viz customers suppliers ,employers, investors, bankers and many other indicators . The variation in performance of contributors in its value chain affects the variation in business performance. The same is applicable and can be seen as replica in our individual life.
Looking at a life of normal person say in late 20's or early 30's , he goes every day to his work station with an ambition to perform better from previous day and objective is to get a success in corporate journey. The organization you work for expects you to perform and deliver outputs which has to be done at an individual level and also at managerial level...and at times there will be a huge enormous pressure.
This is one part of the picture and where he spends 12 hours a day. Besides corporate world , The other look out is his family, social circle and his own individual space.
At family he is not only expected to be with them but also to spend time and fulfill all the leisure and responsible activities. Likes dislikes with your partner and if everything is not on track , start of stress building can be seen
Now he also need to be social creature and has to be part of all family functions programs with right status.
The least he ever think of but the most important root for balance is individual space. and here he look to up skill him self and take decision of his life , such as job change , choosing a life partner, doing some fun , education / certification , knowledge up gradation and giving time for exercise or other health activities.
This is applicable to all of us and we are expected to perform at par level in all dimensions of the life viz social ,corporate, family & personal space.We can outperform in one or two levels but some how we are compromising in other dimension of life..and so while trying to keep balance in all we are stressed and neither of the things improves.
The so called stress that we feel in our daily life is performance stress and is such that we just keep ignoring it day by day. It is such that neither you perform nor there is a fun.
Give a halt to this reading and give a thought - Does this happens to you ? If answer is yes the question comes what can be done to over come performance stress. If answer is No , the challenge is to make sure that it never comes to you.
In both the answers , we have to make us understand with due consideration the basic principle - we have to give equal weightage to all dimensions of life at same phase of time. Which includes our individual space.
Give a break to your daily routine and start with individual space.
With individual space -We refer to visualize your life and give a thoughtful observation- how is your life going on ? How are you performing - What can be done to make you happy.. With such observations you get an opportunity to identify where you are and where you should be.... Start thinking in positive direction to move towards the actual position which you have just discovered to reduce the gap is the key and first barrier to over come the performance stress.
The said process either can be done with fresh air in morning. A 15 to 20 minutes morning walk with fresh oxygen can do wonders to your thought process. With individual space we develop the ability to mange other dimension of life effectively. This happens as we give time in understanding our priorities and giving due consideration to parameter which give us the satisfaction.
With development of such understanding - will not only give you the stress free space to live but also enrich you with positive energy to move ahead in flourishing in all dimensions of your life.
Hope this reading will encourage you to take out some time for you and which will take you towards the road of stress free journey.
With Best wishes
Email has become the technology for intra-office communication. Four years into my career I’m finding that mastering this medium is vitally important for both productivity and perception management. An email faux paux is just as bad as bombing your elevator pitch; sometimes it is worse because it can be copied and forwarded as a digitally perfect reminder of your mistake. Email can cause productivity headaches as well. How many times have you spent valuable time cleaning your inbox rather than getting real work done?
I propose these seven rules for better email in the office.
1. Walk, Meet or Call Before Emailing.
Remember, communication did exist prior to the advent of email. Those old standbys like walking to someone’s desk, setting up a meeting, or calling them on the phone are still viable options. I think it works best when you have a real conversation with someone and then, if a record is needed, summarize the conversation in an email. Some of the worst email train-wrecks occur when trying to troubleshoot, negotiate or problem-solve via email. These conversations are not suited for a medium with a built-in time delay.
2. CC With Care
There are no standards for email etiquette, but I can’t ignore the common practice of people filtering emails in which they are not in the TO: line. I live by this rule: if you expect someone to reply or take action, put them in the TO: line. If you put someone in the CC: line that means you need them to be aware of what is going on but don’t need them to do anything. To put it differently, don’t expect someone to take action if they are in the CC line.
CC’ing with care also includes use of Reply All. Very bad things can happen when you use Reply All. I’ve seen it result in insulting comments about customers being sent to customers. This is pretty much the worst thing that can happen if you are in sales. For example: Sales guy sends support request to support guy and CCs the customer to let the customer know support is now handling the issue, support guy then Replys All with a comments like “oh no, not this idiot customer again”. Customer sees the reply and all hell breaks loose.
Finally, be proactive in trimming the CC list. If an email eventually finds its way to you and you can actually fix it, send an email to the group letting them know that you are taking ownership of the issue and are reducing the CC list. If anyone really wants to stay in the loop, they’ll request it. Most will be happy to be relieved of the clutter in their inbox (especially executives).
3. Be Brief, Be Professional
An email at work is not a blog post. It is not a Facebook message. And it is certainly not your pulpit. Your job is to pack the most message into as few words as possible. People get hundreds of messages a day, and they don’t want to read some rambling approximation of the issue at hand. They want facts and they want clear, articulate responses. Lists and bullets are better than giant bricks of text. Here are some suggested formats:
- where we’ve been
- where we’re we are today
- where we’re going
- possible cause(s)
- fixes tried so far
- next steps
4. Ask Yourself, “Am I Forgetting Anyone?”
Messages have senders and receivers. Your message will fail if you don’t include all the appropriate recipients. Failing to do this can result in people being blindsided or sometimes having their feelings hurt; people can get that left-out feeling. Also, you may be stepping on someone’s toes. You may be doing their job and they might not like that.
5. Let Someone Else Handle It
Don’t be over-eager. If you know someone else in the email chain can handle the problem and is likely to be pro-active, don’t beat them to the punch. Let them reply. Whatever you do, don’t add to the problem by sending a message saying “I think Bob will reply, so let’s wait for his answer”. We need to fight the collective ADD that is sweeping the nation. Just wait a few moments and let the other players make their contribution.
6. Avoid Attachments
One of the biggest annoyances of corporate email is the size limitation on your inbox. I swear, they all seem to be less than Gmail. You don’t want to be the person who put someone else over their size limit, so take measures to avoid or at least minimize attachments. You can post documents to servers and then send links to them, or you can zip files before you attach them. You could also just announce the presence of a document and instruct recipients to email you if they want a copy.
7. Keep Your Signature Short
If your signature is longer than most of your messages, you have a problem. Here’s the basic format I recommend:
Legal Disclaimer (only if absolutely required)
It would be a pleasure to hear from you on the above rules..Your comments / suggestions will be highly appreciated.
Locking Down Cells in Excel
To lock cells containing formulas in excel. Select all cells within a sheet and select Format Cells . Go to the Protection tab and unselect locked and then Okay. Next, select the cells you wish to protect, go back to format cells. Now select “Locked.” To apply the changes, select File, Protect Workbook, Protect current sheet. Enter a password and ensure there is only a checkmark on “allow select unlocked cells,” then select Okay. Reenter your password.
Use Groups to Tie a Range of Cells Together so they can be Expanded/Collapsed
When working with large sets of data, improve your workflow by grouping cells. Select the rows or columns you wish to group, select the Data tab, select Group, then select either rows or columns. Use the + or – symbol on the left to expand and collapse groups. You can also create subgroups of data as well as determine subtotals.
Have you ever used groups - Share the applications where you can use the same or already using
Asking questions can create patterns of activity that compound daily into solutions, for better and for worse. Instead of asking "What job can I find today?" what if you asked, "What kind of job can I create today?" The slight twist of one word, from find to create, might hold the key to more helpful answers.
To guide your job search, try a simple exercise we call "questionstorming." Take four minutes a day to write down nothing but questions about your job search. Doing this consistently for thirty days will take you down new paths as your questions change and your patterns of action follow. For example, an executive in his mid-thirties and in a career transition began by asking "How can I make a bucket of money?" Over time, that question changed to "What will make me happy for the long term?" Which then changed to "How do I create something for the long term?" As a result, he's moved into different kinds of job interviews, landing one with a big multinational company that otherwise would never have happened had he not changed his question.
The methodology does not end with your job search , It is equally applicable in all the processes we are part of ....Job search can be one.
Knowledge is having right answer, Intelligence is asking the right question.
We welcome you on management wall!!