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, and ensure consistency and accuracy.
Correct calculations and the ability to represent your data – powerful reasons to use Excel!
Learn to add numbers across worksheets and across files as well as bring data together from multiple sources. 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.
Participants must have a solid understanding of Excel formulas to take this course.
If you are new to Excel, it is recommended that you start with our Excel: Basics course.
* Small 6-10 person class size - get answers to your questions!
* Acknowledgement of course completion
* Networking opportunity with other professionals
* Discounts on future MLD Solutions training sessions
NOTE: Laptops are available upon request. To borrow a laptop for the session, please send us an email request to firstname.lastname@example.org