Excel Help Blog
Full of helpful tips to help you get the most from Excel
Excel Top Tips
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 repeat a row on a document as it is printing
This quick video explains how to repeat a row on a document as it is printing Learn how to repeat a column or row headings or titles on each page of a document as it is printing. This is useful for multi-page documents with lots of data. Options are in the Page Layout...
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"...
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
Date / Time Formatting
This quick video will show you how to change the appearance of the Time and Date in your worksheet. Changing the appearance of the date and time is very useful in presenting spreadsheets. Many errors in Excel occur because of incorrectly formatted dates – check the...
Copy and paste into other worksheets
This quick video will show you how to Copy and Paste into other Worksheets in Excel. Learn to move and copy data between worksheets on the same workbook. If you find your spreadsheet results misbehaving after a copy paste you may learn some useful information here...
Copy and paste into Word and PowerPoint
This quick video will show you how to Copy and Paste from Excel into Word and PowerPoint. Learn to copy Excel spreadsheets tables and charts from Excel in Microsoft Word and PowerPoint. This is very useful when preparing reports or presentations that need to show...
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"...