QUESTION: “Is it possible to make one validation column dependent upon choices from another validation column?” Here’s an example; Imagine you have 2 columns in an Excel list, one column for the Make of car entries and another column for the Model of the car entry. If a user selects “Ford” as the make, when a model is selected they should only be able to pick from “Ford Models” (Mustang, Escort, Focus). If “Chevy” is chosen, then they should only be able to pick from “Chevy M

During the release of SharePoint 2010, Microsoft put out a website called “I Use SharePoint”. Today the site no longer exists as it did then, but it was a source of several great SharePoint 2010 resources, including the videos below. These video take a humorous look at the inner workings of the modern office environment and go on to explain how SharePoint can help fix the pain points we all feel. SharePoint Sticky Situation SharePoint Team Sites SharePoint Proposal Panic Shar

SharePoint Workflows are huge. The ability to automate a business process, such as submitting a document for approval, ultimately saves time and money. All you need to do is setup the initial Workflow and SharePoint will take over from there. In Section 8 of the SharePoint 2013 Complete Training course I demonstrate using one of the out of the box SharePoint Workflows, the Approval Workflow. This Workflow is great for a simple template based Workflow, but what if you had diff

First off, thank you for your continued participation in my courses on Udemy. Everyday I check my QA box, in my courses, and find loads of great questions. Keep your questions and comments coming! As many of you already know, when you complete a Udemy course, 100%, you'll receive a certificate of completion. You can get access to this certificate from the main page of the course. Just open the course and look towards the top of the screen. ​Next to the progress bar is a troph

I got an excellent question from a student in my Excel course hosted on Udemy. QUESTION: "How can you schedule Microsoft Excel automation?" I've paraphrased the question a little. The student has a specific task that needs to be schedule for daily output. But, in writing this post I want to make it a little more generic as this concept can be applied to loads of scenarios. GENERIC SCENARIO: Imagine you have a daily task that involves work within Microsoft Excel. Below are a f

A student, in my Excel Beginner to Advanced course on Udemy, recently asked an excellent question on Excel's VLOOKUP function. I thought I'd share the question and one solution here on the Office Newb blog. Standard VLOOKUP() Microsoft Excel's VLOOKUP() function is great. Perhaps one of the most sought after functions Excel has to offer. But, it has some limitations. Before we fix the limitation, lets take a peek into what VLOOKUP() looks like by default. =VLOOKUP(Lookup_valu

Using Microsoft Excel's IF() function and a sprinkle of VBA you can play a sound when a condition is met. Chances are you may have used Microsoft Excel's CONDITIONAL FORMATTING feature. (HOME -- CONDITIONAL FORMATTING) In the above example, cell A2 is conditionally formatted to turn red if the cell value is greater than 200. Conditional Formatting is a great feature. But, adding SOUND into the mix will increase the impact the message can have on the user of the document. Crea

Microsoft Excel is full of keyboard shortcuts that will speed up your production. Below is a link to the Microsoft site with loads of shortcut keys specific to the Windows version of Excel. Excel Windows Shortcuts I've taken the most common shortcuts and created a simple pdf for your reference. PDF of Excel Windows Shortcuts

Microsoft Excel is full of keyboard shortcuts that will speed up your production. Below is a link to the Microsoft site with loads of shortcut keys specific to the MAC version of Excel. Excel MAC Shortcuts I've taken the most common shortcuts and created a simple pdf for your reference. PDF of Excel MAC Shortcuts

Below is a quick video demonstration on Microsoft Excel Array Formulas. Arrays, simply put, are a collection of data. For example you may have a column of data in an Excel document. All those values, in range C2:C27, are a collection of data or an array of data. An array of data is great to have, but being able to retrieve data from that array is even more important. Now, imagine that collection of data is stored numerically by position. If I accessed the array and asked for