Formatting Excel 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.
Course info
Level
Intermediate
Updated
Sep 6, 2019
Duration
1h 28m
Table of contents
Description
Course info
Level
Intermediate
Updated
Sep 6, 2019
Duration
1h 28m
Description

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.

About the author
About the author

Pratheerth is a freelance Data Scientist who has entered the field after an eclectic mix of educational and work experiences.

More from the author
Calculating Cell Values with Formulas
Intermediate
1h 24m
Nov 7, 2019
Excel Data Lookup Function Playbook
Advanced
34m
Oct 21, 2019
More courses by Pratheerth Padman
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Partheerth Padman, and welcome to my course, Formatting Excel Worksheets and Cells. Currently, I'm a freelance data scientist. I used to work in manufacturing, but because of my love for all things data, I completely pivoted to data science. Have you ever looked at some of those Microsoft Excel worksheet templates or seen a beautiful, well-crafted worksheet online and wondered how on Earth it got to the point of looking like that from the plain vanilla worksheet we are greeted with in Excel? The magic lies in the formatting options available inside Excel, and helping you navigate that particular means is what this course is targeted towards. Some of the major topics that we'll cover include formatting worksheets and workbooks, formatting cells and ranges, and customizing options and views for worksheets and workbooks. By the end of this course, you'll know the different techniques used to format your worksheets and workbooks to enhance professionalism and readability. There isn't a particular prerequisite before beginning the course, though a basic understanding of Microsoft Excel's interface would be very helpful. I hope you'll join me on this journey to learn how to format Microsoft Excel's worksheets and workbooks with the Formatting Excel Worksheets and Cells course, at Pluralsight.