-
Course
- Data
Formatting Excel 2016 Worksheets and Cells
In this course, we will be talking about changing the look and feel of a Microsoft Excel worksheet or workbook. Here, we’ll be concentrating on how we want the sheets and books to look like and the tools that help us achieve that.
What you'll learn
In the 3rd course in the Excel series, we will be handling the look and feel of an excel worksheet/workbook. Here, we’ll be concentrating on how we want the sheets and books to look like and the tools that help us achieve that. This is an important skill to have in order to create professional-looking spreadsheets.
First, we'll be looking at how to format workbooks and worksheets. Next, we'll look at customizing options and views for worksheets and workbooks. Finally, we'll look at formatting cells and ranges in Excel.
When you're finished with this course, you will have the skills and knowledge to create professional, functional spreadsheets in Microsoft Excel.
Table of contents
- Version Check | 15s
- Module Introduction | 3m 8s
- Fonts and Borders in Excel | 1m 41s
- Demo: Formatting Fonts and Applying Borders | 4m 29s
- Page Setup in Excel | 1m 58s
- Demo: Modifying Page Setup in Excel | 5m 17s
- Inserting and Deleting - Columns, Rows and Cells | 3m 41s
- Row Height, Column Width, Headers and Footers | 1m 47s
- Demo: Adjusting Row Height and Column Width | 4m 33s
- Demo: Inserting Headers and Footers in Excel | 1m 32s
- Workbook Themes | 41s
- Demo: Changing Workbook Themes in Excel | 1m 21s
- Formatting Excel Worksheets Cells M2 12 | 1m 16s
About the author
Pratheerth is a freelance Data Scientist who has entered the field after an eclectic mix of educational and work experiences.
More Courses by Pratheerth