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

  • 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 350+ Companies for Campus Placement.
  • Possibilities of International Exposure.
  • Separate in campus Girls & Boys hostels with Modern Sporting & Gym facilities.

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

Global Learning & Study Abroad Pathways

International Opportunities for Global Career Readiness

DBS Global University provides students with a wide range of opportunities to gain international exposure and enrich their academic journey through global learning experiences that combine international academics, industry exposure, and cross-cultural engagement. Through a strong network of 50+ academic partnerships across 20+ countries, the University offers multiple international pathways including Global Immersion Programs, Month Mobility Programs, Semester Abroad Programs with Credit Transfer, Articulation and Transfer Programs, Dual Degree Programs, and Global Progression Pathways. In addition to these mobility opportunities, students also benefit from international guest lectures, global masterclasses, academic bootcamps, and international events, delivered in collaboration with partner universities and global industry experts.

Image 1
Image 2
Image 3
Image 4
Image 5
Image 6
Image 7
Image 8
Image 9
Image 10
Image 11
Image 12
Image 13
Image 14
Image 15
Image 16
Image 17
Image 18
Image 19
Image 20
Image 21
Image 22
Image 23
Image 24
Image 25
Image 26
Image 27
Image 28
Image 29
Image 30
Image 31
Image 32
Image 33
Image 34
Image 35
Image 36
Image 37
Image 38
Image 39
Image 40
Image 41
Image 1
Image 2
Image 3
Image 4
Image 5
Image 6
Image 7
Image 7
Image 7
Image 7
Image 7
Image 7
Image 7
Image 7

Campus News & Updates

LIFE @ DGU

Buzzing Campus Life

Explore More

Top Recruiters

350+ companies recruit from campus every year

ACC Cement
Adani Cement
Asian Paints
Australian and New Zealand bank
Axis Bank
British Petroleum
Dabur
DBS Bank
Deloitte
EY Building
Grant Thronton
Greenlam Industries Limited
Hafele India
HCL Tech
ICICI Bank
Infosys
ITC Limited
Jhonson
Kansai Nerolac
Mother Dairy
Somany Tiles
Tech Mahindra
UltraTech Cement
Unilever
Wipro
Contact Us Downloads Apply Now Photo Gallery Video Gallery