Excel 2010
4.7 (7 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.
88 students enrolled
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.7 (7 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.
88 students enrolled
Created by Learn iT! Anytime
Last updated 6/2013
English
Current price: $12 Original price: $45 Discount: 73% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Become a Master in the Work Place using Excel 2010
View Curriculum
Requirements
  • None
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
Compare to Other Excel Courses
Curriculum For This Course
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
Learn iT! Anytime
4.3 Average rating
587 Reviews
5,185 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.