- 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
Expert
Online
₹ 639 3,399
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
certificate availability
certificate providing authority
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
Mr Simon Sez IT
Instructor
Udemy
Articles
Popular Articles
Latest Articles
Courses of your interest
Visual Communication
Jain University via Jainx Academy