Excel 2010/2013
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

< Previous: Word Beginner 1

Next: Excel Beginner 2 >

Excel 2010 Beginner Level 1
Beginner Microsoft Excel Tutorial - 1 Hour 29 Minutes

Are you new to Microsoft Excel 2010? This video tutorial will teach you all of the basics of how to use Excel. You will learn:
  - The Excel 2010 Interface & The Ribbon
  - Entering & Editing Data
  - The Formula Bar
  - Rows, Columns, Cells, Ranges
Worksheets & Workbooks
  - Formatting Data & Cells
  - Basic Math Calculations & Formulas
  - Saving, Loading, Printing Sheets

Order Now

If you would like a preview of what's covered in this class,
click here to watch the first lesson of this course (free of charge), or scroll down for more information.


Excel 2010 Beginner Level 1
Description: Excel 2010 Beginner Level 1
Versions: Microsoft Office Excel 2010
Pre-Requisites: Working knowledge of Microsoft Windows required
Basic knowledge of Microsoft Word helpful
Running Time: 1 Hour 29 Minutes
Cost: $5.99

This course is for the novice user who has little or no experience with Microsoft Excel. We will begin by learning about the parts of the Excel interface, including the Title Bar, window control buttons, File menu, and more.


You will learn about the new Ribbon, the different tabs, groups, command, and dialog menus.


Next you will learn about the Quick Access Toolbar, the status bar, zoom controls, and scroll bars.


We will next learn about the Formula Bar, the different parts of a spreadsheet including rows, columns, and cells. You'll learn how to use the mouse pointer with respect to Excel, and learn about the different Sheet Tabs.


You'll learn how to properly input data into an Excel spreadsheet. We'll create a sales summary sheet in class with different sales reps and their sales figures by month. You'll see how to work with both the mouse and keyboard.


We'll learn how to edit data in our sheet. You'll learn how to replace data in the cells, edit data using the Formula Bar, and use Edit Mode directly in a cell. You'll also learn about Undo and Redo.


You will learn how to format your spreadsheet to make it look more professional. You'll learn about cell alignment, ranges, bold, italics, underline, and more.



Next we'll learn more formatting techniques. You'll change the font and font size. You'll learn how to resize columns and rows, change color, and more.



You will learn how to perform basic math calculations in Excel, and how formulas work. You'll learn about the basic math operators (add, subtract, multiply, divide, exponent) and how to use constants in your formulas.



We'll learn how to add multiple cells, use the mouse to build our formulas, work with the status bar, calculate an average, and we'll learn about the all-important Order of Operations.



Finally, you'll learn how to save, load, and print your worksheets. You'll also learn about pinning your files to the Recent Documents menu, and previewing your sheet before you print it.



