Excel 2010 Introduction
4.6 (51 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.
648 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2010 Introduction to your Wishlist.

Add to Wishlist

Excel 2010 Introduction

All you need to know to unleash the power of Excel spreadsheets
4.6 (51 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.
648 students enrolled
Last updated 10/2016
English
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
Requirements
  • Basic Microsoft Windows training or equivalent experience
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.

Who is the target audience?
  • Students who need to create, modify and print basic spreadsheets including formulas and functions
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 62 Lectures Collapse All 62 Lectures 03:49:07
+
Introduction
1 Lecture 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.
Preview 03:29
+
Getting Started
5 Lectures 20:39


Overview of the Excel Screen
08:00

Navigating a Worksheet
06:08

Using Zoom
00:40
+
Basic Worksheet Skills
8 Lectures 34:15
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
+
Creating Formulas
11 Lectures 48:17



Using Autofill with Formulas
02:14

Using AutoSum
03:19

Inserting Functions: AVERAGE, MAX, MIN, COUNT
16:34



Using Clear All
01:01

Relative v. Absolute Cell Addressing
05:51

+
Formatting the Worksheet
13 Lectures 43:16


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
+
Working with Large Worksheets or Multiple Workbooks
6 Lectures 17:10
Using the Zoom Feature
02:43

Splitting the Window
04:03


Tiling Multiple Workbooks
03:41

Synchronous Scrolling
00:56

Hiding, Maximizing, and Closing Windows
01:54
+
Using Protection and Comment Boxes
2 Lectures 12:30
Adding, Hiding, and Deleting Comments
06:14

Locking and Unlocking Cell Ranges
06:16
+
Printing and Page Setup
9 Lectures 28:50
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
+
Conclusion
1 Lecture 02:16
Conclusion
02:16
About the Instructor
Intellezy Trainers
4.4 Average rating
2,739 Reviews
19,219 Students
133 Courses
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.