From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Count employees, interns, and contractors

Count employees, interns, and contractors - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Count employees, interns, and contractors

“

- [Instructor] In this dataset, we've got people who work for us in departments A, B, and C. Katrina's name is followed by a C because Katrina's a contractor. Nanetta, her name is followed by an I because she's an intern. And that means somebody like Dora or Gail, they're regular employees. That's important, because our objective today, get a count of how many interns, how many contractors, how many regular employees. Got that? All right, pause the video, get that tally, come back here, and I'll do some tallying right before your very eyes. (upbeat music) Here we go. Let's get these counts going. I'm going to start this way. I'm going to do total, and then interns, (instructor typing) contractors, (instructor typing) employees. (instructor typing) And I'm going to make these bold, so look kind of professional. Okay, now to get the total, equals count A. I'm going to double click here. And this is…

Contents