Microsoft Excel 2016: Functions, Tips, and Tricks

Friday, December 9, 2022 112 days from now

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 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
Professional Development Solutions
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 Hall

301 Sparkman DriveHuntsville, AL 35899

More Dates

  SHARE