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.
Tag Archives: MS Excel
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 […]
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
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.
Need Excel Training? Check Out All Our Courses!
We are excited to announce the addition of some important new Excel courses to our training catalog Excel Tips, Tricks & Time Savers training is now here! Our classic Excel training courses cover Excel Levels 1, 2, and 3. We’ve noticed that our clients love when we teach tips, tricks and time savers, so we’ve […]
When to Take Excel VBA Programming or Hire a Consultant
You probably use Excel in your day-to-day business operations, but how much of its potential are you putting to good use? If you’re managing a relatively successful business, then you already understand the importance of making sure that your internal processes are running as smoothly and efficiently as possible. Whether it’s streamlining accounting procedures, calculating […]
Don’t Re-invent the Wheel
Importing Tasks from Excel You can import tasks from Excel, rather than re-create entire task lists. You will need to use the Import Wizard. Open the MS Project file you would like to import the data into, or create a blank file. File -> Open -> Files of type -> Excel workbook – Locate the file and click […]
Categories:
Excel
Time Saving Tools for Excel Formulas
If you work in the type of office where you can’t install your own favourite productivity software due to strict IT policies, then it’s likely that Microsoft Office is already installed on your system. Microsoft Office is packed with features that can help you stay on top of things and get the job done. Here […]
Find and Replace Tool
If you work in the type of office where you can’t install your own favourite productivity software due to strict IT policies, then it’s likely that Microsoft Office is already installed on your system. Microsoft Office is packed with features that can help you stay on top of things and get the job done. Here […]