InsideEdgeInsideEdge
Semester 2MGT4211

Excel for Managers (MGT4211) crash course, Online MBA, Semester 2:

This subject covers Microsoft Excel from entering, formatting and printing data through charts, logical, text and lookup functions, pivot tables, and financial…

  • 17 video lessons
  • 3h 37m
  • Study notes
  • 85 quiz questions
  • Assignment
Enroll nowSee the lessons
Excel for Managers crash course

17 lessons in Excel for Managers

Each lesson pairs one topic with a hand-picked video, trimmed to the part that teaches it.

About this subject

This subject covers Microsoft Excel from entering, formatting and printing data through charts, logical, text and lookup functions, pivot tables, and financial and statistical functions. After it you will be able to build and manage business spreadsheets, write formulas, summarise data with pivot tables and charts, and run time value of money and what-if analyses.

  1. 1

    Excel Basics: Entering, Formatting and Saving Data

    Module I, Getting Started with Excel: Introduction to Spreadsheets: Launching Excel, entering data in spreadsheet, widening rows and columns, applying basic formatting in spreadsheet, saving work in excel

    Excel Tutorial For Beginners in Hindi | Complete Microsoft Excel Tutorial (Basic To Advance)· Rishabh Mishra· 21 min

    Study notes 5 quiz questionsWatch lesson
  2. 2

    Autofill, Sort & Filter and Lists in Excel

    Module I, Getting Started with Excel: Entering Data into cells: Using autofill, sort & filter feature, creating lists

    Excel Custom & Autofill List | How to Create Custom & AutoFill Lists in Excel? | CTA· Computer Tech Academy· 5 min

    Study notes 5 quiz questionsWatch lesson
  3. 3

    Insert/Delete Rows, Wrap Text and Merge Cells

    Module I, Getting Started with Excel: inserting & deleting rows and columns, Wrapping & merging text and cells

    Excel: Modifying Columns, Rows, and Cells· LearnFree· 3 min

    Study notes 5 quiz questionsWatch lesson
  4. 4

    Protect & Share Workbooks and Freeze Panes

    Module II, Basics in excel: Protecting & sharing workbooks, freeze panes

    How to Lock Cells 🔒in Excel to Protect your Formulas & Only Allow Input where Needed· Leila Gharani· 6 min

    Study notes 5 quiz questionsWatch lesson
  5. 5

    Excel Page Layout, Page Break Preview and Print Area

    Module II, Basics in excel: understanding normal, page layout and page break preview in excel, Setting the page orientation and print area

    Normal and PageBreak Preview In Excel| Views in Excel | Normal View ||Page Layout || Custom Views· MANOJ KUMAR EXCEL· 9 min

    Study notes 5 quiz questionsWatch lesson
  6. 6

    Hyperlinks, Images, Objects, Equations and Symbols in Excel

    Module II, Basics in excel: Adding hyperlinks to cells, inserting images, objects, equations and symbols

    Lec11 Excel | Hyperlink | Text Box | Header & Footer l | Word Art | Signature line | Object | Symbol· indica computer technology Vijay· 24 min

    Study notes 5 quiz questionsWatch lesson
  7. 7

    Excel Charts: Bar, Pie, Column and Line

    Module III, Charts & Formulas in Excel: Understanding Charts: Inserting bar charts, pie charts, column charts and line charts in spreadsheets, formatting and resizing the chart

    Create and Customize Chart in Excel | Insert Pie, Bar, Column, Line Chart| Chart Setting in Excel-50· Gyanyagya· 14 min

    Study notes 5 quiz questionsWatch lesson
  8. 8

    SUM, AVERAGE, MIN, MAX and Date & Time Functions

    Module III, Charts & Formulas in Excel: Using Basic functions- average, sum, min, max, product etc., date functions, time functions

    Excel Formulas and Functions | Full Course· Kevin Stratvert· 11 min

    Study notes 5 quiz questionsWatch lesson
  9. 9

    Math Operators and Formulas in Excel

    Module III, Charts & Formulas in Excel: Math Operators in Excel, combining mathematical operators

    Excel Formulas and Functions | Full Course· Kevin Stratvert· 13 min

    Study notes 5 quiz questionsWatch lesson
  10. 10

    Logical and Text Functions: IF, AND, OR, TRIM, UPPER

    Module IV, Functions in Excel: Logical- using IF, AND, OR, NOT, TRUE, FALSE Functions, Textual- using TRIM, UPPER, LOWER, REPLACE Functions

    Excel Logical Functions - IF, AND, OR· Yoda Learning Academy· 7 min

    Study notes 5 quiz questionsWatch lesson
  11. 11

    Importing Data and INDEX MATCH Lookup

    Module IV, Functions in Excel: Import data into excel, Look up functions with index and match

    Excel INDEX + MATCH Formula Explained | Index Match का मैजिक Vlookup & Xlookup नहीं कर सकते· Deepak EduWorld· 19 min

    Study notes 5 quiz questionsWatch lesson
  12. 12

    ROUND, SUMPRODUCT, COUNTIF and SUMIF

    Module IV, Functions in Excel: Rounding, sum product, conditional counts and conditional sums

    70 Excel Formulas to Become Excel EXPERT | Most Useful Excel Formulas | Excel Formula Tutorial· Deepak EduWorld· 12 min

    Study notes 5 quiz questionsWatch lesson
  13. 13

    Pivot Tables, Pivot Charts and Conditional Formatting

    Module IV, Functions in Excel: Filtering data, pivot table, pivot charts, conditional formatting

    how to use pivot chart in excel in Hindi | Best Video With Many Examples· Deepak EduWorld· 14 min

    Study notes 5 quiz questionsWatch lesson
  14. 14

    Time Value of Money in Excel: PV, FV and PMT

    Module V, Financial and Statistical Functions in Excel: Financial functions: Time value of money- Present value, Future value, PMT with beginning date, PMT with ending date

    Financial function in Excel. PMT, PPMT, IPMT, PV, FV, NPER Function.· DC HELPING· 21 min

    Study notes 5 quiz questionsWatch lesson
  15. 15

    NPV and IRR in Excel

    Module V, Financial and Statistical Functions in Excel: NPV, IRR

    Capital Budgeting: NPV, IRR, Payback | MUST-KNOW for Finance Roles· Kenji Explains· 7 min

    Study notes 5 quiz questionsWatch lesson
  16. 16

    Goal Seek and Scenario Manager

    Module V, Financial and Statistical Functions in Excel: Goal seek, Scenario Manager

    What-If Analysis (Goal Seek, Scenario Manager and Data Table) in Excel | Step by Step tutorial· PK: An Excel Expert· 14 min

    Study notes 5 quiz questionsWatch lesson
  17. 17

    Statistical Functions: LARGE, SMALL, RANK, VAR, STDEV

    Module V, Financial and Statistical Functions in Excel: Statistical functions: Max, Min, Average, Large, Rank, Small, Var, Std Dev

    12 Excel FUNCTIONS Made Easy [SUM, SUMIF, COUNT, COUNTIF, MAX, MIN.....] | ExcelJunction.com· Excel Junction· 17 min

    Study notes 5 quiz questionsWatch lesson

