Category: Excel
Essential Tips for running your business
Simple and Effective Onboarding for VAs – Part 4: Managing Your Onboarding Process For Free
Another part of Kates amazing Mini-Series for VA Pro Mag, all about the Onboarding process. This part is all about how to manage your process for absolutely free!
Separate Data into Columns in Excel or Google Sheets
Why use text to columns? If you’re an Excel user, chances are that at some point in your...
How to calculate the difference between two dates in Excel
There might be a number of reasons why it would be handy to be able to calculate the difference...
Two easy ways to split text in Google Sheets
Manipulating data is one of the key functions of spreadsheet use, and you might already be aware...
Use Format Painter to Quickly Copy Conditional Formatting in Microsoft Excel
Conditional formatting is a handy tool in Excel that can help you to add visual highlights to data...
How to create a drop down menu in Excel using data validation or form fields
In a previous article we showed you how to create useful data sets with data validation, however...
Why is my CSV file saving as a SLYK file and how can I change this?
This is a problem that we have recently encountered in our work and it took us a good while to...
How to create a double axis graph in Excel
Microsoft Excel’s chart functions help readers quickly visualise information and see insights...
How to analyse sales performance using conditional formatting in Microsoft Excel 2013
Conditional formatting is a useful tool that formats your Excel data based upon certain...
Understand Numeric and Special Formatting in Excel 2013
Excel 2013 has a wealth of numeric formatting options which gives users the ability to perform...
