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
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, th
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
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
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 abo
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 goin
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 varia
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 questio
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
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 –
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 b
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 whe
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 for
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 h
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 g
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 s
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