Assignment

Build a Regional Sales & Investment Decision Workbook

Free login to open
What you get

Less scrolling. More passing.

  • Free

    Hand-picked video lessons

    17 short lessons, each with the best YouTube explanation we could find, trimmed to the part that matters.

  • Free login

    Study notes

    17 lessons come with a summary, key points, key terms and takeaways for quick revision.

  • Free login

    Quizzes

    85 questions across the course, with the right answer and why, the moment you pick.

  • Free login

    Assignments

    1 subject assignments with clear tasks, so you practise what each subject actually asks of you.

  • Free login

    Notebook

    Write notes beside the video, stamped with the exact time, and jump back to that moment later.

  • Free login

    Progress that follows you

    Completed lessons, quiz scores and where you stopped, saved to your account on every device.

  • Live chat pass

    Live chat

    A members-only live chat beside every lesson: doubts, tips, stickers and GIFs with your batch. One ₹19 pass opens every live chat.

Members only

The Online MBA live chat. Study together, live.

A live chat right beside the video, shared by everyone studying Online MBA. Ask a Excel for Managers doubt mid-lesson, share a shortcut, celebrate a finished semester.

  • Live chat beside every lesson
  • One live chat for all of Online MBA
  • Members-only stickers & GIFs
  • One ₹19 pass opens every live chat
Open the live chat
Pass₹19

More from Online MBA Semester 2

All subjects

Excel for Managers: common questions

This subject covers Microsoft Excel from entering, formatting and printing data through charts, logical, text and lookup functions, pivot tables, and financial and statistical functions. After it you will be able to build and manage business spreadsheets, write formulas, summarise data with pivot tables and charts, and run time value of money and what-if analyses. It's the Excel for Managers subject of Online MBA, Semester 2, in 17 lessons: Excel Basics: Entering, Formatting and Saving Data; Autofill, Sort & Filter and Lists in Excel; Insert/Delete Rows, Wrap Text and Merge Cells; Protect & Share Workbooks and Freeze Panes; Excel Page Layout, Page Break Preview and Print Area; Hyperlinks, Images, Objects, Equations and Symbols in Excel; Excel Charts: Bar, Pie, Column and Line; SUM, AVERAGE, MIN, MAX and Date & Time Functions; Math Operators and Formulas in Excel; Logical and Text Functions: IF, AND, OR, TRIM, UPPER; Importing Data and INDEX MATCH Lookup; ROUND, SUMPRODUCT, COUNTIF and SUMIF; Pivot Tables, Pivot Charts and Conditional Formatting; Time Value of Money in Excel: PV, FV and PMT; NPV and IRR in Excel; Goal Seek and Scenario Manager; Statistical Functions: LARGE, SMALL, RANK, VAR, STDEV.

Yes. Every video lesson is free to watch without an account. A free login unlocks study notes, quizzes, the assignment, a notebook and progress that syncs across devices.

About 3h 37m of video across 17 lessons, plus time for notes and quizzes. Go at your own pace; your place is saved.

Yes: “Build a Regional Sales & Investment Decision Workbook”. It comes after the last lesson, with a brief, clear tasks and how the work is judged.

A members-only live chat beside the video, shared by everyone studying Online MBA, where learners ask doubts, share tips and react with stickers and GIFs. One ₹19 pass, paid once from your InsideEdge wallet, opens the live chat for every degree.

No. It's a crash course to help you understand and revise the subject quickly. Use it alongside your official study material and assignments.

Enroll now