Skip to main content

Posts

How to add up\down arrow in excel..

Excel is a sea of very useful and compelling features. You just need to give proper time to explore and operate it in the best possible way. Here I am going to demonstrate how to portray your percentage data in excel in a way that not only looks professional but also, a great way to impress your colleague and boss with your reporting skills.  Let’s begin: Below is the sample table which we are carrying here to demonstrate this tool to you So, in this data table, in the ' Difference'  column we want to exhibit increase\decrease arrows to show if the sales went above the defined target or down. Step 1 . Go to the ' Insert'  tab from the menu and select ' Symbols'  from the right side. ( Refer to the below image) Step 2. A new dialogue box will appear with multiple options. Just choose required titles as shown in the below image and add both up & down arrows to your excel sheet. (Refer to the below image) Once the selection is complete, add both the symbols one...

Top 5 tips to keep calm before & during an interview

1. Consider it as a conversation It is a very common fact that overthinking makes anyone nervous, and most of us tend to make each interview a very big deal as if it is a once in the lifetime chance in our whole career. No guys this is not. Think of it as a normal discussion where you need to present your thoughts and prepare yourself accordingly. That’s it. Don’t overthink it. 2. Prepare the responses to the most expected questions Always be prepared for the standard interview questions such as, tell us about yourself? What are your strengths & weakness? Where do you see yourself in 5 years? why should I hire you? Preparing these questions means, you will have a good start at the interview which makes you more confident for the rest of the session.  3. Thoroughly study the job descriptions and predict the question, practice explanations beforehand It is always recommended to go through the job responsibilities and see if there is anything unknown you would have to dig in befor...

How to answer 5 common interview questions in a best way (With Sample Answers)

1. Tell me about yourself? Start with telling your name followed by explaining your strengths and skills you acquired over your work period in detail. Also mention what strategy you must achieve your goals. Sample Answer: My name is Nina as you already know. Over the period of my experience, I acquired several technical as well as interpersonal skills. I am very positive and love being at work. I have my personal goals which mean I have to perform to a high benchmark at my work in order to accomplish these goals. Further, I am overly attentive and organized, so if you give me loads of work and multiple projects, all will be done within deadline meeting with the necessary standard. 2. Where do you see yourself in 5 years? Rather then answering this question with one liner answer. Think and explain what progress you would see in your career in coming 5 years. Sample Answer:   Well, I am at a point in my career where I want to be with the same organization rather than switch...

How can you add a signature in Gmail for all replies and forward mails?

Gmail has consistently been a favorite email provider for most of the people these days. Not only this but also it is most preferred by all the small or mid-sized businesses around the world. I have Gmail account for since long and had a great experience using its services so far. Did you know you can also add default signature for Gmail emails as we do in outlook?  Follow these steps now to add your signature in Gmail. 1. First login to your Gmail account and click on the Setting button on the right top hand screen of the window and click on the See all settings option. (Refer to the below image) 2. On the next page, the cursor down the page and look for the Signature option and click on the Create New + button. 3. After clicking on Create New , it prompts you to give a title to your signature . Enter the name, click on the Create. 4. In the next window, enter your signature details and click on Save Changes, which is there at the footing of the page. (Refer to the below image) ...

10 most useful windows shortcuts you must know

Keyboard shortcuts are the best way to work efficiently and perform long tasks by pushing some key combinations.  1. Windows Key + E   Use this combination to open File Explorer. 2. Windows Key + I  To launch Windows Setting. 3   . Windows Key + I  Did you know you have Emojis panel available in windows 10. Try this combination to open the emoji panel. 4.  Ctrl + Tab  When we use a browser, we tend to open so many tabs and work on them all simultaneously. Try this combination to Move forward in the Tabs and user Ctrl + Shift + Tab to move backwards in the tabs. 5. Windows Key  + C  Quickly launch Cortana in the listening mode. 6. Ctrl + Shift + N  This shortcut is to create a new folder. 7. F2  Press this on the folder to rename it. 8. Windows Key + ,  Take a glimpse at the desktop while working on several applications. 9. Alt + D  Select the entire address bar in the browser. 10. Ctrl + Shift + Esc  Launch Task-...

How to build and use Microsoft Forms...

Microsoft provided us with many useful tools and applications, and Microsoft form is one of the finest apps we can use to capture surveys, polls and feedback from the customers or your end-users. It is a component of office 365, released in 2016. It is not only fairly simple to create a data input form with Microsoft, but also it is user-friendly and easy to navigate, which requires little technical proficiency to make a highly dynamic and creative form. Since it is a part of Microsoft 365, it will be free for you to use if you have active Microsoft 365 subscription. As we all know, data has become an essential part of any process or function in a small or big organization, and the Microsoft form application comes in handy when we need a tool to collect any kind of data from the end-users or customers.  Here I will demonstrate how to build a Microsoft form and manage data by using it. 1. Firstly, you need to log in to your Microsoft account if you are not already. (Please note Mi...

3 outlook features that you would want to try

Outlook is full of several exciting and fun features. We just need to dig a little to explore those functions and use them to make a most out of it.   1. Accentuate your searched keywords with the color of your preference When we search for something in the outlook, it shows so many results with the searched keywords. Do you know? we can create it more visual and underlined for us. That would enable us to pinpoint the desired results quickly. Here are the few steps you need to follow to make these changes. Go to the  File  option from the Menu bar and select  Options   Choose  Search  from the left side menu. On the right-hand side, you will notice many options. Under the  Highlight search terms in the results,  you can change the  highlight color  as per your choice. Click  OK  once done. 2. Updating Official working hours  This feature is excellent for working professionals. In Outlook, you can add your operati...