Are you wondering how to show formulas in Excel? In this video, we will show you a couple of methods for viewing and working with your formulas on your spreadsheet. How to Show Formulas in Excel – The Transcript There are times in Excel when we would like to see the underlying formulas on our […]
Category Archives: 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.
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@greatcanadiantraining.ca if you’d like to get more information or book a course.
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
The Top 5 Underused Features in Excel
1. VLookups The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a […]
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 […]
Add Ribbon Items to the Quick Access Toolbar
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 […]