Basic/Advanced Excel

Apply Now Download Brochure

About the Program

Microsoft Excel is a powerful spreadsheet program that is widely used for various tasks ranging from simple data entry to complex data analysis and visualization.

Excel skills are valuable in many professions, and users often categorize their Excel proficiency into basic and advanced levels.

Advantage @DGU

  • Dehradun - A Safe, Beautiful & Cosmopolitan Education City.
  • Bundle of Industry Integrated Value Added Certificates.
  • Students from 23 States & 5 Countries on campus.
  • Multiple Placements for all.
  • More than 250+ Companies for Campus Placement.
  • Possibilities of International Exposure.
  • Separate in campus Girls & Boys hostels with Modern Sporting & Gym facilities.

Here's an overview of basic and advanced Excel skills:

Basic Excel Skills

Data Entry

Basic understanding of entering data into cells, columns, and rows.

Formatting Cells

Changing font styles, sizes, and colors.Adjusting cell alignment and applying basic formatting.

Basic Formulas

Using basic formulas such as SUM, AVERAGE, COUNT, and simple arithmetic operations.Understanding cell references (absolute and relative).

Sorting and Filtering

Sorting data alphabetically or numerically.Applying filters to organize and analyze data.

Basic Charts

Creating simple charts like bar charts, line charts, and pie charts.

Basic Functions

Using functions like IF, VLOOKUP, and HLOOKUP.Understanding the basics of logical functions.

Page Setup and Printing

Adjusting page layout settings. Printing worksheets and workbooks.

Data Validation

Applying data validation rules to ensure data accuracy.

Managing Worksheets

Inserting, deleting, and renaming worksheets. Basic navigation between worksheets.

. Cell References

Understanding the difference between relative, absolute, and mixed cell references.

Advanced Excel Skills

Advanced Formulas

Working with advanced functions like INDEX, MATCH, OFFSET, and array formulas. Mastering nested functions.

PivotTables

Creating PivotTables for data analysis and summarization. Using PivotTable features like grouping, calculated fields, and slicers.

Advanced Charting

Creating dynamic and interactive charts. Using advanced chart features such as trendlines and dual-axis charts.

Data Analysis Tools

Using tools like Data Tables, Scenario Manager, and Solver for advanced data analysis and decision-making.

Conditional Formatting

Applying advanced conditional formatting rules. Using formulas for conditional formatting.

Power Query and Power Pivot

Importing and transforming data using Power Query. Building data models and performing advanced analysis with Power Pivot.

Macros and VBA (Visual Basic for Applications)

Automating repetitive tasks with macros.

Writing and editing VBA code for advanced customization.

Data Consolidation and Analysis

Consolidating data from multiple worksheets or workbooks. Conducting advanced data analysis using statistical functions.

Advanced Data Validation

Using custom formulas for data validation. Implementing drop-down lists and dependent validation.

. Dynamic Named Ranges

Creating and using dynamic named ranges for flexible data references.

Mastering advanced Excel skills can significantly enhance your ability to analyze data, create sophisticated reports, and automate complex tasks. Many professionals in finance, analytics, and other data-driven fields benefit from advanced Excel proficiency. Continuous learning and practice are essential to stay proficient in both basic and advanced Excel skills.

How to Apply

In order to pursue this program, the students can talk to our counceller or use links below for further details:

Student Speak

Dhruv Tripathi

I am delighted to say that the faculties and the staff has helped me to achieve these dreams. Here, I not only had the chance to develop on my technical skills but also on other aspects such as Leadership & Management skills.

Saswati Pattjoshi

⁠I am very thankful to the department faculty and the placement cell that helped me achieve this while guiding me at every stage. My experience with the placement procedure was really great as I got to learn a lot. The placement cell is very well versed about each step.

Satyam Shekhar

⁠It is a great experience being at DBSGU. Our CDC department has helped a lot during the process of placement. They make sure that each student is well prepared for the interview.

Jyoti Nainwal

I am really thankful towards our college and placement cell, for supporting and providing us opportunities to learn interview skills, communication skills and guiding us in placements. The staff was supportive and informed us with enough notice regarding every placement drive.

Clubs & Activities Endless activities to get you relexed & refreshed when you are not studying

Campus Updates

Nov 18 2024

Workshop on "Hands-On Recruitment Portal (Naukri.com)"

Read More
Oct 09 2024

DBS Global University Dehradun Strengthens Global Ties with Six International MOUs in Malaysia

In a significant move to enhance global educational collaboration, DBS Global University Dehradun has signed six...

Read More
Oct 09 2024

DBS Global University is proud to announce its membership with the Confederation of Indian Industry (CII)

DBS Global University is proud to announce its membership with the Confederation of Indian Industry (CII),...

Read More

Placements Enjoy Everyday while
Ensuring Great Career

At DBSGU each student gets the opportunity to appear for more than 250+ companies each year and each student is able to get the optimum placement deserved. The maximum take home salary has been Rs. 20.5 Lakhs & CTC 23.5 Lakhs. Based on the intensity of training and exposure involved in the management program chosen by students at DBSGU, they are offered positions ranging from Mid-level Manager, Functional Expert, Consultant (Entry Level), Entry Level Managerial and Domain Trained positions.

Interested in this program? Talk to counsellor @ +91 7259162060
Apply Now