The IF function allows you to check if a certain criteria is true or false. It is a very common business function and this video will help you to understand its uses and how the function works. By the end of the video, the following should make sense: Logical Criteria, Video = “Good”, True – leave me a good rating and comment, False – rewatch the video, lol…and leave me a comment with your question and I’ll make it better:)
Course: Excel Essentials
This course uses realistic business scenarios to show practical application for each technique. It is a comprehensive overview of the critical functions, applications and concepts necessary to proficiently use Excel.
Many people say they “know Excel” but after going through this course, you really will! The learning style includes on screen visual tips and directions to better accommodate visual learners. The audio style is casual and laidback to provide a little extra entertainment and humor.
I hope you enjoy my course!
Sometimes your data is not organized in nice easy to read tables. Rather, it is all compiled in one single list and you don’t want to go bother the IT department about the data…so, you are going to have to manage on your own. This video demonstrates how to match multiple criteria in a lookup function to find exactly what you need – even when your data is not super organized. Master this trick and the IT worker may be asking you for advice next time! Ok, not likely but it’s still really cool:)
If you want more than two options for an If function, you are going to have to Nest one IF function within another. I call this “InFunction.” Oftentimes, your analysis may have more than two results and nesting one “IF” function within another “IF” function will allow you get as many different results as you want (well, technically Excel 2010 only allowed up to 64 IFs but do you really need that many “IFS” – there is probably an easier way…)
The And & Or functions are logical functions which are often used to evaluate certain business decisions. This video will help you familiarize yourself with these functions so that you can start applying them to real world situations.
This video explores how to combine the IF, AND, OR functions together. Business decisions often require multiple logic rules and being able to easily combine these functions together will greatly enhance your value. This video uses the logic function to see which employees get a raise based on certain criteria. Mastering these logic functions will help put you in the eligible for a raise category!
The Goal Seek functionality is great for finding target values. Often times, we want to know how many units to sell to break even, or what our selling price needs to be to make a certain amount of profit. Sure, we could do all the algebra to solve for it – but who wants to do that? Learn how awesome Excel can be with this powerful tool!
The Scenario Manager allows us to analyze the effects of multiple changes to our forecast. Oftentimes, we want to know what happens if the economy is really good, average or bad. This macro environment change affects many of our inputs. The Scenario Manager lets us easily manage these different scenarios to analyze our profitability (or any other variable of interest) under each scenario.
Data Tables are great for sensitivity analysis. Sometimes, one variable is so important to our model, that we want to see what happens if we change just that variable. Excel also allows us to change two variables when doing our sensitivity analysis.
This video demonstrates multiple ways of naming, inserting, and deleting sheets. Naming sheets can help you organize your data and lets your user know where to find information. Naming and inserting sheets is all fun and dandy but be careful when deleting sheets – This action can’t be undone! So save your workbook beforehand just in case;)
Hiding sheets is great when you want to leave data in your workbook but don’t want to present it to your audience. Naturally, you will want to know how to unhide sheets – not only for sheets you hid, but when someone else sends you a workbook. You never know what treasures you’ll find! Also, moving and copying sheets can help you save time by avoiding duplicate data entry and better organize your workbook.
