Excel Data Analysis Bootcamp for Finance Professionals

A Comprehensive Excel Training for the Serious Financial Data Analyst
4.35 (13 reviews)
Udemy
platform
English
language
Microsoft
category
Excel Data Analysis Bootcamp for Finance Professionals
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.

Course Gallery

Excel Data Analysis Bootcamp for Finance Professionals – Screenshot 1
Screenshot 1Excel Data Analysis Bootcamp for Finance Professionals
Excel Data Analysis Bootcamp for Finance Professionals – Screenshot 2
Screenshot 2Excel Data Analysis Bootcamp for Finance Professionals
Excel Data Analysis Bootcamp for Finance Professionals – Screenshot 3
Screenshot 3Excel Data Analysis Bootcamp for Finance Professionals
Excel Data Analysis Bootcamp for Finance Professionals – Screenshot 4
Screenshot 4Excel Data Analysis Bootcamp for Finance Professionals

Charts

Students
Price
Rating & Reviews
Enrollment Distribution
5411236
udemy ID
27/06/2023
course created date
26/01/2024
course indexed date
Bot
course submited by