Blog banner
The IF Statement

The IF Statement

Excel tutorial

IF is one of the functions in the Logical function set of the Formulas tab in Excel. Its greatest use is for running a test and providing a response based on a true or false result. IF is quite a flexible statement and can be used in combination with many others, such as AND, OR, and SUMIF.

Author: Liam Phelan
0 Comments
Article rating: 5.0
Our Best Computer Cheat Sheets

Our Best Computer Cheat Sheets

Download Our Techie Cheat Sheets

All these keyboard shortcuts have been put together into nicely designed and easy to print cheat sheets which everyone can download for free. After downloading and printing them out, simply fold along the guide lines and glue at the ends to make your own quick reference desktop cheat sheet.‚Äč
Author: Liam Phelan
0 Comments
Article rating: 5.0
Quick Solutions For Everyday Problems in Excel

Quick Solutions For Everyday Problems in Excel

Speed up Excel

We’re in an age of Grab and Go technology for work. From hot-desks to constantly mobile staff, many of us are using laptops more and more to get stuff done. But when your work involves excel, the laptop track pad isn't always the most efficient option. Maybe there’s a faster, better, way to go. 

Author: Liam Phelan
0 Comments
Article rating: 5.0
Ground breaking new features in SQL Server 2016

Ground breaking new features in SQL Server 2016

This may well impact the entire Microsoft application software industry as they move from XML to JSON data.

Ground breaking new features in SQL Server 2016 and its impacts on industry.

SQL server 2016 offers a wide range of performance boosting features aimed to the modern workforce. In this post I will be discussing four key features which I find the most interesting.

Author: Liam Phelan
0 Comments
Article rating: 5.0
Using Outlook rules to control emails with different attachments types

Using Outlook rules to control emails with different attachments types

We run you through all the steps required

Outlook is great with rules for many different conditions but often lacking in dealing with attachments. Using VBA for Outlook you can take emails with attachments, rename the files, move based on type, or save the attached files automatically and remove from the email to save on mailbox size.
Author: Liam Phelan
0 Comments
Article rating: 5.0
Ransomware, what is that?

Ransomware, what is that?

Have you been locked out of your own files?

Ransomware is a piece of malicious software that can encrypt files on your computer, meaning you can no longer access them. Commonly you will just get a popup warning telling you are files are locked and here is how much you need to pay to get them unlocked. This is a Trojan attack which would usually come in the form of an email attachment or file.

Author: Liam Phelan
0 Comments
Article rating: 5.0
RSS
First3456789101112

Sign up for our Newsletter