Course Overview
TOPDuring this two-hour live hands-on training, our top-rated instructor will teach how to use advanced Excel functions and formulas to help retrieve data quickly. These tips will help improve the accuracy of your workbooks while saving a ton of time and minimizing data entry errors. Students are encouraged to ask questions during this hands-on session.
Scheduled Classes
TOP| 02/26/25 - HC2 - Virtual Instructor-Led - Virtual Instructor-Led | (click to enroll)
 |
| 05/30/25 - HC2 - Virtual Instructor-Led - Virtual Instructor-Led | (click to enroll)
|
What You'll Learn
TOPDuring this hands-on training you will learn to:
- Create & Use COUNTA functions
- Create & Use SUMIF functions
- Create & Use COUNTIF functions
- Create & Use IF formulas
- Use VLOOKUP
Outline
TOP
Viewing outline for:
- Counts cells that contain numbers, text, logical values and error values but not empty cells
- Function sums cells that meet certain criterion
- Function counts cells that meet certain criterion
- Checks whether a condition is met
- Returns differing values based upon the answer
- Short for vertical lookup
- Designed to work with data that is organized in columns
Prerequisites
TOPSuccessful students will have completed Excel Part 1 training or have equivalent experience.
Who Should Attend
TOPStudents who wish to learn about the Lookup and Logical functions in Excel. The training is categorized as intermediate-to-advanced.
Next Step Courses
TOPOther Bits & Bytes sessions and Microsoft Office courses.
