Skip to content Skip to site navigation Skip to service navigation

Excel Formatting Essentials: Elevate Your Spreadsheets with Professional Style and Clarity

Class Code Date Delivery Method Cost
ITS-1208
  • Thu Jun 20, 1:00 pm to 4:00 pm
Live Online - 1 session $200
ITS-1208
  • Thu Jul 25, 1:00 pm to 4:00 pm
Live Online - 1 session $200
ITS-1208
  • Thu Aug 22, 1:00 pm to 4:00 pm
Live Online - 1 session $200

Before each sesson, Tech Training will provide a Zoom link for live online classes, along with any required class materials.

Note: This class offers an option for online and in-classroom sessions. Participants attending an in-person class will need to adhere to the Stanford Health Check guidelines.

 


Platforms: Windows (PC) or Mac
Required: Install the latest Microsoft 365 (subscription-based, free with your SUNet ID) from http://ess.stanford.edu.

Would you like to improve the look and feel of your spreadsheets? This class puts you on the road to learning the ins and outs of Excel formatting tools, such as colors, borders and shading, numbers and dates, styles, and conditional formatting.

If you feel your spreadsheets could be presented professionally with data displayed exactly the way you want, you found the right class. 

Great formatting is what makes professional spreadsheets stand out from the crowd. It makes them beautiful, easy to understand, and immediately more useful. And the focus of this class is formatting Excel spreadsheets.

When in class, we start with a brief review of the formatting tools on the ribbon and quickly dive into direct-formatting techniques. After getting comfortable with font, borders, and cell color formatting, we will ease into formatting with styles and tables. 

We will pay special attention to formatting numbers and explore the realm of somewhat confusing but extremely flexible and easy-to-use formatting codes. We will cover the ¿Format Cells¿ dialog box ¿ the one tool to rule them all that is a gold standard of cell formatting that gives you full control when it comes to number formatting. 

We will also take a quick look at conditional formatting, which gives spreadsheets amazing chameleon-like qualities and makes them more impressive than before.

List of topics:

  • The ribbon formatting tools overview
  • Borders, cell fill, and fonts formatting
  • Format with styles
  • Create custom styles
  • Copying formatting
  • Formatting with Tables
  • General format
  • The Format Cells dialog box
  • All about number formatting
  • Formatting dates
  • Create custom number and date formats with formatting codes
  • Using Stanford brand colors in Excel spreadsheets
  • Introduction to Conditional Formatting
  • Formatting tables, pivot tables, and floating objects

This class will help provide the knowledge, skills, and ideas necessary for making your spreadsheets more beautiful, professional-looking, and easier to work with.

Igor Ovchinnikov

Igor Ovchinnikov has been teaching software productivity classes for over 20 years. Stanford staff have enjoyed his training since around 2007. His training philosophy stems from a strong belief that learning is a perpetual cycle of new discoveries and improvement.

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training


University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.