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 0m
- Module Introduction 3m
- Fonts and Borders in Excel 2m
- Demo: Formatting Fonts and Applying Borders 4m
- Page Setup in Excel 2m
- Demo: Modifying Page Setup in Excel 5m
- Inserting and Deleting - Columns, Rows and Cells 4m
- Row Height, Column Width, Headers and Footers 2m
- Demo: Adjusting Row Height and Column Width 5m
- Demo: Inserting Headers and Footers in Excel 2m
- Workbook Themes 1m
- Demo: Changing Workbook Themes in Excel 1m
- Formatting Excel Worksheets Cells M2 12 1m
- Module Introduction 1m
- Workbook Views in Excel 2m
- Demo: Changing Workbook Views in Excel 2m
- Window Views in Excel 1m
- Demo: Changing Window Views in Excel 5m
- Document Properties 3m
- Demo: Viewing, Modifying and Removing Document Properties 3m
- Quick Access Toolbar 1m
- Demo: Customizing the Quick Access Toolbar 2m
- Zoom Tool, Hiding Columns and Displaying Formulas 1m
- Demo: Changing Magnification Using Zoom Tool 2m
- Demo: Hiding Columns and Displaying Formulas 2m
- Summary 1m
- Module Introduction 1m
- Merge and Split Cells 1m
- Demo: Merging and Splitting Cells in Excel 4m
- Wrap Text, Cell Alignment and Cell Indentation 3m
- Demo: Wrapping Text and Modifying Cell Alignment & Indentation 4m
- Named Ranges or Cells 1m
- Demo: Creating and Navigating to a Named Range or Cell 4m
- Cell Styles and Format Painter 2m
- Demo: Using Cell Styles and Format Painter in Excel 4m
- Summary and Feedback 2m