From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 23,100 courses taught by industry experts.

Flip the zone

Flip the zone - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Flip the zone

“

- [Instructor] Let me say at the outset that this challenge is based on a baseball strike zone, but we're not here for baseball. I'm not a baseball fan, but I saw something similar to this and found it intriguing and said, "yeah, this could be a good Excel challenge." This says that if something happened in the area of cell F7, there's a 20% chance for success. Whereas in cell C9, there's a 55% chance for success. But this was made with right-handed players in mind. The challenge today is create this zone chart that's flipped for left-handed players. Meaning the 36% that's in B4 needs to be in the upper right instead of the upper left. Similarly, the 21% in F12 needs to be on the bottom left instead of the bottom right, okay? There's a lot of ways to do this. Don't worry about getting those colors. Just get the values flipped, all right? Pause the video and get that flipped. (upbeat music) All right, let's flip this thing. Here we go. Move this box out of the way. I'm going to grab…

Contents