Course / Course Details

Excel formulas for beginners

  • Gayathri Perumal image

    By - Gayathri Perumal

  • 0 students
  • N/A
  • (0)

Course Description

  • This course is designed to introduce beginners to the world of Microsoft Excel formulas. You will learn how to perform calculations, analyze data, and automate tasks using essential formulas and functions. Starting from the basics, the course gradually builds your confidence in using formulas like SUM, IF, VLOOKUP, and more in real-world scenarios.
  • By the end of this course, you will be able to work efficiently with Excel spreadsheets and apply formulas to solve everyday problems in business, education, and personal use.

Course Outcomes

  •  Understand the basics of Excel formulas and how they work
  • ✅ Perform calculations using functions like SUM, AVERAGE, MIN, and MAX
  • ✅ Use logical functions such as IF for decision-making
  • ✅ Apply lookup functions like VLOOKUP to find data quickly
  • ✅ Work with cell references (relative and absolute)
  • ✅ Handle basic errors in formulas
  • ✅ Create simple, automated spreadsheets for daily tasks
  • ✅ Improve productivity and accuracy in data handling

Course Curriculum

  • 1 chapters
  • 66 lectures
  • 0 quizzes
  • N/A total length
Toggle all chapters
1 Formula to find Duplicate Values in Excel
4.04 Min


2 Formula to Extract Text and Number from AlphaNumeric Data in Excel
5.16 Min


3 6 New Functions in Excel Dynamic Array Functions
6.11 Min


4 Find the value against the Largest Number or Date in Excel 4 Different Formulas
8.43 Min


5 Find the value against the Largest Number or Date in Excel 4 Different Formulas
8.43 Min


6 VLOOKUP formula to Search for Multiple Values and Return Multiple Results
7.17 Min


7 7 reasons why XLOOKUP function is better than VLOOKUP
17.36 Min


8 2 Things that VLOOKUP can do and XLOOKUP cannot
6.18 Min


9 How to Auto Number Rows in Excel
2.43 Min


10 Sort Names in the Alphabetical Order Last Names SORTBY Function
3.38 Min


11 Sort Names in the Alphabetical Order Last Names SORTBY Function
3.38 Min


12 Sort Names in the Alphabetical Order Last Names SORTBY Function
3.38 Min


13 Formula to Insert Sheet Name in Excel
3.2 Min


14 Formula to Insert Sheet Name in Excel
3.2 Min


15 Formula to Insert Sheet Name in Excel
3.2 Min


16 MOD function in Excel 10 Practical Uses
17.14 Min


17 How to find Running Total in Excel 5 methods
11.52 Min


18 Excel Formula to add n Percentage to a number
4.05 Min


19 Calculate Percentage difference in Excel
3.51 Min


20 5 different methods to Find the Top n Numbers in Excel
7.46 Min


21 Excel formula to extract Text or Number between Parentheses
7.1 Min


22 Formula to find the Square Root of a Number in Excel
5.55 Min


23 7 methods to Copy formula into adjacent cells below in Excel
5.37 Min


24 Formula to make a random selection in Excel
2.44 Min


25 Excel formula to Pick 3 random values from a list without Duplicates
3.53 Min


26 How to randomly assign people to different Teams using Excel
7.27 Min


27 How to Join Tables using VLOOKUP formula in Excel
6.02 Min


28 How to Find Duplicate Rows in Excel
5.18 Min


29 Formula to Calculate Time Difference in Excel
5.17 Min


30 Count the occurrence of a Text in an entire Excel Workbook
1 Min


31 2 way lookup using INDEX MATCH formula in Excel
1 Min


32 Excel formula for Multiple Match Results
2.3 Min


33 VLOOKUP from Multiple Tables in Excel
6.17 Min


34 Excel Formula for Two Way Lookup
4.28 Min


35 Excel Formula to create Time Stamp
4.1 Min


36 Excel Template with Alert Message for Expiry or Renewal Dates
8.03 Min


37 Fourteen different methods to find SUM in Excel
6.04 Min


38 Excel Formula to Calculate retirement Date
4.33 Min


39 How to find the Day Name from Date Excel Formula
1.49 Min


40 Find the Rank of only those students who have Passed excelshorts


41 VLOOKUP formula Excel Beginners Tutorial
5.2 Min


42 How to convert Small letters to Capital letters in Excel
2.48 Min


43 SUMIF formula Excel Beginners Tutorial
6.48 Min


44 How to use the RAND Formula in Microsoft Excel
4.4 Min


45 How to use the COUNTIF function in Excel
4.28 Min


46 How to use the LEN function in Excel
4.53 Min


47 How to use the RANDBETWEEN formula in Excel
4.48 Min


48 REPT Formula in Excel
6.06 Min


49 TRIM Formula in Excel
3.19 Min


50 How to fix the Formula Errors in Excel using the IFERROR function
4.32 Min


51 XLOOKUP formula in Excel
5.51 Min


52 How to find the largest number in Excel
5.56 Min


53 Current Date in Excel TODAY Function
1.4 Min


54 Excel formula to find the nth largest number
5.03 Min


55 Excel Formula to calculate Rank and Percentage of Marks
7.33 Min


56 Remove Formula but Keep the Data in Excel
2.12 Min


57 How to display Excel Formulas instead of Values
1.22 Min


58 Find the Common Values between two Excel Tables
2.16 Min


59 Automatic Serial Number in Excel
3.49 Min


60 Excel formula to Calculate Percentage
3.37 Min


61 Excel formulas for Beginners
5.27 Min


62 Excel Formula to Calculate Percentage of Total
1.48 Min


63 Excel formula for Compound Annual Growth Rate CAGR
3.17 Min


64 Excel formula to Calculate Overtime Payment
4.55 Min


65 Excel trick to display Tick Mark against Completed Tasks
1.39 Min


66 Excel formula to remove Duplicates
2.42 Min


Instructor

0 Rating
0 Reviews
1 Students
137 Courses

Course Full Rating

0

Course Rating
(0)
(0)
(0)
(0)
(0)

No Review found

Sign In or Sign Up as student to post a review

Student Feedback

You must be enrolled to ask a question