Excel Help Blog
Full of helpful tips to help you get the most from Excel
Excel Top Tips
Importing data from the Web into Excel
This quick video explains how to Import Data from the Web into Excel. 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"...
Calculating a person’s age in Excel
Calculating a Persons Age in Excel. So you want to know a person’s age or need to calculate how many years have lapsed since a renewal date. Perhaps you want to know the ages of your staff without having to calculate it each year or you want to check if one of your...
Excel 2013 New Features – Quick Analysis Tool
The Quick Analysis tool as the name suggests allows us to select data on our sheet and then quickly analyse it using the short cut options available to us from the tool. Once you select your data, if the option is applicable, you will see the Quick Analysis tool...
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
COUNT COUNTA COUNTBLANK Functions
This quick video explains the COUNT Function. Count Counta Countblank Functions. Learn how to use the COUNT functions in Excel to count the number of entries in a cell and learn how not to count blanks or zero values. [et_social_follow icon_style="slide"...
Absolute and Relative Referencing Primer
This quick video explains Absolute and Relative Referencing in Excel Absolute and relative references are an important feature in Excel and widely used. The $ symbol is used to denote an Absolute cell reference. Learn the foundations of absolute referencing here....
Absolute and Relative Referencing – advanced
This quick video explains the Advanced Absolute and Relative Referencing in Excel. Learn how to create row and column absolute references and learn additional features of keeping cells absolute or relative to each other – useful when dragging functions down and across...
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.