September - 2017

Recent Posts

Archive

Tags

Microsoft Excel Dynamic Validation Lists

Microsoft Excel Dynamic Validation Lists

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

A Little SharePoint Humor

A Little SharePoint Humor

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

Creating Custom SharePoint Workflows with SharePoint Designer

Creating Custom SharePoint Workflows with SharePoint Designer

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

Udemy Course Certificate and LinkedIn

Udemy Course Certificate and LinkedIn

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

Schedule Microsoft Excel Tasks with Windows Task Scheduler

Schedule Microsoft Excel Tasks with Windows Task Scheduler

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

Microsoft Excel - Dynamic VLOOKUP() with MATCH() Function

Microsoft Excel - Dynamic VLOOKUP() with MATCH() Function

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

Microsoft Excel VBA - Play a sound based on a condition

Microsoft Excel VBA - Play a sound based on a condition

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 Common Shortcuts for Windows users

Microsoft Excel Common Shortcuts for MAC users

Microsoft Excel Array Formulas

Microsoft Excel Array Formulas

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

1

2