How To Use Nested If Statements In Microsoft office Excel And An Alternative VBA Solution

A common task in Excel is to define category names based on values; for example, grouping test scores into grades. A standard formula in Excel can do the job for a simple if then else scenario, but for multiple selections, the syntax can become complicated.

Let’s look at a simple set of test scores and the formula in the adjacent cell to define the result as passed or not achieved.
45 =if(a1>=50,”Passed”,”Not achieved”)

Excel And Nested If Formulas
The problem occurs when we need to assess values based on multiple ranges. In our example, if we wanted to assess a score of between 50 and 65 as “average” the following formula applies:
=if(and(a1>=50,a1

But this formula doesn’t allow for scores outside the “average” range such as the criteria for assessing scores below:
Below 50 = “Not achieved” 50-65= “Average” Over 65=”Above average”
The formula for applying the above conditions is complex:
=IF(A1=50,A165,”Above average”)))

Clearly, the nested formula can become cumbersome and difficult to debug so let’s look at an elegant VBA alternative.
A VBA Solution For Assessing Multiple Ranges

There are several different methods for assessing multiple values in VBA, but the one we’ll use is the select case method.

One of the best things you can do when writing VBA code is to reflect on the code and consider how easy it is to follow. First, we’ll select a column to assess and to make the code easier to read, assign the grade column and the number of scores to their own variables.

Range(“a1”).CurrentRegion.Columns(1).Select
gradeCol = Selection.Column + 1
items = Selection.Count
Now, we’ll loop through the selection and assign a grade to each score.
For x = 1 To items
test = (x)
‘ we don’t really need to reset the grade variable but it’s good practice to do so.
grade=””Select Case test
Case 0 To 49
grade = “Not achieved”Case 50 to 65
grade = “Average”Case 66 To 100
grade = “Above average”
End SelectCells(x, gradeCol).Value = grade

Next
Points To Note
Using a VBA solution rather than a direct Excel formula reduces the chance of error but a clear disadvantage is that the grade is not updated if the scores are adjusted in the future. One option to address this issue could be a VBA worksheet_change event so that whenever the scores were changed, the code would be repeated.
A more challenging solution might be to develop code which would create the formula as text and insert it into the applicable cells.

Summary
This scenario involved balancing the option of the correct solution – an Excel formula – with the use of easily written VBA code. It’s an example of where Excel users need to make decisions based on their knowledge level and the issue being addressed.

For more information click here : office.com/setup

Content Source :http://officecomoffiice.com/blog/how-to-use-nested-if-statements-in-microsoft-office-excel-and-an-alternative-vba-solution/

In music classroom without instruments, an ensemble of apps play bandleader

At Kaenoisuksa school, in Chiang Mai, Thailand, we face the unique challenge of bringing music education to roughly 600 students who don’t have the benefit of real instruments to practice with. Adding to the complexity, our student body is a diverse mix Shan, Yunnan and Lahu students who all bring a different set of cultural values and learning techniques to the classroom every day. Our curriculum has to be nimble if it’s going to serve all of their unique needs.

As the school’s music and dramatic arts teacher, it’s my job to find educational solutions that will strike a chord with my students. In the common smartphone, I found a tool perfectly fit for the job—so long as it was equipped with the right apps.

Learning music isn’t just a matter of knowing how to play this song on that instrument. Using Microsoft apps like Office, Sway, OneNote, PowerPoint, Windows Movie Maker and others, I weaved together a 21st-century lesson plan that covered a range of musical topics, from theory to technique to history and cultural context. I call it Mobile Music Learning, and through it, my students have learned both the fundaments of music education as well as the value of technology in exploring their own questions in their own ways.

Things That Worked in My Classroom

• Mobile VR Thrills: My students loved exploring international music and concert videos with apps like WITHIN and YouTube VR, which help turn your mobile screen into a virtual-reality headset. Access to music videos—from Operas in London to Indonesian dance routines in Bali—seeded them with questions about instruments, dance and other cultural elements that led to lively discussion as a class.
• Strum Your Screens: Countless apps will turn your phone into a real-live instrument, replete with keys, strings, skins or some other music-making analog of your choosing. This let students get their hands a little dirty with playing where they otherwise wouldn’t have been able to. Even better, they got to do so from home long after class was over—and on just about any instrument they could think of.
• Tech Does Double Duty: I want my students to learn music education, of course, but through it, I also want them to learn tech fluency. They are emerging into a world where success will depend on their ability to confidently navigate tech tools. Employing integrated apps like Microsoft Sway, Word, PowerPoint and Windows MovieMaker to explore, share and present the material helps them build that confidence along the way.

Practicing an instrument on a smartphone may seem like a novel concept, but for my students, a familiarity with mobile devices meant they brought more confidence to the initial lessons than they might’ve in a class with traditional instruments. The portability of our devices also empowered them to continue exploring the lessons for themselves once class had finished.

By applying the tech tools they’re already familiar with, I encouraged my students to explore, and ultimately synthesize, the subject matter in ways that felt natural to them as digital natives. The result was not only a newfound appreciation for music education but also the fostering of a rich and informed dialogue about other related subjects.

