Excel Data Analysis Bootcamp for Finance Professionals
A Comprehensive Excel Training for the Serious Financial Data Analyst
4.35 (13 reviews)
32
students
15 hours
content
Dec 2024
last update
$49.99
regular price
What you will learn
Everything you need to start using Excel like a pro.
Master Excel essentials: cell references, named ranges, tables, Auto-fill, Flash-fill, Text-to-columns, dynamic arrays, data validation and drop-down lists.
Get comfortable with formulas and functions such as SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, UPPER, LOWER, PROPER, TRIM, CONCAT, TEXTJOIN and more.
Feel at ease creating formulas that search and fill data automatically with VLOOKUP, INDEX, MATCH, XLOOKUP.
The secrets of Excel dates and times: DATE, TIME, DAYS, DAYS360, WORKDAY, EDATE, CHOOSE, TEXT and other must-know functions for working with Excel dates.
Create custom Excel functions with LET and LAMBDA.
Screenshots
5411236
udemy ID
6/27/2023
course created date
1/26/2024
course indexed date
Bot
course submited by