UdemyNewYearPromo.jpg
PaparazziAd-01.jpg

Recent Posts

October 3, 2017

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

September 30, 2017

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

September 29, 2017

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

September 28, 2017

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

September 18, 2017

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

September 15, 2017

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

September 11, 2017

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

September 8, 2017

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

September 8, 2017

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

September 6, 2017

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

Please reload

Please reload

Archive

Please reload

Tags

Please reload

FOLLOW

CONTACT

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb