Formatting Excel 2016 Worksheets and Cells

Focused View

Pratheerth Padman

1:27:18

47 View

00. Course Overview

00. Course Overview.mp4

01:50

01. Formatting Worksheets and Workbooks

00. Module Introduction.mp4

03:08

01. Fonts and Borders in Excel.mp4

01:41

02. Demo - Formatting Fonts and Applying Borders.mp4

04:29

03. Page Setup in Excel.mp4

01:58

04. Demo - Modifying Page Setup in Excel.mp4

05:17

05. Inserting and Deleting - Columns, Rows and Cells.mp4

03:41

06. Row Height, Column Width, Headers and Footers.mp4

01:47

07. Demo - Adjusting Row Height and Column Width.mp4

04:33

08. Demo - Inserting Headers and Footers in Excel.mp4

01:32

09. Workbook Themes.mp4

00:41

10. Demo - Changing Workbook Themes in Excel.mp4

01:21

11. Formatting Excel Worksheets Cells M2 12.mp4

01:16

02. Customizing Options and Views for Worksheets and Workbooks

00. Module Introduction.mp4

01:23

01. Workbook Views in Excel.mp4

01:36

02. Demo - Changing Workbook Views in Excel.mp4

02:18

03. Window Views in Excel.mp4

01:28

04. Demo - Changing Window Views in Excel.mp4

05:07

05. Document Properties.mp4

02:57

06. Demo - Viewing, Modifying and Removing Document Properties.mp4

03:21

07. Quick Access Toolbar.mp4

01:01

08. Demo - Customizing the Quick Access Toolbar.mp4

02:09

09. Zoom Tool, Hiding Columns and Displaying Formulas.mp4

01:16

10. Demo - Changing Magnification Using Zoom Tool.mp4

01:48

11. Demo - Hiding Columns and Displaying Formulas.mp4

02:17

12. Summary.mp4

01:29

03. Formatting Cells and Ranges

00. Module Introduction.mp4

00:56

01. Merge and Split Cells.mp4

01:29

02. Demo - Merging and Splitting Cells in Excel.mp4

03:38

03. Wrap Text, Cell Alignment and Cell Indentation.mp4

03:00

04. Demo - Wrapping Text and Modifying Cell Alignment & Indentation.mp4

03:53

05. Named Ranges or Cells.mp4

01:22

06. Demo - Creating and Navigating to a Named Range or Cell.mp4

03:49

07. Cell Styles and Format Painter.mp4

02:18

08. Demo - Using Cell Styles and Format Painter in Excel.mp4

03:39

09. Summary and Feedback.mp4

01:50

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Pratheerth Padman

Instructor's Courses

Pratheerth is a Data Scientist who has entered the field after an eclectic mix of educational and work experiences. He has a Bachelor's in Engineering in Mechatronics from India, Masters in Engineering Management from Australia and then a couple of years of work experience as a Production Engineer in the Middle East. Then when the A.I bug bit him, he dropped everything to dedicate his life to the field. He is currently working on mentoring, course creation and freelancing as a Data Scientist.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.