Welcome

JN Software Consulting provides customized software training, consulting, custom database and Excel development for individuals and groups in companies and small businesses in Toronto, the GTA and across Canada.

Online or on site, JN Software Consulting clients:

  • Learn skills specifically required for their work.
  • Concentrate on developing their computer ability, not someone else's.
  • Feel good about improving their technology ability and confidence.
  • Make software work for them.
Home

Our clients know that:

  • Adding a new computer skill makes everyone's job easier and opens up new opportunities.
  • Building an easy-to-navigate, searchable website positions a company ahead of the competition.
  • Up-to-date data that's organized and searchable in a custom database saves your business time and money.

We have worked with businesses in industries including:

  • Accounting
  • Administration
  • Banking
  • Child Care
  • Human Resources
  • Insurance
  • Investments
  • Manufacturing
  • Marketing
  • Sales
  • Software
  • Health Care
  • Professional Services



Join Remote Support Session

Join a Meeting


TIP OF THE MONTH - JUNE/2016
EXCEL 2010 - PUT EMPTY ROWS BETWEEN EXISTING ROWS

Ever wish you could insert a blank row between existing rows quickly? Now you can by creating the blank rows to interweave with the existing rows by using the Sort function.

  1. Add a new column before the existing column that contains data
  2. In cell A1 enter the number 1
  3. Fill down as a series to the last row that contains data. So now you will have Column A filled with numbers from 1 to the total number of rows
  4. Select these numbers and copy these cells to the clipboard (CTRL+C)
  5. Move to the first empty cell in Column A, underneath the last numbered row, and paste those copied cells (CTRL+V)
  6. Now highlight the entire data area that includes the rows with just a number in Column A.
  7. On the Home tab, Editing Group, choose Sort -> Custom Sort. Sort by Column A. Ensure that "My data has headers" is checked if you have header rows
  8. Now you will have blank rows between the existing data rows