Excel Help Blog
Full of helpful tips to help you get the most from Excel
Excel Top Tips
Locking and Protecting Cells in Excel
Locking and Protecting Cells in Excel. There are times when working in Excel that you want to protect an entire worksheet from someone making changes to it, without protecting the entire workbook. Excel allows you to protect a particular sheet. To simply protect the...
What you didn’t know about the Format Painter
What you didn’t know about the Format Painter. Format Painter is a great tool, it can be used in any of the Office Applications, it allows you to copy formatting from one area/object to another, but did you know that’s only half of what it’s capable of? What if you...
Conditional Formatting and Dropdown Menus
How to create a menu of options that when selected will change the colour of the cell. For example, selecting Cancelled from a list should change the cell background colour to red to indicate clearly to the user that the project or course etc. has not been given the...
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
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...
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...
Data Validation
This quick video explains using Data Validation in Excel. We can use Excel’s powerful Data Validation rules to ensure that data entered into a cell is of the correct type and range for the table it is being inserted into – we can restrict the values for a cell using...
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
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 Reporting and Dashboards
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 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
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.