FREE VIDEOS

Welcome to our FREE videos section. This section will always be free and is open to all newcomers to enjoy some of our content FREE-OF-CHARGE! No payment, no sign up. Simply click a video below and it will open it in full window view. Watch as many you like and enjoy!

FREE SHORT COURSES

How do I Show the Developer Main Tab?

How do I Show the Developer Main Tab?

When you’re first beginning to write macro coding or using objects such as radio buttons, drop downs and so on, it’s helpful to have the developer tab (otherwise, you can’t do ... Read More

100% Stacked Area Graph to Measure Portions Over Time

100% Stacked Area Graph to Measure Portions Over Time

I just started using this chart because I needed to measure how performance in my data changed against each month. This is much better than doing a standard area chart because you can actually ... Read More

Filters for Intermediates

Filters for Intermediates

For large data sets with lots of rows and columns, they make sorting, rearranging and organising data a breeze. When filters are applied to a table, little controls appear above on the column ... Read More

Workbook Protection and Change Tracking

Workbook Protection and Change Tracking

Excel by nature allows anyone and everyone to input data. Unfortunately, not everyone knows how to maintain data integrity. Cells that aren’t meant to be filled out get altered, columns or rows ... Read More

Dashboard Development for Intermediates

Dashboard Development for Intermediates

Instead of redoing the calculation each time, you can build a dashboard which allows you to simply insert your new data and Excel will automatically calculate the new values. It involves a new of Read More

Charts and Graphs for Intermediates

Charts and Graphs for Intermediates

Charts allow us to visual data especially large samples of data and is an effective way of identifying patterns, trends, peaks, valleys and clusters in your data that may otherwise go unnoticed ... Read More

Conditional Formatting for Intermediates

Conditional Formatting for Intermediates

Our brains are hard-wired to recognize colours and symbols far better than numbers, we’ve evolved that way. Therefore we should use that to our advantage to make reading our data even easier. ... Read More

Shortcut Ribbon

Shortcut Ribbon

When spreadsheets get larger, you’ll need to see as much of the workbook as possible to maximize your productivity especially when working on small laptops. One method is to minimize the main ... Read More

Review Functions

Review Functions

Mistakes happen to all of us. We could do a manual search and look for these mistakes but for large documents this will simply take forever. Instead we can use the spelling function which will ... Read More

Formulas – Nested Functions

Formulas – Nested Functions

Depending on the arrangement of data you may choose to have each individual part of the final calculation stored on your workbook or you could combine several formulas into a single cell. Each ... Read More

Excel for Entrepreneurs (COMING SOON!!)

Excel for Entrepreneurs (COMING SOON!!)

32.1% of small businesses fail due to poor management of financial activities (http://www.ronaldcoleman.ca) Businesses fail for a lot of reasons but ultimately because of one reason: the business Read More

I Can’t Find The Pivot Table Tools

I Can’t Find The Pivot Table Tools

I’ve done this before. I’m trying to work with Pivot Tables or the Table function and I can’t find the design options. Remember, to edit the features in a Pivot Table, be sure ... Read More

Page 1 of 3123

 

 

 

FREE SNIPPETS

Like What You See? Join us!

If you’re already familiar with our work and want to sign up straight away, click the button above to sign up!

Want to sign up your entire workforce, team or school? No problem. Get in touch with us personally and we can discuss a bundle package with a discount!

Is there a video you really want us to do but isn’t available? Definitely let us know using the button above!