Microsoft Excel 2013 Advanced
4.6 /5- Offered bySimplilearn
- Private Institute
- Estd. 2010
Microsoft Excel 2013 Advanced at Simplilearn Overview
Duration | 25 hours |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
Future job roles | Application Security, Audacity, Appraisal, Research Associate , Asset Allocation |
Microsoft Excel 2013 Advanced at Simplilearn Highlights
- Experienced and certified trainer are subject matter experts who constantly research the latest trends and infuse them into our training programs
- Training for Microsoft 77-428 exam
- A great course for learning Financial modelling
- Certification Course
Microsoft Excel 2013 Advanced at Simplilearn Course details
- Excel is a powerful spreadsheet application created by Microsoft which helps you to understand and analyze business functions
- This application is mainly useful for business heads for taking decisions about their business
- Microsoft introduced a number of new features in Excel 2013, such as saving files in remote locations, new chart types, slicers and timeline feature to work with pivot tables, FlashFill, etc
- All these features allow the user to work with data more efficiently and effectively
Microsoft Excel 2013 Advanced at Simplilearn Curriculum
Lesson 01 - Manage and Share Workbooks
Introduction
Objectives
Modify Workbook Templates
Business Scenario
Demo - Modify Workbook Templates
Merge Multiple Workbooks
Business Scenario
Demo - Merge Multiple Workbooks
Manage Multiple Versions Of A Workbook
Remove Workbook Metadata
Copy Styles Between Tables
Business Scenario
Demo - Copy Styles Between Templates
Copy Macros Between Workbooks
Business Scenario
Demo - Copy Macros Between Workbooks
External Data Connections
Business Scenario
Demo - External Data Connections
Protect Workbooks For Sharing
Business Scenario
Demo - Protect Workbooks For Sharing
Protect Worksheet Structure
Business Scenario
Demo - Protect Worksheet Structure
Set Tracking Options
Business Scenario
Restrict Editing And Limiting Editors
Business Scenario
Demo - Restrict Editing And Limiting Editors
Encrypt Workbooks With A Password
Business Scenario
Demo - Encrypt Workbook With A Password
Business Scenario
Demo - Mark Workbooks As Final
Control Calculations Options
Business Scenario
Demo - Control Calculations Options
Summary
Mark Workbooks As Final
Quiz
Lesson 02 - Apply Custom Formats and Layouts
Apply Custom Formats and LAyouts
Objectives
Create Custom Formats (number, Time, Date)
Business Scenario
Demo - Create Custom Formats Number Date
Create Custom Accounting Formats
Advanced Fill Series Options
Business Scenario
Demo - Advanced Fill Series Options
Create Custom Templates
Create And Modify Cell Styles
Business Scenario
Demo - Create And Modify Cell Styles
Create Custom Color Formats
Business Scenario
Demo - Create Custom Color Formats
Create Custom Font Formats
Business Scenario
Demo - Create Custom Font Formats
Create Themes
Business Scenario
Demo - Create Themes
Create Form Fields
Business Scenario
Demo - Create Form Fields
Control The Tab Order Of Objects
Summary
Quiz
Lesson 03 - Create Advanced Formulas
Introduction
Objectives
Nested Functions
If, And, Or Functions
Business Scenario
Demo - If And Or Functions
Advanced Sumifs Function
Business Scenario
Demo - Advanced Sumifs Functions
Advanced Countifs Function
Business Scenario
Demo - Advanced Countifs Functions
Advanced Averageifs Function
Business Scenario
Demo - Advanced Averageifs Functions
What-if-analysis Tools
Watch Window
Business Scenario
Demo - Utilize Watch Window
Goal Seek
Business Scenario
Demo - Goal Seek
Create Scenarios
Business Scenario
Demo - Create Scenarios
Create Data Table
Business Scenario
Demo - Data Table
Consolidate Data
Business Scenario
Demo - Consolidate Data
Financial Functions
Summary
Quiz
Lesson 04 - Create Advanced Charts and Objects
Introduction
Objectives
Pivotchart
Create New Pivotcharts
Business Scenario
Demo - Create New Pivotcharts
Pivotcharts With Animations
Business Scenario
Pivotcharts With Animations
Manipulate Options In Existing Pivotcharts
Business Scenario
Manipulate Options In Existing Pivotcharts
Pivotchart Styles
Business Scenario
Demo - Pivotcharts Styles
Summary
Quiz
Lesson 05 - Excel 2013 Advance New Features
Introduction
Objectives
Introduction To Apps For Office
Installing Apps From Office Store
Business Scenario
Demo - Installing Apps From Office Store
Inserting And Managing Apps
Business Scenario
Demo - Inserting And Managing Apps
Timeline Filter
Business Scenario
Demo - Timeline Filter
Introduction To Powerview Report
Create Powerview Report
Business Scenario
Demo - Creating Powerview Reports
Powerview Reports Options
Business Scenario
Demo - Powerview Reports Option
Summary
Quiz
Lesson 06 - Creating Templates with Advanced Functions
Introduction
Objectives
Creating Excel User Defined Templates
Business Scenario
Demo 1 - Creating Excel User Defined Templates
Multiple List Box
Business Scenario
Demo 2 - Multiple List Box
Advanced Validation Rule With Isnumber
Business Scenario
Demo 3 - Advanced Validation Rule With Isnumber
Advanced Validation Rule With Istext
Business Scenario
Demo 4 - Advanced Validation Rule With Istex
Combine Date And Logical Functions
Business Scenario
Demo 5 - Combine Date And Logical Functions
Eomonth Function
Business Scenario
Demo 6 - Eomonth Function
Match Function
Business Scenario
Match Function
Business Scenario
Index With Match Function
ndex With Match Function
Summary
Other courses offered by Simplilearn
Student Forum
Anything you would want to ask experts?