Introduction to Microsoft Excel 2010

Learn the basics of using Microsoft Excel 2010

Created bySimon Sez IT

Last updated 4/2026

English

English [Auto],

What you'll learn

Entering text and numbers into a spreadsheet.
Using the order of operations for formulas.
How to save an Excel spreadsheet file and the different file formats.
Using the freeze pane option to freeze rows or columns in a spreadsheet.

Course content

5 sections • 20 lectures • 1h 28m total length

Introduction and Overview of Excel 2010 Course0:57
Join Cindy for the Excel 2010 training, starting from the basics and learning the screen and terminology. Create your first workbook, customize it, and explore printing and formulas.
READ ME: Essential Information for a Successful Training Experience0:55
Overview of the Excel Window11:52
Working with the Mouse4:05
Excel Options2:44
Explore Excel options in Excel 2010 to tailor general settings, ribbon customization, and advanced preferences, including mini toolbar, live preview, font size, formulas, proofing, and add-ins.

Entering Text and Numbers5:39
Learn to start a new workbook in Excel 2010, enter text and numbers, navigate cells with enter, tab, or the check mark, and use the fill handle to auto-fill months.
Creating Basic Formulas6:55
Relative References1:54
Order of Operations4:33
Explore how Excel follows the order of operations in formulas, from parentheses to exponents, then multiplication, division, addition, and subtraction, with practical examples.
Working with Ranges5:03
Explore ranges—adjacent cells from a start to an end cell like B3:C5—selected by dragging or shift-clicking, used in formulas, with the status bar showing sum, min, max, and average.

Working with Save and Save As Commands5:22
Master saving workbooks by using save and save as, choosing a location and file name, and understanding extensions so changes are saved and organized on your drive.
File Extensions3:48
Understand Excel file extensions, from three- to four-letter formats, and how older versions affect compatibility. Choose save as type to pick xls, xlsx, csv, pdf, or templates, cross-program access.

Opening a File4:37
Working with Larger Files6:27
Freeze Panes Options2:20
Learn to use Excel's freeze panes and split screen to keep headers visible as you scroll, choosing freeze panes, the top row, or the first column, and unfreeze when needed.
Split Screen Option3:43
Master the split screen option in Excel 2010 to view two parts of a workbook at once, using a movable splitter and dual scroll bars for comparisons.
Course Review0:43
Encourages learners to rate the course with stars, leave comments, and provide feedback to improve the training material.
Bonus lecture5:00
Get 70% off any Simon Sez IT courses offered at Udemy. See the attached file for discount links and discount codes.

Requirements

Microsoft Excel 2010

Description

During this introductory course on using Microsoft Excel 2010, we'll teach the basics of using Microsoft Excel 2010.

Your professional instructor will talk you through Excel 2010's features, starting with the basics, from creating files to editing existing documents. You'll start with creating a new workbook and entering text and numbers, moving onto saving and printing your documents.

The course is designed for individuals and office professionals who need to learn the basics of Microsoft Excel 2010.

Who this course is for:

Anyone new to Microsoft Excel or upgrading from an earlier version.

Introduction to Microsoft Excel 2010

What you'll learn

Explore related topics

Course content

Introduction to Excel5 lectures • 21min

Creating a New Workbook5 lectures • 24min

Saving Workbooks2 lectures • 9min

Navigating Workbooks6 lectures • 23min

Additional Training2 lectures • 17min

Requirements

Description

Who this course is for: