# Working with Advanced Excel Functions Course

Master the power of Excel with our course on Advanced Functions, covering text manipulation, mathematical operations, date handling, and conditional logic.

Preferred
4.96 (151 ratings)

### What Will You Learn?

• Text Functions
• Math Functions
• Date Functions
• Conditional Function

### This Course Includes

2+ hours of video tutorials

Certificate of completion

### Course Summary

Master Excel’s advanced capabilities with this comprehensive course on text manipulation, mathematical functions, date handling, and conditional logic, empowering you to streamline data tasks and enhance your spreadsheet proficiency. The course aims to equip you with the potential of Excel’s versatile features for improving your efficiency in data analysis and presentation.

## Course Content

1. UPPER, LOWER, PROPER
2. LEFT, RIGHT, MID, CONCATENATE
3. TRIM
4. LEN
5. SEARCH
1. ROUND, ROUNDUP, ROUNDDOWN
2. MROUND.
3. SUMPRODUCT, POWER
4. MOD
1. NOW, TODAY, DATEVALUE, TIMEVALUE
2. DAY, MONTH, YEAR, WEEKDAY, DAYS, YEARFRAC
3. DATEDIF, WORKDAY, NETWORKDAY, HOUR, MINUTE, SECOND
4. DATE
5. TIME
1. IF
2. Nested IF
3. AND, OR, IF AND, IF OR
4. SUMIF, AVERAGEIF, COUNTIF
5. SUMIFS, AVERAGEIFS, COUNTIFS

## Course Description

Master Excel’s Advanced Functions with this comprehensive course on Text, Math, Date, and Conditional functions. Learn to manipulate text, perform complex calculations, handle date-based data, and create dynamic spreadsheets using powerful conditional functions. This course on Advanced Excel will give you hands-on guidance to elevate your Excel skills and efficiency while handling large amounts of data.

## What We Offer

• Comprehensive Curriculum: Our Working with Advanced Excel functions Course provides a well-structured curriculum with comprehensive learning materials.
• Expert Guidance: The course enables you to learn from experienced instructors who are well-versed in the world of Excel. You will be guided through each concept, offering practical insights and real-world applications.
• Hands-on Practice: By the end of the course, you will gain confidence through hands-on exercises and projects. You will also learn to apply the functions to real scenarios, ensuring you’re ready to tackle any challenge in your professional journey.
• Flexible Learning: We understand that life can get busy, so our course is designed to be flexible. You get to study at your own pace, and access the course materials 24/7 from anywhere in the world.
• Certification: Upon successful completion of the course requirements, you will receive a Certificate of Completion, showcasing your dedication to learning and your newly acquired expertise in Working with advanced excel functions. You can display your certificate proudly on your resume or LinkedIn profile to enhance your professional credibility.

## Who Is Eligible?

• Professionals
• Analysts seeking to streamline data analysis processes.
• Entrepreneurs
• Students and educators aiming to excel academically and professionally
• Anyone Interested in learnings advance Excel

This course is on Advanced Excel Functions, hence a prior knowledge would be required.

No prerequisites are required. This course is open to anyone interested in gaining insights into advanced Excel Functions.

The course duration depends on your pace of learning. Since the course is self-paced, you can complete it at your convenience.

Yes, upon successfully completing the course, you will receive a certificate of completion to showcase your newfound expertise.

Yes. Every course will conclude with MCQ-style quizzes to test your learnings throughout the course. You will be provided with a certification once you score the minimum marks required from the assessment.

Yes. Anyone from anywhere, irrespective of their geographical location, can enroll in the course.

Enroll now to learn the tricks of Excel and become a master of spreadsheets!

## Testimonials

John S. – Financial Analyst

“This course took my Excel skills to a whole new level. The instructors provided clear explanations and practical examples. The advanced functions and techniques I learned here have greatly improved my efficiency in analyzing financial data.”

“The concepts explained in this course are quite advanced but the speaker manages to explain in a simplified way. Would recommend this course to everyone.”

Joe Morgan, Aspiring investment banker

“This course has helped me a lot in learning advanced Excel tools and I can seamlessly use them in my spreadsheets.”

Limited Period Offer ends in:
Only 3 seats are left with this price
\$77 \$193 60%
One year unlimited access

## Course Director

Dheeraj Vaidya, CFA, FRM

• ex-JPMorgan, CLSA Equity Analyst
• CFA, FRM Chaterholder
• 18+ years of Training Experience