Excel Help Blog

Full of helpful tips to help you get the most from Excel

Excel Top Tips

Arranging Workbooks

Arranging Workbooks

This quick video explains how to Switch and Arrange your Workbooks in Excel. Switching and Arranging workbooks allows us to work with multiple worksheets and workbooks at the same time. This is useful when comparing values on different sheets or viewing multiple sheet...

read more
Importing MS Access Data

Importing MS Access Data

This quick video will show you how to Import File Information from Access. Access tables can be imported and linked to Excel so that we can run reports or build charts based on that data. Learn how to link and import data from Microsoft Access. [et_social_follow...

read more
Adding text to a number format

Adding text to a number format

This quick video explains how to add Text to a Number Format in Excel. Sometimes it is useful to be able to create a custom number format that displays units in the same cells as the number – e.g. 100Kgs, 100 units and ask Excel to treat that cell as a number. Learn...

read more

Excel Foundations

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

Excel Formulas and Functions

How to use the SUMIF Function in Excel

How to use the SUMIF Function in Excel

This quick video explains how to work with the SUMIF formula in Excel. Learn how to work with the SUMIF formula to add up values in a range of cells only if a matching cell meets a certain criteria (particular sales person, region etc.). Sum up quantities based on a...

read more
Data Validation

Data Validation

This quick video explains using Data Validation in Excel. We can use Excel’s powerful Data Validation rules to ensure that data entered into a cell is of the correct type and range for the table it is being inserted into – we can restrict the values for a cell using...

read more
IF Statement

IF Statement

This quick video explains The IF Statement in Excel. Learn to use the IF statement – widely used in Excel when testing for a particular condition (is commission payable? Is it a Monday?) Learn when to use this function and understand when it is used. [et_social_follow...

read more

Excel Analyzing Data

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

Excel Charts

Change sparkline type

Change sparkline type

This quick video explains how to Change the Sparkline Type. The most common Sparkline is the ‘line’ – but there are three different types – Column, Win/Loss and Line sparklines. Learn how to change the sparklline type here. [et_social_follow icon_style="slide"...

read more
Delete a sparkline

Delete a sparkline

This quick video explains how to Delete a Sparkline in your Excel worksheet. Sometimes we need to remove a sparkline from a cell once it has been inserted. Deleting a sparkline has to be done from within the Sparkline Tools by selecting the Clear option from the...

read more

Excel Reporting and Dashboards

Importing CSV files

Importing CSV files

This quick video explains how to Import Text or CSV Files. CSV Files are one of the most common TXT file types you will come across. We are regularly required to work CSV files in Excel and there are a number of options that are presented when importing them....

read more
Manipulating imported .CSV data files in Excel

Manipulating imported .CSV data files in Excel

Manipulating Imported CSV Data Files in Excel. Let’s look at a scenario where data is given to you in .CSV format or already has been imported into Excel for you. It may be the case that you have a list of ID numbers, when they are pasted or imported into Excel, the...

read more

Excel Security and Design

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

Excel Recording Macros and VBA

Recording a simple macro to save yourself repetitive work.

Recording a simple macro to save yourself repetitive work.

The whole area of macros in Excel can be an intimidating area to start with but some things can be very straightforward. I thought it would be useful to publish some useful tips on our blog to give you a taste of what is contained in our online courses should you wish...

read more