Loads of FREE content on Microsoft Office Training

Monthly Archives: April 2016

Archive of posts published in the specified Month

Apr
19

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…

Apr
16

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…

Apr
16

SharePoint Introduction

SharePoint – A Quick Intro on How to Work with a¬†SharePoint Site So, you want to learn Microsoft¬†SharePoint. Maybe you’re just starting out with SharePoint. Maybe you just landed a new job and the office you work at uses SharePoint to maintain all…

Apr
12

Handling Errors in Your Excel VBA Code

It’s a fact of life, mistakes are going to happen. Whether the mistake is something in the code itself or a user interfacing with your code does something you didn’t anticipate. We just have to accept the fact that something is bound to…

Apr
8

Simple Excel VBA User Defined Lookup Function

Microsoft Excel is full of all sorts of useful and powerful functions. The function category of Lookup and Reference have several useful functions, including; VLOOKUP() HLOOKUP() INDEX() MATCH() Those four are perhaps some of the more commonly used Lookup and Reference¬†functions. There are…

Apr
5

Microsoft Excel Hack #2 – Deleting Empty Rows in an Excel List

If you’ve ever gone through a list of records and manually deleted empty rows, then this Excel Hack is for you. Use Microsoft Excel’s Go To Special command to select all the empty rows in a list and quickly and efficiently delete the…

Apr
5

AutoNumber Excel Records

I was recently asked how you could AutoNumber records within an Excel list. Below is one method that can be used to accomplish this task. Convert your Excel List to an Excel Table (HOME –> FORMAT AS TABLE) Insert the formula =ROW()-1 in…

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.