Aditya D

I am currently working in a reputed bank in India.

Banks • Tiempo completo

Dec 2021 - Present • 4 yrs 11 mos

Basic Excel Skills Data entry and editing Spreadsheet formatting and styling Cell formatting (font, color, borders, alignment) Row and column management Sorting and filtering data Find and Replace Remove duplicates Freeze Panes Page layout and print settings Basic charts and graphs Basic formulas: SUM, AVERAGE, MIN, MAX, COUNT Basic arithmetic formulas AutoFill and Flash Fill Data validation and drop-down lists Excel tables Intermediate Excel Skills Logical functions: IF, AND, OR, IFERROR Conditional calculations: SUMIF, SUMIFS, COUNTIF, COUNTIFS Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP Text functions: LEFT, RIGHT, MID, LEN, TRIM, CONCAT Date and time functions: TODAY, NOW, DATEDIF, EOMONTH Combining multiple formulas Conditional Formatting with custom rules PivotTables and PivotCharts Data cleaning and transformation Basic dashboard creation Charts and data visualization Subtotals and grouped data Named ranges Basic What-If Analysis Protecting worksheets and workbooks Importing and exporting CSV files Basic financial calculations Creating invoices, expense trackers, and reports Best Skills to Offer on Fiverr If you're creating Excel gigs, prioritize these practical services: Data entry and spreadsheet formatting Data cleaning and duplicate removal Excel formulas and functions Data sorting, filtering, and organization VLOOKUP and XLOOKUP solutions PivotTables and summary reports Charts and basic dashboards Data validation and drop-down lists PDF/CSV to Excel conversion and formatting Monthly expense reports and business trackers