Admission Helpline1800121288800
  • Level 1 - Beginner
  • Course Code: 26GPA104

Basics of Microsoft Excel

Apply Now

Course Description

This course introduces learners to the fundamental concepts and practical applications of Microsoft Excel. It is designed for beginners who want to build a strong foundation in spreadsheet management, data organization, and basic analysis. Participants will learn how to navigate the Excel interface, create and format worksheets, use formulas and functions, manage data, and generate simple charts. By the end of the course, learners will be able to confidently use Excel for everyday tasks such as budgeting, reporting, and data tracking.

Advanced Credit Program

Course Objectives

  • Understand the Excel interface and basic terminology.
  • Create, save, and manage workbooks and worksheets.
  • Enter, edit, and format data effectively.
  • Apply basic formulas and functions for calculations.
Advanced Credit Program

Course Outcomes

  • CO1: Understand and navigate the Excel interface, including worksheets, ribbons, and toolbars.
  • CO2: Apply basic data entry, formatting, and cell referencing techniques for structured data management.
  • CO3: Use basic formulas and functions (SUM, AVERAGE, COUNT, etc.) to perform calculations efficiently.
Advanced Credit Program

Day Wise Schedule

Day

Topic

Sub-Topic No.

Sub-Topic Title

Detailed Contents

Day 1

Introduction to Excel

1.1

What is Microsoft Excel

Purpose, applications, real-world use cases
   

1.2

Excel Interface Overview

Ribbon, Tabs, Workbook, Worksheet, Formula Bar, Status Bar
   

1.3

Creating and Saving Workbooks

New workbook, save options, file formats
   

1.4

Basic Navigation and Shortcuts

Cell selection, scrolling, keyboard shortcuts

Day 2

Data Entry and Formatting

2.1

Entering Data

Text, numbers, dates, AutoFill
   

2.2

Formatting Cells

Font, alignment, borders, colors, number formats
   

2.3

Managing Rows and Columns

Insert, delete, resize, hide/unhide

Day 3

Formulas and Functions

3.1

Writing Formulas

Arithmetic operations, cell references
   

3.2

Common Functions

SUM, AVERAGE, MIN, MAX, COUNT
   

3.3

Relative vs Absolute References

Use of $ in formulas, practical examples

Day 4

Worksheet and Data Tools

4.1

Managing Worksheets

Rename, move, copy, delete, freeze panes
   

4.2

Sorting and Filtering

Sort by value, custom sort, filter by condition
   

4.3

Data Validation

Drop-down lists, input restrictions

Day 5

Charts and Visualization

5.1

Creating Charts

Column, Line, Pie charts
   

5.2

Customizing Charts

Titles, legends, labels, colors
   

5.3

Conditional Formatting

Highlighting rules, data bars, color scales

Day 6

Page Setup and Applications

6.1

Page Layout and Printing

Margins, orientation, scaling, print preview
   

6.2

Exporting and Sharing

Save as PDF, sharing options
   

6.3

Practical Use Cases

Budget sheet, attendance tracker, grade calculator

Reference Books

  • Book 1: Microsoft Excel 2021 Step by Step – Curtis Frye
    A beginner-friendly guide covering all the essential Excel features step by step.
  • Book 2: Excel Formulas & Functions for Dummies – Ken Bluttman
    Perfect for mastering Excel formulas and functions, including logical, lookup, and financial functions.

Mentor Details

Know your Mentor

Contact Number

Email Id

Teaching Experience (in Yrs.)

Mr. Sobit Rehan

80546-27987

sobit.e16168@cumail.in

9+

What Students say about the Program


The Advanced Credit Program at Chandigarh University has been a game-changer for my academic journey. It gave me the flexibility to accelerate my studies while exploring subjects in greater depth. The curriculum is structured, industry-relevant, and supported by faculty who genuinely want students to grow. What I appreciated most was how the program helped me build confidence—both academically and professionally—by encouraging higher-level thinking and self-discipline. This program doesn’t just add credits; it adds real value to your learning experience and future opportunities.

Mohammad Fahad Siddique
Applied Data Analytics for Business Decisions

Completing the Introduction to AI course with ACP was a game-changer for my career. The curriculum was incredibly well-structured, providing a clear path from foundational concepts to practical applications like Machine Learning and Natural Language Processing. I especially appreciated the hands-on projects, which allowed me to build my first functional AI model. This course didn't just teach me about AI; it gave me the confidence and skills to actively pursue opportunities in one of the world's most exciting and fastest-growing fields. I highly recommend ACP to anyone looking to make a meaningful pivot into technology!

Jaswanth Chidirala
Introduction to AI

The Advanced Credit Program at Chandigarh University has played a transformative role in my academic journey. It offered the flexibility to fast-track my studies while allowing me to delve deeper into key subjects. The well-structured, industry-focused curriculum, combined with the constant support of dedicated faculty, truly enhanced my learning experience. What stood out the most was how the program boosted my academic and professional confidence by promoting critical thinking and self-discipline. This program goes beyond earning extra credits—it meaningfully enriches learning and opens doors to future opportunities.

