Microsoft Excel
4.0 (18 ratings)
962 students enrolled
Wishlisted Wishlist

Microsoft Excel

A complete guide to learn the essential as well as the advanced features in Microsoft Excel 2010.
4.0 (18 ratings)
962 students enrolled
Created by ioniya .
Last updated 11/2013
English
English [Auto-generated]
Current price: \$10 Original price: \$20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
• 6 hours on-demand video
• 2 Articles
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• By the end of this course, you will be very fluent with excel.
• Learn Shortcuts used in Excel to make your life easy
View Curriculum
Requirements
• Microsoft Excel 2010
Description

A complete guide to learn the essentials as well as the advanced features in Microsoft Excel 2010. This course starts right from the basics of entering data into a cell to the advanced features of excel. Learning is made easier with the exercise files provided along with each of the tutorials. Take this course and see yourself work more efficiently than ever !!!

Who is the target audience?
• Students
• Working Professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
78 Lectures
05:55:34
+
Introduction to Excel 2010
2 Lectures 00:48
Preview 00:42

Exercise files
00:06
+
Data Entry
6 Lectures 30:53
Layout of excel
04:27

Entering data into cell
04:37

Understanding the backstage view
03:12

Alignment of entered data
05:25

Formatting the entered data
04:59

Preview 08:13
+
Shapes & data selection
4 Lectures 21:05
Inserting and editing shapes
06:18

Cut Copy and paste
05:52

Preview 06:03

Inserting rows and columns
02:52
+
Formula's and Function's
13 Lectures 01:12:06
Formulas
08:03

Preview 04:33

Creating range names
03:37

Using range names
04:45

Basic functions
04:47

References
07:58

If function
04:45

Sumif and average if
05:18

General math functions
05:57

Dates
08:42

06:23

Using formula across sheets
02:47

Formula Auditing
04:31
+
Conditional Formatting & Cipart
6 Lectures 35:21
Conditional formatting
07:10

More on conditional formatting
04:49

03:52

Pictures and clipart
06:34

Smartart
06:14

Inserting tables
06:42
+
Themes & Printing
9 Lectures 27:38
Worksheet theme
01:59

Applying theme
04:18

02:19

printing
06:16

More on printing
03:39

03:23

Inserting watermarks
02:07

Creating PDF
01:14

Freezing panes
02:23
+
Charts
6 Lectures 30:52
Introduction to charts
01:25

Inserting column bars
04:18

Customizing chart
07:01

Pie charts
08:15

Sparkline
06:27

Editing the data series
03:26
+
Managing Rows and columns
6 Lectures 31:00
Hiding rows and columns
03:35

Outlines
05:04

Working with sheets
06:29

05:41

Find select and sort filter
04:54

05:17
+
Data Tools
8 Lectures 35:07
Compound interest rate
03:10

Preview 04:57

Present value, period and rate
03:47

Creating loan schedule
08:21

Using data tables
03:19

Using two way data tables
03:07

Goal seek
02:39

Scenario manager
05:47
+
Data Validation
6 Lectures 25:04
Joining cells
04:58

Splitting the cell data
03:21

Uppercase and lowercase
04:10

Preview 03:30

Hlookup function
03:17

Data validation
05:48
3 More Sections