Excel Basic Functions
Learn Basic Excel to understand basic functions and charts.
Course Curriculum
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
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
FAQ's
How does the certification program work?
We have created short courses on specific skills that you will need to master in the business and finance domain. Once you go through the recorded lessons and attend practice sessions online, you will need to finish a short assessment like a quiz and an assignment and send it over. We will review your submission and send you back a score. If you obtain more than 80% result, we will award you a certification for the same.
How long does it take to complete the certification?
We have divided the certifications into very specific modules to make it very easy for you to complete any one certification in the least time possible. But really the pace of completing the certification is up to you. As soon as you send us your assignment, we will take 2-3 days to review and send over your result. So whenever you are ready, you should complete the assessment and get certified.
Can you retake the assessments?
Yes you can, we allow you to make 10 submissions per certification to ensure you have enough opportunities to clear and get certified.
Do I have access to the materials even after completing the certifications?
Yes, as long as you have an active membership, you will continue to have access to all resources to the certification.
Will I get a certification for the individual courses?
Yes, each course will have a certification provided on successful completion and taking the assessment successfully at the end of the program
Can I upload my certification online?
Yes, we will provide a LinkedIn verifiable certificate in different formats that you can add on your social media profile to get access to more opportunities. For example, You can add the certificate under the certification section of LinkedIn where recruiters look at to understand the different skills you possess.
How will we support me to find more opportunities?
We have a very active LinkedIn presence where we will showcase your certifications on completion. Ideally the more the certifications you complete the better will your chances to be noticed by other members of our LinkedIn community. Our push to your profile will potentially lead to more opportunities coming your way.
ashish_agarwal
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.
Student Ratings & Reviews
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
