PLU | Formatting Excel Worksheets And Cells (2019 EN)

Company: Pluralsight
Author: Pratheerth Padman
Full Title: Formatting Excel Worksheets And Cells
Year: 2019
Language: English
Genre: Educational: Spreadsheets
Skill Level: Intermediate
Price:
-
Files: MP4 (+ Subtitles .SRT, Slides .PDF)
Time: 01:27:18
Video: AVC, 1280 x 720 (1.778) at 15.000 fps, 200 kbps
Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz



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.

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.


Lessons:
1. Course Overview
01. Course Overview
2. Formatting Worksheets and Workbooks
02. Module Introduction
03. Fonts and Borders in Excel
04. Demo: Formatting Fonts and Applying Borders
05. Page Setup in Excel
06. Demo: Modifying Page Setup in Excel
07. Inserting and Deleting - Columns, Rows and Cells
08. Row Height, Column Width, Headers and Footers
09. Demo: Adjusting Row Height and Column Width
10. Demo: Inserting Headers and Footers in Excel
11. Workbook Themes
12. Demo: Changing Workbook Themes in Excel
13. Formatting Excel Worksheets Cells M2 12
3. Customizing Options and Views for Worksheets and Workbooks
14. Module Introduction
15. Workbook Views in Excel
16. Demo: Changing Workbook Views in Excel
17. Window Views in Excel
18. Demo: Changing Window Views in Excel
19. Document Properties
20. Demo: Viewing, Modifying and Removing Document Properties
21. Quick Access Toolbar
22. Demo: Customizing the Quick Access Toolbar
23. Zoom Tool, Hiding Columns and Displaying Formulas
24. Demo: Changing Magnification Using Zoom Tool
25. Demo: Hiding Columns and Displaying Formulas
26. Summary
4. Formatting Cells and Ranges
27. Module Introduction
28. Merge and Split Cells
29. Demo: Merging and Splitting Cells in Excel
30. Wrap Text, Cell Alignment and Cell Indentation
31. Demo: Wrapping Text and Modifying Cell Alignment & Indentation
32. Named Ranges or Cells
33. Demo: Creating and Navigating to a Named Range or Cell
34. Cell Styles and Format Painter
35. Demo: Using Cell Styles and Format Painter in Excel
36. Summary and Feedback

Our members see more. Join us!
-------------
Our members see more. Join us!