Microsoft Excel Formulas & Functions
BeginnerLevel
3 Hrs 30 MinsDuration
About this Course
- Master Essential Excel Formulas & Functions – Learn arithmetic, logical, LookUp, Date & Time, and text functions to analyze data efficiently in real-world scenarios.
- For Beginners to Advanced Users – Whether you're new to Excel or refining your skills, this course covers essential formulas, functions, and data analysis techniques.
- Boost Your Data Analysis Skills – Excel remains the industry standard for data analysis. Gain hands-on expertise to efficiently process, analyze, and visualize data.
Learning Outcomes
Master Excel Functions
Learn to design, deploy, and manage cloud solutions using AWS.
Deep Dive into Excel
Explore powerful functions to clean and analyze data.
Hands-On Excel Skills
Work on real projects to boost data analysis expertise.
Who Should Enroll
- Aspiring professionals Ideal for students and beginners looking to build expertise in Data visualization.
- Aspiring Analysts & Enthusiasts – Perfect for those starting in data analysis, business analytics, or data science.
- Excel Users Seeking Mastery – For those wanting to master formulas, and apply them in real-world projects.
Course Curriculum
Master Excel with a hands-on curriculum covering formulas, functions, data analysis, and automation. Learn to organize, calculate, and visualize data, boosting productivity and decision-making skills for real-world applications.
1. Getting Started with Excel Formulas
2. Referencing
3. Paste Special & Format Painter
1. DateTime Function
2. Left,Right,Mid,Len,Concatenate
3. Find & Search
1. Sum, Product, Mod, Sqrt, Fact
2. Round, RoundUp, Rounddown, SumIFS
1. Present Value and Future Value
2. NPV and IRR
3. Financial Functions in Excel
1. Vlookup and Hloopup
2. Matching in Excel
3. Indexing in Excel
Meet the instructor
Our instructor and mentors carry years of experience in data industry
Get this Course Now
With this course you’ll get
- 3 Hours 30 Mins
Duration
- Pranav Dar
Instructor
- Beginner
Level
Certificate of completion
Earn a professional certificate upon course completion
- Globally recognized certificate
- Verifiable online credential
- Enhances professional credibility
Frequently Asked Questions
Looking for answers to other questions?
This course is designed for anyone who wants to learn about the different formulas and functions in Microsoft Excel.
You will need to have Microsoft Excel installed in your machine.
We would highly recommend taking the course in the order in which it has been designed to gain the maximum knowledge from it.
Yes, you will receive a certificate of completion upon successfully finishing the course and all associated assessments.
This course is free of cost.
Related courses
Expand your knowledge with these related courses and expand way beyond
1 Hour 20 Minutes 6 Lessons 4.6
Getting Started with Large Language Models
30 Minutes 1 Lesson4.8
Navigating LLM Tradeoffs: Techniques for Speed, Cost, Scale & Accuracy
1 Hour6 Lessons 4.5
Framework to Choose the Right LLM for Your Business
Popular free courses
Discover our most popular courses to boost your skills
Contact Us Today
Take the first step towards a future of innovation & excellence with Analytics Vidhya
Unlock Your AI & ML Potential
- India+91
- United States+1
- Afghanistan+93
- Albania+355
- Algeria+213
- American Samoa+1
- Andorra+376
- Angola+244
- Anguilla+1
- Antigua & Barbuda+1
- Argentina+54
- Armenia+374
- Aruba+297
- Ascension Island+247
- Australia+61
- Austria+43
- Azerbaijan+994
- Bahamas+1
- Bahrain+973
- Bangladesh+880
- Barbados+1
- Belarus+375
- Belgium+32
- Belize+501
- Benin+229
- Bermuda+1
- Bhutan+975
- Bolivia+591
- Bosnia & Herzegovina+387
- Botswana+267
- Brazil+55
- British Indian Ocean Territory+246
- British Virgin Islands+1
- Brunei+673
- Bulgaria+359
- Burkina Faso+226
- Burundi+257
- Cambodia+855
- Cameroon+237
- Canada+1
- Cape Verde+238
- Caribbean Netherlands+599
- Cayman Islands+1
- Central African Republic+236
- Chad+235
- Chile+56
- China+86
- Christmas Island+61
- Cocos (Keeling) Islands+61
- Colombia+57
- Comoros+269
- Congo - Brazzaville+242
- Congo - Kinshasa+243
- Cook Islands+682
- Costa Rica+506
- Côte d’Ivoire+225
- Croatia+385
- Cuba+53
- Curaçao+599
- Cyprus+357
- Czech Republic+420
- Denmark+45
- Djibouti+253
- Dominica+1
- Dominican Republic+1
- Ecuador+593
- Egypt+20
- El Salvador+503
- Equatorial Guinea+240
- Eritrea+291
- Estonia+372
- Eswatini+268
- Ethiopia+251
- Falkland Islands+500
- Faroe Islands+298
- Fiji+679
- Finland+358
- France+33
- French Guiana+594
- French Polynesia+689
- Gabon+241
- Gambia+220
- Georgia+995
- Germany+49
- Ghana+233
- Gibraltar+350
- Greece+30
- Greenland+299
- Grenada+1
- Guadeloupe+590
- Guam+1
- Guatemala+502
- Guernsey+44
- Guinea+224
- Guinea-Bissau+245
- Guyana+592
- Haiti+509
- Honduras+504
- Hong Kong+852
- Hungary+36
- Iceland+354
- India+91
- Indonesia+62
- Iran+98
- Iraq+964
- Ireland+353
- Isle of Man+44
- Israel+972
- Italy+39
- Jamaica+1
- Japan+81
- Jersey+44
- Jordan+962
- Kazakhstan+7
- Kenya+254
- Kiribati+686
- Kosovo+383
- Kuwait+965
- Kyrgyzstan+996
- Laos+856
- Latvia+371
- Lebanon+961
- Lesotho+266
- Liberia+231
- Libya+218
- Liechtenstein+423
- Lithuania+370
- Luxembourg+352
- Macau+853
- Madagascar+261
- Malawi+265
- Malaysia+60
- Maldives+960
- Mali+223
- Malta+356
- Marshall Islands+692
- Martinique+596
- Mauritania+222
- Mauritius+230
- Mayotte+262
- Mexico+52
- Micronesia+691
- Moldova+373
- Monaco+377
- Mongolia+976
- Montenegro+382
- Montserrat+1
- Morocco+212
- Mozambique+258
- Myanmar (Burma)+95
- Namibia+264
- Nauru+674
- Nepal+977
- Netherlands+31
- New Caledonia+687
- New Zealand+64
- Nicaragua+505
- Niger+227
- Nigeria+234
- Niue+683
- Norfolk Island+672
- North Korea+850
- North Macedonia+389
- Northern Mariana Islands+1
- Norway+47
- Oman+968
- Pakistan+92
- Palau+680
- Palestine+970
- Panama+507
- Papua New Guinea+675
- Paraguay+595
- Peru+51
- Philippines+63
- Poland+48
- Portugal+351
- Puerto Rico+1
- Qatar+974
- Réunion+262
- Romania+40
- Russia+7
- Rwanda+250
- Samoa+685
- San Marino+378
- São Tomé & Príncipe+239
- Saudi Arabia+966
- Senegal+221
- Serbia+381
- Seychelles+248
- Sierra Leone+232
- Singapore+65
- Sint Maarten+1
- Slovakia+421
- Slovenia+386
- Solomon Islands+677
- Somalia+252
- South Africa+27
- South Korea+82
- South Sudan+211
- Spain+34
- Sri Lanka+94
- St Barthélemy+590
- St Helena+290
- St Kitts & Nevis+1
- St Lucia+1
- St Martin+590
- St Pierre & Miquelon+508
- St Vincent & Grenadines+1
- Sudan+249
- Suriname+597
- Svalbard & Jan Mayen+47
- Sweden+46
- Switzerland+41
- Syria+963
- Taiwan+886
- Tajikistan+992
- Tanzania+255
- Thailand+66
- Timor-Leste+670
- Togo+228
- Tokelau+690
- Tonga+676
- Trinidad & Tobago+1
- Tunisia+216
- Turkey+90
- Turkmenistan+993
- Turks & Caicos Islands+1
- Tuvalu+688
- Uganda+256
- Ukraine+380
- United Arab Emirates+971
- United Kingdom+44
- United States+1
- Uruguay+598
- US Virgin Islands+1
- Uzbekistan+998
- Vanuatu+678
- Vatican City+39
- Venezuela+58
- Vietnam+84
- Wallis & Futuna+681
- Western Sahara+212
- Yemen+967
- Zambia+260
- Zimbabwe+263
- Åland Islands+358
Get Expert Guidance
Need Support? We’ve Got Your Back Anytime!
+91-8068342847 | +91-8046107668
10AM - 7PM (IST) Mon-Suncustomersupport@analyticsvidhya.com
You'll hear back in 24 hours