90% off on Premium Membership - Mega Sale
Excel Essential Formulas And Functions
Created by: ProCapitas
This course includes:
-
Analyzing backtesting reports.
-
Costs of trading - Slippages and Brokerage.
-
How to build trading psychology.
-
Problems with manual backtesting.
LESSONS
Lessons | 3 Hours 22 Mins
1
Course Introduction
What is Excel?
00:09:24Basic Calculations in Excel Workbook?
00:11:51All Excel Formulas - Premium Ebook
All Excel Shortcuts - Premium Ebook
All Excel Functions - Premium Ebook
All Resources
2
Essential Mathematical Functions
Implementing SUM, AVERAGE AND MAX FUNCTION using Sales Data
00:11:53Implementing MIN, ROUND AND SUMIF FUNCTION using Sales Data
00:12:06Implementing COUNT,COUNTA AND COUNTIF FUNCTION using Sales Data
00:07:23Section Exercise Implementing ALL Essential Mathematical FUNCTIONS using School Data
00:11:323
Essential Text Functions
Implementing LEFT, RIGHT AND CONCATENATE FUNCTION using College Data
00:09:19Implementing UPPER, LOWER AND MID FUNCTION using College Data
00:07:27Implementing PROPER, TRIM AND REPT FUNCTION using College Data
00:07:50Implementing TYPE, EXACT AND HYPERLINK FUNCTION using College Data
00:10:20Section Exercise Implementing ALL Essential Text FUNCTIONS using University Data
00:13:404
Essential Date & Time Functions
Implementing NOW & TODAY FUNCTION using College Data
00:08:20Implementing YEAR, MONTH, DAY using College Data
00:08:41Implementing HOUR, MINUTE, SECOND, TIME AND EDATE using College Data
00:11:36Section Exercise Implementing ALL Essential Date & Time FUNCTIONS using Amazon Warehouse Data
00:09:335
Essential Logical Functions
Implementing IF & VLOOK FUNCTION using Sales Data
00:13:06Implementing AND, OR FUNCTION using Sales Data
00:12:31Section Exercise Implementing ALL Logical FUNCTIONS using Examination Data
00:10:376
Essential DataValidation & Filter Functions
Implementing Data Validation and Filter using Sales and College Data
00:08:55Section Exercise Implementing ALL Essential Data Validation & Filter Functions using Bank Data
00:05:37very clearly explained basics concepts of excel and formulas.
fname
Nice and amazing course... the interesting thing is that in each section end everything is revised. Read More
Nikhil Agarwal
One of the best excel course for the beginners, He clearly explains all the important things in a sh Read More
chahat
Great learning experience, This course well organized and explaining also well. The interesting thin Read More
lokeswari kr
Quite good and informative. Always good to revisit them and brush up on known skills. Instructor - P Read More
1,499
