Excel 2010 Introduction

All you need to know to unleash the power of Excel spreadsheets
4.6 (49 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
632 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 62
  • Length 4 hours
  • Skill Level Beginner Level
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2013 English Closed captions available

Course Description

This course is designed to teach students the fundamentals of Excel. Specifically you will understand how to create, save, enter data and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to format spreadsheets, manipulate columns and rows, add headers and footers and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks.

What are the requirements?

  • Basic Microsoft Windows training or equivalent experience

What am I going to get from this course?

  • Create the framework of a basic worksheet
  • Build formulas and work with basic functions
  • Edit a worksheet
  • Format a worksheet to enhance appear and increase readability
  • Handle large worksheets effectively
  • Protect a worksheet from edits
  • Print all or parts of a worksheet

What is the target audience?

  • Students who need to create, modify and print basic spreadsheets including formulas and functions

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
03:29
If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.
Section 2: Getting Started
Three Primary Functions of Excel
Preview
02:31
Spreadsheet Terminology
Preview
03:20
Overview of the Excel Screen
08:00
Navigating a Worksheet
06:08
Using Zoom
00:40
Section 3: Basic Worksheet Skills
Creating a New Workbook
03:32
Entering Data
05:20
Selecting a Range
02:10
Selecting Columns, Rows and Non-contiguous Cells
04:45
Using Worksheets
02:58
Using AutoFill
11:43
Deleting a Worksheet
00:52
Saving a Workbook
02:55
Section 4: Creating Formulas
Entering a Simple Formula
Preview
04:55
Using Cell Addresses in a Formula
Preview
01:21
Using Simple Functions: SUM
Preview
04:39
Using Autofill with Formulas
02:14
Using AutoSum
03:19
Inserting Functions: AVERAGE, MAX, MIN, COUNT
16:34
Working with Date Arithmetic
Preview
03:14
Date and Currency Formatting
Preview
03:13
Using Clear All
01:01
Relative v. Absolute Cell Addressing
05:51
AutoCalculate
Preview
01:56
Section 5: Editing a Workbook
Deleting a Range
Preview
01:53
Using Undo and Redo
Preview
01:14
Using Cut, Copy and Paste
Preview
02:40
Using Paste Options
Preview
05:20
Using the Clipboard Task Pane
02:00
Using Find and Replace
Preview
05:18
Section 6: Formatting the Worksheet
Inserting and Deleting Columns and Rows
Preview
05:19
Adjusting Column Widths and Row Heights
Preview
04:17
Hiding Rows and Columns
03:17
Changing Numeric Formats
01:49
Using the Format Cells Dialog Box
03:17
Changing Text Formats
02:00
Aligning Data
06:05
Using Borders and Shading
06:18
Using the Format Painter
01:30
Using Cell Styles
04:38
Creating New Cell Styles
01:17
Modifying Cell Styles
00:37
Using Themes
02:52
Section 7: Working with Large Worksheets or Multiple Workbooks
Using the Zoom Feature
02:43
Splitting the Window
04:03
Freeze and Unfreeze Panes
Preview
03:53
Tiling Multiple Workbooks
03:41
Synchronous Scrolling
00:56
Hiding, Maximizing, and Closing Windows
01:54
Section 8: Using Protection and Comment Boxes
Adding, Hiding, and Deleting Comments
06:14
Locking and Unlocking Cell Ranges
06:16
Section 9: Printing and Page Setup
Using Page Break Preview
07:10
Using Print Preview
04:35
Changing the Orientation
01:23
Changing the Margins
01:06
Adding Headers and Footers
04:50
Setting Sheet Options
01:52
Setting Print Titles
03:59
Working with Print Areas
01:27
Using the Page Layout Tab
02:28
Section 10: Conclusion
Conclusion
02:16

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.

Ready to start learning?
Take This Course