About | Urban Nomad Adventures

What you'll learn ?

Excel Fundamentals

Build a strong foundation by learning the core Excel skills every finance professional shouldknow.You'll cover:

Understanding the Excel interface
Working with rows, columns, and worksheets
Cell references (Relative, Absolute & Mixed)
Basic formatting and number formatting
Sorting and filtering data
Essential keyboard shortcuts
Basic formulas and functions
Creating professional-looking spreadsheets

By the end of Module 1, you'll be comfortable navigating Excel and using the essentialfunctions required for day-to-day finance work.

Data Analysis & Reporting

Learn how finance professionals analyse large datasets and prepare meaningful reports.
Topics include:
● XLOOKUP
● VLOOKUP
● INDEX & MATCH
● OFFSET & MATCH
● Text functions
● Logical functions
● Conditional Formatting
● Data Validation
● Pivot Tables
● Pivot Charts
● Basic data analysis techniques
● Working with financial datasets
By the end of Module 2, you'll be able to organise, analyse, and summarise financial
information efficiently.

Build a strong foundation by learning the core Excel skills every finance professional shouldknow.You'll cover:

Understanding the Excel interface
Working with rows, columns, and worksheets
Cell references (Relative, Absolute & Mixed)
Basic formatting and number formatting
Sorting and filtering data
Essential keyboard shortcuts
Basic formulas and functions
Creating professional-looking spreadsheets

By the end of Module 1, you'll be comfortable navigating Excel and using the essentialfunctions required for day-to-day finance work.

Advanced Excel for Finance

Move beyond formulas and discover tools that improve productivity when working with large
amounts of financial data.
Topics include:
● Introduction to Power Query
● Importing data from PDFs, Excel files, and other sources
● Cleaning and transforming financial data
● Combining multiple datasets
● Introduction to Power Pivot
● Data modelling basics
● Time Value of Money (TVM)
By the end of Module 3, you'll know how to automate repetitive data preparation tasks and
perform common financial calculations in Excel.

Practical Finance Applications

Apply everything you've learned to real business and finance scenarios.
Topics include:
● Budget preparation
● Financial forecasting
● Variance analysis
● Building simple financial models
● Creating management reports
● AI tools for Excel and Finance
● Using AI to improve productivity while working with spreadsheets
● Best practices for finance professionals
The final module focuses on applying Excel skills to practical finance tasks, helping you work
more efficiently and confidently with financial data.

Quick Call

Choose Your Plan

One- Time Subscriptions

Just pay

$50

Pay Now

How the Course Works

Recorded Session
Self-paced
Practical finance examples
Hands-on exercises
Doubt clarification during Doubts session
Lifetime access
Certificate Provided

What Makes This Course Different?

Many Excel courses teach every feature available in Excel. This course takes a different approach.
Every topic is explained through finance and accounting examples, helping you understand not only how to use Excel but also why it matters in real financial work.
The focus is on building practical skills you can apply in internships, entry-level roles, and
everyday finance tasks.

Email : mandalnfinance@gmail.com