/
July 3, 2025

Excel Basic Functions

4.638
22 Enrolled
This content is for Free Trial members only.
Login Join Now
This content is for Free Trial members only.
Login Join Now

What Will I Learn?

  • Undertake data analysis in Excel
  • Data extraction functions
  • Look up functions
  • Data aggregation
  • Data presentation
  • Data visualization

Course Content

Module 1: Basic Excel Functions To Analyze Large Data

  • 01:07
  • 03:45
  • Download the Excel spreadsheet for this module
    00:00
  • 02:56
  • Extraction of data: understanding the SUMIF function
    08:14
  • Extraction of data: calculating growth rates
    03:58
  • Extraction of data: understanding the VLOOKUP function
    11:41
  • Extraction of data: understanding the HLOOKUP function
    09:31
  • Extraction of data: understanding the INDEX and MATCH function
    13:56
  • Extraction of data: understanding the IF, COUNTIF and COUNTIFS function
    09:10
  • Presentation of data: understanding the LINE chart
    12:34
  • Presentation of data: understanding the PIE chart
    11:45
  • Presentation of data: understanding the COLUMN chart
    13:04
  • Presentation of data: understanding the STACKED COLUMN chart
    10:57
  • Presentation of data: understanding the CONDITIONAL FORMATTING function
    06:58
  • Practice Assignment #1 – Difficulty level: MEDIUM
    00:00
  • Solution to Practice Assignment #1
    00:00
  • Recap
    01:03

About the instructors

Ashish is a Business and Finance Expert with around 10 years of experience in this domain. Previously, he has worked with BlackRock, the world’s largest asset management company, as a Vice President in the Financial Markets Advisory (FMA) team. Prior to that, he worked at McKinsey in the Strategy and Corporate Finance practice. He is also the founder of the website skillfinlearning.com which creates online programs in Business, Finance and Data Analysis topics. At Skillfin Learning, we believe we can change the way we adults learn.
4.67 (215 ratings)

33 Courses

208 students

4.71 (70 ratings)

10 Courses

0 students

Student Feedback

Excellent
5
Very Good
3
Average
0
Poor
0
Terrible
0
4.6
8 Reviews

Good one with right examples!

Good!

I recently completed the "Excel Basic Functions" course, and while it provides a foundational understanding of Microsoft Excel, there are some areas that could be improved to make it a more effective learning experience, especially for beginners.

he instructors were knowledgeable and presented the material effectively. They explained complex concepts in a straightforward manner, which was especially helpful for someone like me who was new to Excel. Their teaching style was engaging and made learning enjoyable.

"Excel Basic Functions Fundamentals" course and I am liked to share my positive experience on this, this course has very effective content. A perfect course roadmap is available on this, so it is highly recommended

Amazing Course

I am excited to share my positive experience and heartfelt recommendation for the "Excel Basic Functions Fundamentals" course. This course provides an essential foundation for individuals seeking to develop their skills in using Excel's basic functions. Whether you're a beginner or someone looking to refresh your Excel knowledge, this course offers a comprehensive and engaging learning journey.

good one

Pick a plan

Enrollment validity: Membership Wise
Durations: 1 hour 58 minutes
Lectures: 18
Students: Max 0
Level: Intermediate
Language: English
Certificate: Yes

Material Includes

  • 30 day access
  • 1.5 hours on-demand video
  • Access on mobile
  • Certificate of Completion

Requirements

  • None. We will teach everything from scratch.