Simple and Easy: Microsoft Excel 2010 Basic/Intermediate
3.5 (2 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.
10 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Simple and Easy: Microsoft Excel 2010 Basic/Intermediate to your Wishlist.

Add to Wishlist

Simple and Easy: Microsoft Excel 2010 Basic/Intermediate

From the basics through to intermediate topics, learn all you need to know to have command over Excel.
3.5 (2 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.
10 students enrolled
Created by GEM Learning
Last updated 5/2013
English
Price: $20
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV

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?
  • Learn how to format in Excel, as well as use tables, charts, and illustrations
  • Learn about functions, ranges, data filtering, date & time, and other useful functions
  • Learn how to use Excel for business, along with customization, formulas and, filters and more
  • Also learn about how we are changing how people are learning! Visit www.gemlearning.com
View Curriculum
Requirements
  • No prior knowledge required, just a desire to improve and Excel on your system!
Description
This course will teach you everything you need to know to usefully make use of and benefit from Microsoft Excel. The course has been divided into Basic and Intermediate levels. You can either build your expertise from the ground up and start off at basic, or you may choose any of the sub-topics directly by clicking on the video and learning what interests you. Ideal for beginners, students, and professionals, as well as those who may already have a basic understanding of spreadsheets or data analysis.
Who is the target audience?
  • Beginners who have no prior Excel knowledge
  • Intermediate users who want to get the most of Excel at work, home or school
Compare to Other Excel Courses
Curriculum For This Course
113 Lectures
04:25:41
+
Formatting (Beginner Section 2/5)
13 Lectures 42:08



Selecting Cells
04:18

Rotate Cell Data
02:47

Inserting Cells Rows and Columns
02:48

Indenting Cell Data
02:31

Fill Color Patterns and Gradients
04:04

Adding Cell Borders
03:55

Sort Columns
02:49

How to Sort Data of a Single Column
01:14

Conditional Formatting
02:56

Find and Replace Feature
04:11
+
Illustrations (Beginner Section 3/5)
4 Lectures 08:26
Inserting ClipArt
02:27

Inserting Pictures
01:37

Inserting Shapes
01:14

Inserting SmartArt
03:08
+
Working with Tables (Beginner Section 4/5)
6 Lectures 11:10
Creating Tables
02:13

Apply a Table Style
01:37

Filter Numbers
02:39

Filter Dates
02:04

Filter Colors
00:49

Creating a Summary
01:48
+
Working with Charts (Beginner Section 5/5)
13 Lectures 24:44
Getting to Know Charts
02:29

Inserting Charts
00:41

Right Type of Chart
04:45

Types and Styles of Charts
02:21

Add Titles to Charts
01:45

Add Data Labels to Charts
02:10

Formatting X and Y Axes
01:43

Formatting Charts
02:31

Editing a Chart's Data Source
01:49

Move and Resize Charts
02:08

Moving Chart to Chart Sheet
00:54

Printing an Embedded Chart
00:44

Copy Charts to Word
00:44
+
Intermediate Level 1/9 (Level 6)
14 Lectures 24:17
Insert Text
02:25

Insert Hyperlinks
02:07

Inserting WordArt
01:17

Inserting Text Box
00:57

Inserting Symbols
01:17

Inserting Objects
01:55

Headers & Footers
01:35

Freeze and Unfreeze Panes
02:20

Borders & Gridlines
02:07

Wrap Text and Merge & Center
02:19

Format Painter
01:25

Using Templates
01:22

Grouping and Ungrouping Worksheets
01:25

Paste Special
01:46
+
Intermediate Level 2/9 (Level 7)
8 Lectures 21:32
Insert a Function From a Function Library
01:22

Insert Function Command
02:22

Relative References
02:03

Absolute References
02:21

Named Ranges
01:54

Reference Formulas and Data on Other Sheets
01:40

Text Functions in Excel
05:29

Find and Replace Feature
04:21
+
Intermediate Level 3/9 (Level 8)
8 Lectures 24:55
Today and Date Functions
01:55

Date Formats
01:02

Days Between Dates
00:49

Calculating Age or Anniversary Date
02:36

Workday Function
04:04

Net Workdays Function
03:11

Working with Overtime Hours in Excel
07:20

Now, Time and TimeValue Functions
03:58
+
Intermediate Level 4/9 (Level 9)
8 Lectures 16:41
Logical Functions
05:43

'Not' Function
00:42

Assigning Letter Grades
02:56

Pass or Fail Grades
01:28

Blank, Text or Number Containing Cell
00:46

Count Cells with Text
01:45

Vector Form of Lookup
02:35

Calculating Sales Tax
00:46
+
Intermediate Level 5/9 (Level 10)
4 Lectures 07:39
Goal Seek Intro
01:23

Using Goal Seek
02:35

Scenario Manager
02:48

Scenario Summary Report
00:53
4 More Sections
About the Instructor
GEM Learning
3.6 Average rating
3 Reviews
40 Students
3 Courses
Educate. Inspire. Enable.

GEM Learning is a learning solutions provider with expertise in corporate and technical training and e-learning. We specialize in e-learning and instructor-led classes for organizations, governments and institutions. 

GEM's IT trainers have developed software training screencasts that have been used by learners in many countries. we are now making them available to a wider audience through Udemy.com.