Basic/Advanced Excel
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
Level & Duration
Level
Certificate
Duration
1 Year
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.
Placements
Enjoy Everyday while Ensuring Great Career
Thanks to DGU’s mock interviews, value‑added courses, and hands‑on projects I developed confidence, communication skills and real-world business sense. The practical exposure and industry-aligned learning helped me step into Indigo Paints Limited ready to perform and grow.
From engaging campus activities to hands-on projects, DGU made learning practical and exciting. This experience helped me step into Reliance Retail ready to make an impact.
One thing that really helped me during the placement season was the confidence I gained from the mock sessions. My professors pointed out mistakes I hadn’t even realized I was making and gave me valuable tips that made the process smoother. This foundation prepared me well for my role at Asian Paints Ltd.
The mix of interactive learning, practical projects, and expert guidance shaped my skills effectively. It gave me the confidence to start my professional journey with Tech Mahindra.
Hands-on learning, value-added courses, and supportive faculty prepared me for real-world challenges. These experiences helped me confidently join Hafele India Pvt Ltd and contribute from day one.
DBS Global University’s rigorous learning environment and hands-on experiences challenged me to grow constantly. This preparation gave me the confidence and skills to step into Grant Thornton Bharat LLP with readiness.
DBS Global University’s competitive and dynamic environment pushed me to perform at my best every day. This energy, combined with practical learning and guidance from faculty, helped me secure my role at MyGetWellStore.
DBS Global University’s practical projects and faculty guidance helped me build real-world skills and confidence. This preparation enabled me to step into Prism Johnson ready to contribute effectively.
At DBS Global University, engaging in practical projects and hands-on learning enhanced my skills and confidence, equipping me to step into my role at Phronesis Partners with clear direction and focus.
Through DBS Global University’s hands-on projects and skill-focused sessions, I gained practical experience and strengthened my confidence. These opportunities equipped me to make meaningful contributions at Digital Marveled Private Limited.
DGU helped me grow into someone who can take on challenges with confidence and clarity. My placement at Extramarks Education feels like the right step toward building a meaningful career.
DGU shaped my skills through constant guidance, practical exposure, and a supportive environment. Getting placed at High Beam Global feels like a strong beginning to my professional journey.
Student Education Immersion Program
Study Abroad Opportunities for Global Careers
DBS Global University offers students flexible and impactful study abroad pathways designed to build global competence and career readiness. Backed by a strong network of 50+ MOUs across 20+ countries, the University enables meaningful international exposure through Short-Term Global Immersion Programs, Credit Transfer Study Abroad Programs, and Dual Degree & Long-Term Global Pathways.
Through strategic partnerships with institutions across Australia, USA, Europe, Malaysia, Singapore, Dubai, Thailand, Indonesia, Turkey, Hong Kong and Russia, students benefit from internationally benchmarked curricula, industry exposure, multicultural classrooms, and cross-cultural learning. These experiences integrate academics with experiential learning, global networking, and real-world insights—empowering students with a global mindset, enhanced employability, and the skills required for successful international careers.
