On-site or Off-site
Custom on-site or off-site training offers many benefits including the ability to choose dates, customize content and save 50% or more with larger groups. To ensure the best experience for your staff, a maximum of 12 students is permitted in a custom training course.
Interested in discussing custom training options? Contact us!
Our training specialists can travel to your location. View on-site training locations.
Discover the Benefits of Custom Training
Discover 3 key benefits with custom training: you choose the date, customize content and save (depending on the size of the group).
You choose the date
If scheduled dates aren't convenient, you can arrange training at your site or in one of our Toronto classrooms. We'll co-ordinate dates based on your preferences and the availability of our training specialist.
Customize the content
You can opt to customize the content of any of our courses by adding or removing topics. Arrange a consultation with one of our staff to review the content and we'll work with you to arrange the best solution.
There are several strategies to replace zero values (0) with blanks in Excel. If you want to replace zero values in cells with blanks, you can use the Replace command or write a formula to return blanks. However, if you simply want to display blanks instead of zeros, you have two formatting options – create a custom number format or a conditional format.
Power Query in Excel is a powerful data transformation tool that allows you to import data from many different sources and then extract, clean, and transform the data. You will then be able to load the data into Excel or Power BI and perform further data analysis. With Power Query (also known as Get & Transform), you can set up a query once and then refresh it when new data is added. Power Query can import and clean millions of rows of data.
You can freeze one or more rows in an Excel worksheet using the Freeze Panes command. If you freeze rows containing headings, the headings will appear when you scroll down. You can freeze columns as well so when you scroll to the right columns will be frozen.