Buying for a Team? Gift This Course
Wishlisted Wishlist

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

Add to Wishlist

Excel 2010

Online Excel training is designed to create a strong foundation for using the world's most popular business software.
4.5 (6 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.
74 students enrolled
Last updated 6/2013
English
$15 $45 67% off
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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.

Who is the target audience?
  • Everyone
Students Who Viewed This Course Also Viewed
What Will I Learn?
Become a Master in the Work Place using Excel 2010
View Curriculum
Requirements
  • None
Curriculum For This Course
Expand All 173 Lectures Collapse All 173 Lectures 09:24:35
+
Essentials and Intro to Formulas and Functions
26 Lectures 01:23:28






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
+
Formatting, Spreadsheet Design, Page Setup and Printing
25 Lectures 01:42:17
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
+
List/Table Essentials and Charting
40 Lectures 01:39:54
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
+
Importing Data, Pivot Tables, Protecting and Linking Data
36 Lectures 01:44:12
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

Editing Text Data in Excel
01:33

Edit Data in Notepad
01:41

Refresh the Excel Communication
01:30

Link to Access
03:26

Editing from Excel
05:52

Open Day Two Workfiles
01:11

Export to PDF
02:14

Renaming Worksheets
00:47

Pivot Tables
03:58

Classic Pivot Table Skeleton
02:50

Creating Pivot Table
04:23

Multiple Fields in Pivot Table
03:15

Formatting Totals
02:36

Report Filter and Slicer
03:27

Pivot Chart
01:10

Filter the Table and Chart
02:10

Insert a New Sheet
04:05

Link by Copy/Paste
01:37

Insert Comment
01:12

Show all Comments
00:24

Print with Comments
01:24

Conditional Formatting
04:31

Color Scales
03:14

Data Bars
02:04

Data Validation
08:02

Data Validation Value Boundaries
04:06

Conditional Formatting for DV Rule Breaker
01:45

Protect the Worksheet
06:47

Protect the Workbook
03:01

Protect the File
04:23

Course Check List
00:59
+
Creating Forms
21 Lectures 01:30:46
Download Practice Files
00:43

Creating Range Names
02:16

Names in Formulas
04:44

Create Names from Selection
04:49

Logical Functions
02:00

If Functions
06:37

Nesting If Functions
12:34

V Lookup
12:55

Copy and Adjust V Lookup
02:59

V Lookup with TRUE
05:59

Using TRUE
03:55

Nest If Inside V Lookup
00:56

Nest If Inside V Lookup (cont.)
01:35

Sumif
04:00

Averageifs
03:15

Sumifs
03:57

Data Validation List
02:12

Date Functions
10:30

Today Function
01:59

Overview
01:50

Course Check List
01:01
+
Creating Reports
25 Lectures 01:23:58
Getting Started
02:42

Consolidate
05:42

Opening a Template
01:48

Goal Seek
05:32

Goal Seek (cont)
01:18

Install Solver Addin
07:48

Practice Constraints 2 and 3
02:14

Constraint 3
01:40

Constraint 4
00:40

The Results
03:15

Absolute References via F4
06:41

Two-Variable Data Table
03:01

Scenario Manager
09:46

Summary Sheet
02:02

Install Developer Tool
00:50

Record Absolute References Macro
06:03

Visual Basic Editor
02:18

Relative Macro References
02:49

Problems Running H3 Relative Macro from F3
03:06

Relative Recorded from H3
04:14

Additional Macros
02:06

Assign KBD Shortcut Later
01:14

Macro with Ribbon
02:42

Excel Speaks
03:26

Course Check List
01:01
About the Instructor
4.2 Average rating
407 Reviews
3,912 Students
21 Courses
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.

Report Abuse