From the course: SAS Essential Training: 1 Descriptive Analysis for Healthcare Research

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Tricks in Excel

Tricks in Excel - SAS Tutorial

From the course: SAS Essential Training: 1 Descriptive Analysis for Healthcare Research

Start my 1-month free trial

Tricks in Excel

- [Instructor] We are going to start this chapter by revisiting our completed categorical table one. This spreadsheet is familiar and is in your exercise files for this movie. It's named Categorical_Desc Tbl_v4_Complete. This is the same one we've been working with. What I want to show you in this movie is how to make those Excel formulas that display those yellow cells off to the right so nice. Let's click on cell C2 and look at the formula. See the formula right here? Let's go break this down. As you can see, I reproduced the exact formula on the slide. Just to remind you, I put how the cell is currently displayed in the upper right corner of the slide. As you can see the formula starts with an equals because all Excel formulas start that way. Next, you'll see that we refer to cell H2, which is from column H, the All n column and on the same row as C2. After that, you'll see an and sign, more formally called an ampersand. In Excel, the ampersand concatenates the values to which we…

Contents