Microsoft Excel 2016: Functions, Tips, and Tricks Conference/Lecture Friday, May 12, 2023 The event started -503 days agoMultiday event - 0 days 8:30 AM 4:30 PM Wilson Hall On-Campus or Live Virtual Take your Excel skills to the next level by unlocking the power of Excel to learn the most useful and under-used functions. Most people use Excel but very few have a deep knowledge of this powerful tool. There may be elements in your work that can easily be bypassed with a function. Increase your knowledge in Excel and save time. Learn the logic behind functions such as IF, VLOOKUP, COUNT, INDEX, and many more. This course is aimed at those who have basic knowledge of Excel and understand how Excel functions are used but want to learn more. What you will learn: Lookup Formulas - VLOOKUP, HLOOKUP, INDEX, and MATCH IFERROR Function Text to Columns SUMPRODUCT Function CONCATENATE, CONCAT, and TEXTJOIN Functions SUMIFS and More TEXT Function IF and IFS (New for Excel 2016) INDIRECT Function Date Functions Data Validation SUBTOTAL Function CONVERT DOLLARDE and DOLLARFR MMULT Function LEN Function OFFSET Function REPT Function CELL and GET Functions MOD Function GETPIVOTDATA User-Defined Functions Flash Fill SIGN Function CHOOSE Function Regressions Tables Prerequisite: Experience using Microsoft Excel. Register Online 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