Skip to main content

Posts

Showing posts from 2022

Long collection of scientific evidence supporting the risks of cell phones

I spend a lot of time on the computer since I am an IT professional. Even at night, when I should be unwinding and avoiding blue light, I use computer. Modern computers undoubtedly have provided countless benefits, but they also have their share of issues. The Effects of Computer Use on Health- My primary worries regarding extended computer use are: Exposure to blue light (Mainly at night) Heat generated by the machines Exposure to electromagnetic radiation Concerns about posture when seated I firmly believe that we should use technology, just make sure to do it safely. Since technology isn't going away any time soon, I sought to identify strategies for minimizing its drawbacks and dangers. I've discovered solutions for each of the aforementioned risks, so I feel more secure using a computer now. Exposure to blue light Numerous studies have shown that blue light exposure after sunset can impair circadian rhythm and reduce melatonin production, but more recent research indicates...

Top 10 facts about iPhone 14 you should know before making a purchase decision

Well, it's not new to have several rumors flowing in the air whenever apple announces a new model release for an iPhone. We are here to review and update you that how many facts out of those are true or turn out to be false. You might heard already that the principles of the leaks were accurate: there will be four new iPhone 14 variants, none of which will be "small" versions this year, but there will be a new large-screen "Plus" model that will be more affordable than the Pro Max. Here is a brief summary: iPhone 14 Pro Max :   Available in below four colors, with four storage options (128GB, 256GB,512GB, 1TB), Starting from $1549, goes up to $2239, A16 chip, big battery & triple camera. iPhone 14 pro :  Available in same four colors, storage options, Price starting from $1399 goes up to $2089, 6.1” 120Hz screen, Again A16 Chip and triple camera   iPhone 14 Plus :    This model comes in below 5 shades, with 3 storage options- 128GB, 256GB & 512GB...

How to create a canvas app using a Power Apps sample templates

In this article, you will get a step-by-step process to create a canvas app through a sample template.  Since this is just a basic start, after creating your own form, you can take deep dive in to the several internal functionalities and explore the different designs you may like to use or apply to you form. So, let’s start!! Start with signing to your Power Apps account. Remember if you don’t have account, you can try this function through 30-days trial period Now once you are signed in, click on Create option from the left-pane. It’s easy to spot options on Power Apps After clicking on Create button, you will see an option Start from template, click on that and select a sample app from the available list such as Meeting Capture Please note you can also use search box to look for the specific template you desired.      4. On the next step, you will have to provide the app name you want. Please enter and click Create       5. After that, your a...

Amazing apps to make student’s life more manageable

Since we all know that technological advancement made a mark on everyone’s life, and students are not left unaffected. Be it massive project assignments or online learning classes, students need to have cutting-edge software to make their life effortless. Supernotes Things 3 This application allows people to collaborate and document their memos in notecards. Further, you can create your task list and ideas in excessively efficient note-taking the nuisance. I love the structure, and card design, somehow the layout is more straightforward on the cognitive front. Pulling up corresponding cards is much more manageable than say Roam, Craft, and other apps.   Todoist Todoist is another fan favourite within the efficiency space and rightfully so. It could be an awesome assignment director with cross-platform support and coordinating with many of your other instruments. Todoist features a liberal free arrange, alongside a few other Master plans that are as moo as $4 per month. Numi A str...

After $50 million funding led with the aid of IIFL made Neobank Open unicorn

 Advisors briefed on this matter commented that along with the existing investors Temasek, Tiger Global & 3one4 , Neobank Open has finalised a $50 million financing led by IIFL Finance. With this huge success, open has been included in the unicorn club that now has a valuation of $1 billion. It has already been reported by ET last year during December that this has been a plan of Open for the very long time to raise funding of around $100-$150 in this round and has been preparing for this big event rigorously which has now been finalist with a $50 million funding strongly led by IIFL Finance. Isn’t it awesome? Team involved in the plan has commented that in future, open will utilise the newly earned capital and IIFL Finance’s business plan & strategy knowhow to expand a lending business further and reach new boundaries. The spherical  comes on the  lower back  of Open  elevating  $100 million in a funding  spherical  led  by ...

How to blur your background or addustomized background in Microsoft Teams..

