Icon Sets

Icon Sets This quick video explains how you use Icon Sets in Conditional Formatting in Excel Traffic light icons, signal bars, indicators and other symbols can be used to highlight values in a range of cells and compare them with each other using icon sets....

Text to Columns

Text to Columns This quick video will explain how to split contents of a cell across multiple cells. Regularly when importing a text file – multiple pieces of data will end up in one cell – the Text to Columns option allows to us to split the contents of a cell across...

Importing Web Data

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"...

Importing MS Access Data

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...

Developer Toolbar Ribbon

Developer Toolbar Ribbon This quick video will show you how to view the Developer Tab or Ribbon in Excel. Since Excel 2007 – the traditional Visual BASIC options have moved to a new Developer Tab. This Tab is not visible by default. Learn how to view the developer tab...

#DIV/0 instead of content

#DIV/0 Instead of Content This quick video will show you how to remove the #DIV/0 Error. The #DIV/0 – Division by 0 error is quite a common error in Excel. Learn what causes it and how to remove them from your spreadsheet [et_social_follow icon_style="slide"...