Top Reasons to Buy

100% Animated Lessons
Unlimited Course Access
Unlimited Practice Test - Avoid Exam Fear
Instant Report Alerts - SMS/App/Email Alerts
Access both Web & Apps
Try our Free Trial - Like It, Buy It

Lowest Price - High Quality Product
Save your Tuition Fee - Watch & Teach
Save Time - Learn Anytime, Anywhere
1 Lakh Worth of Course Library
Family License ( 1+2 Licenses) - 1st in India
1 Subscription Fee - 3 Licenses (Father, Mother, Child)

Demo links

Must see Links

Excel 2013

Excel 2013 icon

03:53:52 Hrs

Lesson Plans : 76
Self Assessments : 0

Course Description

Excel 2013

Video Resolution:

Lesson search

Related Courses

Lesson Plans
Bookmark
Glossary

BM

Lesson Plans

Duration

Status

Notes

Collapse all Expand all

Author MentoringOpen or Close

-

Audience for this Course

01:09

-

Job Roles and Employment Opportunities

01:15

FundamentalsOpen or Close

-

What is Microsoft Excel?

03:09

Getting started with Excel 2013Open or Close

-

New Features of Excel 2013

03:13

-

Understanding Ribbon

02:47

-

Customizing the Ribbon - Part I

04:48

-

Customizing the Ribbon - Part II

02:32

Customizing the WorkbooksOpen or Close

-

Arranging Multiple Windows

02:40

-

Modifying Workbooks and Worksheets - Part I

04:41

Working with Data and Excel TablesOpen or Close

-

Using Fill Options

02:58

-

Understanding the Flash Fill Option

02:41

-

Moving Data within a Workbook

02:28

-

Finding and Replacing Data

03:36

-

Correcting And Expanding Upon Data

02:29

-

Working Excel Tables - Part I

02:01

-

Working Excel Tables - Part II

03:03

Performing Calculations on DataOpen or Close

-

Simple Operators and Precedence

02:17

-

Working with Formulas

03:46

-

Summarizing Data using Conditions

02:58

-

Working with Iterative Calculation Options

03:00

-

Understanding Arrays in Excel 2013

03:09

-

Finding and Correcting Errors in Calculations

04:33

Changing Appearances in WorkbookOpen or Close

-

Formatting Cells

03:45

-

Working with Styles

02:41

-

Applying Workbook Themes

03:49

-

Adding Images to Worksheets

02:18

Using FiltersOpen or Close

-

Limiting Data Using Filters

04:19

-

Manipulating Worksheet Data

03:10

-

Using Data Validation

02:39

Reordering and Summarizing DataOpen or Close

-

Sorting Worksheet Data

01:59

-

Sorting with Custom Lists

02:03

-

Organizing Data into Levels

02:44

Combining Data from Multiple SourcesOpen or Close

-

Using Workbook Templates

03:23

-

Link between Worksheets and Workbooks

03:53

-

Consolidating Multiple Data Sets

02:51

Analyzing Data and Alternative Data SetsOpen or Close

-

Using the Quick Analysis Lens

01:31

-

Working with Alternative Dataset

02:48

-

Defining Multiple Alternative Datasets

03:38

-

Analyzing Data by using Data Tables

01:56

-

Working with Goal Seek

02:25

-

Using Solver

06:44

-

Understanding Descriptive Statistics

02:22

Charts and GraphicsOpen or Close

-

Creating Charts Based on the Data

03:17

-

Customizing Charts

03:35

-

Working with Trends

01:20

-

Understanding Dual-axis Charts

02:15

-

Using Spark Lines

03:24

-

Working with Diagrams using SmartArt

03:15

-

Understanding Mathematical Equations

04:43

PivotTables and Pivot ChartsOpen or Close

-

Working with PivotTables

02:53

-

Filtering, Showing, and Hiding PivotTable Data

03:28

-

Editing PivotTables

02:59

-

Formatting PivotTables

04:21

-

Creating PivotTables using External Data

03:22

-

Creating Dynamic Charts

03:50

Print OptionsOpen or Close

-

Working with Page Headers and Footers

04:11

-

Page Setup Properties

02:53

-

Understanding Print Options

01:55

-

Printing Parts of Worksheets

03:43

-

Printing Charts

01:47

Macros and FormsOpen or Close

-

Enabling Macros

04:27

-

Examining Macros

02:34

-

Working with Buttons

02:47

-

Using Record Macro

02:20

-

Understanding Form Controls - Part I

03:44

-

Understanding Form Controls - Part II

07:33

Understanding Office365Open or Close

-

What is Office 365?

03:07

-

Office 365 Plans

02:45

-

System Requirements for Office365

01:35

-

Working with SkyDrive

02:25

-

Adding User in SkyDrive

02:08

Sharing WorkbooksOpen or Close

-

Understanding Sharing Workbooks

03:12

-

Managing Comments

01:57

-

Tracking and Managing Changes

03:00

-

Protecting Workbooks and Worksheets

05:05

-

Importing and Exporting XML Data

01:51

BM

Tips & Tricks

Status

Self Assessments

Attempts

Status

BM

Lesson Plans

Duration

Status

ABL

Notes

Exercise

Lesson Plans

Tips and Tricks

Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Glossary is not available for this index.

Scroll

sticky_image

Register for Free!

Special Subscription Offer

Get eGuruLive Premium at ~~Rs. 2499/-~~ Rs. 1249/-
Only
(all inclusive)
Grab This Offer
Close