This is an amazing feature of Microsoft Team where you can alter your video background or anything else you like. This is very helpful feature when you are in your engagement and someone strolls behind you by an accident, it will blur the entire background hence no one will be visible in your background during the call. Needless to say, you will feel more ready and less oblivious. When you click on join meeting, it will land on you on the page where you adjust your Audio and Video before entering the call, on the left-hand side of that window you will see your video and  Background filters  option available right under it. (Refer to the below image) Just click on Background filters . Once you click on that option, a new Background settings window will appear on the right of the window (Refer to the below image) Just select  Blur  as selected in the above image, and you are done.  You can also add images available under these options or can also add customize...

How to create a webinar through Microsoft Teams with customized registration form for attendees

Microsoft Teams has a great range of features. Not only do they help us to schedule a meeting and connect with your co-workers instantly through chat or call, but also you can access your files stored on Microsoft cloud instantly when & where required. But here I am going to tell you about the feature which allows you to plan a webinar through Teams following simple steps, and you can also add customized forms for attendees to fill out to register for the webinar. I will show you how to schedule a webinar and add a response form to it for attended: 1. Start with going to your Microsoft teams and select Calendar from the left Panel. (Refer to the below screenshot) 2. Now on the right top-hand side, you can see a down arrow near the  New meeting  button. You will get three choices by pressing that arrow button which are Schedule meetings, webinars and live events. Please click on  Webinar . 3. In the next windows, you will have several options. We will start with cre...

How to locate your meeting link in Microsoft Teams

1. Open Microsoft Teams and go to your calendar 2. On your calendar, you will find a Meet now button on the top right-hand side of your screen, click on that (Refer to the below screenshot)   3. When you click on that, a new window will appear. Please select Get a link to share (Refer to the below screenshot) 4. You will get your meeting link. You can either copy or share the same through mail from that window. That’s all. Keep learning, Keep improving.

‘Countifs’ formula in excel and how to use it

Now you might be already aware of the countif function that most people use for their reports and excel sums. Again as I have explained in my previous blog about sumifs function ,   the ‘ countif’  function can fetch data using one exception whereas ‘ countifs’  can match up to 29 criteria.  Here, i will demonstrate you this function with the simple example: Example1 . Below is the table we will be working on in this tutorial: As you see in the above table, we have Year , Product , country , and total Sales . From this data table, we want to get our total sales using different criteria available in this table.  In the above table, we need count of Red trolley Bags in the year 2019 Here is the formula syntax: COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2, criteria_range3, criteria3, … criteria_range_n, criteria_n] )” In the above example, since we are looking for count of product Red trolley bags in 2019 . Next, we have the first...

‘Sumifs’ function in excel and how to use it

This must have occurred with you multiple times in the office while preparing excel reports when you need to bring particular values from the massive chunk of data based on specific criteria and requirements. Essentially, if you ever want to make a sum with exceptions and specifically, if these exceptions are more than one which is typically the case in actual life. This is when 'sumifs' function in excel comes handy. Now you might be already aware of the ' sumif'  function that most people use for their reports and excel sums. However, ' sumifs'  is there in the system since Excel 2007 version, and many of us may have just skipped this. It is not only a time-saving function but also assists you to fetch data from large data arrays using several criteria in one go. while the ' sumif'  function can fetch data using one exception whereas ' sumifs'  can match up to 29 criteria.  Here, i will demonstrate you this function with the simple example: E...

How to apply conditional formatting icon to a text in Excel...

This is a very fascinating feature of excel to visualize your data and make it more constructive and impressive to the viewer. Let’s begin: We will be using the below table to demonstrate how to add icons to your data in excel Assume we want to ascertain our target status in the above table more visual with the help of  icon Sets  from the format conditioning Here is the code table. For instance, we have assigned -1 to depict target status as  Not Met , 0 to show  Met  and 1   if the target is  exceeded.  And   we want to assign format icons to these classes as per the below table: Now we have to convert Target Status numbers to text values ( Met, Not met & Exceeded) which we defined earlier and, we will do the same with the help of custom formatting. Step 1. Select the entire column and right-click. Select  Format Cells  from the available options  (Refer to the below screenshot) Step 2 . A new window will appear. Please...