Increase Productivity
Oh Yes, You Can! If you’re old enough to remember this, think back to the days before digital cameras. You had to buy film, and on average a roll took 24 pictures. And you had to drive to a store to get them developed! Because of the expense, processing and time involved in photography, people […]
Tag Archives: Excel
Excel – Quickly Convert Formulas to Values
This video shows how to quickly convert your formulas to static values to prevent Excel from calculating new results. Visit and subscribe to our YouTube channel for even more great tips.
Keep Excel-ling – Ways to Improve at Any Excel Skill Level
Excel’s deceptively simple grid interface hides an extremely complex program capable of deep data manipulation and visualization. Students that have taken our Excel Level 1, 2, and 3 courses feel confident in their abilities, and yet are surprised to learn that they can go even further with their Excel skills. In the past, students that […]
Announcing Free Monthly Webinars!
We have set a gold standard of training that translates to real workplace improvements. We are proud to announce our latest initiative in providing that same exceptional learning experience with free monthly webinars. Our first five topics will help users better use the Microsoft Suite to increase efficiency, communication and collaboration. These topics demonstrate how […]
Excel – Updating Numbers Without Using Excel
In this video we will show you how to update numbers on your spreadsheet without using formulas or functions.
Categories:
Excel
Excel – Displaying Formulas
In this video, we will show you a couple of methods for viewing and working with your formulas on your spreadsheet.
Custom Lists
Excel Custom Lists In this month’s video, we will show you how to create custom lists to save time with data entry and to sort in a non-alphabetical format.
Excel’s Camera Tool
Excel’s Hidden Gem In this month’s video, we will show you how to use the camera tool to create linked images of your Excel spreadsheets.
Clearing Up the Confusion – Choosing Databases
We all know how useful databases are. They allow us to easily input, gather, analyze, and sort data. Plus, thanks to databases, we can even access this data from anywhere. This is very important for today’s businesses as they deal with thousands of GBs of data that they send to partners, clients, etc. That’s why […]
Categories:
Databases
Flash Fill 101
Excel’s Flash Fill In this month’s video, we will explain how to use Excel’s Flash Fill to help you become more productive. Visit our website for more information on our Excel training. Contact us at 416-264-6247 or info@jnsoftware.ca if you’d like to get more information or book a course.