Advanced Excel Training
I completed Internshala’s four-week Advanced Excel training in 2020, scoring 84%. The course covered formulas, data handling, Pivot Tables, charts and reporting, with assignments and a final project.
Category
Data Science
Training provider
Internshala Trainings
Course Duration
4 Weeks
Course Dates
15.05.20 – 14.06.20
Final Score
84%
Verification Links
Topics covered
- Worksheets, navigation, shortcuts and cell references.
- Data entry, sheet management, protection, sorting and filtering.
- Formulas such as IF, VLOOKUP, HLOOKUP and INDEX-MATCH.
- Conditional formatting.
- Scenario Manager, Goal Seek and Data Tables.
- Pivot Tables and charts.
- Page layout and printing.
Final Project
The final project used marketing and customer support data for a food technology startup called Food2Go. I cleaned and analysed the data in Excel, using formulas, Pivot Tables and What-If Analysis.
I looked at campaign performance, cuisine popularity and restaurant support metrics, then submitted a workbook and a report of the findings.
What I learned
I practised cleaning and summarising data, choosing formulas and presenting results in tables and charts. The project also gave me practice with turning a spreadsheet analysis into a written report.
Excel remains part of my audit work, especially for reviewing samples, checking data and preparing workpapers. This course was one of my early introductions to those tasks.