Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Formatting Numbers and Cells in Excel for Beginners

Formatting Numbers and Cells in Excel for Beginners

A beginner's guide to Excel spreadsheets, formulas, and fundamental data analysis.
Created bySimon Sez IT
Last updated 3/2025
English

What you'll learn

  • Demonstrate proficiency in applying specific number and date formats in Excel.
  • Customize Excel elements by formatting cells, rows, and columns effectively.
  • Apply Format Painter for quick and consistent formatting across multiple cells or ranges.
  • Apply number formats such as currency and percentage.

Course content

1 section10 lectures39m total length
  • Course Introduction1:55
  • WATCH ME: Essential Information for a Successful Training Experience2:11
  • DOWNLOAD ME: Course Files0:23
  • DOWNLOAD ME: Exercise Files0:23
  • Applying Number Formats10:03
  • Applying Date and Time Formats5:38
  • Formatting Cells, Rows and Columns8:38
  • Using Format Painter4:39
  • Exercise4:06
  • Course Close1:06
  • Course Quiz

Requirements

  • Microsoft Excel 2021 installed – You need Excel 2021 to follow along.
  • Basic computer skills – Familiarity with using a computer and navigating files.
  • No prior Excel experience required – This course is for beginners.
  • Access to the internet – For downloading course materials and resources.
  • Willingness to practice – Regular practice will help reinforce your learning.

Description

**This course includes downloadable course instructor and exercise files to work with and follow along.**


Welcome to the Microsoft Excel Beginner course. This short course is designed to teach you how to format numbers and cells in Excel. This course covers applying general, currency, percentage, and date formats, helping you present data clearly and professionally. You'll explore key tools within Excel, like the Number Formatting group on the Home ribbon, and how to adjust settings for better readability. Each lesson includes video tutorials and downloadable exercises, ensuring hands-on practice for comprehensive learning.


Whether you are taking your first steps into spreadsheet management or seeking to solidify your beginner-level skills, this course will equip you with the skills to create high-quality spreadsheets that meet the needs of your audience. Join us and elevate your Excel proficiency today.


In this course, you will learn how to:

  • Demonstrate proficiency in applying specific number and date formats in Excel.

  • Customize Excel elements by formatting cells, rows, and columns effectively.

  • Apply Format Painter for quick and consistent formatting across multiple cells or ranges.

  • Apply number formats such as currency and percentage.


This course includes:

  1. 38 minutes of video tutorials

  2. 7 individual video lectures

  3. Course and Exercise Files to follow along

  4. Certificate of completion

Who this course is for:

  • Beginners who are new to Excel 2021 and spreadsheets.
  • Anyone looking to improve their skills in formatting numbers and cells.
  • Students or professionals wanting to enhance their Excel proficiency for personal or work-related tasks.
  • Anyone who want to learn how to organize and format data effectively in Excel.