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