Excel 2010

Online Excel training is designed to create a strong foundation for using the world's most popular business software.
4.5 (5 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.
69 students enrolled
$19
$45
58% off
Take This Course
  • Lectures 173
  • Length 9.5 hours
  • Skill Level All Levels
  • Languages English
  • 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 6/2013 English

Course Description

Online Excel training is designed to create a strong foundation for using the world's most popular business software as a place to organize and analyze information. Participants in this course will start by establishing fundamental skills and best practices essential for using Excel, and will leave with a working knowledge of advanced formulas and functions, as well as key tools to organize, format, and manage data in a spreadsheet. This  12 hour online Excel course is designed for individuals, Career Changers, and skill enhancement.

What are the requirements?

  • None

What am I going to get from this course?

  • Become a Master in the Work Place using Excel 2010

What is the target audience?

  • Everyone

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: Essentials and Intro to Formulas and Functions
Getting Started
Preview
01:03
Practice Starting Excel
Preview
02:32
Navigating
Preview
03:25
McDonalds Cash Register
Preview
01:19
Autofit Column Width
Preview
01:17
Replace Data
Preview
03:12
Accounting Formatting Looks Like Money
02:19
Zooming
01:06
Formulas Should Use Cell Addresses
06:23
More About Formulas
03:07
Copy and Paste Formula
03:10
Additional Arithmetic
06:51
Saving Files
03:17
Open Practice Fields
00:31
Sheet Tabs
02:33
Right Click Sheet Tabs for TOC
01:48
Sum Function
03:20
Ctrl + Enter Stays in the Cell to be Copied
03:19
Sum Down and Autofill Sideways
02:37
Max and Min
02:39
Autofill
01:29
Formula Auditing Tools
02:33
Absolute References
03:35
Evaluate Formula Button
13:13
Interactive 2003 Command Reference Guide
04:45
Course Check List
02:05
Section 2: Formatting, Spreadsheet Design, Page Setup and Printing
Open Excel Day 1 Workfiles
03:25
Insert a Sheet
03:59
Copy and Paste Between Sheets
02:02
Paste Widths
05:23
Pasting Continued
01:46
Insert a Column
01:34
Cut/Paste
02:42
Drag/Drop
01:54
Autofill A Months
02:46
Autofill with Days and Numbers
06:06
Formatting Cell Styles
06:47
Font Size
01:13
Number Formatting
02:43
Templates
14:09
Sheets: Color and Grouping
03:42
Sheets: Ungrouping and Deleting
02:08
Edit Multiple Sheets
01:44
Copy Entire Sheets
02:53
Spell Check
05:48
Freeze Panes
07:52
Unfreeze Panes and Split Screen
02:33
Custom Views
05:40
Page Setup for Printing
08:42
Page Layout View
02:41
Course Check List
02:05
Section 3: List/Table Essentials and Charting
Introduction
01:02
A Well-Defined List
03:26
Sort by One Field
05:28
Sort Multiple Fields
03:42
Custom Sort Lists
02:14
Create a Custom Sort List
03:42
Sorting Numbers, Dates, and Text
01:30
Filtering
03:16
Multi-field Filtering
01:33
Filter for a Range of Values
02:01
Remove One Filter at a Time
01:06
Remove Multiple Filters
02:29
Remove Autofilter Arrows
08:01
Create the Duplicate Record Problem
01:40
Automatic Subtotals
02:51
Sort Before Subtotaling
01:37
Subtotal by Division
02:56
Subtotal by Second Field
01:47
Format Cells as a Table
06:48
Convert to Range
00:44
Charts
02:04
Column Chart
02:56
Modifying Charts
01:29
Themes Affect Chart Colors
01:14
Change Chart Column Colors
01:23
Include a Chart Title
01:30
Add a Gradient Fill to the Plot Area
02:22
Switch Row and Column Order
02:45
Add Data to your Chart
01:33
Change Chart Column Order
00:54
Line Charts
01:09
X Axis for Line Charts
02:10
Pie Charts
02:25
Data Labels
01:39
Create a Chart Template
07:19
Printing Charts
01:42
Sparklines
04:14
Column-Style Sparklines
00:44
Win/Loss Sparklines
01:30
Course Check List
00:59
Section 4: Importing Data, Pivot Tables, Protecting and Linking Data
Introduction and Practice Files
01:16
Start Excel 2010
02:04
Look at the Text Data
01:46
Link to the Text File
08:52
Saving Workbook
00:37

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Learn iT! Anytime, Self-Paced Online Training Videos

Learn iT! Anytime is an online training provider with over 20 years of experience teaching to more than 450,000 students, including industry leaders. Our self-paced e-Learning helps you gain new skills, quickly and convieniently. If you're serious about learning, we're serious about providing you with the best content for your learning needs.

Ready to start learning?
Take This Course