Excel Help Blog
Full of helpful tips to help you get the most from Excel
Excel Top Tips
Turning on and off Filters
This quick video explains how to turn on and off Filters in Excel. There are two ways of turning on the filters in Excel – which will work with any list – providing there are no complete empty rows of data. Using the HOME TAB we can apply a Table Format to range of...
Icon Sets
This quick video explains how you use Icon Sets in Conditional Formatting in Excel Traffic light icons, signal bars, indicators and other symbols can be used to highlight values in a range of cells and compare them with each other using icon sets. [et_social_follow...
Drop down lists
This quick video explains how to create a Drop Down List in Excel. Drop down lists are a useful way of presenting the user with a finite list of options. Learn how to create them Data Validation [et_social_follow icon_style="slide" icon_shape="rectangle"...
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...
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...
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...
Excel Formulas and Functions
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"...
Applying a Filter
This quick video explains how to Apply a Filter in your Excel worksheet. Once a Filter has been enabled on a list or table – we can turn on or off a filter and use it to select a range of cells that matches the filter selected. [et_social_follow icon_style="slide"...
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...
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...
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...
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...
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...
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...
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"...
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...
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...
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...
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"...
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...
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"...