Again, this is the perfect class for anyone who is new to Microsoft Excel 2010. If you have little or no experience with spreadsheets, or you just want to get familiar with how Excel 2010 works, this class is for you. You should have some basic knowledge of Windows beforehand, and a little bit of Microsoft Word helps (so you're familiar with formatting text), but we'll teach you everything you need to know to use Excel to make simple spreadsheets. 

Of course, if you have any questions about whether or not this class is for you, please contact me.


Complete Outline - Excel 2010 Beginner Level 1

01. Excel Interface 1 (6:22)
Starting Excel
The Ribbon Changes with Window Size
Title Bar
Maximize, Minimize, Restore Down
Close Button
File Tab - Backstage View

02. Excel Interface 2 (7:06)
The Ribbon
Ribbon Tabs, Groups, Buttons
Help Popup Menus for Each Command
Command Buttons
Drop-Down Menus
Command Button Groups
Dialog Box Launcher Buttons

03. Excel Interface 3 (5:30)
Quick Access Toolbar
Adding or Removing a Command from QAT
Status Bar
Views Buttons
Zoom Controls
Scroll Bars

04. Excel Interface 4 (5:55)
Formula Bar
What is a Spreadsheet
Columns, Rows, Cells
Name Box
Mouse Pointer
Sheet Tabs

05. Entering Data (5:19)
Creating a sales summary sheet
Entering text in Excel
Typing data into a cell
Select a Cell with Mouse
Select a Cell with Keyboard
Move with ENTER, TAB
Move with Arrow Keys
Entering Data

06. Editing Data (7:37)
Editing data in a cell
Four methods for editing data
Overtyping your data
Replacing data in your cells
Editing data using the Formula Bar
Editing a cell by double-clicking
Backspace vs. Delete Keys
Edit Mode with F2
Deleting data in a cell
Using UNDO in Excel
Using REDO in Excel
07. Formatting 1 (6:14)
Home, Alignment
Formatting your text
Horizontal cell alignment
Align Right, Left, Center
Format multiple cells at once
A Cell Range defined
Cell Range Notation (A1:B5)
Selecting cell rangess
Bold, Italics, Underline

08. Formatting 2 (8:40)
Changing the Font
Live Preview
Change Font Size Dropdown
Type in a Font Size Manually
Increase Font Size
Decrease Font Size
Resizing Columns
Changing Column Width
Resize Column with Double-Click
Resizing Rows
Background Color / Fill Color
Foreground Color / Font Color

09. Basic Math 1 (7:48)
Moving to a different sheet tab
Using a "scratch" sheet
Adding two cells together
How Formula Work in Excel
Auto Recalculation of Formula
See Formula in Formula Bar
See Result on the Sheet
Basic math operators
Using Constants
Clearing a range of cells
Selecting an Entire Column

10. Basic Math 2 (5:11)
Adding Multiple Cells
Select to See Summary in Status Bar
Click to Add Cell to Formula
Order of Operations
Using parentheses in math operations
Average a Group of Cells

11. Save, Load, Print (8:24)
Saving Your Workbook File
Save As a Different File
Open Recent Documents
Open Any Document
Pinning Documents to the List
Create a New Blank Workbook
Print Preview
Print Your Spreadsheet

12. Review (4:57)


Keywords: microsoft excel tutorial, microsoft excel 2010 tutorial, microsoft office excel 2010 tutorial, microsoft excel 2010 training, ribbon, interface, formula, sheet tabs, sales summary, entering data, editing data, formatting, cell, range, column, row, align, math, addition, subtraction, multiplication, division, constants, adding, save, load, print, workbook, worksheet

Student Interaction: Excel 2010 Beginner 1

Richard on 1/1/2010:  This is the first beginner class for the Microsoft Excel novice. You will learn: The Excel 2010 Interface & The Ribbon, Entering & Editing Data, The Formula Bar, Rows, Columns, Cells, Ranges, Worksheets & Workbooks, Formatting Data & Cells, Basic Math Calculations & Formulas, Saving, Loading, Printing Sheets
 Lynn Robbins on 12/21/2010: I enjoyed the excel 2010 beginner course.
Looking forward to other excel 2010 and access 2010 courses

robert on 9/11/2011: I realey enjoyed excel beginner 1 looking forward to learning excel 2
you make it so easey

bill ritchie on 1/8/2012: lesson 11 stops at 3:59.
  on 2/11/2012: I am at Excel 2010,Beginner 1, lesson 11, time index is 3.59 and the video stop. Pls advise how to fix the problem, tks
 robert on 4/8/2012: it explained very well

Patrick Woo-Ching on 4/27/2012: how can make colums in a cell
cira on 2/2/2013: very good lesson, i like it so much
Annie Kingi on 2/13/2013: Thank you very much for your course, very informative and easy to follow along.
Susan on 11/25/2013: How to print when part of the work is out of the page?
Normand J Caron on 2/18/2014: I really enjoyed this course. I was able to create a sample spreadsheet with colors, highlight, bold and underline. Richard is an excellent instructor.
teresa hajek on 5/23/2014: gust want I needed. looking forward to more lessons.
teresa hajek on 5/23/2014: perfect lesson for first time users with excel. I look forward to other lessons.
Julie Martin-Beaulieu on 7/16/2014: I am using excel 2013, will this apply?
Thanks, Julie

Reply from Richard Rost:

Yep. The two versions are almost identical.

Cynthia M on 10/30/2014: I had the same question, I am using 2013 Excel. Thanks
Alonzo Dumas on 1/7/2015: Is there a online tests after each course?

Reply from Alex Hedley:

There used to be a system for Tests but it's currently being redeveloped.

Would you find something like this useful?
What would you want it to be like?

iqbal on 4/1/2015: i have benifited a lot from this site and thanks to richard for such a wonderful work.how can i get the full package for expert and advance excel and access 2913.i am from pakistan.please help me in this regard

Reply from Alex Hedley:

You can order any courses using the order form.

John Bill Law on 8/18/2015: Thanks
Jonathan Singer on 10/26/2015: how do I fast forward

Reply from Alex Hedley:

You can select or scrub to any part in the video.

Richard Mumba on 11/15/2015: I like the course so much it has really jam started me.

Reply from Alex Hedley:

Glad you're enjoying it Richard :)

kamalakar reddy on 12/6/2015: do i have to watch 599 cd .there is no excell platform in my computer

Reply from Alex Hedley:

There are many videos for many programs, which program do you want to learn?


Reply from Alex Hedley:

There was a short outage at the weekend that may have delayed the time it became available.

samuel campbell on 3/11/2016: I wish to take Excel beginner lesion 2 would I be able to revert back to lesion 1 for memory purposes?

Reply from Alex Hedley:

Any courses you have purchased will be available in the theater so you can watch as many times as you'd like.

louella rodricks on 7/1/2016: when do you have advanced courses after this

Reply from Alex Hedley:

There are Expert courses for 2010, checkout the Course List

Chris Knapp on 2/6/2017: I purchased Excel12010B1 and the handbook but I'm only able to view the intro video before I'm directed to a blue screen telling me to purchase the class that I already have. I've logged on and off and closed my browser numerous times and sent two customer service emails without a response.

Reply from Alex Hedley:

Was the email you purchased it with the email you are logging in with?
Did you get a confirmation email with the order?

samuel campbell on 10/1/2018: I believe that I need some of the WORD classes to learn how to create folders etc. How do I get started on that? my last job required me to make daily reports and place them into folders with pictures taken daily. I could not and lost the job.

Reply from Alex Hedley:

This is more a WINDOWS thing, have you taken any of those courses?


You may want to read these articles from the 599CD News:


Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP