Brochure
Enquire
- Prerequisites of Excel 2013 Advanced Course
- WATCH ME: Essential Information for a Successful Training Experience
- Course exercise files
- Microsoft Excel 2013 keyboard shortcuts
- Course transcripts
- Downloadable course MP3 audio files
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 399 ₹3,299
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction
Functions
- List of Functions; Common Types of Arguments; Basic Use of Functions
- Advanced Aspects of Functions; Searching for a Function
- Autosum
Personal and Professional Financial Functions
- Payment
- Future Value
- Principle Payment
- Depreciations
Date and Time Functions
- How Dates and Times are Stored
- Dates and Times Calculation
- Exercise on Date and Time Functions; Date and Time Settings
Statistical Functions for Description, Prediction and Interference
- Average
- Percentile
- Regression
- LINEST Function
- Example of Functions for Inferential Statistics
Text Functions
- Text Function Case Study - 1
- Text Function Case Study - 2
Lookup Functions
- Lookup and Reference Functions
Logical Functions
- Logical Functions
Connecting to External Data
- Course Review
- Connecting to Other Workbooks
- Connecting to Access Data
- Connecting to Web Data
Tables
- Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
- Inserting Columns and Rows; Resizing Tables
- Table Reference
- Table Styles
- Table Selection
Pivot Tables
- Basic Principles of Pivot Tables
- Presentational Side of Pivot Tables
- Filtering in Pivot Tables; Slices
Data Analysis
- What if
- Scenario Manager
- Goal Seek
- Solver
Charts
- Area Charts
- Surface Charts
- Stock Charts - Part 1
- Stock Charts - Part 2
- Radar Charts
- Bubble Charts
Graphs
- Regression and Scatter Chart
Pivot Charts
- Creating Pivot Charts
Sparklines
- Using Sparklines
Web App
- Creating Workbooks using a Web App
- Sharing your Workbook
Conclusion
- Closing
- Assessment Test
Instructors
Articles
Popular Articles
prev
next
Latest Articles
prev
next
Similar Courses
Courses of your Interest
Communicating with Presence
Stanford via Edx
Visual Communication
Jain Deemed to be University, Bangalore via Jainx Academy
prev
next
