Excel Help Blog
Full of helpful tips to help you get the most from Excel
Excel Top Tips
Turning on and off option in Show Group
This quick video will show you how to display or hide items in a Pivot Table for presentation purposes. We can display or hide items in a Pivot Table for presentation purposes – this makes the Pivot Table easier to view without showing some of the Panels used when...
Extra Pivot Table options in Excel 2013
This quick video will show you the difference between Excel 2010 and Excel 2013 Pivot Tables Excel adds a number of New Features in Excel 2013. Here you can find the differences between Excel 2010 and Excel 2013 Pivot Tables – including using pre-built or recommended...
Highlight Cell Rules
This quick video explains Highlighting Cells in Conditional Formatting in Excel. Highlight Cell Rules. Conditional formatting provides a powerful way to highlight data in a list. The foundation of conditional formatting are the rules you need to select cells for...
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
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"...
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...
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...
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
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"...
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...
Excel Reporting and Dashboards
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....
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...
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
Excel VBA Common Question: What is ‘Option Explicit’ for?
What is Option Explicit for? From time to time I thought I would post answers to the most common questions I get asked during the classroom based courses that we run. We will also do this for the online Excel courses and also feel free to ask questions on the blog if...
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...