Filter Categories
All
Formulas
PivotTables
Power Query
VBA
Charts
Excel Tips
-
A unique use case for summing values, could be to sum formulas only in... -
There are a few methods to calculate age in Excel using formulas. In this...
-
This tutorial explains how to create a custom sort order in Excel with two...
-
The XLOOKUP function in Excel does not perform a case sensitive match by default....
-
There are two main reasons you should consider aggregating rows in Power Query: creating...
-
When using formulas in tabular data in Excel, you will need to copy a...
-
Everyone works with dates in Excel. Often a spreadsheet will contain multiple date columns....
-
A frustration with PivotTables in Excel is the automatic resizing of column widths that...
-
The rich data types make it easy to get a live currency exchange rate...
-
This tutorial will return non-adjacent columns with the FILTER function. Dynamic array functions such...
-
This tutorial will look at how to calculate moving average in Excel. The moving...
-
In this tutorial, we see how to sort by drop down list in Excel. We...
-
This tutorial shows some advanced SUM function examples. The SUM function is far more...
-
Excel does not display negative time. So if you are working with negative times,...
-
In this tutorial, we will use Excel formulas to lookup multiple values and combine...
-
This tutorial covers how to make table column references absolute. It will cover both...
-
Many Excel users are familiar with lookup functions such as VLOOKUP, INDEX and MATCH...
-
This tutorial will take you through the new Power Query custom data types in...
-
In this post, we look at how to import multiple Excel files that contain...
-
Conditional Formatting is an amazing feature of Excel. It is sure to create a...
-
Working recently at a large Internet company they needed to find how many words...
-
In this post, we look at a neat Excel VLOOKUP trick to select a...
-
Entering fractions in Excel can be confusing. When a fraction is entered, Excel converts...
-
In this tutorial, we will create a shrinking drop-down list using the dynamic array...
-
A common requirement in Excel is the need to compare two lists. In this tutorial,...
-
You can use a lookup formula to return the address of a cell instead...
-
Excel lookup functions such as VLOOKUP and MATCH are not case sensitive. They will...
-
You may require a multiple condition lookup formula in Excel to perform a lookup based on...
-
Dynamic arrays have been rolled out to Office 365 users that are on the...
-
A bar in bar chart is a great way to compare two values such...
-
This blog post looks at some productivity hacks for creating professional, consistent and awesome...
-
In this blog post, we will look at 3 PivotTable frequently asked questions. These...
-
In this blog post, we will explore using Conditional Formatting with multiple columns. And...
-
In this blog post, we take an in-depth look at the Excel VBA Find...
-
In this post, we will look at how to use the IF function to...
-
IF functions are some of the most popular formulas in Excel, and in this...
-
Creating a hyperlink to another worksheet in Excel is easy. But if that worksheet...
-
In this blog post, we will look at how to get the absolute value...
-
Create a line graph with a target range to easily visualise values that are...
-
In this blog post, we will create a macro to sort sheet tabs alphabetically...
-
In this tutorial, we look at how to import multiple Excel files into Excel...
-
In this blog post, we explore the secret Excel buttons that are hidden in...
-
Using message boxes in Excel VBA is an essential skill for a budding VBA...
-
In this blog post we explore how to replicate a VLOOKUP in Power Query...
-
The Excel VBA MultiPage control is a useful way of logically grouping the controls...
-
In this blog post, we look at how to unpivot columns in Excel. The...
-
In this blog post, we will look at showing search results in a ListBox...
-
With the FIFA World Cup 2018 starting tomorrow, excitement is reaching fever pitch. In...
-
One of the most common questions to receive in training is to consolidate or...
-
The SUBSTITUTE function in Excel is an awesome text function. It helps us manipulate...
-
In this blog post, we will look at how to create dependent combo boxes...
-
When learning Excel VBA, you need to know how to use loops competently. By using...
-
Do you want to learn the advanced Excel tricks that only the experts know? Stand...
-
The Evaluate function is a hidden secret that few Excel VBA users know. In...
-
Creating macros in Excel is a fantastic way to automate Excel processes and save...
-
The Excel SWITCH function was introduced in Excel 2016 (sorry not available in previous...
-
The Select Case statement can offer a neater and more concise alternative to nested...
-
Add a single checkbox to select all checkboxes on a worksheet with one click. If...
-
In this blog post we create a reverse FIND formula to extract text after...
-
Excel PivotTables do not refresh automatically when the data source is updated. Learn how...
-
Create a five star rating system in Excel using Conditional Formatting. This can be...
-
The GETPIVOTDATA function in Excel is used to query and extract data from a...
-
Nested IF formulas are extremely useful for complex decision making on a spreadsheet, but...
-
The CHAR function in Excel returns a character specified by a code, from the...
-
In this blog post we look at how to create a custom progress bar...
-
To be an Excel pro you must master these Paste Special tricks. Copy and paste...
-
An Excel Doughnut chart is a very popular way to measure progress towards a...
-
When your Excel formula is not calculating, or not updating, it can be very...
-
In this blog post, we create a geographic heat map in Excel using a...
-
If your spreadsheet contains a list of times, it is useful to group time...
-
The Immediate Window in Excel VBA is a very useful tool to help us...
-
The Excel MOD function is used to return the remainder after one number is...
-
In this blog post, we look at how to highlight the cells that contain...
-
When learning the VLOOKUP function, one of the things people can struggle with is...
-
Use wildcard characters in Excel formulas to perform partial matches on text. This can...
-
In this blog post, we look at 5 SUMPRODUCT function examples. This is one...
-
This blog post will take you through the steps to create a searchable drop...
-
This blog post looks at how to group worksheets in Excel, and a couple...
-
The WEEKDAY function in Excel is one of its many wonderful date and time...
-
Having to calculate date and time difference in Excel is a common task. Unfortunately,...
-
In this blog post we will uncover an Excel formula to count how many...
-
In this blog post, we look at creating an interactive checklist in Excel. The...
-
In this blog post, we look at how you can use your own icon...
-
You may be familiar with Conditional Formatting in Excel. Well, Conditional Formatting can also be...
-
I was asked recently in class how to extract a postcode from an address...
-
This blog post uncovers 4 Secret PowerPoint Tricks that will help you to deliver...
-
A very common task in Excel VBA is to find the last row of...
-
This blog post looks at using the IF function to display a symbol conditionally...
-
This tutorial explains an Excel formula to find the least frequent value in a...
-
You may need to count the occurrences of a specific weekday between two dates...
-
You may already be familiar with the Conditional Formatting tool in Excel. The amazing...
-
If you have ever tried to count cells by colour in Excel, you may...
-
If you find yourself creating projects on a regular basis, you should consider creating...
-
When creating reports in Excel, a common requirement is to report on a rolling...
-
This blog post looks at using an Excel formula to display the sheet name...
-
Euro 2016 is here and I have a Euro 2016 planner to share. The...
-
This tutorial will demonstrate how to export multiple sheets of a workbook into a...
-
A common Excel VBA requirement is to work with different files and folders of...
-
When using column charts to compare values, you may want to highlight the max...
-
The functionality in Excel to send a workbook via email as an attachment is...
-
VLOOKUP is an awesome Excel function. One of its limitations is that it can...
-
In this blog post, we will explore how to pick names at random from...
-
If you are responsible for analysing a list of URL’s in Excel, then you...
-
In this blog post, we look at how to pick a name at random...
-
The Excel TEXT function is used to convert a numeric value to text in...
-
When creating a timesheet in Excel you may need to calculate different rates of...
-
The women’s World Cup is currently underway in Canada and at the time of...
-
The COUNTIF function is one of the most useful functions in Excel. Its job...
-
You may have scenario on a spreadsheet when you want to sum negative values...
-
PivotTables are one of the most useful tools in Excel. They allow you to...
-
Add drop lines to a line graph in Excel to connect the data point...
-
This tutorial looks at how you can create a macro in Excel to export...
-
Custom Fields in Microsoft Project allow you to define your own fields (columns) for...
-
If you are sharing a PowerPoint presentation with others, you may decide to embed...
-
If you have ever tried to add a hyperlink to a userform, you would...
-
When using a PivotTable to summarise a large list of data, you may need...
-
In this blog post, we look at how to create a macro that will...
-
Using the SUM function to total a column of values is an essential skill...
-
When performing a mail merge from Excel to Word, your mail merge fields tend to...
-
Create a battery chart in Excel just like you see on your smartphone, tablet...
-
Drop down lists can be created in Excel to assist with data entry and...
-
In Excel, one of the PivotTable calculation options is to rank fields in a...
-
This blog post looks at how you can create a looping PowerPoint introduction. This...
-
Microsoft Project has many settings that control the behaviour of the application, and of...
-
In Microsoft Project you can display different project information next to the task bars...
-
When a range of cells are selected, Excel automatically displays formula results on the...
-
For Microsoft Project to accurately calculate your project schedule, you will need to specify...
-
With the FIFA World Cup 2014 in full swing. Today I have another World...
-
I have created a World Cup history dashboard full of fascinating statistics from the...
-
Animate a chart in Excel to create a cool effect for your charts. You...
-
I created a hangman game using Excel VBA for fun, and thought I would...
-
A common requirement in Excel is the need to separate text into different cells....
-
A common question from Excel analysts and enthusiasts on my courses is to count...
-
I am often asked in Microsoft Project courses how to automatically change the colour...
-
At some point you may need to sum the value from every nth row...
-
Creating a scrollable chart in Excel is a great chart trick for enhancing the...
-
Create a Histogram in Excel to graphically represent the distribution of data. It looks...
-
If a workbook contains many sheets you can create a table of contents to...
-
Having formula errors on a spreadsheet can be bad news. They look ugly, they...
-
Microsoft Project contains many fields for storing information about the tasks and resources of...
-
I have started to learn German as it has always been a goal of...
-
Your spreadsheet formulas are always shown in the Formula Bar of Excel. This makes...
-
Microsoft Project uses the duration field to calculate the difference between the start and...
-
When a change is made to a tasks schedule in Microsoft Project 2010, such...
-
When entering text into a document, MS Word wraps your text onto different lines...
-
When you spell check your Word documents, there are bound to be some words...
-
In this blog post, we explore five of the best date functions in Excel....
-
Timeline Slicers are a new addition to Excel 2013. They are a new filter...
-
Microsoft PowerPoint has revolutionized the delivery of presentations so much so, that it even...
-
In the latest version of Excel it has become your responsibility (if you choose...
-
Excel was created for the use of calculating and analysing huge amounts of data....
-
Written by Mynda Treacy of My Online Training Hub. Writing formulas can have you tearing...
-
This Excel badminton league table can be used to track team or player positions...
-
Display pop up text on mouse over of an image or some other object...
-
There are many ways to count with multiple conditions in Excel. These can range...
-
The team planner view was introduced in MS Project 2010. The view makes it...
-
One of the main reasons to create a macro in Excel is to make...
-
Microsoft Project provides many features for the management of resources in a project. It...
-
Excel contains 500+ functions and this list is constantly growing. There are functions to...
-
A Gantt chart is used to plan and track the progress of a project....
-
It is essential to have a fire evacuation plan. As a trainer I am...
-
A key skill in Excel training is to be able to lookup and retrieve...
-
Footnotes are text displayed at the bottom of a page used mainly for references...
-
A constraint is a restriction on the start or finish date of a task...
-
Worksheet protection is used in Excel to protect cells containing formulas, hide sensitive data...
-
Think you know your Christmas movies? Why not try this Christmas movie quiz. There are...
-
Blank rows in your Excel spreadsheet are undesirable and can make it difficult to...
-
I was asked today if it was possible to write an IF function that...
-
Following my Excel lottery number generator video I have had frequent requests for a...
-
My wife and I are expecting our first child in just 5 days now....
-
If you are working on a long document you may want to display each...
-
The popular data entry form was removed from the Ribbon in Excel 2010. I...
-
If you wish to protect the cells on a worksheet that contain formulas you...
-
The CELL function in Excel is very powerful and relatively unknown to many. Use...
-
When pasting data from another program such as the Internet into a Word document,...
-
Shortcuts will save you time when creating your Visio diagrams that you could spend...
-
I was asked yesterday how to highlight dates that were over 30 days old....
-
Due to popular demand, I have created an Excel fixture and league table generator. Following...
-
When inserting slide numbers at the bottom of each slide of a PowerPoint presentation,...
-
An interesting question came up during one of my consultancy visits last week. They...
-
It is possible to perform quick calculations in Excel without having to write any...
-
Outline tasks in Microsoft Project to organise your list of project tasks and make...
-
If you collect email addresses in your spreadsheet. You may want to validate an...
-
The TRUNC function in Excel is used to reduce the number of decimal places...
-
Got data in an Excel spreadsheet that you want to use to create an...
-
Set a baseline for your project so that you can track its progress against...
-
Are you looking to try and work faster in Microsoft Word. There are many...
-
It is very easy to see two presentations at the same time in PowerPoint....
-
Add a deadline date to a task to keep track of it's finish date...
-
A splash screen is a screen which loads when you open a program. A...
-
The photo album feature of PowerPoint makes it easy to create a presentation displaying...
-
By default, Word 2007 stores your documents in the My Documents folder. However, you...
-
The report filter is fantastic for analysing Excel PivotTable data. It allows you to...
-
Excel VBA offers many different ways to refer to ranges in a worksheet. One...
-
Visio 2010 makes it even easier to create drawings, and one of the main...
-
The OnTime method of the Application object in Excel VBA occurs at a specific...
-
If you import dates into Excel from another system, or from the web, they...
-
Microsoft Project has two ways of filtering its’ tables. There is the AutoFilter, similar...
-
When you enter a date into Excel, Excel will format it using its default...
-
The AutoFilter tool in Microsoft Excel enables you to filter a large list of...
-
The ability to insert video into presentations has always been an incredibly useful feature...
-
To take advantage of some of the more advanced features of Word, you require...
-
If working with dates in Excel you may need to find out how many...
-
The header and footer options in Excel are very useful for printing information related...
-
Mail Merge is, in my opinion, one of the best features of Microsoft Word....
-
A common problem when using Excel is handling duplicate entries. I am often asked...
-
If you are storing pictures in a list in Excel, then you need to...
-
-
Named ranges provide many benefits when using spreadsheets. They allow easy access to data...
-
Ever wondered how you can view your PowerPoint speaker notes during a presentation without...
-
The Data Validation tool in Excel can be used to validate uppercase entries. This...
-
This post contains the download of a stock control spreadsheet. The spreadsheet is used...
-
When working on a large document it can become difficult to quickly locate and...
-
When using Track Changes in Word, balloons are used to mark formatting changes and...
-
The Conditional Formatting tool can be used for some very cool tricks in Excel....
-
If you have used the Caption tool to label tables, figures or images in...
-
This tutorial demonstrates how to create a simulation of a dice throw in Excel. The...
-
I was reading the Metro newspaper home from work a couple of days ago...
-
I got a question yesterday asking how to play a movie and music at...
-
This post looks at using a couple of text functions together in Excel. The...
-
Have you ever been using Word and wondered where your top and bottoms margins...
-
Got asked in training yesterday if it was possible to select all the blanks...
-
By default, music in a PowerPoint presentation will end as soon as the slide...
-
You can insert a tick symbol in Word using the Symbol dialog box or...
-
Mail Merge can handle conditional rules such as If... Then... Else... to display different...
-
PowerPoint makes it easy for you to create new slide layouts in the Master...
-
I have recently been working on an Excel fixture list creator as it is...
-
A common question I hear when training Excel or browsing the forums is whether...
-
Change the default font in Word to prevent having the change it every time...
-
I am currently working on an Excel VBA project that requires me to check...
-
Protected View in Office 2010 is used to open any potentially dangerous files in...
-
I was presented with a problem yesterday where somebody had two sheets of records....
-
PowerPoint contains an in-built feature for you to import slides from another presentation. This...
-
After applying text wrapping to a picture in Microsoft Word you may have noticed...
