From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Unlock the full course today

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

Format worksheets and workbooks

Format worksheets and workbooks

From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Start my 1-month free trial

Format worksheets and workbooks

“

- [Narrator] Formatting worksheets and workbooks makes your data so much easier to read. And, naming your worksheets, color coding the worksheets, and rearranging the worksheets in a workbook, will help your users quickly find the data that they need. The other formatting option that we'll review is how to AutoFit your rows and columns, so all the data in the cells is visible to your users. These skills, while considered basic concepts in Excel, are still important to review, to prepare for the MOS Exam. I have the 02_03 exercise file open, so let's get started. Let's take a look at how our worksheets are named in this workbook. We have Q2 Transportation Expenses and then Q1 Travel. Looks like we have the information for all four of our quarters. I do see a discrepancy right here, on the Q1 Transportation Expenses. Looks like it's named a little differently. We have expenses spelled out and we have "Exp." Let's take a minute to go ahead and change the quarter two transportation…

Contents