Jump to content
Positive Zeal

Blogs

Featured Entries

  • Arpana Jain

    Raksha bandhan celebration with Ecofriendly Rakhi ideas

    By Arpana Jain

    The name of the festival, Raksha Bandhan is made up of two words, Raksha (Protection) and Bandhan (Relation). On this day, a sister ties ‘Rakhi’ around her brother’s wrist while the brother undertakes an oath to protect his sister until death. He vows to stand by his sister through thick and thin. Sisters tying the sacred thread around the wrists of brothers is a symbol of attachment, meant to strengthen their bond of love. More than a colourful, decorative silk thread, Raksha Bandhan has b
    • 0 comments
    • 485 views
 

Selecting range using F8 Key - without using mouse

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.

saurabhjain

saurabhjain

 

Use a Macro to Add Multiple Sheets

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 Sub Add_49_Sheets() On the next line paste: Worksheets.Add After:=Worksheets(Worksheets.Count), Count:=49 This line should be followed by End Sub N

saurabhjain

saurabhjain

 

Freeze Panes to See Headings When Working with Multiple Columns and Rows

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

saurabhjain

saurabhjain

 

Visualize data trends with Sparklines

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.

saurabhjain

saurabhjain

 

Filter and Sort Data in Excel

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.

saurabhjain

saurabhjain

 

Use Text to Columns to Separate Text (for example First and Last Names)

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.

saurabhjain

saurabhjain

 

Decision taker V/S Decision makers

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 !!!!

saurabhjain

saurabhjain

 

Is your organization ready for reverse mentoring ?

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

saurabhjain

saurabhjain

 

Great Ideas Bosses Never Hear - What to do when there are no takers?

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

saurabhjain

saurabhjain

 

Start networking to create a job (and stop networking to find a job).

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

saurabhjain

saurabhjain

 

Time Management "All of us don’t have time "

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

saurabhjain

saurabhjain

 

For all those employers who have everything under control - Why why why?

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

saurabhjain

saurabhjain

 

Up-skills practice - A Self-Management approach for your professional journey

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

saurabhjain

saurabhjain

 

Basic sets of Questions for managers - Management Questions

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. Basic Questions For all managers in any situation at any time - start with basic question list What Where When? Why? Who? How? How Much/ What if? These questions are universally applicable. If you ever in a situation where you need a question, or if you

saurabhjain

saurabhjain

 

The Leadership Vacuum Crisis

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 –

saurabhjain

saurabhjain

 

5 Simple Ways to Save Money as a Young Professional

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

saurabhjain

saurabhjain

 

Hierarchy of systems for developing sustainable processes in your organizations/ business

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

saurabhjain

saurabhjain

 

Let's take the Leadership resolution - Join the Self Management movement !

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

saurabhjain

saurabhjain

 

Overcoming Performance Stress -the one we all suffer from - at some point of our life

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

saurabhjain

saurabhjain

 

7 Rules for Email in the Office

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

saurabhjain

saurabhjain

 

Locking Down Cells in Excel

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.

saurabhjain

saurabhjain

 

Use Groups to Tie a Range of Cells Together so they can be Expanded/Collapsed

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

saurabhjain

saurabhjain

 

Start asking the right questions (and stop asking the wrong ones).

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

saurabhjain

saurabhjain



×
×
  • Create New...