[fusion_builder_container hundred_percent=”no” hundred_percent_height=”no” hundred_percent_height_scroll=”no” hundred_percent_height_center_content=”yes” equal_height_columns=”no” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” status=”published” publish_date=”” class=”” id=”” background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” video_preview_image=”” border_size=”” border_color=”” border_style=”solid” margin_top=”” margin_bottom=”” padding_top=”” padding_right=”” padding_bottom=”” padding_left=””][fusion_builder_row][fusion_builder_column type=”1_2″ layout=”1_2″ spacing=”” center_content=”no” link=”” target=”_self” min_height=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_image_id=”” background_position=”left top” background_repeat=”no-repeat” hover_type=”none”

Read More

Excel gets maths wrong sometimes… Do you use Excel regularly? And do you trust that if it says something’s true, then it’s probably true? Perhaps not in the area of global politics, or issues around faith and ethics, but you can rely on it when it comes to maths, right? We’re not talking high-level, professor

Read More

Get over the limitations of the built-in CONCATENATE function in Excel.

In this post we take a look at writing an alternateive to Excel’s concatenate function, which both overcomes the limit on the number of values that can be concatenated, and also allows a delmiter to be specified, such as a comma, beteween values.

...
Read More

Creating dynamic forms with Conditional Formatting
In this video tutorial we take a look at using conditional formatting to make Excel forms dynamically respond to user entries.
For example, display “Additional info” fields when users select a particular value, or display multiple sections based on user input elsewhere.

...
Read More

Get more from Excel’s Conditional Formatting tools

Excel’s conditional formatting tool really got beefed up with the new options introduced in Excel 2007. But in this video, we show you how to do more with conditional formatting – whether you’re using Excel 2010 or Excel 97!
Learn how to…
– Highlight a whole row of data based on a condition in one cell
– Change a value with a scroll-bar control
– Make conditional formatting more dynamic

...
Read More

In the first part of our video tutorial, we looked at the basics of what PivotTables are, how they work, and how to create them. In this second part, we’re going to take a look at some ways in which you can extend your PivotTables, to include: Grouping dates, so that they can be summarised

Read More