Articles written by: Cyrus Mohseni

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

Back to top