Back to All Events

Excel Linking and Lookups

  • MLD Solutions Inc. 210-379 Dundas Street London, ON, N6B 1V5 Canada (map)

Excel is one of the most widely used tools – known for its ability to crunch numbers. Excel is also very powerful in its ability to manage large amounts of text and numerical data with ease. Keep lists of information, subtotal groups of numbers, pivot data for analysis and decision-making, or chart information to illustrate your data. 

Most users have a basic understanding of the software. With a few simple tips and tricks you can use Excel with more efficiency and power. Learn about the hidden strategies that will save you lots of time, ensure consistency and also ensure that your numbers and calculations are correct. 

Correct calculations and the ability to represent the data – powerful reasons to use Excel! 

Learn to add up numbers across worksheets and across files as well asbring data together from multiple sources. In addition, discover how to manage multiple sets of data when the original file is changed. Learn how to use formulas and Excel lookup functions such as VLOOKUP and INDEX to extract a value from a range of values based on a column and/or row reference. 

What's Included: 

* Small 6-10 person class size 

* Refreshments 

* Acknowledgement of course completion 

* Networking opportunity with other professionals 

* Discounts on future MLD Solutions training sessions 

Prerequisite: Participants must have a basic understanding of Excel formulas. If you are new to Excel you should take the Excel Basics course before attending this session. 

If you would like to use one of our laptops for the session, please select the ticket that states "LAPTOP NEEDED". 

Register