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


I am sincerely thankful to Chandigarh University for the invaluable opportunity to participate in the ACP Level 1. This program has significantly enhanced my skills in e-trading, web designing, and data visualization. The e-trading module provided me with a comprehensive understanding of online trading platforms, market analysis, and effective trading strategies, empowering me to navigate financial markets confidently. In the web designing course, I acquired essential skills in creating and managing websites using the latest technologies and principles of user experience design and responsiveness. This knowledge has enabled me to develop both functional and visually appealing websites.

Swerah Sadulla Kadli

One of the most transformative experiences of my academic journey was taking cooking and baking, a class that perfectly aligned with my passion for cooking. From the moment I enrolled, I knew this class would be special, offering a deep dive into a field that has always fascinated me as I am always fond of Cooking. Cooking and Baking was an immersive course focused on the knowledge of cooking, learning great cooking techniques and making practical use of it. The class format combined engaging lectures, providing a comprehensive understanding of cooking. Each session was an opportunity to explore new concepts and apply them in the kitchen. Throughout the course, I gained a profound knowledge about types of foods, recipes and much more. One of the most memorable assignments was making Fish Besara which is a famous dish in my state Odisha. This project not only allowed me to apply theoretical knowledge but also sparked a deeper interest in cooking.

Sanchit Suman Malik

Participating in the Advanced Credit Program was instrumental in my academic success. It provided me with the opportunity to challenge myself with college-level courses, preparing me for the demands of higher education. This experience not only enriched my knowledge but also instilled in me the skills of time management, critical thinking, and independent study—skills that are crucial for future academic and professional endeavors. I am proud to have excelled in the Advanced Credit Program and look forward to continuing my journey of academic excellence.

Aadil Mehta

I have received Honors certificate (appreciation of my exemplary performance) from my school for the subjects History (92%) and Political Science (95%) in CBSE Board. I Enrolled myself in Advanced Credit Program-2024 Level-1 Effective Communication and Interpersonal skills scoring 92% Advanced credit Program is an excellent initiative by the Chandigarh University to upgrade and sharpen skills of students. Great presentation style by speakers with lots of opportunities to ask questions and talk about real life examples which all made for a really enjoyable and informative course. I found the course interesting, informative and well lead which has boosted my confidence and helped me grow both personally and professionally and exceeded my expectations in all dimensions. This course leaves you with a real feel-good factor. I can highly recommend the course for all students.

Areeba Qureshi

The professors were exceptionally knowledgeable and supportive, and they emphasized hands-on learning, making the learning process both enjoyable and engaging. The best part was that, by completing each course, I acquired practical knowledge and skills and earned Advanced Academic Credit Points along with a nationally recognized certificate, all at no cost. Thanks to the Chandigarh university for offering such a unique and valuable opportunity to all students.

Hemant Singh

Enrolling in Chandigarh University's Advanced Credit Program marked a pivotal moment in my education. This program, allowed me to navigate through subjects with flexibility. The free access and nationally recognized certification added substantial value to my skill set. The sessions on Web Designing were very interesting and involving, helping me to learn in a better way. Thanks to this initiative, I not only gained advanced academic credits but also had the opportunity to explore diverse subjects, enhancing my overall learning experience. Chandigarh University's commitment to empowering students through such programs has undoubtedly shaped my academic success and future endeavours.

Anshita

Engaging in Chandigarh University's Advanced Credit Program (ACP) was a great learning experience for me. Opting for my passion, Cricket, in this program not only earned me academic credits but also provided a unique platform to sharpen my skills. The faculty was exceptional, offering valuable guidance and insights that went beyond the classroom. ACP empowered me to enhance my passion-based skills. The blend of insightful learning and the support of dedicated faculty made my ACP experience truly enriching, setting the stage for both academic success and personal growth.

Divik Saxena

Completing the Advanced Credit Program at Chandigarh University had a profound impact on my academic journey. The three-level program provided a seamless learning journey, allowing me to probe into my chosen subjects at my own pace. This program not only reduced the demands of my academic schedule but also equipped me with valuable skills. The best part – it's free! The nationally recognized certification adds an extra edge to my profile. Thanks to Chandigarh University, I not only excelled academically but also had the freedom to explore my passions and develop practical skills.
It was truly a transformative experience!

Damandeep kaur

Embarking on Chandigarh University's Advanced Credit Program was a transformative experience enriched by exceptional faculty guidance. Completing this program became a defining milestone in my academic journey. This program allowed me to navigate my courses seamlessly, while the invaluable support and expertise of the faculty were instrumental in my success. The program's free accessibility and nationally recognized certification provided a remarkable boost to my academic profile. Chandigarh University's commitment to quality education and supportive faculty has not only lightened my academic load but also significantly contributed to my growth and confidence as a student.

Annishekh Bora

Thank you to the faculty and staff for being so encouraging and nurturing. A special thanks to Ms. Lovely, Chef Saurabh Khurana for being great teachers like they are. Their fierce dedication to this Advanced Credit Programme is an very beneficial for all the budding hoteliers.

Ms Kajal Bhamba