Excel Help Blog

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

Excel Top Tips

Text to Columns

This quick video will explain how to split contents of a cell across multiple cells. Regularly when importing a text file – multiple pieces of data will end up in one cell – the Text to Columns option allows to us to split the contents of a cell across multiple cells....

read more

Freeze panes

This quick video will show you how you can Freeze a Row or a Column. As you scroll through your spreadsheet is often hard to know which row or column you are looking at. Freezing a row or column or both is a useful way to keep them onscreen and is a very useful...

read more

Importing Web Data

This quick video explains how to easily Import Data from the Web. More frequently we can find data we need to feed our spreadsheet online – learn how to import and link to web data using Excel. [et_social_follow icon_style="slide" icon_shape="rectangle"...

read more

Excel Foundations

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

Margins, Orientation and Page size

This quick video explains how you alter the margins, orientation and page size in the Excel worksheet. Within the page layout tab – there is a section called Page Setup which allows us to alter the margins, orientation and page size. Learn what these settings refer to...

read more

How to use Headers and Footers in Excel

This quick video explains sorting how to use Headers and Footers in Excel. When printing a long spreadsheet is useful to include headers and footers to display page numbers, dates and the document’s filename. The headers and footers option is in the TEXT section of...

read more

Excel Formulas and Functions

COUNTIF

This quick video explains how you use The COUNTIF Function in Excel. Learn how to use the COUNTIF function to count entries in a range of cells that meet certain criteria (e.g. values over a certain amount). Useful function to use when trying to avoid using a filter...

read more

Sorting and Filtering by Format

This quick video explains Sorting and Filtering by Format in Excel. Sorting and Filtering by Format Excel provides a powerful new Filtering option – that allows us to Filter based on the format that the cell has been formatted in. This allows us to selected just rows...

read more

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

Excel Analyzing Data

Slicer tool

This quick video explains how to use the Slicer Tool to view Data in Excel. The Slicer Tool provides powerful ways of looking at Data in a Pivot Table in different ways. Its new since Excel 2010 but very popular with Pivot Table users. [et_social_follow...

read more

Data Bars

This quick video explains Data Bars in Conditional Formatting in Excel. Data Bars – are little graphs that appear in the background of numbered cells that have had conditional formatting applied to them. They provide a useful way of highlighting and comparing values...

read more

Show Data Bars and Values as separate columns

This quick video explains how to Show Data Bars and Values as Separate Columns in Excel. Learn how to use Conditional Formatting to display Data Bars in a separate cell to the value that is used for conditional formatting in order to simplify the appearance and create...

read more

Excel Charts

Chart Styles

This quick video explains the different Chart Styles in Excel A new feature in 2013 – Chart Styles allow us to quickly change the style of a specific chart. Choose from a range of different chart types built-into Excel and modify the colour schemes used in your...

read more

Chart filters

This quick video explains the different Filters in Charts for Excel. A new feature in 2013 – Chart Filters allow us to quickly filter data that appears in a chart. We can quickly hide and remove elements of a chart – very useful for previewing what a chart will look...

read more

Chart Design Tab

This quick video explains how to use The Chart Design Tab in Excel. The Excel Design Tab gives us additional options that allows us to change the format and appearance of our Chart in Excel. [et_social_follow icon_style="slide" icon_shape="rectangle"...

read more

Excel Reporting and Dashboards

Create a pivot chart from a list

facebook Twitter Instagram Google+ Youtube This quick video shows how to create a Pivot Chart from a List in Excel. Pivot Charts provide a graphically rich way of viewing data from long lists of data. Pivot Charts are created along with Pivot Tables to summarise data...

read more

Formatting the Pivot Chart

This quick video explains how to Format your Pivot Chart in Excel. Once you have selected a pivot chart – you can start to modify its appearance. Changing the design of your pivot chart is useful to help emphasize particular data points and highlight the areas which...

read more

Refreshing a Pivot Table and Pivot Chart

This quick video explains how you Refresh the Data in your Pivot Table and Pivot Chart. Pivot Tables do not refresh automatically if the underlying data is changed. Producing a new Pivot Table is a memory and time consuming exercise for Excel so it only refresh 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

Delete a Macro stored on PERSONAL MACRO WORKBOOK

This quick video explains how to Delete a Macro saved to your Personal Workbook Delete a Macro that you have saved into your Personal Workbook so that you can update it or just remove it. [et_social_follow icon_style="slide" icon_shape="rectangle" icons_location="top"...

read more

Simple Edits to a Macro

This quick video explains how to make the Simple Edits to a Macro Excel Macros are recorded and then converted into Visual BASIC programming language. Without too much programming knowledge we can make basic edits to a Macro to amend how the Macro works. Learn how to...

read more

Assigning a Macro to a button

"Assigning a Macro to a Button" in Excel. Here is our quick Video so you can she how easy it to do . Once we have recorded a Macro we can assign it to a bottom – the macro can then be run quickly by pressing the button. [et_social_follow icon_style="slide"...

read more