Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Beginner
- [Instructor] Well, well, our jokester friend Connie is at it again. You and I are gettin' ready to go into a meeting with our best clients, we asked Connie to send us a report, and she does things like this. The formatting is all weird and this laughing heart, what is that about? We've got to hurry up, get this straightened out so we can go into the meeting. Remove the laughing heart, convert the entire sheet to Calibri font, clear all cell field colors, merge project status report across columns A through F and underline it, then in the days behind schedule column make those numbers red and bold.
Pause this, come back, I'll show you a solution so we can go to this meeting. We're back and I hope you got this straightened out. We gotta hurry up and get this ready. So, remove this heart. Highlight it, click delete, gone. Convert the sheet to Calibri font, go up to this corner, okay, highlight the whole sheet, go on up here, and I'm gonna select Calibri.
Next, clear all cell field colors. All right, everything is still highlighted, go to this paint bucket here, go down to no fill. Merge project status report across the columns and underline it. Highlight A through F, then Merge and Center. Underline, that's over here in this section. In the days behind schedule column, make those numbers red and bold. I'm gonna highlight these cells, great. Red, bold, okay good.
Now we're ready for the meeting and Connie did not trip us up.