May 29, 2021
The Benefits of Office 365
With our Deploying and Managing Office 2016 with Office 365 webinar coming up next month, I thought it would be a good idea to make today’s blog post all [...]
Feb 07, 2021
Nintex: Read data back into a new Repeating Section control
We know that all the data provided in a Repeating Section is stored in a field. In effect, you are storing many records of tabular data into one single field. For this [...]
Dec 12, 2020
How-to: Redirect to a different page after adding new list items in SharePoint
Normally, to add a list item, users go to the List, click on new item to go to the NewForm.aspx page and then after they've added the information and clicked on [...]
Nov 30, 2020
Java: Extend or Implement? This is the question.
Quite often, new Object Oriented programmers get confused as whether to inherit from a Class or from an Interface. First of all, let me just explain that an Interface [...]
Oct 13, 2020
Remove all hyperlinks from an Excel sheet using VBA
You can remove all hyperlinks in an Excel sheet by writing only one statement in VBA and that’s: ActiveSheet.Hyperlinks.Delete Of course if you were to remove [...]
Oct 04, 2020
Nintex: Submit a form to a different page
When a user fills in a Nintex form and clicks on the Save button, Nintex saves the data and then displays the list or library page. Here, the user can see if the [...]
Sep 22, 2020
Create cascaded dropdowns in Nintex forms
Quite often in a Nintex form we need to populate a dropdown based on the value of another dropdown. For example we might need to select a value from a States [...]
Sep 13, 2020
How-to: Promote a Sub-Site to a Top-Site in SharePoint 2013
If you have a sub-site in SharePoint 2013 that you would like to disjoint from its site collection and put it right at the top of a new site collection, here are the [...]
Sep 05, 2020
How-to: Validate data based on the value of a different cell in Excel
You can get Excel not to accept a cell value if it falls outside a criterion. You specify the criterion in Data Validation located in the Data tab. The criterion, [...]
Aug 23, 2020
How-to: Import Appointments from Excel to SharePoint 2013 Calendar
If you have a list of appointments in Excel and you want to append them to your SharePoint calendar follow these steps: In Your SharePoint calendar click on [...]
Aug 17, 2020
10 steps to working better in SharePoint
Work more efficiently in Microsoft SharePoint by sending periodical document review email notifications to users. You can set email reminders to users to notify them [...]
Aug 11, 2020
How-to: Open an Excel workbook containing macros, without running the macros
Have you ever locked yourself out of an Excel workbook because you wrote a macro that kicks in automatically and then closes the workbook? This way you will never have a [...]
Aug 09, 2020
How-to: chart an equation in Excel VBA without producing a table
In Excel a chart is normally based on a table of data. Therefore, to chart a mathematical equation all we have to do is produce a table of two columns in which the first [...]
Aug 04, 2020
Create and use workflow templates in SharePoint Designer 2013
There are 3 types of workflows that you can create in SharePoint Designer. List Workflows: are attached to a specific List or Library and have access to all the items [...]
Aug 01, 2020
Social tagging in SharePoint 2010
SharePoint 2010 provides 2 options for tagging; I like it and Tags & Notes. Although they are normally used for private use, they have the potential to facilitate [...]
Jul 25, 2020
Formula vs. measure in PowerPivot
A Formula and a Measure are both calculations, but in general, you write a Formula to apply it to a PowerPivot Table whereas you write a Measure to apply to a PowerPivot [...]
Jul 21, 2020
How-to: Give access to a list only in SharePoint 2013
To be able to use a SharePoint List, naturally users first needs to get to the Site where the List resides. However there may be occasions when certain users are not [...]
Jul 12, 2020
Create cascaded drop-downs in Microsoft Access forms
In Microsoft Access, we are going to create two Combo Boxes whose values in one of them depend on the value selected in the other one. For example selecting a country [...]
Jun 27, 2020
Make a Form Read-Only in Access
Forms are interfaces that enable users to read from and write to a table. In Access, through forms you can show or hide what you want users to see or not to see. [...]
Feb 15, 2021
The magic of scrollbar control in Excel
By adding a scrollbar control to a Microsoft Excel sheet you can bind it to a range of values. As you scroll, the values in that range will be returned into a cell. You [...]
Feb 04, 2021
Convert a Column to a Link-to-Item in SharePoint
In a SharePoint List or Library by default, there is a column from which you can edit or view the properties of an item, e.g. column Title in the picture. This [...]
Dec 03, 2020
Hide Parts of a Page from Certain Users in SharePoint
In general, to manipulate a page’s behaviour in SharePoint you normally add a Content Editor web part to the page, and write appropriate JavaScript in it to accomplish [...]
Nov 12, 2020
Customise the navigation drop-down in SharePoint
Change the width of the top link bar navigation drop-down in SharePoint. When you have a sub-site under another sub-site, the top link bar will show you a small arrow [...]
Oct 27, 2020
On the Checkout Option in SharePoint
The Checkout option in SharePoint 2010+ serves two purposes. It controls incrementation of versions It disallows concurrent editing of an [...]
Sep 29, 2020
Cascaded Dropdowns in Nintex Forms
Quite often in a form we need to populate a dropdown based on the value of another dropdown. For example we might need to select a value from a States dropdown after we [...]
Sep 14, 2020
All About VLOOKUP() in Excel
Vlookup is a handy function in Excel. It is a quick and easy answer to lookup requests. It does exactly what we humans normally do when we look up something in a table. [...]
Aug 28, 2020
Show Excel Chart in SharePoint 2013
If you ever wanted to show your SharePoint users a chart or a table that is located inside and Excel workbook then read on. You upload the workbook to a document [...]
Jul 24, 2020
Create Documents Archive Repository in SharePoint 2013
You can create a Document Library in SharePoint 2013 to manually or automatically transfer your old files to, from any site in a site collection. In order to do this you [...]
Jul 07, 2020
Autofill to the Last Row Using VBA
Sometimes you require imitating the operation of Autofill to the last cell in Excel VBA. This is when you double click the little dot located at the right bottom corner [...]
Jun 23, 2020
SharePoint permissions on views using workflows
Another method to prevent certain users from viewing some documents or items is to directly apply permissions on the items themselves. Item level permission overrides [...]
May 29, 2021
Recursive functions in VBA
In programming, you use functions for two purposes. You either want to reuse a piece of code over and over again, therefore you encapsulate it as a function, or you may [...]
May 05, 2021
Group data in ranges of values in Excel
Let’s assume you have a column full of numbers, as shown in Figure 1 below. Let's say you need to visually group the Quantity column into 4 groups or ranges as [...]
Apr 09, 2021
SharePoint permissions on views using [Me]
In a previous blog post, we looked at one way to apply permissions on views and discussed its limitations. If you need a view so that everyone sees items that are [...]
Jan 30, 2021
CHOOSE() function with arrays in Excel
The =CHOOSE function in Microsoft Excel can be a confusing, but today, I’ll provide a detailed explanation about this very handy function. In general =CHOOSE(index_num, [...]
Nov 27, 2020
Apply permissions on web parts in SharePoint
In Microsoft SharePoint, the only straightforward way to hide a view from public is to set it as a "Personal View." This way, only you can see the view and others can’t. [...]
Sep 30, 2020
Customise the Ribbon in an Excel workbook
We all know how to customise the Ribbon in Microsoft Excel by using the graphical user interface, but the problem with this way of customisation is that if you move the [...]
Sep 22, 2020
All about autofill in Microsoft Excel
You all agree that Microsoft Excel’s Autofill feature is one of the most popular and versatile features in Excel, however not a lot of people know about its full [...]
Aug 18, 2020
How to create a simple Waterfall chart in Excel
Microsoft Excel comes with a whole heap of different chart types and it is amazing to see that Waterfall chart is not one of them. A Waterfall chart is a column chart [...]
Aug 08, 2020
Easily delete blank rows from your data using Excel VBA
Quite often, you'll be required to remove non-contiguous blank rows to join ranges of data together. This is quite tricky to do in Excel, but I've explained how to do [...]
Aug 05, 2020
Keep your Excel formulas in place with dynamic named ranges
So, you have developed an exciting formula somewhere that works perfectly by extracting some value from a specified range and you are quite proud of it. Then one day, [...]
Jul 29, 2020
Returning multiple lookups using Excel's VLOOKUP
Excel's #vlookup function, like every other Excel function, returns only one value from a table. It looks up a table to find a row that has a key value in its first [...]
Jul 17, 2020
Remove blank rows in Excel with this VBA code
Quite often, you will find that you may have several table ranges in your Excel worksheet separated by blank rows that are undesirable. You also might even have a big [...]
Jun 30, 2020
How to populate tables in Excel VBA
There may be occasions where you need to populate an existing table with more data, and in such occasions, the first thing you would generally think would be "Where [...]
Jun 02, 2021
Borders and shading in Microsoft Word 2010
Don’t you hate it when you can’t get the borders to appear on all sides? Or when the frame of the border goes all the way to the edge of the margin when you really want [...]
May 29, 2021
3 programming tips in Visual Basic
As per the Microsoft Developer Network website, Visual Basic is engineered for productively building type-safe and object-oriented applications. Here are 3 tips I've [...]
May 01, 2021
How to access Office Applications from within VBA
Did you know you can access and manipulate any Office application from within Visual Basic (VB) code? In today's blog post, we'll go through the basic steps to connect [...]
Apr 24, 2021
How to link two lists in Microsoft SharePoint
Almost all information about an item, called a record, is recorded in small chunks of data called 'fields.' For example, information about an employee is [...]
Mar 03, 2021
A Closer Look at Excel PowerPivot and Power View
I'm sure that we can all agree that Microsoft Excel is an incredible application. You can do so much with it, but broadly speaking, there are 3 main functions that Excel [...]
Jan 06, 2021
Work offline with SharePoint Workspace 2010
If you are a SharePoint site member or a site owner who occasionally works from home, you may find it difficult to maintain a site or a library up to date simply because [...]
Dec 16, 2020
PowerPivot's CALCULATE function to the rescue
One of the most commonly used DAX functions in PowerPivot is the ‘CALCULATE’ function, and in my opinion, it's one of the most interesting functions because it’s a very [...]
Dec 11, 2020
Customising Layouts in SharePoint Designer 2010
Customising layouts in SharePoint has changed over time as newer versions are introduced so let's take a look at the differences between the 2007 and 2010 [...]
