Microsoft Excel 2013 Foundation
- Offered bySimplilearn
- Private Institute
- Estd. 2010
Microsoft Excel 2013 Foundation at Simplilearn Overview
Duration | 15 hours |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Microsoft Excel 2013 Foundation at Simplilearn Highlights
- 24x7 learner assistance and support
- A great course for learning MS Office
- Certification Course
Microsoft Excel 2013 Foundation at Simplilearn Course details
- Microsoft Excel 2013 Foundation certification enables the professionals to gain proficiency in handling advanced formulas and tools. This certification training helps the users to enhance their skills in function with calculation, graphic tools, pivot tools, converting lists to a table and more. It is ideal for those who are looking to improve their job prospects by adopting Excel 2013 advanced skills and knowledge.
- 6+ Hrs of High Quality e-Learning content
- 53 demo's with example on application
- 1 Microsoft Excel Simulation Exam
- 6 Chapter End Quizzes
- Prepare for MOS Excel 2013 Core (77-4
- Aimed at helping those candidates who are new to Excel, this course imparts the knowledge required to efficiently handle the applications and tools of MS Excel. This enables the users to work with graphic tools, pivot tools and other calculations. This end-user course enables the participants to understand all capabilities of the Microsoft Excel.
Microsoft Excel 2013 Foundation at Simplilearn Curriculum
Overview of MOS Foundation
Welcome
Overview of MOS Foundation
Table of Content
Course Objective
Course Overview
Value of Excel for Professionals
Value of Excel for Organizations
Exam Pattern
MOS Excel Level Certification
Sources of Information
Thank you
Introduction to Excel
Introduction to Excel
Objectives
Excel Application User Interface
Excel Application User Interface contd
Excel Application Window
Excel Application Window Elements
Ribbon Options
Business Scenario
Demo Summary
Quick Access Toolbar
Customize Quick Access Toolbar
Business Scenario
Demo summary
Backstage View in Excel
New Features in Excel
Quiz
Summary
Thank You
Create and Manage Workbooks and Worksheets
Create and Manage Workbooks and Worksheets
Objectives
Excel Workbooks
Create a Blank Workbook
Create a Workbook from a Template
Open an Existing Workbook
Business Scenario
Demo Summary
Native and Non native Files
Connect Import External Files
Connect Import External Files contd
Business Scenario
Demo summary
Worksheet Operations
Change Worksheet Tab Color
Hide or Unhide Worksheets
Business Scenario
Demo summary
Search and Replace Data
Go To and Name Box
Business Scenario
Demo summary
Insert Hyperlinks
Business Scenario
Demo summary
Modifying Workbook Themes
Modify Page Setup
Insert and Delete Columns and Rows
Modify Row Height and Column Width
Hide or Unhide Columns and Rows
Business Scenario
Demo summary
Insert Headers and Footers
Insert Headers and Footers contd
Business Scenario
Demo summary
Data Validation
Data Validation contd
Business Scenario
Demo summary
Enable Developer Tab
Macro Security Options
Record Macros
Business Scenario
Demo summary
Backward Compatibility
Workbook Views
Use Zoom for Workbooks
Freeze Panes
Split Window
Business Scenario
Demo summary
Show Formulas
Business Scenario
Demo summary
Add Values to Workbook Properties
Business Scenario
Demo summary
Save Workbooks in Alternate File Formats
Set Print Area and Print Workbooks
Business Scenario
Demo summary
Save Workbooks to Remote Locations
Quiz
Summary
Thank You
Create Cells and Ranges
Create Cells and Ranges
Objectives
Cells and Ranges
Create Data using FillSeries
Business Scenario
Demo Summary
Create Data using AutoFill
Business Scenario
Demo Summary
Customize AutoFill Options
Business Scenario
Demo Summary
Paste Options
Paste Special
Format Cell Structure
Business Scenario
Demo Summary
Merge and Center
Business Scenario
Demo Summary
Format Cell Content
Business Scenario
Demo Summary
Cell Styles
Business Scenario
Demo Summary
Number Formats
Format Painter
Business Scenario
Demo Summary
Data Model with Advanced Conditional Format
Data Model with Advanced Conditional Format contd
Sparklines
Business Scenario
Demo Summary
Create Named Ranges
Business Scenario
Demo Summary
Data Group and Ungroup
Subtotals
Quiz
Summary
Thank You
Create Tables
Create Tables
Objectives
Tables in Excel
Create and Format a Table
Business Scenario
Demo Summary
Define Table Names
Business Scenario
Demo Summary
Insert Table Rows and Columns
Business Scenario
Demo Summary
Delete Table Rows and Columns
Business Scenario
Demo Summary
Move Table Rows and Columns
Business Scenario
Demo Summary
Convert to Range
Business Scenario
Demo Summary
Remove Duplicates
Business Scenario
Demo Summary
Design Table Styles
Business Scenario
Demo Summary
Table Style Options
Filter Tables
Business Scenario
Demo Summary
Sort Table Data
Business Scenario
Demo Summary
Quiz
Summary
Thank You
Apply Formulas and Functions
Apply Formulas and Functions
Objectives
Formulas and Functions
Cell References and Ranges in Formulas
Cell References and Ranges in Formulas contd
Business Scenario
Demo Summary
Formula Calculations Order
SUM Function
Business Scenario
Demo Summary
COUNT Function
COUNTA Function
Business Scenario
Demo Summary
AVERAGE Function
MIN Function
MAX Function
Business Scenario
Demo Summary
Conditional Logic in Functions
SUMIF Function
SUMIFS Function
Business Scenario
Demo Summary
COUNTIF Function
COUNTIFS Function
Business Scenario
Demo Summary
AVERAGEIF Function
AVERAGEIFS Function
Business Scenario
Demo Summary
LOWER PROPER UPPER and CONCATENATE Functions
TRIM Function
Business Scenario
Demo Summary
LEFT Function
RIGHT Function
mid Function
Business Scenario
Demo Summary
Quiz
Summary
Thank You
Create Charts and Objects
Create Charts and Objects
Objectives
Introduction to Charts
Create Charts
Create Charts contd
Create Charts contd
Business Scenario
Demo Summary
Format Charts
Format Charts contd
Business Scenario
Demo Summary
Move and Resize Charts
Business Scenario
Demo Summary
Recommended Charts
Business Scenario
Demo Summary
Recommended Charts
Insert Picture Objects
Business Scenario
Demo Summary
Insert Other File Formats as Objects
Business Scenario
Demo Summary
Add Textboxes
Business Scenario
Demo Summary
Add SmartArt
Business Scenario
Demo Summary
Quiz
Summary
Thank You
Other courses offered by Simplilearn
Student Forum
Anything you would want to ask experts?