Excel Help Blog

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

Excel Top Tips

Text to Columns

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

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

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

Gridlines and Headings

Gridlines and Headings

This quick video explains how you can Print Gridlines and Headings in Excel. Excel has many printing options – displaying and printing the sheet Gridlines and Headings is one useful option. If you have taken the borders off a range of cells we can force Excel to print...

read more
How to set a Print Area in Excel

How to set a Print Area in Excel

This quick video explains how to set a Print Area in Excel. Often we will want to just print a part of a worksheet - a selected area rather than a whole workbook. Learn how to print a selection or range of cells in Excel. [et_social_follow icon_style="slide"...

read more
Drill down lists

Drill down lists

This quick video explains Drill Downs on a Pivot Table in Excel. Once we have a Pivot Table we can view the summary data. As we view the summary data we may wish to drill-down and view more information underlying the pivot table. We can drill down on the data within a...

read more

Excel Formulas and Functions

Filtering by date number and text

Filtering by date number and text

This quick video explains how to Filter by Date, Number and Text in Excel. Filtering by Date Number and Text. Once a filter is applied to a list – we can filter based on the values in each of the rows. Here we look at applying filters using different data types in...

read more
COUNTIF

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

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

Excel Analyzing Data

Manage Conditional Formatting Rules

Manage Conditional Formatting Rules

This quick video explains how to Manage the Rules and options within Conditional Formatting in Excel Learn how to manage the rules and options within conditional formatting – changing and understanding these rules is important to ensure the correct information is...

read more
How to create a form for data entry in Excel

How to create a form for data entry in Excel

Have you ever created a Workbook in Excel as part of a business process and defined how you wanted people to enter the data just to find that they disregard your method and just put the information anywhere. This can be frustrating but will involve you being the one...

read more

Excel Charts

Chart Format Tab

Chart Format Tab

This quick video explains the Chart Format Tab in Excel. The Chart Format Tab allows us to select individual parts of a chart and make changes to it. [et_social_follow icon_style="slide" icon_shape="rectangle" icons_location="top" col_number="auto" outer_color="dark"]...

read more
Insert a sparkline

Insert a sparkline

This quick video explains how to insert a Sparkline in Excel. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. [et_social_follow icon_style="slide"...

read more
Edit a sparkline

Edit a sparkline

This quick video explains how to Edit a Sparkline in Excel. Once we have inserted a sparkline – we have a new sparkline tools option that allows us to edit the sparkline options – including a way to hide empty of blank sparkline cells. [et_social_follow...

read more

Excel Reporting and Dashboards

Multiple headings in table

Multiple headings in table

This quick video explains how to have Multiple Headings in a Pivot Table. We can add additional fields to create additional columns and rows to our Pivot Table. This creates different levels of grouping within our pivot table. [et_social_follow icon_style="slide"...

read more
Using Action settings

Using Action settings

This quick video will show you how to use the Action Settings in Excel. Within a Pivot Table we have an options Tab and within this there is a group called Actions – which gives us additional options to manage our Pivot Table – including removing all of the Pivot...

read more
Editing Pivot Table options

Editing Pivot Table options

This quick video will show you your different Options to Edit in Pivot Tables . The Pivot Table options allows us to name our Pivot Table – useful if you have a number of Pivot Tables. We can also modify change the layout, totals, display, printing options for our...

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

Assigning Macro to an Icon

Assigning Macro to an Icon

 "Assigning Macro to an Icon" on the toolbar in Excel. Watch our quick video to see how easy it is to do. We can assign a macro to an icon on the toolbar or shortcut toolbar – making it easy to find no matter what sheet your are on or what workbook is open....

read more
Creating a custom Tab and adding icons to the Ribbon

Creating a custom Tab and adding icons to the Ribbon

This quick video explains how to you can go about Creating a Custom Tab and also how to add Icons to the Ribbon. Excel allows us to add our own Custom ribbon – like the eLearnExcel ribbon and we can add our own custom macros and buttons. [et_social_follow...

read more
Generalising Macros to prompt for a file

Generalising Macros to prompt for a file

Often when we record a Macro we find that it will work for a week or a month or a particular file – but we have to re-record it in order to make it work for another file or time period. In order to make a macro more useful – we can try to generalise it and remove any...

read more