I just got another great question from a student in my Microsoft Excel course on Udemy.

The question deals with automating a conditional check using VBA. One way to accomplish this would be create a custom function using VBA. I put together a quick video describing the...

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 u...

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...

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 SharePo...

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%,...

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...

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...

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 forma...

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...

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...