The Mobile Music Learning curriculum I created is little more than a collection of everyday Microsoft software applications. On their own, any one of the apps provides an important, specific tool. When combined in symphony, though, they strike a harmony that is greater than the sum of their unique parts. For my students, that approach helped fuel a modern, imaginative curiosity that made the curriculum more engaging and the group discussion more meaningful.

Content Source :http://officecomoffiice.com/blog/in-music-classroom-without-instruments-an-ensemble-of-apps-play-bandleader/

Microsoft Says Office 365 Helps Companies Stay Compliant With Laws And Regulations

Microsoft continues with their campaign to show how Office 365 is the most secure and pleasant proficiency programming pack available. Business fathom that they need to seek after government laws concerning insurance and security, and consenting to those laws can be costly. Microsoft is pitching Office 365 as a way for associations to cut a bit of the costs of their consistence approach. Since Office com setup is incredibly pleasing and attempted to be improved to remain predictable, associations can rest ensured that they are following pertinent security laws.

office.com/setup

Security laws spread touchy information which could hurt buyers whenever misused. This is the reason there is a great deal of government guidelines in the US and the EU overseeing how information is to be taken care of and put away. Microsoft has a group working with Office 365 to keep their product in accordance with the law. The group at Microsoft constantly examines the laws as they change and tells the item group to make acclimations to remain in consistence with the law.

Consistence affirmation, for example, HIPAA, which was set up in 1996, is a US law administering how human services information is dealt with, and Office 365 meets every one of the necessities to be HIPAA consistent. In the EU Microsoft has gotten a letter expressing that office com setup undertaking cloud contracts fulfill the high protection guidelines. Notwithstanding government guidelines, Microsoft is likewise working for affirmation with ISO (International Standards Origination). ISO has a few unique affirmations which can be accomplished by having legitimate information taking care of and putting away methodology.

These distinctive principles and systems cost cash for organizations to hold fast to, so it sets aside some cash when changing to Microsoft’s undertaking administrations who have effectively taken the necessary steps to get guaranteed and agreeable. Clients have saved money overall 6.8% in consistence costs, 10.7% in time spent on eDiscovery, 73% abatement in the quantity of information breaks, and 32% decrease in the expense of the information ruptures which occurred. This makes Office.com/setup an incredible beneficial arrangement, yet additionally one which will give more assurance, greater security, and cost funds.

Content Source :http://officecomoffiice.com/blog/microsoft-says-office-365-helps-companies-stay-compliant-with-laws-and-regulations/

How to Find Your Forgotten Email Address? – office.com/setup

It is worth noting the fact that the mails which you send to others always have your email address. In case you have forgotten your email address and want to recover it, then go through this blog.

Here’s how to get your email address

The general steps for searching forgotten mail address

1. Firstly, go to compose mail.
2. Then, find an option called From. On that line itself, you shall get the mail address of yours
3. If by chance, you do not get a From line, then you require reading this blog a bit more.

By using an Echo service for viewing your mail address

1. Firstly, go to a new mail message.
2. Then, put echo@univie.ac.at in To location. The subject or text is not compulsory
3. After that, click on Send.
4. Give some time and, then open the mail from Vienna University Echo.
5. Then, search your mail ID in the To line. It shall be towards the above.

The rest of the process differs according to the service that you use.

The method of finding a forgotten AOL mail address

1. Firstly, begin a new mail by tapping on Compose.
2. Then, look on the default sending mail address. It shall be next to your name on top of your To line.
3. By chance, if you get more than one address, click on the address that you would like to use. Each one of it belongs to you only.

The method of finding out the forgotten mail address in iOS mail

1. Firstly, go to the Settings application.
2. Then, visit the Passwords and Accounts section.
3. In the parts of Accounts, click on the mail account that you like.
4. Lastly, look at the mail ID of a particular account. It shall be towards the above of the display.

The method of finding out the mail address in Outlook

Go through the given below instructions for knowing the mail address in Outlook for Windows:

1. Firstly, compose a mail by pressing the combination of ctrl and N together.
2. Then, view mail address in the From line.
3. After that, press From to view other mail addresses that you can use.

Go through the given below instructions for knowing the mail address in Outlook for Mac:

1. Firstly, choose Outlook.
2. Then, press on Preferences from the menu of Outlook.
3. After that, go to the Accounts section from Personal Settings.

Lastly, search the address for every account mentioned below its name.

Bob Martin is a self-professed security expert; he has been making the people aware of the security threats. His passion is to write about Cybersecurity, cryptography, malware, social engineering, internet and new media. He writes for Norton security products at office.com/setup.

Content Source :http://officecomoffiice.com/blog/how-to-find-your-forgotten-email-address-office-com-setup/

Office 365 subscription transition has been very effective

www.office.com/setup – Over the past couple of quarterly outcomes, Microsoft has been reclassifying its prosperity by its developing numbers in cloud-associated administrations. While Windows authorizing still records for huge segments of what Microsoft puts in the bank, items and administrations, for example, Azure and Office 365 have been standing out as truly newsworthy starting late.

