Working Hours :

Monday - Friday, 10am - 06pm

+911244962543

Home 2024

Year: 2024

  • admin
  • 23 Dec 2024

SUMIF Function symplyfied in Excel

SUMIF Function symplyfied in Excel ✅ SUMIF Function symplyfied in Excel !! ✅ Formula: =SUMIF($J$2:$J$23,M2,$K$2:$K$23) ✅ Syntax: =SUMIF(Select the Department list & press F4 to lock the range, select criteria i.e. first cell of department, select the sum range i.e. Sales List & press F4 to lock the range) View this post on Instagram A

More Details
  • admin
  • 23 Dec 2024

Excel

Basic Excel Course Content Sr. No Topics Sub Topics 1 Data Sorting A To Z Sorting Z To A Sorting Custom Sort Font Colour Wise Data Sorting Cell Colour Wise Data Sorting 2 Filter Normal Filter Text Colour Filter Cell Colour Filter 3 Conditional Formating Highlight Duplicate Value Highlight Top 10 Value Highlight Bottom 10

More Details
  • admin
  • 23 Dec 2024

Fixed Messy Data by using PROPER & TRIM function/formula in Excel 

✅Formula: =PROPER(TRIM(A2) ✅Syntax: =PROPER(TRIM(Select the cell range) ✅Used TRIM function to remove unwanted space form the data. ✅Used PROPER function to change case into proper case from messy text format. View this post on Instagram A post shared by Up MMS (Make my Skill) (@upmms_)

More Details
  • admin
  • 23 Dec 2024

How to split text by using TEXTSPLIT FUNCTION With Delimeter in Excel !!

Formula: TEXTSPLIT(D2,”,”) Syntax: TEXTSPLIT(D2″ Range”,”,”(Delimeter in the inverted commas for separate text data on behalf of delimiters in the different-different columns). View this post on Instagram A post shared by Up MMS (Make my Skill) (@upmms_)

More Details
  • admin
  • 23 Dec 2024

How to find salary by using Vlookup (Binary Numbers) if data type is mismatch in Excel!!.

By using this method/formula can find any data if data type is mismatched. Formula: VLOOKUP(1*G2,$C$2:$E$23,3,0) Syntax: VLOOKUP(1* for convert change data type form text data to number data, G2-Lookup Value, Select table array/Data range,3 for column number, 0 for exact match) Normal VLOOKUP function will not work if Lookup value data type is mismatch, so

More Details
  • admin
  • 23 Dec 2024

About UpMMS (Make my Skill)

About UpMMS (Make my Skill)

About Us Welcome to Upmms – Your Gateway to Unlimited Learning! Our Mission At Upmms, we are dedicated to empowering individuals and organizations through comprehensive and accessible education. Our mission is to provide high-quality courses that equip learners with the skills and knowledge they need to succeed in today’s fast-paced digital world. Why Choose Us?

More Details