03:53:52 Hrs
Course Description
Excel 2013
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
Excel 2013
BM
Lesson Plans
Duration
Status
Notes
- 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