// Get the current URL var currentUrl = window.location.href; // Define an object with mappings of variables to corresponding text fields var fieldMappings = { utm_campaign: 'mx_utm_campaign', utm_medium: 'mx_utm_medium', utm_source: 'mx_utm_source', }; // Loop through the mappings and insert the values into the corresponding text fields for (var param in fieldMappings) { var fieldName = fieldMappings[param]; var match = currentUrl.match(new RegExp('[?&]' + param + '=([^&]+)')); if (match) { var paramValue = match[1]; var textField = document.querySelector('input[name="' + fieldName + '"]'); if (textField) { textField.value = paramValue; } } }
top of page
Search

Excel Formulas for Management Students: The Essential Cheat Sheet

  • Aug 10
  • 2 min read

Excel skills are a must-have for every management student. From building financial models to analyzing placement data, knowing the right Excel formulas for MBA students can save hours of work and impress recruiters. Here's a quick guide to the Excel formula essentials, as part of VSB's Future Ready Series: Smart Tools, Stronger You.


Explained PGDM ( Post Graduation in Diploma Management)

 

1. Why Learn Excel Formulas? 

Recruiters in marketing, finance, HR, and operations expect business graduates to be confident with Excel for business analysis. Mastering these formulas early gives you an edge in internships, live projects, and placements.


2. Must-Know Excel Formulas

Basic Arithmetic: =A1+B1, =A1-B1, =A1*B1, =A1/B1, =A1^2

Aggregate Functions: =SUM(), =AVERAGE(), =MIN(), =MAX(), =COUNT(), =COUNTA()

Logical Functions: =IF(), =AND(), =OR() — for example, =IF(B2>=50,"Pass","Fail")

Lookup Functions: =XLOOKUP(), =VLOOKUP(), =INDEX(MATCH()) — used to fetch data from other tables

Text Functions: =LEFT(), =RIGHT(), =MID(), =UPPER(), =TRIM(), =CONCAT(), =TEXTJOIN()

Date Functions: =TODAY(), =NOW(), =YEAR(), =MONTH(), =DAY(), date differences (=A2-B2)

Conditional Functions: =SUMIF(), =COUNTIF(), =AVERAGEIF()

Multiple Criteria Functions: =SUMIFS(), =COUNTIFS() — for analysis with more than one condition

Error Handling: =IFERROR(A2/B2,0) — keeps your reports clean

Ranking & Statistics: =RANK(), =LARGE(), =SMALL()

Financial Formulas: =PMT() for EMI, =NPV(), =IRR() — key for Excel finance formulas

Dynamic Array Functions (Excel 365): =FILTER(), =SORT(), =UNIQUE()

Top 20 Formulas to Remember

SUM, AVERAGE, COUNT, COUNTA, MIN, MAX, IF, AND, OR, IFERROR, SUMIF, COUNTIF, SUMIFS, VLOOKUP, XLOOKUP, INDEX, MATCH, CONCAT, TODAY, RANK

Save it. Use it. Master it.


3. Beyond Formulas: Excel Power Skills for MBA Students

  • Charts and Dashboards

  • Pivot Tables & Pivot Charts

  • Conditional Formatting & Data Validation

  • Sort, Filter & Remove Duplicates

  • Flash Fill

  • What-If Analysis (Goal Seek)


Work Smart. Analyze Better. Decide Faster.

These Excel formula essentials will help you analyze data with confidence, build stronger business cases, and stand out in interviews. At Vidyalankar School of Business (VSB), we're building future-ready professionals - strong in both tools and thinking.


Stay tuned for the next Future Ready Series guides on Power BI, Canva, and GitHub. 

Explore our programs at vsb.edu.in.


Connect with us today:


 
 
 

1 Comment

John Brown
John Brown
6 days ago

I liked how this post focuses on practical Excel skills instead of only explaining theory. I have found formulas like SUM, IF, and XLOOKUP especially useful when working with large sets of information because they can save a lot of time. When I was working on a difficult project, I once searched for assignment help after getting stuck with data analysis, and it showed me how useful basic Excel knowledge can be. Learning these tools early can make management work much easier.

Like
bottom of page