Shivam
Programming in Python

The Advanced Credit Program at Chandigarh University has been an enriching part of my academic journey. It gave me the flexibility to accelerate my studies without compromising on learning quality. The curriculum is well-structured and closely aligned with industry requirements. Faculty members are supportive and always encourage deeper understanding. The program helped me develop critical thinking and self-discipline. Overall, it added real value to my academic and professional growth.

Danveer Singh
Digital Banking and Fintech essentials

Being a part of the Advanced Credit Program allowed me to explore subjects beyond the regular curriculum. The flexibility offered by the program helped me manage my time efficiently while learning advanced concepts. The industry-relevant content kept me engaged and motivated throughout. Faculty guidance played a crucial role in my learning process. This program significantly boosted my academic confidence. It has positively impacted my future career outlook.

Vivek
Ethical Hacking

The Advanced Credit Program at Chandigarh University provided a perfect blend of academic rigor and flexibility. It enabled me to fast-track my education while gaining in-depth subject knowledge. The structured curriculum ensured clarity and consistency in learning. Faculty members were approachable and supportive at every step. The program enhanced my analytical and problem-solving skills. It truly prepared me for higher academic and professional challenges.

Saanvi Goyal
Basics of Taxation and GST

What I appreciated most about the Advanced Credit Program was its focus on quality learning. The program encouraged independent thinking and a disciplined approach to academics. The industry-oriented curriculum helped me understand real-world applications. Faculty support made complex concepts easier to grasp. I gained confidence in both academic and professional settings. This program goes beyond credits and adds meaningful learning value.

Shivam Singh
Data Visualization using Power BI

The Advanced Credit Program has played an important role in shaping my academic journey. It offered me the opportunity to learn at an advanced level while maintaining flexibility. The curriculum is thoughtfully designed to meet current industry standards. Faculty mentorship helped me stay motivated and focused. The program improved my critical thinking abilities. It has been a valuable addition to my overall learning experience.

Archi
Data Science

Participating in the Advanced Credit Program was a rewarding experience. It allowed me to strengthen my subject knowledge and progress academically at a faster pace. The structured coursework ensured a smooth learning process. Faculty members provided constant support and guidance. The program helped me build confidence and self-discipline. It has greatly contributed to my academic and professional development.

Sneha Kumari
Introduction to Machine Learning

The Advanced Credit Program at Chandigarh University enhanced my learning experience in many ways. The flexibility of the program helped me balance academics effectively. The curriculum is relevant, practical, and well-organized. Faculty encouragement pushed me to think beyond textbooks. I developed a more analytical and confident mindset. This program truly prepares students for future opportunities.

Payal Kumari
Introduction to Blockchain Technology

Through the Advanced Credit Program, I gained exposure to advanced academic concepts and practical learning. The program structure allowed me to manage my studies efficiently. Industry-focused content made the learning experience more meaningful. Faculty support ensured clarity and continuous improvement. The program helped me develop professional confidence. It added significant value to my academic profile.

Seerat
Coding

The Advanced Credit Program has been a transformative academic experience for me. It encouraged deeper learning and a disciplined study approach. The curriculum is designed to meet industry expectations. Faculty members played a key role in guiding and motivating students. The program strengthened my analytical and problem-solving skills. It has positively influenced my career readiness.

Yogendra Kushwaha
Basics of Java Programming

Enrolling in the Advanced Credit Program at Chandigarh University was a great decision. The program allowed me to earn credits faster while focusing on quality education. The structured and industry-relevant curriculum enhanced my understanding of key subjects. Faculty guidance was consistent and supportive. I gained confidence in my academic and professional abilities. This program truly adds long-term value to a student’s journey.

Paras Thakur
Introduction to Robotics

The Advanced Credit Program at Chandigarh University has been a truly transformative part of my academic journey. It provided the flexibility to accelerate my studies while exploring subjects in greater depth. The curriculum is well-structured, industry-focused, and aligned with practical learning needs. Continuous guidance and support from dedicated faculty enhanced the overall learning experience. The program encouraged critical thinking and a disciplined approach to academics. It significantly boosted my academic and professional confidence. This program adds real value by preparing students for future opportunities beyond extra credits.

Astha Chauhan
Basics of Microsoft Excel

The Advanced Credit Program at Chandigarh University has had a meaningful impact on my academic growth. It allowed me to progress faster while gaining a deeper understanding of important subjects. The industry-oriented and well-organized curriculum ensured practical and relevant learning. Faculty members were consistently supportive and approachable throughout the program. The program fostered critical thinking, self-discipline, and independent learning. It helped strengthen both my academic foundation and professional confidence. Overall, this program goes beyond credits by creating long-term academic and career value.

Sumanpreet Kaur
Social Media Marketing