Microsoft Excel 2016: Formulas and Functions Conference/Lecture Friday, September 30, 2022 The event started -727 days agoMultiday event - 0 days 8:30 AM 4:30 PM Wilson Hall On-Campus or Live Virtual Excel formulas and functions are useful in all types of spreadsheet applications. They are essential to manipulating data and obtaining useful information. This course will expand your understanding and use of Excel by focusing on the techniques to build useful worksheet formulas and enhance spreadsheet functionality. Learn to create formulas, and import, export, and validate data, plus more. Understand how to maintain your original data, audit your formulas for correctness, and adjust values to be able to calculate how to reach outcome goals. Topics Include: Operators How to use built-in Excel functions Subtotal Function Relative, Absolute, and Mixed Cell References, Formulas with Tables Named Cells and Ranges Mathematical functions Using logical functions to create conditional results, including IF statements Using powerful lookup functions, such as VLOOKUP Troubleshooting Formulas and Functions Prerequisite: Intermediate-level Excel users familiar with general concepts of Excel features. Register Here > For more information, contact PDSolutions@uah.edu or 256.824.4430. Visit PDSolutions.uah.edu for a full listing of courses. Details Category Conference/Lecture department Audience Public, Students, Faculty and Staff, Alumni Contact 256.824.4430 This email address is being protected from spambots. You need JavaScript enabled to view it. Venue Wilson Hall301 Sparkman DriveHuntsville, AL 35899View map More Dates SHARE