Excel Help Blog
Full of helpful tips to help you get the most from Excel
Excel Top Tips
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...
Day to Day Shortcuts for Excel
Day to Day Shortcuts for Excel . I have compiled a list of shortcuts that I use regularly on a day to day basis. These handy shortcuts should have you navigating and formatting your worksheets in no time at all. They require a bit of practice, but it’s definitely...
Quickly Transpose Tables
Quickly Transpose Tables. Have you ever found yourself creating a table in excel and then realising later that its structure should have been layout differently. In other words, have the column headings appear as row headings or visa versa. Well, the technique 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
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"...
Drop down lists using INDIRECT
This quick video explains Drop Down Lists using the INDIRECT Formula Learn how to create drop-down lists using the INDIRECT function. [et_social_follow icon_style="slide" icon_shape="rectangle" icons_location="top" col_number="auto" outer_color="dark"] Be Brilliant at...
Paste Special
This quick video explains using Paste Special in Excel. The Paste Special button allows us to change the behavior of the standard Paste command – and includes special features allowing us to transpose cells, copy just the values (without the formulae) and other useful...
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.