Actions and Detail Panel
Excel Linking and Lookups
Wed, 29 March 2017, 2:00 PM – 4:00 PM EDT
Excel is one of the most widely used software tools – known for 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 as bring 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.
* Small 6-10 person class size
* Acknowledgement of course completion
* Networking opportunity with other professionals
* Discounts on future MLD Solutions training sessions
This is a beginner's course. We welcome attendees new to Excel.
NOTE: Laptops are available upon request. To borrow a laptop for the session, please select the “Laptop Needed” ticket.