Spreadsheets for Business (Excel) crash course, Online BBA, Semester 2:
This subject teaches practical Excel for business work, covering data entry and formatting, formulas with relative and absolute referencing, logical, lookup,…
- 9 video lessons
- 1h 39m
- Study notes
- 40 quiz questions
- Assignment
9 lessons in Spreadsheets for Business (Excel)
Each lesson pairs one topic with a hand-picked video, trimmed to the part that teaches it.
About this subject
This subject teaches practical Excel for business work, covering data entry and formatting, formulas with relative and absolute referencing, logical, lookup, text and date functions, pivot tables, charts, conditional formatting, and the PMT and NPV financial functions. After it you will be able to build and analyse business spreadsheets, look up and summarise data, chart results, and calculate loan payments and investment values.
- 1
Excel Data Entry and Formatting Basics
Module 1, Excel Essentials: Data entry, formatting
Learn Excel for Office Work: Master Data Entry, Formatting & Printing | Computer Tech Academy· Computer Tech Academy· 10 min
Watch lesson - 2
Excel Formulas: Relative vs Absolute Cell References
Module 1, Excel Essentials: Formulas and cell referencing
Excel Cell Reference: Absolute, Relative or Mixed?· Leila Gharani· 8 min
Study notes 5 quiz questionsWatch lesson - 3
Sorting and Filtering Data in Excel
Module 1, Excel Essentials: Sorting and filtering
Excel Tutorial For Beginners : Sort and Filter in Excel | Microsoft Excel· Excel with Rahul Chaudhary· 8 min
Study notes 5 quiz questionsWatch lesson - 4
Excel IF, AND, OR Functions
Module 2, Functions: Logical (IF, AND, OR)
Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)· Leila Gharani· 14 min
Study notes 5 quiz questionsWatch lesson - 5
VLOOKUP vs XLOOKUP vs INDEX-MATCH
Module 2, Functions: Lookup (VLOOKUP, XLOOKUP, INDEX-MATCH)
The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more)· Kenji Explains· 13 min
Study notes 5 quiz questionsWatch lesson - 6
Excel Text and Date Functions
Module 2, Functions: Text and date functions
Excel Formulas and Functions | Full Course· Kevin Stratvert· 7 min
Study notes 5 quiz questionsWatch lesson - 7
Excel Pivot Tables for Beginners
Module 3, Analysis & Charts: Pivot tables
Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)· Leila Gharani· 13 min
Study notes 5 quiz questionsWatch lesson - 8
Excel Charts and Conditional Formatting
Module 3, Analysis & Charts: Charts, Conditional formatting
Conditional Formatting in Excel Tutorial· Kevin Stratvert· 7 min
Study notes 5 quiz questionsWatch lesson - 9
Excel PMT and NPV Functions
Module 3, Analysis & Charts: Financial functions (PMT, NPV)
Excel Financial Functions - PMT, IPMT, PPMT & GOAL SEEK | Excel Formulas and Functions· Deepak EduWorld· 19 min
Study notes 5 quiz questionsWatch lesson
Assignment
Build a Sales & Investment Workbook for a Small Retailer
Less scrolling. More passing.
- Free
Hand-picked video lessons
9 short lessons, each with the best YouTube explanation we could find, trimmed to the part that matters.
- Free login
Study notes
8 lessons come with a summary, key points, key terms and takeaways for quick revision.
- Free login
Quizzes
40 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.
The Online BBA live chat. Study together, live.
A live chat right beside the video, shared by everyone studying Online BBA. Ask a Spreadsheets for Business (Excel) doubt mid-lesson, share a shortcut, celebrate a finished semester.
- Live chat beside every lesson
- One live chat for all of Online BBA
- Members-only stickers & GIFs
- One ₹19 pass opens every live chat
Online BBA live chat
Anyone else finding Spreadsheets for Business (Excel) tricky? 😅
Lesson 2 cleared it up for me. Watch it before the quiz
Doing it now, thanks!
Starting Business Communication tonight if anyone wants to go together
More from Online BBA Semester 2
All subjects- Sem 2
Business Communication
Oral, written and employment communication skills for the workplace.
- 11 lessons
- 3h 41m
- Notes
- Quiz
- Sem 2
Financial Accounting
From journal entries to final accounts, partnership and company accounts as per Indian standards.
- 12 lessons
- 5h 27m
- Notes
- Quiz
- Sem 2
Human Resource Management
HR functions from planning and hiring to pay, relations and international HRM.
- 12 lessons
- 2h 42m
- Notes
- Quiz
- Sem 2
Quality Management
TQM, quality gurus, tools, SQC, ISO systems and quality awards.
- 5 lessons
- 1h 25m
- Notes
- Quiz
- Sem 2
Retail Management and Term Paper
Retailing fundamentals in India and the literature review term paper.
- 8 lessons
- 1h 51m
- Notes
- Quiz
- Sem 2
Indian Constitution, Values & Indian Knowledge Systems
This subject covers the Preamble, fundamental rights and duties, and directive principles of the Indian Constitution, along with human values, ethical…
- 8 lessons
- 1h 20m
- Notes
- Quiz
Spreadsheets for Business (Excel): common questions
This subject teaches practical Excel for business work, covering data entry and formatting, formulas with relative and absolute referencing, logical, lookup, text and date functions, pivot tables, charts, conditional formatting, and the PMT and NPV financial functions. After it you will be able to build and analyse business spreadsheets, look up and summarise data, chart results, and calculate loan payments and investment values. It's the Spreadsheets for Business (Excel) subject of Online BBA, Semester 2, in 9 lessons: Excel Data Entry and Formatting Basics; Excel Formulas: Relative vs Absolute Cell References; Sorting and Filtering Data in Excel; Excel IF, AND, OR Functions; VLOOKUP vs XLOOKUP vs INDEX-MATCH; Excel Text and Date Functions; Excel Pivot Tables for Beginners; Excel Charts and Conditional Formatting; Excel PMT and NPV Functions.
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 1h 39m of video across 9 lessons, plus time for notes and quizzes. Go at your own pace; your place is saved.
Yes: “Build a Sales & Investment Workbook for a Small Retailer”. 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 BBA, 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.