Level 1

Basics of Microsoft Excel

Registrations Open !!

Basic Computer Knowledge

  • Level 1 - Beginner
  • Course Code: 26GPA104

Basics of Microsoft Excel

Apply Now chandigarh university lucknow

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.

  • 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.

  • 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.

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

  • 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.

Know your Mentor Contact Number Email Id Teaching Experience (in Yrs.)
Mr.Sobit Rehan 80546-27987 sobit.e16168@cumail.in 9+ Years

Students Testimonials

Testimonial image

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
Testimonial image

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
Testimonial image

"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
Testimonial image

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
Testimonial image

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
Testimonial image

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
Testimonial image

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
Testimonial image

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
Testimonial image

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
Testimonial image

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