When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Excel Data Analysis Bootcamp for Finance Professionals
A Comprehensive Excel Training for the Serious Financial Data Analyst
This Course Includes
udemy
4.3 (10 reviews )
14.5 total hours 
english
Online - Self Paced
course
Udemy
About Excel Data Analysis Bootcamp for Finance Professionals
Dear Aspiring Excel Wizard,
Are you ready to elevate your Excel skills to new heights?
If you answer YES, I invite you to embark on a learning journey with me into the wonderful world of Excel. If you join this course, I practically guarantee that your skills will jump to a higher orbit almost overnight.
I am so confident because I meticulously designed it for people like you who are serious about their skills and aspire to master Excel as quickly and as deeply as humanly possible.
That’s why I believe this comprehensive course is going to be your gateway to mastery of one of the most sought-after skills in today’s job market.
This is not one of those regular courses, which are a dime a dozen. No way!
It is a transformative learning experience that helps you build your skills step by step, nourishes your mind with fresh knowledge and creative ideas and gently leads you towards mastery. So you can transform yourself into a true Excel wizard.
Here’s what you are getting with this course:
Lifetime access to the entire training so you can hone your skills anytime you choose.
Excel-basics crash course: Where it all begins. A smooth journey through the fundamentals, paving the way for mastery. This is where you build a strong understanding of the most important Excel topics. Such as user-interface tools, Flash-fill, Auto-fill, Text-to-columns, cell references, tables, named ranges, dynamic arrays.
How to create drop-down lists with data validation tools in Excel.
Formulas and Functions: The backbone of Excel.
Lookup and reference tutorials: VLOOKUP, INDEX, MATCH, XLOOKUP.
Concatenation: Formulas to join text strings with CONCAT, TEXTJOIN or the ampersand operator.
How to transform text values with UPPER, LOWER, PROPER, TRIM functions.
The basics of professional formatting of spreadsheets.
Date and Time Mastery: A comprehensive training on how to work with dates and times in Excel. From formatting to calculations. Master date and time functions: DATE, TIME, DATEDIF, WORKDAY, WORKDAY.INTL, YEARFRAC, NETWORKDAYS, NETWORKDAYS.INTL, DAYS, DAYS360.
How to calculate fiscal years based on dates.
How to create custom functions with LET and LAMBDA.
Excel what-if analysis tools: Goal seek, Data Table, Scenario Manager.
Data Visualization: A picture is worth a thousand numbers. Bring your data to life. Learn to present data with Excel charts that impress, captivate and inform.
Pivot Tables: Unravel the secrets of summarizing and analyzing large data sets effortlessly. This is where data bows to you, revealing its hidden gems through your newfound mastery.
Practical homework (Lab) assignments with solution walk-throughs.
And more...
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..