In any case, to the normal onlooker, discuss income, pennies on the dollar and benefit in the billions in some cases eclipses exactly how viable Microsoft has been at changing over conventional box buys of Office com setup into a month to month membership generator.

The people over at The Montley Fool have assembled an astonishingly basic see why Wall Street brought Microsoft’s stock up in lieu of declining Windows licenses income, botched chances in portable and inferior Xbox One support deals. Scouring through a portion of Microsoft’s SEC filings, The Montley Fool has uncovered Microsoft’s quarter over quarter development with its Office.com/setup administration.

Office Com Setup

As indicated by the discoveries, Microsoft has gone from 4.4 million 0ffice 365 endorsers in 2014 to 18.2 million supporters before the finish of Microsoft’s 2015 monetary year. The increases per quarter have seen bounces from a simple 1.2 million of every 2014 to 3 million a quarter before the finish of this late spring. What is increasingly great, is that the numbers are intelligent of buyer interest for Office.com/setup.

Seemingly, Microsoft’s meat and potatoes lay inside its capacity to pitch its administrations and equipment to organizations. Be that as it may, with the rush of convey your-own-gadgets proceeding to flood in business, Microsoft’s Office 365 memberships might encounter the additional advantage of shoppers mixing their work existence with their business life.

Content Source :http://officecomoffiice.com/blog/office-365-subscription-transition-has-been-very-effective/

How To Watch Movies Through Google Drive? – Office.com/setup

Google Drive is incredible because it is helpful for plenty of things. Not only can you store your documents, pictures, and backup your videos, but you can also do a more more. For instance, you can watch movies through it. One of the best parts is that it can also be used for downloading films and TV shows to your system.

Steps to watch movies through Google Drive

The method of playing, saving and downloading Google Drive Movies

1. Firstly, press the link for visiting Google Drive film file.
2. Then, you shall be taken to the player display.
3. After that, click on the Play symbol for watching the movie.
4. Then, if you wish to download a film, then you require to press on the symbol of Download. It shall be an arrow pointing downwards.
5. Next, for saving the movie to Google Drive, press Add to My Drive symbol.
6. Note that after a movie is put to a Google Drive, you may download it later on whenever you want. For doing it, look for the file within the Google Drive and press on it for opening an additional options menu. Lastly, you need to choose the location wherever you would like saving it.

The method of Downloading Google Drive Movies by using Google Backup and Synchronize

1. Firstly, do the Back up by downloading and Synchronize application from Google.
2. Then, do the installation of the application.
3. After setting up the Backup and synchronize, you may view the symbol of application in the menu bar. Choose it for looking at the overview of actions. Next, press on the three-dot options menu.
4. After that, press on Preferences.
5. Then, press on Google Drive. It shall be in the Backup and synchronize.
6. Lastly, check that the Google Drive movie or movies shall get downloaded in the background of your system.

The method of playing Google Movies that are saved in PC

1. Firstly, visit the VLC website.
2. Then, press on Download VLC.
3. After that, install the application.
4. Next, open VLC.
5. Then, place the movie on your system.
6. After adding it, the movie shall by itself start playing.
7. Note that the movie shall be in the VLC playlist till you won’t be able to take it out from it.

You shall be able to play more movies by first clicking on File. And next by pressing on Open file by using the file picker.

Howdy, I’m Nick. I’m a software engineer living in Manhattan, New York. I am a fan of technology, photography, and design. I’m also interested in music and blogging. You can visit my website office.com/setup.

Content Source :http://officecomoffiice.com/blog/how-to-watch-movies-through-google-drive-office-com-setup/

Office 365 For Mac Now Lets You Insert And Rotate 3D Models In Word, Excel, And Powerpoint

www.office.com/setup – Mac users would now be able to get imaginative with 3D models following the current week’s update for Office 365 for Mac. In the wake of introducing the most recent variants of Word, Excel and PowerPoint for Mac, Mac clients will probably embed 3D models from nearby documents or Microsoft’s Remix 3D online library.

office.com/setup

3D models ought to show up on the Insert tab of the Office strip, ideal to Shapes and Icons. In the wake of including a 3D object in a Word, Excel or PowerPoint report, the three Office.com/setup will give you a chance to pivot or tilt it toward any path, much the same as you can in an application like Paint 3D on Windows 10.

Notwithstanding support for 3D models, this most recent update for Office 365 for Mac additionally given you a chance to install your custom textual styles in your documents in PowerPoint. The more innovative clients will likewise be satisfied to realize that they would now be able to utilize their mouse or contact cushion to attract with ink Word, Excel and PowerPoint.

office com setup

All these new highlights require an Office 365 membership, and 3D models are just upheld on Mac OS variant 10.12 or more current. You can get familiar with how to begin with 3D models on this help page.

Update: We’ve altered this post to elucidate that these highlights are just accessible to Office 365 supporters, not Office com setup 2019 for Mac unending clients.

Content Source :http://officecomoffiice.com/blog/office-365-for-mac-now-lets-you-insert-and-rotate-3d-models-in-word-excel-and-powerpoint/