Microsoft Excel 2016: Formulas and Functions

Friday, September 30, 2022 43 days from now

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
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